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 453 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `event`26264
2DESCRIBE `company`27278
3DESCRIBE `condet`171710
4DESCRIBE `countrycode`4432
5DESCRIBE `person`151514
6DESCRIBE `account`29293
7DESCRIBE `product_legacy`662
8DESCRIBE `sales_people`6633
9DESCRIBE `profile`14145
10DESCRIBE `currencies`7710
11DESCRIBE `update_rec`771
12DESCRIBE `user`24243
13DESCRIBE `enquiry`141421
14DESCRIBE `module_types`665
15DESCRIBE `dms_companies`26262
16DESCRIBE `dms_releases`10103
17DESCRIBE `dms_categories`4413
18DESCRIBE `dms_clinical_areas`449
19DESCRIBE `dms_categories_dms_releases`225
20DESCRIBE `dms_clinical_areas_dms_releases`223
21DESCRIBE `dms_releases_sites`5520
22DESCRIBE `licopp`23238
23DESCRIBE `development_statuses`5512
24DESCRIBE `category`141421
25DESCRIBE `categories_sites`5517
26DESCRIBE `categorisation`886
27DESCRIBE `licopps_sites`336
28DESCRIBE `service`151518
29DESCRIBE `press_release`13138
30DESCRIBE `press_releases_sites`556
31DESCRIBE `story`121214
32DESCRIBE `sites_stories`557
33DESCRIBE `story_assoc`448
34DESCRIBE `companies_sites`333
35DESCRIBE `categories_users`2223
36DESCRIBE `authority`333
37DESCRIBE `sites_users`555
38DESCRIBE `sites`5526
39SELECT `Site`.`id`, `Site`.`name`, `Site`.`email_domain`, `Site`.`short_name`, `Site`.`brand` FROM `sites` AS `Site` WHERE `Site`.`id` = 1 LIMIT 11118
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 11112
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, 100017