Warning (512): /home/pharma/website/current/cakephp/app/pharmalicensing/tmp/cache/ is not writable [CORE/cake/libs/cache/file.php, line 267]
Innovaro Pharmalicensing's service company directory enables you to meet your outsourcing needs quickly.
Search the Innovaro Pharmalicensing service company directory by keyword. Alternatively our advanced search allows you to query by industry sector, therapeutic target and development phase.
Pharmaceutical Stability Studies as in ICH/CPMP guidelines
moreFull manufacturing outsourcing in a complete GMPs/ISO9002 facility
more| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | DESCRIBE `service` | 15 | 15 | 5 | |
| 2 | DESCRIBE `company` | 27 | 27 | 1 | |
| 3 | DESCRIBE `condet` | 17 | 17 | 2 | |
| 4 | DESCRIBE `countrycode` | 4 | 4 | 17 | |
| 5 | DESCRIBE `person` | 15 | 15 | 5 | |
| 6 | DESCRIBE `account` | 29 | 29 | 2 | |
| 7 | DESCRIBE `product_legacy` | 6 | 6 | 1 | |
| 8 | DESCRIBE `sales_people` | 6 | 6 | 3 | |
| 9 | DESCRIBE `profile` | 14 | 14 | 1 | |
| 10 | DESCRIBE `currencies` | 7 | 7 | 17 | |
| 11 | DESCRIBE `update_rec` | 7 | 7 | 2 | |
| 12 | DESCRIBE `user` | 24 | 24 | 3 | |
| 13 | DESCRIBE `enquiry` | 14 | 14 | 19 | |
| 14 | DESCRIBE `module_types` | 6 | 6 | 4 | |
| 15 | DESCRIBE `dms_companies` | 26 | 26 | 9 | |
| 16 | DESCRIBE `dms_releases` | 10 | 10 | 4 | |
| 17 | DESCRIBE `dms_categories` | 4 | 4 | 4 | |
| 18 | DESCRIBE `dms_clinical_areas` | 4 | 4 | 8 | |
| 19 | DESCRIBE `dms_categories_dms_releases` | 2 | 2 | 2 | |
| 20 | DESCRIBE `dms_clinical_areas_dms_releases` | 2 | 2 | 7 | |
| 21 | DESCRIBE `dms_releases_sites` | 5 | 5 | 6 | |
| 22 | DESCRIBE `licopp` | 23 | 23 | 12 | |
| 23 | DESCRIBE `development_statuses` | 5 | 5 | 5 | |
| 24 | DESCRIBE `category` | 14 | 14 | 2 | |
| 25 | DESCRIBE `categories_sites` | 5 | 5 | 13 | |
| 26 | DESCRIBE `categorisation` | 8 | 8 | 17 | |
| 27 | DESCRIBE `licopps_sites` | 3 | 3 | 6 | |
| 28 | DESCRIBE `press_release` | 13 | 13 | 19 | |
| 29 | DESCRIBE `press_releases_sites` | 5 | 5 | 5 | |
| 30 | DESCRIBE `story` | 12 | 12 | 47 | |
| 31 | DESCRIBE `sites_stories` | 5 | 5 | 8 | |
| 32 | DESCRIBE `story_assoc` | 4 | 4 | 3 | |
| 33 | DESCRIBE `companies_sites` | 3 | 3 | 3 | |
| 34 | DESCRIBE `categories_users` | 2 | 2 | 57 | |
| 35 | DESCRIBE `authority` | 3 | 3 | 21 | |
| 36 | DESCRIBE `sites_users` | 5 | 5 | 11 | |
| 37 | DESCRIBE `sites` | 5 | 5 | 38 | |
| 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 | 10 | |
| 39 | SELECT `Category`.`uid`, `Category`.`name` FROM `category` AS `Category` WHERE `Category`.`parent` = 712 ORDER BY `Category`.`name` ASC | 13 | 13 | 1 | |
| 40 | SELECT DISTINCT `Service`.`id`, `Service`.`slug`, `Service`.`headline`, `Service`.`detail` FROM `service` AS `Service` INNER JOIN company AS `ParentCompany` ON (`ParentCompany`.`uid`=`Service`.`company_id` AND `ParentCompany`.`is_live`="Y") LEFT JOIN `person` AS `Person` ON (`Service`.`contact_id` = `Person`.`uid`) LEFT JOIN `user` AS `UpdateUser` ON (`Service`.`last_modified_by_user_id` = `UpdateUser`.`uid`) LEFT JOIN `company` AS `Company` ON (`Service`.`company_id` = `Company`.`uid`) WHERE `Service`.`is_live` > 0 ORDER BY `Service`.`viewed_counter` DESC, `Service`.`is_live` DESC LIMIT 5 | 5 | 5 | 19 | |
| 41 | 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 (114, 2, 179, 230, 231) AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="V" ORDER BY `Category`.`root` ASC, `Category`.`clan` ASC, `Category`.`parent` ASC, `Category`.`name` ASC | 10 | 10 | 2 | |
| 42 | SELECT DISTINCT `Service`.`id`, `Service`.`slug`, `Service`.`headline`, `Service`.`detail` FROM `service` AS `Service` INNER JOIN company AS `ParentCompany` ON (`ParentCompany`.`uid`=`Service`.`company_id` AND `ParentCompany`.`is_live`="Y") LEFT JOIN `person` AS `Person` ON (`Service`.`contact_id` = `Person`.`uid`) LEFT JOIN `user` AS `UpdateUser` ON (`Service`.`last_modified_by_user_id` = `UpdateUser`.`uid`) LEFT JOIN `company` AS `Company` ON (`Service`.`company_id` = `Company`.`uid`) WHERE `Service`.`is_live` > 0 ORDER BY `Service`.`modified` DESC, `Service`.`is_live` DESC LIMIT 5 | 5 | 5 | 10 | |
| 43 | 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 (237, 246, 245, 244, 234) AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="V" ORDER BY `Category`.`root` ASC, `Category`.`clan` ASC, `Category`.`parent` ASC, `Category`.`name` ASC | 1 | 1 | 8 | |
| 44 | SELECT `Category`.`uid`, `Category`.`name` FROM `category` AS `Category` LEFT JOIN `categories_sites` AS `CategorySite` ON (`CategorySite`.`category_id` = `Category`.`uid`) WHERE `CategorySite`.`site_id` = 1 AND `Category`.`parent` = 712 ORDER BY `Category`.`name` ASC | 13 | 13 | 14 |