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

Events

Innovaro Pharmalicensing brings you advice, commentary and analysis from industry experts.

Browse events

No results found for given criteria.
Please try to put more general criteria into your selection.

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

(website) 42 queries took 102 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `event`26261
2DESCRIBE `company`27271
3DESCRIBE `condet`17172
4DESCRIBE `countrycode`441
5DESCRIBE `person`15152
6DESCRIBE `account`29296
7DESCRIBE `product_legacy`663
8DESCRIBE `sales_people`661
9DESCRIBE `profile`14141
10DESCRIBE `currencies`771
11DESCRIBE `update_rec`775
12DESCRIBE `user`24241
13DESCRIBE `enquiry`14148
14DESCRIBE `module_types`661
15DESCRIBE `dms_companies`26264
16DESCRIBE `dms_releases`10101
17DESCRIBE `dms_categories`441
18DESCRIBE `dms_clinical_areas`4413
19DESCRIBE `dms_categories_dms_releases`222
20DESCRIBE `dms_clinical_areas_dms_releases`223
21DESCRIBE `dms_releases_sites`551
22DESCRIBE `licopp`23234
23DESCRIBE `development_statuses`552
24DESCRIBE `category`14142
25DESCRIBE `categories_sites`551
26DESCRIBE `categorisation`881
27DESCRIBE `licopps_sites`330
28DESCRIBE `service`15151
29DESCRIBE `press_release`13131
30DESCRIBE `press_releases_sites`550
31DESCRIBE `story`12121
32DESCRIBE `sites_stories`550
33DESCRIBE `story_assoc`441
34DESCRIBE `companies_sites`331
35DESCRIBE `categories_users`220
36DESCRIBE `authority`330
37DESCRIBE `sites_users`550
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 `Event`.`id`, `Event`.`issued`, `Event`.`is_live` FROM `event` AS `Event` WHERE `Event`.`is_live` >= 0 AND DATE(`Event`.`issued`) >= DATE(NOW()) ORDER BY `Event`.`issued` DESC LIMIT 11110
41SELECT `Company`.`uid`, `Company`.`name` FROM `company` AS `Company` LEFT JOIN `companies_sites` AS `CompanySite` ON (`CompanySite`.`company_id` = `Company`.`uid`) WHERE `CompanySite`.`site_id` = 1 AND `Company`.`uid` = 2905 AND `Company`.`is_live` = 'y' LIMIT 1110
42SELECT `Event`.`id`, `Event`.`slug`, `Event`.`legacy_id`, `Event`.`company_id`, `Event`.`issued`, `Event`.`ends`, `Event`.`headline`, `Event`.`detail`, `Event`.`body`, `Event`.`content`, `Event`.`email`, `Event`.`contact`, `Event`.`regform`, `Event`.`url`, `Event`.`telephone`, `Event`.`location`, `Event`.`venue`, `Event`.`course`, `Event`.`prices`, `Event`.`featured`, `Event`.`created`, `Event`.`modified`, `Event`.`is_live`, `Event`.`flags`, `Event`.`organizer`, `Event`.`viewed_counter`, `Company`.`uid`, `Company`.`slug`, `Company`.`name`, `Company`.`condet_id`, `Company`.`person_id`, `Company`.`billing_id`, `Company`.`parent`, `Company`.`has_children`, `Company`.`notes_id`, `Company`.`contact_status`, `Company`.`last_contacted`, `Company`.`profile_id`, `Company`.`account_id`, `Company`.`summary`, `Company`.`is_customer`, `Company`.`change_time`, `Company`.`flags`, `Company`.`is_anon`, `Company`.`is_resource`, `Company`.`satellite`, `Company`.`no_dms`, `Company`.`is_live`, `Company`.`viewed_counter`, `Company`.`created`, `Company`.`last_disabled`, `Company`.`no_trial`, `Company`.`trial_notification_sent` FROM `event` AS `Event` INNER JOIN company AS `CompanyLive` ON (`Event`.`company_id`=`CompanyLive`.`uid` AND `CompanyLive`.`is_live`="Y") INNER JOIN company AS `Organiser` ON (`Event`.`company_id`="2905" AND `Event`.`company_id`=`Organiser`.`uid` AND `Organiser`.`is_live`="Y") LEFT JOIN `company` AS `Company` ON (`Event`.`company_id` = `Company`.`uid` AND `Company`.`is_live` = 'Y') WHERE `Event`.`is_live` > 0 AND ((DATE(`Event`.`issued`) >= DATE(now())) OR (DATE(`Event`.`ends`) >= DATE(now()))) ORDER BY `Event`.`issued` ASC LIMIT 0, 100017