| 1 | DESCRIBE `dms_releases` | | 10 | 10 | 11 |
| 2 | DESCRIBE `dms_categories` | | 4 | 4 | 1 |
| 3 | DESCRIBE `dms_clinical_areas` | | 4 | 4 | 1 |
| 4 | DESCRIBE `dms_categories_dms_releases` | | 2 | 2 | 1 |
| 5 | DESCRIBE `dms_clinical_areas_dms_releases` | | 2 | 2 | 1 |
| 6 | DESCRIBE `dms_releases_sites` | | 5 | 5 | 1 |
| 7 | DESCRIBE `category` | | 14 | 14 | 1 |
| 8 | DESCRIBE `categories_sites` | | 5 | 5 | 1 |
| 9 | DESCRIBE `story` | | 12 | 12 | 12 |
| 10 | DESCRIBE `categorisation` | | 8 | 8 | 1 |
| 11 | DESCRIBE `sites_stories` | | 5 | 5 | 1 |
| 12 | DESCRIBE `licopp` | | 23 | 23 | 4 |
| 13 | DESCRIBE `company` | | 27 | 27 | 2 |
| 14 | DESCRIBE `condet` | | 17 | 17 | 4 |
| 15 | DESCRIBE `countrycode` | | 4 | 4 | 1 |
| 16 | DESCRIBE `person` | | 15 | 15 | 5 |
| 17 | DESCRIBE `account` | | 29 | 29 | 2 |
| 18 | DESCRIBE `product_legacy` | | 6 | 6 | 1 |
| 19 | DESCRIBE `sales_people` | | 6 | 6 | 6 |
| 20 | DESCRIBE `profile` | | 14 | 14 | 1 |
| 21 | DESCRIBE `currencies` | | 7 | 7 | 1 |
| 22 | DESCRIBE `update_rec` | | 7 | 7 | 0 |
| 23 | DESCRIBE `user` | | 24 | 24 | 1 |
| 24 | DESCRIBE `enquiry` | | 14 | 14 | 1 |
| 25 | DESCRIBE `module_types` | | 6 | 6 | 0 |
| 26 | DESCRIBE `dms_companies` | | 26 | 26 | 1 |
| 27 | DESCRIBE `development_statuses` | | 5 | 5 | 0 |
| 28 | DESCRIBE `licopps_sites` | | 3 | 3 | 0 |
| 29 | DESCRIBE `service` | | 15 | 15 | 1 |
| 30 | DESCRIBE `press_release` | | 13 | 13 | 1 |
| 31 | DESCRIBE `press_releases_sites` | | 5 | 5 | 0 |
| 32 | DESCRIBE `story_assoc` | | 4 | 4 | 0 |
| 33 | DESCRIBE `companies_sites` | | 3 | 3 | 0 |
| 34 | DESCRIBE `categories_users` | | 2 | 2 | 0 |
| 35 | DESCRIBE `authority` | | 3 | 3 | 0 |
| 36 | DESCRIBE `sites_users` | | 5 | 5 | 1 |
| 37 | DESCRIBE `feature_article` | | 13 | 13 | 1 |
| 38 | DESCRIBE `feature_author` | | 13 | 13 | 1 |
| 39 | DESCRIBE `newsml` | | 9 | 9 | 1 |
| 40 | DESCRIBE `prnsubjects` | | 4 | 4 | 0 |
| 41 | DESCRIBE `newsml_prnsubjects` | | 2 | 2 | 0 |
| 42 | DESCRIBE `sites` | | 5 | 5 | 1 |
| 43 | 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 |
| 44 | SELECT `Outlicensing`.`uid`, `Outlicensing`.`slug`, `Outlicensing`.`title`, `Outlicensing`.`change_time`, `Category`.`uid` FROM `licopp` AS `Outlicensing` LEFT JOIN categorisation AS `Categorisation` ON (`Categorisation`.`company_id` = `Outlicensing`.`uid` AND `Categorisation`.`cat_type` = 'L') LEFT JOIN category AS `Category` ON (`Category`.`uid` = `Categorisation`.`category_id`) LEFT JOIN `person` AS `Person` ON (`Outlicensing`.`contact_id` = `Person`.`uid`) LEFT JOIN `development_statuses` AS `DevelopmentStatus` ON (`Outlicensing`.`devstatus` = `DevelopmentStatus`.`id`) LEFT JOIN `update_rec` AS `UpdateRecord` ON (`Outlicensing`.`update_id` = `UpdateRecord`.`uid`) LEFT JOIN `company` AS `Company` ON (`Outlicensing`.`company_id` = `Company`.`uid`) LEFT JOIN `licopps_sites` AS `OutlicensingSite` ON (`OutlicensingSite`.`licopp_id` = `Outlicensing`.`uid`) WHERE `OutlicensingSite`.`site_id` = 1 AND ((`Outlicensing`.`is_out` = 'Y') AND (`Company`.`is_live` = 'Y')) GROUP BY `Outlicensing`.`uid` ORDER BY `Outlicensing`.`change_time` DESC LIMIT 13 | | 13 | 13 | 520 |
| 45 | SELECT `Category`.`uid`, `Category`.`name`, `Category`.`parent`, `Category`.`has_children`, `Category`.`show_children`, `Category`.`show_grandchildren`, `Category`.`members`, `Category`.`num_children`, `Category`.`root`, `Category`.`restricted`, `Category`.`clan`, `Category`.`lft`, `Category`.`rgt`, `Category`.`level`, `Categorisation`.`id`, `Categorisation`.`company_id`, `Categorisation`.`buysell`, `Categorisation`.`category_id`, `Categorisation`.`browse_category_id`, `Categorisation`.`cat_type`, `Categorisation`.`story_id`, `Categorisation`.`network_id` FROM `category` AS `Category` JOIN `categorisation` AS `Categorisation` ON (`Categorisation`.`company_id` IN (5567, 18663, 5252, 6011, 19194, 19385, 18780, 4572, 4565, 4242, 19304, 19397, 6510) AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="L" ORDER BY `Category`.`root` ASC, `Category`.`clan` ASC, `Category`.`parent` ASC, `Category`.`name` ASC | | 92 | 92 | 1 |
| 46 | SELECT `Inlicensing`.`uid`, `Inlicensing`.`slug`, `Inlicensing`.`title`, `Inlicensing`.`change_time`, `Category`.`uid` FROM `licopp` AS `Inlicensing` LEFT JOIN categorisation AS `Categorisation` ON (`Categorisation`.`company_id` = `Inlicensing`.`uid` AND `Categorisation`.`cat_type` = 'P') LEFT JOIN category AS `Category` ON (`Category`.`uid` = `Categorisation`.`category_id`) LEFT JOIN `person` AS `Person` ON (`Inlicensing`.`contact_id` = `Person`.`uid`) LEFT JOIN `development_statuses` AS `DevelopmentStatus` ON (`Inlicensing`.`devstatus` = `DevelopmentStatus`.`id`) LEFT JOIN `update_rec` AS `UpdateRecord` ON (`Inlicensing`.`update_id` = `UpdateRecord`.`uid`) LEFT JOIN `company` AS `Company` ON (`Inlicensing`.`company_id` = `Company`.`uid`) LEFT JOIN `licopps_sites` AS `InlicensingSite` ON (`InlicensingSite`.`licopp_id` = `Inlicensing`.`uid`) WHERE `InlicensingSite`.`site_id` = 1 AND ((`Inlicensing`.`is_out` = 'N') AND (`Company`.`is_live` = 'Y')) GROUP BY `Inlicensing`.`uid` ORDER BY `Inlicensing`.`change_time` DESC LIMIT 13 | | 13 | 13 | 5 |
| 47 | SELECT `Category`.`uid`, `Category`.`name`, `Category`.`parent`, `Category`.`has_children`, `Category`.`show_children`, `Category`.`show_grandchildren`, `Category`.`members`, `Category`.`num_children`, `Category`.`root`, `Category`.`restricted`, `Category`.`clan`, `Category`.`lft`, `Category`.`rgt`, `Category`.`level`, `Categorisation`.`id`, `Categorisation`.`company_id`, `Categorisation`.`buysell`, `Categorisation`.`category_id`, `Categorisation`.`browse_category_id`, `Categorisation`.`cat_type`, `Categorisation`.`story_id`, `Categorisation`.`network_id` FROM `category` AS `Category` JOIN `categorisation` AS `Categorisation` ON (`Categorisation`.`company_id` IN (5627, 2112, 18665, 19291, 19251, 5471, 1213, 1362, 19300, 19299, 19302, 19298, 19252) AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="P" ORDER BY `Category`.`root` ASC, `Category`.`clan` ASC, `Category`.`parent` ASC, `Category`.`name` ASC | | 184 | 184 | 1 |
| 48 |
SELECT Company.uid, Company.slug, Company.name, Company.summary, Company.change_time FROM company AS Company INNER JOIN companies_sites AS CompanySite ON CompanySite.company_id = Company.uid AND CompanySite.site_id = 1 WHERE Company.is_customer="Y" AND Company.is_live="Y" GROUP BY Company.uid
ORDER BY Company.change_time DESC
LIMIT 4 | | 4 | 4 | 6 |
| 49 | SELECT `Outlicensing`.`uid`, `Outlicensing`.`slug`, `Outlicensing`.`title`, `Outlicensing`.`change_time`, `Category`.`uid` FROM `licopp` AS `Outlicensing` LEFT JOIN categorisation AS `Categorisation` ON (`Categorisation`.`company_id` = `Outlicensing`.`uid` AND `Categorisation`.`cat_type` = 'L') LEFT JOIN category AS `Category` ON (`Category`.`uid` = `Categorisation`.`category_id`) LEFT JOIN `person` AS `Person` ON (`Outlicensing`.`contact_id` = `Person`.`uid`) LEFT JOIN `development_statuses` AS `DevelopmentStatus` ON (`Outlicensing`.`devstatus` = `DevelopmentStatus`.`id`) LEFT JOIN `update_rec` AS `UpdateRecord` ON (`Outlicensing`.`update_id` = `UpdateRecord`.`uid`) LEFT JOIN `company` AS `Company` ON (`Outlicensing`.`company_id` = `Company`.`uid`) LEFT JOIN `licopps_sites` AS `OutlicensingSite` ON (`OutlicensingSite`.`licopp_id` = `Outlicensing`.`uid`) WHERE `OutlicensingSite`.`site_id` = 1 AND ((`Outlicensing`.`is_out` = 'Y') AND (`Company`.`is_live` = 'Y')) AND `Company`.`uid` = 1139 GROUP BY `Outlicensing`.`uid` ORDER BY `Outlicensing`.`change_time` DESC LIMIT 13 | | 13 | 13 | 2 |
| 50 | SELECT `Category`.`uid`, `Category`.`name`, `Category`.`parent`, `Category`.`has_children`, `Category`.`show_children`, `Category`.`show_grandchildren`, `Category`.`members`, `Category`.`num_children`, `Category`.`root`, `Category`.`restricted`, `Category`.`clan`, `Category`.`lft`, `Category`.`rgt`, `Category`.`level`, `Categorisation`.`id`, `Categorisation`.`company_id`, `Categorisation`.`buysell`, `Categorisation`.`category_id`, `Categorisation`.`browse_category_id`, `Categorisation`.`cat_type`, `Categorisation`.`story_id`, `Categorisation`.`network_id` FROM `category` AS `Category` JOIN `categorisation` AS `Categorisation` ON (`Categorisation`.`company_id` IN (19341, 19405, 18727, 19331, 19295, 19281, 19246, 18788, 19250, 19280, 19263, 18789, 18729) AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="L" ORDER BY `Category`.`root` ASC, `Category`.`clan` ASC, `Category`.`parent` ASC, `Category`.`name` ASC | | 118 | 118 | 0 |
| 51 | SELECT `Inlicensing`.`uid`, `Inlicensing`.`slug`, `Inlicensing`.`title`, `Inlicensing`.`change_time`, `Category`.`uid` FROM `licopp` AS `Inlicensing` LEFT JOIN categorisation AS `Categorisation` ON (`Categorisation`.`company_id` = `Inlicensing`.`uid` AND `Categorisation`.`cat_type` = 'P') LEFT JOIN category AS `Category` ON (`Category`.`uid` = `Categorisation`.`category_id`) LEFT JOIN `person` AS `Person` ON (`Inlicensing`.`contact_id` = `Person`.`uid`) LEFT JOIN `development_statuses` AS `DevelopmentStatus` ON (`Inlicensing`.`devstatus` = `DevelopmentStatus`.`id`) LEFT JOIN `update_rec` AS `UpdateRecord` ON (`Inlicensing`.`update_id` = `UpdateRecord`.`uid`) LEFT JOIN `company` AS `Company` ON (`Inlicensing`.`company_id` = `Company`.`uid`) LEFT JOIN `licopps_sites` AS `InlicensingSite` ON (`InlicensingSite`.`licopp_id` = `Inlicensing`.`uid`) WHERE `InlicensingSite`.`site_id` = 1 AND ((`Inlicensing`.`is_out` = 'N') AND (`Company`.`is_live` = 'Y')) AND `Company`.`uid` = 1139 GROUP BY `Inlicensing`.`uid` ORDER BY `Inlicensing`.`change_time` DESC LIMIT 13 | | 10 | 10 | 2 |
| 52 | SELECT `Category`.`uid`, `Category`.`name`, `Category`.`parent`, `Category`.`has_children`, `Category`.`show_children`, `Category`.`show_grandchildren`, `Category`.`members`, `Category`.`num_children`, `Category`.`root`, `Category`.`restricted`, `Category`.`clan`, `Category`.`lft`, `Category`.`rgt`, `Category`.`level`, `Categorisation`.`id`, `Categorisation`.`company_id`, `Categorisation`.`buysell`, `Categorisation`.`category_id`, `Categorisation`.`browse_category_id`, `Categorisation`.`cat_type`, `Categorisation`.`story_id`, `Categorisation`.`network_id` FROM `category` AS `Category` JOIN `categorisation` AS `Categorisation` ON (`Categorisation`.`company_id` IN (19406, 19393, 18815, 19303, 18794, 19120, 18606, 6612, 18793, 18791) AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="P" ORDER BY `Category`.`root` ASC, `Category`.`clan` ASC, `Category`.`parent` ASC, `Category`.`name` ASC | | 84 | 84 | 0 |
| 53 | SELECT `Person`.`salutation` FROM `person` AS `Person` LEFT JOIN `condet` AS `Contact` ON (`Person`.`condet_id` = `Contact`.`uid`) LEFT JOIN `company` AS `Company` ON (`Person`.`company_id` = `Company`.`uid`) WHERE `Person`.`uid`="" LIMIT 1 | | 0 | 0 | 0 |
| 54 | DESCRIBE `blurb` | | 9 | 9 | 1 |
| 55 | SELECT `Blurb`.`id`, `Blurb`.`headline`, `Blurb`.`body` FROM `blurb` AS `Blurb` WHERE `Blurb`.`id` LIKE "PL%" AND `Blurb`.`headline` <> "" ORDER BY `Blurb`.`id` ASC | | 3 | 3 | 0 |
| 56 | SELECT `Outlicensing`.`uid`, `Outlicensing`.`slug`, `Outlicensing`.`title`, `Outlicensing`.`change_time`, `Category`.`uid` FROM `licopp` AS `Outlicensing` LEFT JOIN categorisation AS `Categorisation` ON (`Categorisation`.`company_id` = `Outlicensing`.`uid` AND `Categorisation`.`cat_type` = 'L') LEFT JOIN category AS `Category` ON (`Category`.`uid` = `Categorisation`.`category_id`) LEFT JOIN `person` AS `Person` ON (`Outlicensing`.`contact_id` = `Person`.`uid`) LEFT JOIN `development_statuses` AS `DevelopmentStatus` ON (`Outlicensing`.`devstatus` = `DevelopmentStatus`.`id`) LEFT JOIN `update_rec` AS `UpdateRecord` ON (`Outlicensing`.`update_id` = `UpdateRecord`.`uid`) LEFT JOIN `company` AS `Company` ON (`Outlicensing`.`company_id` = `Company`.`uid`) LEFT JOIN `licopps_sites` AS `OutlicensingSite` ON (`OutlicensingSite`.`licopp_id` = `Outlicensing`.`uid`) WHERE `OutlicensingSite`.`site_id` = 1 AND ((`Outlicensing`.`is_out` = 'Y') AND (`Company`.`is_live` = 'Y')) AND `Company`.`uid` = 1139 GROUP BY `Outlicensing`.`uid` ORDER BY `Outlicensing`.`change_time` DESC LIMIT 3 | | 3 | 3 | 2 |
| 57 | SELECT `Category`.`uid`, `Category`.`name`, `Category`.`parent`, `Category`.`has_children`, `Category`.`show_children`, `Category`.`show_grandchildren`, `Category`.`members`, `Category`.`num_children`, `Category`.`root`, `Category`.`restricted`, `Category`.`clan`, `Category`.`lft`, `Category`.`rgt`, `Category`.`level`, `Categorisation`.`id`, `Categorisation`.`company_id`, `Categorisation`.`buysell`, `Categorisation`.`category_id`, `Categorisation`.`browse_category_id`, `Categorisation`.`cat_type`, `Categorisation`.`story_id`, `Categorisation`.`network_id` FROM `category` AS `Category` JOIN `categorisation` AS `Categorisation` ON (`Categorisation`.`company_id` IN (19341, 19405, 18727) AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="L" ORDER BY `Category`.`root` ASC, `Category`.`clan` ASC, `Category`.`parent` ASC, `Category`.`name` ASC | | 29 | 29 | 0 |
| 58 | SELECT `Inlicensing`.`uid`, `Inlicensing`.`slug`, `Inlicensing`.`title`, `Inlicensing`.`change_time`, `Category`.`uid` FROM `licopp` AS `Inlicensing` LEFT JOIN categorisation AS `Categorisation` ON (`Categorisation`.`company_id` = `Inlicensing`.`uid` AND `Categorisation`.`cat_type` = 'P') LEFT JOIN category AS `Category` ON (`Category`.`uid` = `Categorisation`.`category_id`) LEFT JOIN `person` AS `Person` ON (`Inlicensing`.`contact_id` = `Person`.`uid`) LEFT JOIN `development_statuses` AS `DevelopmentStatus` ON (`Inlicensing`.`devstatus` = `DevelopmentStatus`.`id`) LEFT JOIN `update_rec` AS `UpdateRecord` ON (`Inlicensing`.`update_id` = `UpdateRecord`.`uid`) LEFT JOIN `company` AS `Company` ON (`Inlicensing`.`company_id` = `Company`.`uid`) LEFT JOIN `licopps_sites` AS `InlicensingSite` ON (`InlicensingSite`.`licopp_id` = `Inlicensing`.`uid`) WHERE `InlicensingSite`.`site_id` = 1 AND ((`Inlicensing`.`is_out` = 'N') AND (`Company`.`is_live` = 'Y')) AND `Company`.`uid` = 1139 GROUP BY `Inlicensing`.`uid` ORDER BY `Inlicensing`.`change_time` DESC LIMIT 3 | | 3 | 3 | 1 |
| 59 | SELECT `Category`.`uid`, `Category`.`name`, `Category`.`parent`, `Category`.`has_children`, `Category`.`show_children`, `Category`.`show_grandchildren`, `Category`.`members`, `Category`.`num_children`, `Category`.`root`, `Category`.`restricted`, `Category`.`clan`, `Category`.`lft`, `Category`.`rgt`, `Category`.`level`, `Categorisation`.`id`, `Categorisation`.`company_id`, `Categorisation`.`buysell`, `Categorisation`.`category_id`, `Categorisation`.`browse_category_id`, `Categorisation`.`cat_type`, `Categorisation`.`story_id`, `Categorisation`.`network_id` FROM `category` AS `Category` JOIN `categorisation` AS `Categorisation` ON (`Categorisation`.`company_id` IN (19406, 19393, 18815) AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="P" ORDER BY `Category`.`root` ASC, `Category`.`clan` ASC, `Category`.`parent` ASC, `Category`.`name` ASC | | 36 | 36 | 0 |
All rights reserved. Terms and Conditions | Contact us