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

        if ($this->_init && !is_writable($this->settings['path'])) {
            $this->_init = false;
            trigger_error(sprintf(__('%s is not writable', true), $this->settings['path']), E_USER_WARNING);

FileEngine::__active() - CORE/cake/libs/cache/file.php, line 267
FileEngine::init() - CORE/cake/libs/cache/file.php, line 94
Cache::_buildEngine() - CORE/cake/libs/cache.php, line 151
Cache::config() - CORE/cake/libs/cache.php, line 126
include - /home/pharma/website/releases/20120317114903/cakephp/app/pharmalicensing/config/core.php, line 345
Configure::__loadBootstrap() - CORE/cake/libs/configure.php, line 391
Configure::getInstance() - CORE/cake/libs/configure.php, line 52
include - CORE/cake/bootstrap.php, line 38
[main] - /home/pharma/website/releases/20120317114903/cakephp/webroot/pharmalicensing/index.php, line 100

Deals review

Deals
Browse

Deals

479 deals found.

In order to access this content you must be logged in and have a subscription to Pharmalicensing Intelligence.

Pharmalicensing Intelligence is a one-stop environment for time-conscious executives. Keeping you abreast of the latest developments in the life sciences industry, saving you time and money when you need it most.

Subscribe now for instant access to the benefits Pharmalicensing Intelligence has to offer.
Find out more.

Request a demo of
Pharmalicensing Intelligence

Your selection

Therapeutic target: Immune related disorders del

Browse By

Industry sector: Academic/Research; Animal health; Biotechnology; Diagnostic; Drug delivery; Drug discovery; Medical device; Non-profit org./Government; Pharmaceutical; Research tools; Service
Therapeutic target: Adoptive immunotherapy; Amyloidosis; Autoimmune disease (non-specific); Chronic fatigue syndrome; Chronic granulomatous disease; Chronic immunosuppression; Gout; Graft versus host disease; HIV/AIDS; Immune disorder (non-specific); Immune thrombocytopenic purpura; Immunomodulation; Immunostimulation; Immunosuppression; Lupus erythematosis; Myalgic encephalomyelitis; Myasthenia gravis; Neoplastic disease; Organ transplant rejection; Rheumatoid arthritis; Servere combined immunodeficency; Sjogren's syndrome; Systemic sclerosis; Transplant rejection; Xenotransplantation
Year: 2010; 2009; 2008; 2007; 2006; 2005; 2004; 2003; 2002; 2001; 2000; 1999

Products:	Partnering Search	Company Profiling	Pharmalicensing Intelligence	Reports	Comparision
In-licensing:	Latest records	Industry Sector	Therapeutic Target	Search	Profile your company	Pharma partnering
Out-licensing:	Latest records	Industry Sector	Therapeutic Target	Search	Profile your company	Pharma partnering
Companies:	Profiled companies	Industry Sector	Therapeutic Target	Geographic Location	Search	Add your company
Reports:	Biotechnology	Business Development	Management	Market & Sales	Medical Devices	Pharmaceuticals
News:	Deals & Alliances	Development	Financial Results	Financings	Intellectual Property	Regulatory
Events:	Pharma events	Calendar	Organizers	Featured events	Search
Articles:	Industrial Sector	Therapeutic Target	Articles date
Deals:	Industry Sector	Therapeutic Target	Deals Date	Search	Reports	Press releases
About us:	Our Audience	Case Studies	Newsletter	FAQ	Contact us	Site map

(website) 49 queries took 1584 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `story`	12	12	2
2	DESCRIBE `category`	14	14	2
3	DESCRIBE `categories_sites`	5	5	5
4	DESCRIBE `categorisation`	8	8	1
5	DESCRIBE `sites_stories`	5	5	1
6	DESCRIBE `sites`	5	5	12
7	DESCRIBE `user`	24	24	1
8	DESCRIBE `condet`	17	17	1
9	DESCRIBE `countrycode`	4	4	12
10	DESCRIBE `company`	27	27	2
11	DESCRIBE `person`	15	15	4
12	DESCRIBE `account`	29	29	5
13	DESCRIBE `product_legacy`	6	6	1
14	DESCRIBE `sales_people`	6	6	3
15	DESCRIBE `profile`	14	14	4
16	DESCRIBE `currencies`	7	7	1
17	DESCRIBE `update_rec`	7	7	1
18	DESCRIBE `dms_companies`	26	26	2
19	DESCRIBE `dms_releases`	10	10	3
20	DESCRIBE `dms_categories`	4	4	1
21	DESCRIBE `dms_clinical_areas`	4	4	2
22	DESCRIBE `dms_categories_dms_releases`	2	2	1
23	DESCRIBE `dms_clinical_areas_dms_releases`	2	2	3
24	DESCRIBE `dms_releases_sites`	5	5	2
25	DESCRIBE `licopp`	23	23	3
26	DESCRIBE `development_statuses`	5	5	2
27	DESCRIBE `licopps_sites`	3	3	1
28	DESCRIBE `service`	15	15	2
29	DESCRIBE `enquiry`	14	14	4
30	DESCRIBE `module_types`	6	6	2
31	DESCRIBE `press_release`	13	13	3
32	DESCRIBE `press_releases_sites`	5	5	2
33	DESCRIBE `story_assoc`	4	4	2
34	DESCRIBE `companies_sites`	3	3	2
35	DESCRIBE `categories_users`	2	2	2
36	DESCRIBE `authority`	3	3	3
37	DESCRIBE `sites_users`	5	5	3
38	SELECT `Site`.`id`, `Site`.`name`, `Site`.`email_domain`, `Site`.`short_name`, `Site`.`brand` FROM `sites` AS `Site` WHERE `Site`.`id` = 1 LIMIT 1	1	1	1
39	SELECT `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` = 651 LIMIT 1	1	1	3
40	SELECT `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` = (651) ORDER BY `name` ASC	25	25	0
41	SELECT `Category`.`uid`, `Category`.`name`, `Category`.`parent`, `Category`.`has_children`, `Category`.`show_children`, `Category`.`show_grandchildren`, `Category`.`members`, `Category`.`num_children`, `Category`.`root`, `Category`.`restricted`, `Category`.`clan`, `Category`.`lft`, `Category`.`rgt`, `Category`.`level`, `Parent`.`uid`, `Parent`.`name`, `Parent`.`parent`, `Parent`.`has_children`, `Parent`.`show_children`, `Parent`.`show_grandchildren`, `Parent`.`members`, `Parent`.`num_children`, `Parent`.`root`, `Parent`.`restricted`, `Parent`.`clan`, `Parent`.`lft`, `Parent`.`rgt`, `Parent`.`level`, `CategorySite`.`id`, `CategorySite`.`created`, `CategorySite`.`modified`, `CategorySite`.`site_id`, `CategorySite`.`category_id` 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	11	11	2
42	SELECT `Category`.`uid`, `Category`.`name`, `Category`.`parent`, `Category`.`has_children`, `Category`.`show_children`, `Category`.`show_grandchildren`, `Category`.`members`, `Category`.`num_children`, `Category`.`root`, `Category`.`restricted`, `Category`.`clan`, `Category`.`lft`, `Category`.`rgt`, `Category`.`level`, `Parent`.`uid`, `Parent`.`name`, `Parent`.`parent`, `Parent`.`has_children`, `Parent`.`show_children`, `Parent`.`show_grandchildren`, `Parent`.`members`, `Parent`.`num_children`, `Parent`.`root`, `Parent`.`restricted`, `Parent`.`clan`, `Parent`.`lft`, `Parent`.`rgt`, `Parent`.`level`, `CategorySite`.`id`, `CategorySite`.`created`, `CategorySite`.`modified`, `CategorySite`.`site_id`, `CategorySite`.`category_id` 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	25	25	3
43	SELECT DISTINCT SUBSTRING(issued, 1, 4) AS publication_year FROM story AS Deal WHERE is_live = 1 AND issued IS NOT NULL ORDER BY publication_year DESC	12	12	1
44	SELECT `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` = 651 LIMIT 1	1	1	1
45	SELECT `Category`.`uid`, `Category`.`name`, `Category`.`level` 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`.`lft` <= 3505 AND `Category`.`rgt` >= 3556 AND `Category`.`level` > 1 ORDER BY `Category`.`level` ASC	1	1	4
46	SELECT `Category`.`uid`, `Category`.`name`, `Category`.`parent`, `Category`.`has_children`, `Category`.`show_children`, `Category`.`show_grandchildren`, `Category`.`members`, `Category`.`num_children`, `Category`.`root`, `Category`.`restricted`, `Category`.`clan`, `Category`.`lft`, `Category`.`rgt`, `Category`.`level`, `Parent`.`uid`, `Parent`.`name`, `Parent`.`parent`, `Parent`.`has_children`, `Parent`.`show_children`, `Parent`.`show_grandchildren`, `Parent`.`members`, `Parent`.`num_children`, `Parent`.`root`, `Parent`.`restricted`, `Parent`.`clan`, `Parent`.`lft`, `Parent`.`rgt`, `Parent`.`level`, `CategorySite`.`id`, `CategorySite`.`created`, `CategorySite`.`modified`, `CategorySite`.`site_id`, `CategorySite`.`category_id` 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` = 651 LIMIT 1	1	1	2
47	SELECT `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` = (651) ORDER BY `name` ASC	25	25	0
48	SELECT Deal.uid, Deal.slug, Deal.headline, Deal.summary FROM story as Deal JOIN sites_stories AS SitesStories ON Deal.uid=SitesStories.story_id AND SitesStories.site_id=1 INNER JOIN categorisation tt_ctg ON tt_ctg.story_id = Deal.uid AND tt_ctg.cat_type = "S" AND tt_ctg.category_id IN (SELECT uid FROM category WHERE (lft >= 3505 AND rgt <= 3556) ) WHERE Deal.is_live = 1 GROUP BY Deal.uid ORDER BY Deal.viewed_counter DESC, Deal.headline LIMIT 0, 10	10	10	840
49	SELECT count(DISTINCT Deal.uid) AS total FROM story as Deal JOIN sites_stories AS SitesStories ON Deal.uid=SitesStories.story_id AND SitesStories.site_id=1 INNER JOIN categorisation tt_ctg ON tt_ctg.story_id = Deal.uid AND tt_ctg.cat_type = "S" AND tt_ctg.category_id IN (SELECT uid FROM category WHERE (lft >= 3505 AND rgt <= 3556) ) WHERE Deal.is_live = 1	1	1	624

(website) 49 queries took 1584 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `story`

DESCRIBE `category`

DESCRIBE `categories_sites`

DESCRIBE `categorisation`

DESCRIBE `sites_stories`

DESCRIBE `sites`

DESCRIBE `user`

DESCRIBE `condet`

DESCRIBE `countrycode`

DESCRIBE `company`

DESCRIBE `person`

DESCRIBE `account`

DESCRIBE `product_legacy`

DESCRIBE `sales_people`

DESCRIBE `profile`

DESCRIBE `currencies`

DESCRIBE `update_rec`

DESCRIBE `dms_companies`

DESCRIBE `dms_releases`

DESCRIBE `dms_categories`

DESCRIBE `dms_clinical_areas`

DESCRIBE `dms_categories_dms_releases`

DESCRIBE `dms_clinical_areas_dms_releases`

DESCRIBE `dms_releases_sites`

DESCRIBE `licopp`

DESCRIBE `development_statuses`

DESCRIBE `licopps_sites`

DESCRIBE `service`

DESCRIBE `enquiry`

DESCRIBE `module_types`

DESCRIBE `press_release`

DESCRIBE `press_releases_sites`

DESCRIBE `story_assoc`

DESCRIBE `companies_sites`

DESCRIBE `categories_users`

DESCRIBE `authority`

DESCRIBE `sites_users`

SELECT `Site`.`id`, `Site`.`name`, `Site`.`email_domain`, `Site`.`short_name`, `Site`.`brand` FROM `sites` AS `Site` WHERE `Site`.`id` = 1 LIMIT 1

SELECT `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` = 651 LIMIT 1

SELECT `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` = (651) ORDER BY `name` ASC

SELECT `Category`.`uid`, `Category`.`name`, `Category`.`parent`, `Category`.`has_children`, `Category`.`show_children`, `Category`.`show_grandchildren`, `Category`.`members`, `Category`.`num_children`, `Category`.`root`, `Category`.`restricted`, `Category`.`clan`, `Category`.`lft`, `Category`.`rgt`, `Category`.`level`, `Parent`.`uid`, `Parent`.`name`, `Parent`.`parent`, `Parent`.`has_children`, `Parent`.`show_children`, `Parent`.`show_grandchildren`, `Parent`.`members`, `Parent`.`num_children`, `Parent`.`root`, `Parent`.`restricted`, `Parent`.`clan`, `Parent`.`lft`, `Parent`.`rgt`, `Parent`.`level`, `CategorySite`.`id`, `CategorySite`.`created`, `CategorySite`.`modified`, `CategorySite`.`site_id`, `CategorySite`.`category_id` 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

SELECT DISTINCT SUBSTRING(issued, 1, 4) AS publication_year FROM story AS Deal WHERE is_live = 1 AND issued IS NOT NULL ORDER BY publication_year DESC

SELECT `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` = 651 LIMIT 1

SELECT `Category`.`uid`, `Category`.`name`, `Category`.`level` 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`.`lft` <= 3505 AND `Category`.`rgt` >= 3556 AND `Category`.`level` > 1 ORDER BY `Category`.`level` ASC

SELECT Deal.uid, Deal.slug, Deal.headline, Deal.summary FROM story as Deal JOIN sites_stories AS SitesStories ON Deal.uid=SitesStories.story_id AND SitesStories.site_id=1 INNER JOIN categorisation tt_ctg ON tt_ctg.story_id = Deal.uid AND tt_ctg.cat_type = "S" AND tt_ctg.category_id IN (SELECT uid FROM category WHERE (lft >= 3505 AND rgt <= 3556) ) WHERE Deal.is_live = 1 GROUP BY Deal.uid ORDER BY Deal.viewed_counter DESC, Deal.headline LIMIT 0, 10

840

SELECT count(DISTINCT Deal.uid) AS total FROM story as Deal JOIN sites_stories AS SitesStories ON Deal.uid=SitesStories.story_id AND SitesStories.site_id=1 INNER JOIN categorisation tt_ctg ON tt_ctg.story_id = Deal.uid AND tt_ctg.cat_type = "S" AND tt_ctg.category_id IN (SELECT uid FROM category WHERE (lft >= 3505 AND rgt <= 3556) ) WHERE Deal.is_live = 1

624