Warning (512): /home/pharma/website/current/cakephp/app/pharmalicensing/tmp/cache/ is not writable [CORE/cake/libs/cache/file.php, line 267]
Companies: Diagnostic
RSS Feeds
Search

Companies

Companies

Displaying 1..10 of 320 - per page Next page
Order by
Technology Marketing and Licensing for The University of Nebraska Medical Center More
Government Research & Biopharmaceutical Production More
Medical School - Teaching Hospital - Research Institution More
Inven2 AS identifies, protects and commercialises inventions and discoveries of the University of Oslo, Oslo University Hospital and other health enterprises in the south-east of Norway. More
INNOPHARMAX is a specialty pharmaceutical company focused in the treatment of infectious diseases,immunology and oncology via DDS technology to improve safety & effectivene of currently available drug More
Medilink UK is the industry association for Life Science SMEs. More
Dynamic consumer products company, and full-service contract manufacturer, adept in the development, manufacture & marketing of unique OTC products under its female health, psoriasis & outdoor brands. More
Take advantage of the inventions and technologies from the leading university in Poland. More
Bonac Corporation of Japan is a research oriented company with a focus in nucleic acid chemistry. Bonac has developed a novel proprietary platform technology for RNAi. More
The worldwide leader in market research publications, advisory services and consulting More
Displaying 1..10 of 320 - per page Next page
Order by

Related Reports

© Copyright 1998-2012 Innovaro Europe Ltd Innovaro Corporation All rights reserved. Terms and Conditions | Contact us

(website) 49 queries took 248 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `company`27276
2DESCRIBE `condet`17172
3DESCRIBE `countrycode`4410
4DESCRIBE `person`151515
5DESCRIBE `account`292910
6DESCRIBE `product_legacy`661
7DESCRIBE `sales_people`661
8DESCRIBE `profile`14143
9DESCRIBE `currencies`771
10DESCRIBE `update_rec`776
11DESCRIBE `user`24242
12DESCRIBE `enquiry`14143
13DESCRIBE `module_types`662
14DESCRIBE `dms_companies`26262
15DESCRIBE `dms_releases`10102
16DESCRIBE `dms_categories`441
17DESCRIBE `dms_clinical_areas`442
18DESCRIBE `dms_categories_dms_releases`221
19DESCRIBE `dms_clinical_areas_dms_releases`221
20DESCRIBE `dms_releases_sites`553
21DESCRIBE `licopp`23232
22DESCRIBE `development_statuses`554
23DESCRIBE `category`14141
24DESCRIBE `categories_sites`552
25DESCRIBE `categorisation`8814
26DESCRIBE `licopps_sites`331
27DESCRIBE `service`15152
28DESCRIBE `press_release`131328
29DESCRIBE `press_releases_sites`553
30DESCRIBE `story`12126
31DESCRIBE `sites_stories`5515
32DESCRIBE `story_assoc`441
33DESCRIBE `companies_sites`331
34DESCRIBE `categories_users`221
35DESCRIBE `authority`330
36DESCRIBE `sites_users`5510
37DESCRIBE `products`881
38DESCRIBE `sites`556
39SELECT `Site`.`id`, `Site`.`name`, `Site`.`email_domain`, `Site`.`short_name`, `Site`.`brand` FROM `sites` AS `Site` WHERE `Site`.`id` = 1 LIMIT 1111
40SELECT `Category`.`uid`, `Category`.`name` FROM `category` AS `Category` LEFT JOIN `category` AS `Parent` ON (`Category`.`parent` = `Parent`.`uid`) LEFT JOIN `categories_sites` AS `CategorySite` ON (`CategorySite`.`category_id` = `Category`.`uid`) WHERE `CategorySite`.`site_id` = 1 AND `Category`.`parent` = 432 ORDER BY `Category`.`name` ASC 131316
41SELECT `Child`.`uid`, `Child`.`name`, `Child`.`parent`, `Child`.`has_children`, `Child`.`show_children`, `Child`.`show_grandchildren`, `Child`.`members`, `Child`.`num_children`, `Child`.`root`, `Child`.`restricted`, `Child`.`clan`, `Child`.`lft`, `Child`.`rgt`, `Child`.`level` FROM `category` AS `Child` WHERE `Child`.`parent` IN (2058, 2057, 433, 2056, 434, 435, 436, 452, 437, 448, 438, 447, 451) ORDER BY `name` ASC 10100
42SELECT `Category`.`uid`, `Category`.`name` FROM `category` AS `Category` LEFT JOIN `category` AS `Parent` ON (`Category`.`parent` = `Parent`.`uid`) LEFT JOIN `categories_sites` AS `CategorySite` ON (`CategorySite`.`category_id` = `Category`.`uid`) WHERE `CategorySite`.`site_id` = 1 AND `Category`.`parent` = 560 ORDER BY `Category`.`name` ASC 20204
43SELECT `Child`.`uid`, `Child`.`name`, `Child`.`parent`, `Child`.`has_children`, `Child`.`show_children`, `Child`.`show_grandchildren`, `Child`.`members`, `Child`.`num_children`, `Child`.`root`, `Child`.`restricted`, `Child`.`clan`, `Child`.`lft`, `Child`.`rgt`, `Child`.`level` FROM `category` AS `Child` WHERE `Child`.`parent` IN (1476, 561, 575, 582, 595, 603, 635, 616, 1477, 631, 641, 651, 562, 654, 662, 572, 1479, 670, 679, 689) ORDER BY `name` ASC 3163161
44SELECT `Category`.`uid`, `Category`.`name` FROM `category` AS `Category` LEFT JOIN `category` AS `Parent` ON (`Category`.`parent` = `Parent`.`uid`) LEFT JOIN `categories_sites` AS `CategorySite` ON (`CategorySite`.`category_id` = `Category`.`uid`) WHERE `CategorySite`.`site_id` = 1 AND `Category`.`parent` = 1 ORDER BY `Category`.`name` ASC 885
45SELECT `Child`.`uid`, `Child`.`name`, `Child`.`parent`, `Child`.`has_children`, `Child`.`show_children`, `Child`.`show_grandchildren`, `Child`.`members`, `Child`.`num_children`, `Child`.`root`, `Child`.`restricted`, `Child`.`clan`, `Child`.`lft`, `Child`.`rgt`, `Child`.`level` FROM `category` AS `Child` WHERE `Child`.`parent` IN (72, 46, 69, 212, 2, 119, 145, 244) ORDER BY `name` ASC 1871871
46SELECT c.lft, c.rgt FROM category c WHERE c.uid = 4321125
47SELECT c.uid, c.name, c.level FROM category c WHERE c.lft <= "1467" AND c.rgt >= "1514" AND c.level > 1 ORDER BY c.level 112
48SELECT `IndustrySector`.`lft`, `IndustrySector`.`rgt`, `IndustrySector`.`uid` FROM `category` AS `IndustrySector` LEFT JOIN `category` AS `Parent` ON (`IndustrySector`.`parent` = `Parent`.`uid`) LEFT JOIN `categories_sites` AS `CategorySite` ON (`CategorySite`.`category_id` = `IndustrySector`.`uid`) WHERE `CategorySite`.`site_id` = 1 AND `IndustrySector`.`uid` = 432 LIMIT 11114
49SELECT `Child`.`uid`, `Child`.`name`, `Child`.`parent`, `Child`.`has_children`, `Child`.`show_children`, `Child`.`show_grandchildren`, `Child`.`members`, `Child`.`num_children`, `Child`.`root`, `Child`.`restricted`, `Child`.`clan`, `Child`.`lft`, `Child`.`rgt`, `Child`.`level` FROM `category` AS `Child` WHERE `Child`.`parent` = (432) ORDER BY `name` ASC 13137
(website_slave) 2 queries took 1921 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Company`.`uid`, `Company`.`slug`, `Company`.`name`, `Company`.`summary`, `Company`.`is_customer` FROM `company` AS `Company` INNER JOIN categorisation AS `CategorisationIndustrySector` ON (`CategorisationIndustrySector`.`company_id` = `Company`.`uid` AND `CategorisationIndustrySector`.`cat_type` = 'C') INNER JOIN category AS `IndustrySector` ON (`IndustrySector`.`uid` = `CategorisationIndustrySector`.`category_id` AND `IndustrySector`.`lft` >= '1467' AND `IndustrySector`.`rgt` <= '1514') LEFT JOIN `companies_sites` AS `CompanySite` ON (`CompanySite`.`company_id` = `Company`.`uid`) WHERE `CompanySite`.`site_id` = 1 AND `Company`.`is_live` = 'Y' GROUP BY `Company`.`uid` ORDER BY `Company`.`is_customer` DESC, `Company`.`viewed_counter` DESC, `Company`.`name` ASC LIMIT 101010829
2SELECT COUNT(DISTINCT Company.uid) AS `count` FROM `company` AS `Company` INNER JOIN categorisation AS `CategorisationIndustrySector` ON (`CategorisationIndustrySector`.`company_id` = `Company`.`uid` AND `CategorisationIndustrySector`.`cat_type` = 'C') INNER JOIN category AS `IndustrySector` ON (`IndustrySector`.`uid` = `CategorisationIndustrySector`.`category_id` AND `IndustrySector`.`lft` >= '1467' AND `IndustrySector`.`rgt` <= '1514') LEFT JOIN `companies_sites` AS `CompanySite` ON (`CompanySite`.`company_id` = `Company`.`uid`) WHERE `CompanySite`.`site_id` = 1 AND `Company`.`is_live` = 'Y' 111092
(default) 0 query took ms
NrQueryErrorAffectedNum. rowsTook (ms)
(report) 1 query took 2 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `reports`17172
(report_slave) 1 query took 12 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `MarketResearchReport`.`id`, `MarketResearchReport`.`slug`, `MarketResearchReport`.`name`, `MarketResearchReport`.`description`, `MarketResearchReport`.`summary`, `MarketResearchReport`.`content`, `MarketResearchReport`.`isbn`, `MarketResearchReport`.`code`, `MarketResearchReport`.`pages`, `MarketResearchReport`.`published`, `MarketResearchReport`.`net_price_usd`, `MarketResearchReport`.`active`, `MarketResearchReport`.`publisher_id`, `MarketResearchReport`.`views`, `MarketResearchReport`.`tags`, `MarketResearchReport`.`created`, `MarketResearchReport`.`modified` FROM `reports` AS `MarketResearchReport` WHERE `MarketResearchReport`.`active` = 1 AND MATCH (`MarketResearchReport`.`name`, `MarketResearchReport`.`description`, `MarketResearchReport`.`summary`, `MarketResearchReport`.`content`, `MarketResearchReport`.`isbn`, `MarketResearchReport`.`code`) AGAINST ("Diagnostic") ORDER BY MATCH (`MarketResearchReport`.`name`, `MarketResearchReport`.`description`, `MarketResearchReport`.`summary`, `MarketResearchReport`.`content`, `MarketResearchReport`.`isbn`, `MarketResearchReport`.`code`) AGAINST ("Diagnostic") DESC , MarketResearchReport.published DESC LIMIT 10101012