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

Deals review

Deals

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.

© Copyright 1998-2012 Innovaro Europe Ltd Innovaro Corporation All rights reserved. Terms and Conditions | Contact us

(website) 40 queries took 3407 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `story`12122
2DESCRIBE `category`14141
3DESCRIBE `categories_sites`551
4DESCRIBE `categorisation`881
5DESCRIBE `sites_stories`551
6DESCRIBE `sites`553
7DESCRIBE `user`24244
8DESCRIBE `condet`17171
9DESCRIBE `countrycode`441
10DESCRIBE `company`27272
11DESCRIBE `person`15151
12DESCRIBE `account`29292
13DESCRIBE `product_legacy`661
14DESCRIBE `sales_people`661
15DESCRIBE `profile`14142
16DESCRIBE `currencies`771
17DESCRIBE `update_rec`771
18DESCRIBE `dms_companies`26261
19DESCRIBE `dms_releases`10101
20DESCRIBE `dms_categories`440
21DESCRIBE `dms_clinical_areas`440
22DESCRIBE `dms_categories_dms_releases`220
23DESCRIBE `dms_clinical_areas_dms_releases`220
24DESCRIBE `dms_releases_sites`5519
25DESCRIBE `licopp`23236
26DESCRIBE `development_statuses`555
27DESCRIBE `licopps_sites`335
28DESCRIBE `service`15151
29DESCRIBE `enquiry`14142
30DESCRIBE `module_types`661
31DESCRIBE `press_release`13134
32DESCRIBE `press_releases_sites`552
33DESCRIBE `story_assoc`443
34DESCRIBE `companies_sites`332
35DESCRIBE `categories_users`226
36DESCRIBE `authority`331
37DESCRIBE `sites_users`552
38SELECT `Site`.`id`, `Site`.`name`, `Site`.`email_domain`, `Site`.`short_name`, `Site`.`brand` FROM `sites` AS `Site` WHERE `Site`.`id` = 1 LIMIT 1116
39SELECT COUNT(*) AS `count` FROM `story` AS `Deal` LEFT JOIN `sites_stories` AS `DealSite` ON (`DealSite`.`story_id` = `Deal`.`uid`) WHERE `DealSite`.`site_id` = 1 AND (DATE(`Deal`.`issued`) BETWEEN "2012-02-01" AND "2012-03-01") AND is_live=1 111926
40SELECT `Deal`.`uid`, `Deal`.`slug`, `Deal`.`created`, `Deal`.`lastmod`, `Deal`.`issued`, `Deal`.`author`, `Deal`.`author_email`, `Deal`.`headline`, `Deal`.`summary`, `Deal`.`body`, `Deal`.`is_live`, `Deal`.`viewed_counter`, `DealSite`.`id`, `DealSite`.`story_id`, `DealSite`.`created`, `DealSite`.`modified`, `DealSite`.`site_id` FROM `story` AS `Deal` LEFT JOIN `sites_stories` AS `DealSite` ON (`DealSite`.`story_id` = `Deal`.`uid`) WHERE `DealSite`.`site_id` = 1 AND (DATE(`Deal`.`issued`) BETWEEN "2012-02-01" AND "2012-03-01") AND is_live=1 ORDER BY `Deal`.`headline` ASC LIMIT 10001388