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

Companies

Companies

Displaying 1..10 of 317 - per page Next page
Order by
KHIDI, provides various services on technology transfer. KHIDI will license and commercialise several technologies of KHIDI's client companies via collaboration with overseas partners. 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
NRC-BRI's Health and Bioprocess Sectors promote and conduct innovative collaborations, services and technology transfers with the biotechnology and pharmaceutical industries. More
Government Research & Biopharmaceutical Production 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
Pharmovation is the technology licensing company of The School of Pharmacy, University of London. 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
Displaying 1..10 of 317 - 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 80 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `company`27271
2DESCRIBE `condet`17172
3DESCRIBE `countrycode`442
4DESCRIBE `person`15156
5DESCRIBE `account`29291
6DESCRIBE `product_legacy`661
7DESCRIBE `sales_people`661
8DESCRIBE `profile`14144
9DESCRIBE `currencies`771
10DESCRIBE `update_rec`771
11DESCRIBE `user`24241
12DESCRIBE `enquiry`14143
13DESCRIBE `module_types`661
14DESCRIBE `dms_companies`26262
15DESCRIBE `dms_releases`10102
16DESCRIBE `dms_categories`441
17DESCRIBE `dms_clinical_areas`441
18DESCRIBE `dms_categories_dms_releases`221
19DESCRIBE `dms_clinical_areas_dms_releases`221
20DESCRIBE `dms_releases_sites`551
21DESCRIBE `licopp`23231
22DESCRIBE `development_statuses`553
23DESCRIBE `category`14141
24DESCRIBE `categories_sites`554
25DESCRIBE `categorisation`881
26DESCRIBE `licopps_sites`331
27DESCRIBE `service`15151
28DESCRIBE `press_release`13132
29DESCRIBE `press_releases_sites`553
30DESCRIBE `story`12121
31DESCRIBE `sites_stories`551
32DESCRIBE `story_assoc`442
33DESCRIBE `companies_sites`332
34DESCRIBE `categories_users`221
35DESCRIBE `authority`331
36DESCRIBE `sites_users`551
37DESCRIBE `products`885
38DESCRIBE `sites`552
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` = 514 ORDER BY `Category`.`name` ASC 12121
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 (515, 516, 517, 518, 519, 520, 521, 522, 523, 524, 525, 526) ORDER BY `name` ASC 001
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 20201
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 3163162
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 884
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 1871870
46SELECT c.lft, c.rgt FROM category c WHERE c.uid = 514110
47SELECT c.uid, c.name, c.level FROM category c WHERE c.lft <= "1875" AND c.rgt >= "1900" 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` = 514 LIMIT 1110
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` = (514) ORDER BY `name` ASC 12121
(website_slave) 2 queries took 1031 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` >= '1875' AND `IndustrySector`.`rgt` <= '1900') 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 101010764
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` >= '1875' AND `IndustrySector`.`rgt` <= '1900') LEFT JOIN `companies_sites` AS `CompanySite` ON (`CompanySite`.`company_id` = `Company`.`uid`) WHERE `CompanySite`.`site_id` = 1 AND `Company`.`is_live` = 'Y' 11267
(default) 0 query took ms
NrQueryErrorAffectedNum. rowsTook (ms)
(report) 1 query took 1 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `reports`17171
(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 ("Non-profit org./Government") ORDER BY MATCH (`MarketResearchReport`.`name`, `MarketResearchReport`.`description`, `MarketResearchReport`.`summary`, `MarketResearchReport`.`content`, `MarketResearchReport`.`isbn`, `MarketResearchReport`.`code`) AGAINST ("Non-profit org./Government") DESC , MarketResearchReport.published DESC LIMIT 1010101