Warning (512): /home/pharma/website/current/cakephp/app/pharmalicensing/tmp/cache/ is not writable [CORE/cake/libs/cache/file.php, line 267]
Events: Imapac
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 114 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `event`26263
2DESCRIBE `company`27271
3DESCRIBE `condet`17174
4DESCRIBE `countrycode`442
5DESCRIBE `person`15153
6DESCRIBE `account`29293
7DESCRIBE `product_legacy`663
8DESCRIBE `sales_people`662
9DESCRIBE `profile`14142
10DESCRIBE `currencies`772
11DESCRIBE `update_rec`772
12DESCRIBE `user`24243
13DESCRIBE `enquiry`14148
14DESCRIBE `module_types`661
15DESCRIBE `dms_companies`26263
16DESCRIBE `dms_releases`10101
17DESCRIBE `dms_categories`442
18DESCRIBE `dms_clinical_areas`442
19DESCRIBE `dms_categories_dms_releases`222
20DESCRIBE `dms_clinical_areas_dms_releases`221
21DESCRIBE `dms_releases_sites`552
22DESCRIBE `licopp`23231
23DESCRIBE `development_statuses`551
24DESCRIBE `category`14142
25DESCRIBE `categories_sites`551
26DESCRIBE `categorisation`881
27DESCRIBE `licopps_sites`331
28DESCRIBE `service`15153
29DESCRIBE `press_release`13131
30DESCRIBE `press_releases_sites`551
31DESCRIBE `story`12122
32DESCRIBE `sites_stories`553
33DESCRIBE `story_assoc`442
34DESCRIBE `companies_sites`333
35DESCRIBE `categories_users`221
36DESCRIBE `authority`331
37DESCRIBE `sites_users`551
38DESCRIBE `sites`5511
39SELECT `Site`.`id`, `Site`.`name`, `Site`.`email_domain`, `Site`.`short_name`, `Site`.`brand` FROM `sites` AS `Site` WHERE `Site`.`id` = 1 LIMIT 1117
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 1119
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` = 21130 AND `Company`.`is_live` = 'y' LIMIT 1111
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`="21130" 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, 10009