| 1 | DESCRIBE `press_release` | | 13 | 13 | 1 |
| 2 | DESCRIBE `company` | | 27 | 27 | 1 |
| 3 | DESCRIBE `condet` | | 17 | 17 | 1 |
| 4 | DESCRIBE `countrycode` | | 4 | 4 | 0 |
| 5 | DESCRIBE `person` | | 15 | 15 | 1 |
| 6 | DESCRIBE `account` | | 29 | 29 | 1 |
| 7 | DESCRIBE `product_legacy` | | 6 | 6 | 0 |
| 8 | DESCRIBE `sales_people` | | 6 | 6 | 0 |
| 9 | DESCRIBE `profile` | | 14 | 14 | 1 |
| 10 | DESCRIBE `currencies` | | 7 | 7 | 1 |
| 11 | DESCRIBE `update_rec` | | 7 | 7 | 16 |
| 12 | DESCRIBE `user` | | 24 | 24 | 1 |
| 13 | DESCRIBE `enquiry` | | 14 | 14 | 1 |
| 14 | DESCRIBE `module_types` | | 6 | 6 | 0 |
| 15 | DESCRIBE `dms_companies` | | 26 | 26 | 1 |
| 16 | DESCRIBE `dms_releases` | | 10 | 10 | 17 |
| 17 | DESCRIBE `dms_categories` | | 4 | 4 | 0 |
| 18 | DESCRIBE `dms_clinical_areas` | | 4 | 4 | 1 |
| 19 | DESCRIBE `dms_categories_dms_releases` | | 2 | 2 | 0 |
| 20 | DESCRIBE `dms_clinical_areas_dms_releases` | | 2 | 2 | 0 |
| 21 | DESCRIBE `dms_releases_sites` | | 5 | 5 | 0 |
| 22 | DESCRIBE `licopp` | | 23 | 23 | 1 |
| 23 | DESCRIBE `development_statuses` | | 5 | 5 | 0 |
| 24 | DESCRIBE `category` | | 14 | 14 | 1 |
| 25 | DESCRIBE `categories_sites` | | 5 | 5 | 0 |
| 26 | DESCRIBE `categorisation` | | 8 | 8 | 1 |
| 27 | DESCRIBE `licopps_sites` | | 3 | 3 | 0 |
| 28 | DESCRIBE `service` | | 15 | 15 | 1 |
| 29 | DESCRIBE `story` | | 12 | 12 | 1 |
| 30 | DESCRIBE `sites_stories` | | 5 | 5 | 0 |
| 31 | DESCRIBE `story_assoc` | | 4 | 4 | 0 |
| 32 | DESCRIBE `companies_sites` | | 3 | 3 | 0 |
| 33 | DESCRIBE `categories_users` | | 2 | 2 | 0 |
| 34 | DESCRIBE `authority` | | 3 | 3 | 1 |
| 35 | DESCRIBE `sites_users` | | 5 | 5 | 1 |
| 36 | DESCRIBE `press_releases_sites` | | 5 | 5 | 1 |
| 37 | DESCRIBE `sites` | | 5 | 5 | 1 |
| 38 | SELECT `Site`.`id`, `Site`.`name`, `Site`.`email_domain`, `Site`.`short_name`, `Site`.`brand` FROM `sites` AS `Site` WHERE `Site`.`id` = 1 LIMIT 1 | | 1 | 1 | 0 |
| 39 | SELECT c.uid, c.name FROM category c WHERE c.parent = 297 ORDER BY c.name | | 11 | 11 | 0 |
| 40 | SELECT c.uid, c.name FROM category c WHERE c.parent = 679 ORDER BY c.name | | 29 | 29 | 0 |
| 41 | SELECT DISTINCT SUBSTRING(issued, 1, 4) AS publication_year FROM press_release AS Press WHERE is_live = 1 AND issued IS NOT NULL ORDER BY publication_year DESC | | 14 | 14 | 0 |
| 42 | SELECT c.lft, c.rgt FROM category c WHERE c.uid = 679 | | 1 | 1 | 0 |
| 43 | SELECT c.uid, c.name, c.level FROM category c WHERE c.lft <= "4097" AND c.rgt >= "4156" AND c.level > 1 ORDER BY c.level | | 1 | 1 | 0 |
| 44 | SELECT press_release.uid, press_release.slug, press_release.headline, press_release.summary FROM press_release JOIN company AS Company ON press_release.company_id=Company.uid INNER JOIN categorisation tt_ctg ON tt_ctg.story_id = press_release.uid AND tt_ctg.cat_type = "R" AND tt_ctg.category_id IN (SELECT uid FROM category WHERE (lft >= 4097 AND rgt <= 4156) ) WHERE press_release.is_live > 0 AND (press_release.company_id IS NULL OR (Company.is_live="y" AND press_release.company_id=Company.uid)) GROUP BY press_release.uid ORDER BY press_release.viewed_counter DESC, press_release.headline LIMIT 0, 10 | | 10 | 10 | 145 |
| 45 | SELECT count(DISTINCT press_release.uid) AS total FROM press_release JOIN company AS Company ON press_release.company_id=Company.uid INNER JOIN categorisation tt_ctg ON tt_ctg.story_id = press_release.uid AND tt_ctg.cat_type = "R" AND tt_ctg.category_id IN (SELECT uid FROM category WHERE (lft >= 4097 AND rgt <= 4156) ) WHERE press_release.is_live > 0 AND (press_release.company_id IS NULL OR (Company.is_live="y" AND press_release.company_id=Company.uid)) | | 1 | 1 | 93 |