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

Companies

Companies

Displaying 1..10 of 307 - per page Next page
Order by
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
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
Ramot at Tel Aviv University Ltd, is the technology transfer company of Tel Aviv University (TAU). More
CrystecPharma applies the latest supercritical fluid (SCF) technologies to improve the design and performance of medicines 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
Zinda Pharma Limited is located in Montreal- Canada, one of the two Pharma hubs in Canada. Zinda Pharma is a subsidiary of Balcorp Group Limited. More
Displaying 1..10 of 307 - 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 437 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `company`272718
2DESCRIBE `condet`171717
3DESCRIBE `countrycode`445
4DESCRIBE `person`15154
5DESCRIBE `account`292915
6DESCRIBE `product_legacy`662
7DESCRIBE `sales_people`664
8DESCRIBE `profile`14145
9DESCRIBE `currencies`7714
10DESCRIBE `update_rec`775
11DESCRIBE `user`24245
12DESCRIBE `enquiry`14144
13DESCRIBE `module_types`663
14DESCRIBE `dms_companies`262625
15DESCRIBE `dms_releases`10103
16DESCRIBE `dms_categories`441
17DESCRIBE `dms_clinical_areas`441
18DESCRIBE `dms_categories_dms_releases`227
19DESCRIBE `dms_clinical_areas_dms_releases`222
20DESCRIBE `dms_releases_sites`553
21DESCRIBE `licopp`232318
22DESCRIBE `development_statuses`557
23DESCRIBE `category`141413
24DESCRIBE `categories_sites`5515
25DESCRIBE `categorisation`886
26DESCRIBE `licopps_sites`333
27DESCRIBE `service`151522
28DESCRIBE `press_release`131332
29DESCRIBE `press_releases_sites`552
30DESCRIBE `story`121212
31DESCRIBE `sites_stories`558
32DESCRIBE `story_assoc`4415
33DESCRIBE `companies_sites`332
34DESCRIBE `categories_users`221
35DESCRIBE `authority`331
36DESCRIBE `sites_users`554
37DESCRIBE `products`882
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 111134
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 1111111
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` = 651 ORDER BY `Category`.`name` ASC 252533
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 (2049, 1623, 1624, 1625, 2131, 1626, 2132, 1627, 1628, 1629, 1630, 2134, 652, 653, 1631, 2130, 2133, 1633, 1638, 1634, 1635, 1636, 1637, 1639, 1640) ORDER BY `name` ASC 0026
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 882
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 = 6511122
47SELECT c.uid, c.name, c.level FROM category c WHERE c.lft <= "3505" AND c.rgt >= "3556" 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` = 651 LIMIT 11110
(website_slave) 2 queries took 1847 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` >= '3505' AND `TherapeuticTarget`.`rgt` <= '3556') LEFT JOIN `companies_sites` AS `CompanySite` ON (`CompanySite`.`company_id` = `Company`.`uid`) WHERE `CompanySite`.`site_id` = 1 AND ((`TherapeuticTarget`.`lft` >= 3505) AND (`TherapeuticTarget`.`rgt` <= 3556)) AND `Company`.`is_live` = 'Y' GROUP BY `Company`.`uid` ORDER BY `Company`.`is_customer` DESC, `Company`.`viewed_counter` DESC, `Company`.`name` ASC LIMIT 101010789
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` >= '3505' AND `TherapeuticTarget`.`rgt` <= '3556') LEFT JOIN `companies_sites` AS `CompanySite` ON (`CompanySite`.`company_id` = `Company`.`uid`) WHERE `CompanySite`.`site_id` = 1 AND ((`TherapeuticTarget`.`lft` >= 3505) AND (`TherapeuticTarget`.`rgt` <= 3556)) AND `Company`.`is_live` = 'Y' 111058
(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 19 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 ("Immune related disorders") ORDER BY MATCH (`MarketResearchReport`.`name`, `MarketResearchReport`.`description`, `MarketResearchReport`.`summary`, `MarketResearchReport`.`content`, `MarketResearchReport`.`isbn`, `MarketResearchReport`.`code`) AGAINST ("Immune related disorders") DESC , MarketResearchReport.published DESC LIMIT 10101019