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 25 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `company`27274
2DESCRIBE `condet`17171
3DESCRIBE `countrycode`440
4DESCRIBE `person`15151
5DESCRIBE `account`29291
6DESCRIBE `product_legacy`661
7DESCRIBE `sales_people`660
8DESCRIBE `profile`14141
9DESCRIBE `currencies`771
10DESCRIBE `update_rec`771
11DESCRIBE `user`24241
12DESCRIBE `enquiry`14141
13DESCRIBE `module_types`660
14DESCRIBE `dms_companies`26261
15DESCRIBE `dms_releases`10101
16DESCRIBE `dms_categories`440
17DESCRIBE `dms_clinical_areas`440
18DESCRIBE `dms_categories_dms_releases`220
19DESCRIBE `dms_clinical_areas_dms_releases`220
20DESCRIBE `dms_releases_sites`550
21DESCRIBE `licopp`23231
22DESCRIBE `development_statuses`551
23DESCRIBE `category`14141
24DESCRIBE `categories_sites`550
25DESCRIBE `categorisation`880
26DESCRIBE `licopps_sites`330
27DESCRIBE `service`15151
28DESCRIBE `press_release`13131
29DESCRIBE `press_releases_sites`550
30DESCRIBE `story`12121
31DESCRIBE `sites_stories`550
32DESCRIBE `story_assoc`440
33DESCRIBE `companies_sites`330
34DESCRIBE `categories_users`220
35DESCRIBE `authority`330
36DESCRIBE `sites_users`550
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 1110
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 11110
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 1111110
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 25250
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 000
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 1871870
46SELECT c.lft, c.rgt FROM category c WHERE c.uid = 651112
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 1110
(website_slave) 2 queries took 213 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 101010117
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' 1196
(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 ("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 1010101