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 2637 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `story`12121
2DESCRIBE `category`14141
3DESCRIBE `categories_sites`550
4DESCRIBE `categorisation`881
5DESCRIBE `sites_stories`550
6DESCRIBE `sites`550
7DESCRIBE `user`24241
8DESCRIBE `condet`17171
9DESCRIBE `countrycode`440
10DESCRIBE `company`27271
11DESCRIBE `person`15151
12DESCRIBE `account`29291
13DESCRIBE `product_legacy`661
14DESCRIBE `sales_people`661
15DESCRIBE `profile`14141
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`550
25DESCRIBE `licopp`23231
26DESCRIBE `development_statuses`550
27DESCRIBE `licopps_sites`330
28DESCRIBE `service`15151
29DESCRIBE `enquiry`14141
30DESCRIBE `module_types`660
31DESCRIBE `press_release`13131
32DESCRIBE `press_releases_sites`550
33DESCRIBE `story_assoc`442
34DESCRIBE `companies_sites`331
35DESCRIBE `categories_users`221
36DESCRIBE `authority`330
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 1110
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 111086
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 10001527