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

Companies

Companies

Displaying 1..10 of 3857 - per page Next page
Order by
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
Innovaro Pharmalicensing.com - the leading global resource for partnering, licensing, and business development. 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
One of the leading manufacturer of Antihemorrhoidal and Female Health Care Products in Germany 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
Almirall researches, develops, produces and markets proprietary R&D medicines and those under licence with the aim of improving people's health and well-being. More
Displaying 1..10 of 3857 - 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 209 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `company`27271
2DESCRIBE `condet`17172
3DESCRIBE `countrycode`447
4DESCRIBE `person`15154
5DESCRIBE `account`29292
6DESCRIBE `product_legacy`662
7DESCRIBE `sales_people`667
8DESCRIBE `profile`14144
9DESCRIBE `currencies`771
10DESCRIBE `update_rec`771
11DESCRIBE `user`24242
12DESCRIBE `enquiry`14146
13DESCRIBE `module_types`663
14DESCRIBE `dms_companies`26266
15DESCRIBE `dms_releases`101014
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`23232
22DESCRIBE `development_statuses`554
23DESCRIBE `category`14146
24DESCRIBE `categories_sites`553
25DESCRIBE `categorisation`883
26DESCRIBE `licopps_sites`334
27DESCRIBE `service`15152
28DESCRIBE `press_release`13135
29DESCRIBE `press_releases_sites`552
30DESCRIBE `story`12124
31DESCRIBE `sites_stories`552
32DESCRIBE `story_assoc`442
33DESCRIBE `companies_sites`333
34DESCRIBE `categories_users`221
35DESCRIBE `authority`331
36DESCRIBE `sites_users`552
37DESCRIBE `products`8817
38DESCRIBE `sites`554
39SELECT `Site`.`id`, `Site`.`name`, `Site`.`email_domain`, `Site`.`short_name`, `Site`.`brand` FROM `sites` AS `Site` WHERE `Site`.`id` = 1 LIMIT 11129
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 11112
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 11111114
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 3163164
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` = 2 ORDER BY `Category`.`name` ASC 434313
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 (4, 3, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 37, 36, 38, 39, 40, 41, 42, 43, 44, 45) ORDER BY `name` ASC 007
46SELECT c.lft, c.rgt FROM category c WHERE c.uid = 2111
47SELECT c.uid, c.name, c.level FROM category c WHERE c.lft <= "2249" AND c.rgt >= "2336" AND c.level > 1 ORDER BY c.level 111
48SELECT `Category`.`lft`, `Category`.`rgt`, `Category`.`uid` 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`.`uid` = 2 LIMIT 1112
(website_slave) 2 queries took 612 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Company`.`uid`, `Company`.`slug`, `Company`.`name`, `Company`.`summary`, `Company`.`is_customer` FROM `company` AS `Company` INNER JOIN condet AS `ContactGeographicLocation` ON (`Company`.`condet_id` = `ContactGeographicLocation`.`uid`) INNER JOIN category AS `GeographicLocation` ON (`GeographicLocation`.`uid` = `ContactGeographicLocation`.`country` AND `GeographicLocation`.`lft` >= '2249' AND `GeographicLocation`.`rgt` <= '2336') LEFT JOIN `companies_sites` AS `CompanySite` ON (`CompanySite`.`company_id` = `Company`.`uid`) WHERE `CompanySite`.`site_id` = 1 AND ((`GeographicLocation`.`lft` >= '2249') AND (`GeographicLocation`.`rgt` <= '2336')) AND `Company`.`is_live` = 'Y' GROUP BY `Company`.`uid` ORDER BY `Company`.`is_customer` DESC, `Company`.`viewed_counter` DESC, `Company`.`name` ASC LIMIT 101010354
2SELECT COUNT(DISTINCT Company.uid) AS `count` FROM `company` AS `Company` INNER JOIN condet AS `ContactGeographicLocation` ON (`Company`.`condet_id` = `ContactGeographicLocation`.`uid`) INNER JOIN category AS `GeographicLocation` ON (`GeographicLocation`.`uid` = `ContactGeographicLocation`.`country` AND `GeographicLocation`.`lft` >= '2249' AND `GeographicLocation`.`rgt` <= '2336') LEFT JOIN `companies_sites` AS `CompanySite` ON (`CompanySite`.`company_id` = `Company`.`uid`) WHERE `CompanySite`.`site_id` = 1 AND ((`GeographicLocation`.`lft` >= '2249') AND (`GeographicLocation`.`rgt` <= '2336')) AND `Company`.`is_live` = 'Y' 11258
(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 2 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 ("Europe") ORDER BY MATCH (`MarketResearchReport`.`name`, `MarketResearchReport`.`description`, `MarketResearchReport`.`summary`, `MarketResearchReport`.`content`, `MarketResearchReport`.`isbn`, `MarketResearchReport`.`code`) AGAINST ("Europe") DESC , MarketResearchReport.published DESC LIMIT 1010102