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

Companies

Companies

Displaying 1..10 of 229 - per page Next page
Order by
Labtec GmbH provides innovative Product Development and Manufacturing Services all over the world. More
One Nucleus is a membership organisation for international life science and healthcare companies, based in Cambridge and London UK, the heart of Europe’s largest life science cluster More
The NIH supports and conducts basic, clinical, and translational medical research, and investigates the causes, treatments, and cures for both common and rare diseases. More
Spanish public research organisation with 126 centres covering all knowledge areas and highly active in collaborating with the industry. More
Technology Marketing and Licensing for The University of Nebraska Medical Center More
Medical School - Teaching Hospital - Research Institution More
The aim of St George’s University of London (SGUL) is to promote the prevention and treatment of diseases via excellence in research, teaching, innovation and clinical practice. . 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
Ramot at Tel Aviv University Ltd, is the technology transfer company of Tel Aviv University (TAU). More
UMIP is The University of Manchester’s agent for Intellectual Property (IP) commercialisation www.umip.com More
Displaying 1..10 of 229 - 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 265 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `company`27272
2DESCRIBE `condet`17172
3DESCRIBE `countrycode`448
4DESCRIBE `person`15158
5DESCRIBE `account`29292
6DESCRIBE `product_legacy`661
7DESCRIBE `sales_people`662
8DESCRIBE `profile`14143
9DESCRIBE `currencies`774
10DESCRIBE `update_rec`779
11DESCRIBE `user`24241
12DESCRIBE `enquiry`14145
13DESCRIBE `module_types`661
14DESCRIBE `dms_companies`26264
15DESCRIBE `dms_releases`10107
16DESCRIBE `dms_categories`448
17DESCRIBE `dms_clinical_areas`442
18DESCRIBE `dms_categories_dms_releases`222
19DESCRIBE `dms_clinical_areas_dms_releases`220
20DESCRIBE `dms_releases_sites`551
21DESCRIBE `licopp`23239
22DESCRIBE `development_statuses`558
23DESCRIBE `category`14142
24DESCRIBE `categories_sites`553
25DESCRIBE `categorisation`8825
26DESCRIBE `licopps_sites`331
27DESCRIBE `service`15152
28DESCRIBE `press_release`131317
29DESCRIBE `press_releases_sites`553
30DESCRIBE `story`12121
31DESCRIBE `sites_stories`559
32DESCRIBE `story_assoc`445
33DESCRIBE `companies_sites`332
34DESCRIBE `categories_users`221
35DESCRIBE `authority`337
36DESCRIBE `sites_users`559
37DESCRIBE `products`8828
38DESCRIBE `sites`551
39SELECT `Site`.`id`, `Site`.`name`, `Site`.`email_domain`, `Site`.`short_name`, `Site`.`brand` FROM `sites` AS `Site` WHERE `Site`.`id` = 1 LIMIT 1112
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` = 527 ORDER BY `Category`.`name` ASC 6612
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 (528, 529, 530, 531, 532, 533) ORDER BY `name` ASC 003
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 20202
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 31631613
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 887
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 = 527119
47SELECT c.uid, c.name, c.level FROM category c WHERE c.lft <= "1413" AND c.rgt >= "1426" AND c.level > 1 ORDER BY c.level 111
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` = 527 LIMIT 1119
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` = (527) ORDER BY `name` ASC 661
(website_slave) 2 queries took 1222 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` >= '1413' AND `IndustrySector`.`rgt` <= '1426') 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 101010444
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` >= '1413' AND `IndustrySector`.`rgt` <= '1426') LEFT JOIN `companies_sites` AS `CompanySite` ON (`CompanySite`.`company_id` = `Company`.`uid`) WHERE `CompanySite`.`site_id` = 1 AND `Company`.`is_live` = 'Y' 11778
(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 1 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 ("Academic/Research") ORDER BY MATCH (`MarketResearchReport`.`name`, `MarketResearchReport`.`description`, `MarketResearchReport`.`summary`, `MarketResearchReport`.`content`, `MarketResearchReport`.`isbn`, `MarketResearchReport`.`code`) AGAINST ("Academic/Research") DESC , MarketResearchReport.published DESC LIMIT 1010101