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

Companies

Companies

Displaying 1..10 of 620 - per page Next page
Order by
Novartis Consumer Health is a world leader in self-medication products. The company welcomes the opportunity to review business opportunities for new products and technologies which bring innovations More
APR is a private, independent, integrated Healhcare Company focused on Delivering, Funding and Supporting Innovation in Healthcare. More
Zambon Company SpA is a privately-held multinational pharmaceutical and chemical company that looks for in-licensing products in late stage development or already in the market.. More
Specialty pharmaceutical and drug delivery company engaged in the research and manufacture of collagen-based technologies for local drug delivery, surgical implants, advanced wound care and oncology. More
Amarin is engaged in the development of innovative pharmaceutical products using its proprietary topical and transdermal drug delivery technologies and know-how. More
Alliance pharmaceuticals is a dynamic UK pharmaceutical company with a successful acquisition and partnership track record More
NYCOMED Regional Business Development, new; near to market presciption drugs for region Northern Europe More
Labtec GmbH provides innovative Product Development and Manufacturing Services all over the world. More
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
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
Displaying 1..10 of 620 - 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) 48 queries took 95 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `company`27272
2DESCRIBE `condet`17172
3DESCRIBE `countrycode`444
4DESCRIBE `person`15151
5DESCRIBE `account`29291
6DESCRIBE `product_legacy`661
7DESCRIBE `sales_people`662
8DESCRIBE `profile`14143
9DESCRIBE `currencies`771
10DESCRIBE `update_rec`771
11DESCRIBE `user`24242
12DESCRIBE `enquiry`14142
13DESCRIBE `module_types`661
14DESCRIBE `dms_companies`26262
15DESCRIBE `dms_releases`10102
16DESCRIBE `dms_categories`441
17DESCRIBE `dms_clinical_areas`447
18DESCRIBE `dms_categories_dms_releases`222
19DESCRIBE `dms_clinical_areas_dms_releases`223
20DESCRIBE `dms_releases_sites`552
21DESCRIBE `licopp`23232
22DESCRIBE `development_statuses`551
23DESCRIBE `category`14143
24DESCRIBE `categories_sites`551
25DESCRIBE `categorisation`882
26DESCRIBE `licopps_sites`332
27DESCRIBE `service`15154
28DESCRIBE `press_release`13131
29DESCRIBE `press_releases_sites`554
30DESCRIBE `story`12122
31DESCRIBE `sites_stories`551
32DESCRIBE `story_assoc`442
33DESCRIBE `companies_sites`331
34DESCRIBE `categories_users`221
35DESCRIBE `authority`332
36DESCRIBE `sites_users`551
37DESCRIBE `products`881
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 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` = 297 ORDER BY `Category`.`name` ASC 11118
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 (527, 505, 303, 432, 319, 798, 453, 514, 298, 805, 534) ORDER BY `name` ASC 1111114
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` = 595 ORDER BY `Category`.`name` ASC 997
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 (1886, 1890, 600, 1929, 2119, 2120, 2118, 1958, 1960) ORDER BY `name` ASC 73730
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 880
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 = 595110
47SELECT c.uid, c.name, c.level FROM category c WHERE c.lft <= "2999" AND c.rgt >= "3164" AND c.level > 1 ORDER BY c.level 110
48SELECT `TherapeuticTarget`.`lft`, `TherapeuticTarget`.`rgt`, `TherapeuticTarget`.`uid` FROM `category` AS `TherapeuticTarget` LEFT JOIN `category` AS `Parent` ON (`TherapeuticTarget`.`parent` = `Parent`.`uid`) LEFT JOIN `categories_sites` AS `CategorySite` ON (`CategorySite`.`category_id` = `TherapeuticTarget`.`uid`) WHERE `CategorySite`.`site_id` = 1 AND `TherapeuticTarget`.`uid` = 595 LIMIT 1110
(website_slave) 2 queries took 1157 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Company`.`uid`, `Company`.`slug`, `Company`.`name`, `Company`.`summary`, `Company`.`is_customer` FROM `company` AS `Company` INNER JOIN categorisation AS `CategorisationTherapeuticTarget` ON (`CategorisationTherapeuticTarget`.`company_id` = `Company`.`uid` AND `CategorisationTherapeuticTarget`.`cat_type` = 'C') INNER JOIN category AS `TherapeuticTarget` ON (`TherapeuticTarget`.`uid` = `CategorisationTherapeuticTarget`.`category_id` AND `TherapeuticTarget`.`lft` >= '2999' AND `TherapeuticTarget`.`rgt` <= '3164') LEFT JOIN `companies_sites` AS `CompanySite` ON (`CompanySite`.`company_id` = `Company`.`uid`) WHERE `CompanySite`.`site_id` = 1 AND ((`TherapeuticTarget`.`lft` >= 2999) AND (`TherapeuticTarget`.`rgt` <= 3164)) AND `Company`.`is_live` = 'Y' GROUP BY `Company`.`uid` ORDER BY `Company`.`is_customer` DESC, `Company`.`viewed_counter` DESC, `Company`.`name` ASC LIMIT 101010557
2SELECT COUNT(DISTINCT Company.uid) AS `count` FROM `company` AS `Company` INNER JOIN categorisation AS `CategorisationTherapeuticTarget` ON (`CategorisationTherapeuticTarget`.`company_id` = `Company`.`uid` AND `CategorisationTherapeuticTarget`.`cat_type` = 'C') INNER JOIN category AS `TherapeuticTarget` ON (`TherapeuticTarget`.`uid` = `CategorisationTherapeuticTarget`.`category_id` AND `TherapeuticTarget`.`lft` >= '2999' AND `TherapeuticTarget`.`rgt` <= '3164') LEFT JOIN `companies_sites` AS `CompanySite` ON (`CompanySite`.`company_id` = `Company`.`uid`) WHERE `CompanySite`.`site_id` = 1 AND ((`TherapeuticTarget`.`lft` >= 2999) AND (`TherapeuticTarget`.`rgt` <= 3164)) AND `Company`.`is_live` = 'Y' 11600
(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 7 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 ("Central Nervous System") ORDER BY MATCH (`MarketResearchReport`.`name`, `MarketResearchReport`.`description`, `MarketResearchReport`.`summary`, `MarketResearchReport`.`content`, `MarketResearchReport`.`isbn`, `MarketResearchReport`.`code`) AGAINST ("Central Nervous System") DESC , MarketResearchReport.published DESC LIMIT 1010107