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 2632 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `story`12121
2DESCRIBE `category`14141
3DESCRIBE `categories_sites`555
4DESCRIBE `categorisation`882
5DESCRIBE `sites_stories`552
6DESCRIBE `sites`551
7DESCRIBE `user`24242
8DESCRIBE `condet`17174
9DESCRIBE `countrycode`441
10DESCRIBE `company`27272
11DESCRIBE `person`15151
12DESCRIBE `account`29292
13DESCRIBE `product_legacy`662
14DESCRIBE `sales_people`663
15DESCRIBE `profile`14144
16DESCRIBE `currencies`771
17DESCRIBE `update_rec`771
18DESCRIBE `dms_companies`26261
19DESCRIBE `dms_releases`10106
20DESCRIBE `dms_categories`447
21DESCRIBE `dms_clinical_areas`444
22DESCRIBE `dms_categories_dms_releases`223
23DESCRIBE `dms_clinical_areas_dms_releases`225
24DESCRIBE `dms_releases_sites`551
25DESCRIBE `licopp`23234
26DESCRIBE `development_statuses`552
27DESCRIBE `licopps_sites`335
28DESCRIBE `service`15152
29DESCRIBE `enquiry`14143
30DESCRIBE `module_types`665
31DESCRIBE `press_release`13132
32DESCRIBE `press_releases_sites`551
33DESCRIBE `story_assoc`441
34DESCRIBE `companies_sites`331
35DESCRIBE `categories_users`228
36DESCRIBE `authority`331
37DESCRIBE `sites_users`551
38SELECT `Site`.`id`, `Site`.`name`, `Site`.`email_domain`, `Site`.`short_name`, `Site`.`brand` FROM `sites` AS `Site` WHERE `Site`.`id` = 1 LIMIT 1111
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-04-23" AND "2012-05-23") AND is_live=1 111249
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-04-23" AND "2012-05-23") AND is_live=1 ORDER BY `Deal`.`headline` ASC LIMIT 10001284