Warning (512): /home/pharma/website/current/cakephp/app/pharmalicensing/tmp/cache/ is not writable [CORE/cake/libs/cache/file.php, line 267]
Events: Informa plc
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.

Your selection

Organiser
Informa plc del

Browse By

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

(website) 42 queries took 878 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `event`262621
2DESCRIBE `company`272739
3DESCRIBE `condet`171726
4DESCRIBE `countrycode`447
5DESCRIBE `person`151548
6DESCRIBE `account`292927
7DESCRIBE `product_legacy`6638
8DESCRIBE `sales_people`6623
9DESCRIBE `profile`141423
10DESCRIBE `currencies`7737
11DESCRIBE `update_rec`7718
12DESCRIBE `user`242414
13DESCRIBE `enquiry`14145
14DESCRIBE `module_types`6618
15DESCRIBE `dms_companies`262637
16DESCRIBE `dms_releases`101039
17DESCRIBE `dms_categories`446
18DESCRIBE `dms_clinical_areas`4414
19DESCRIBE `dms_categories_dms_releases`225
20DESCRIBE `dms_clinical_areas_dms_releases`224
21DESCRIBE `dms_releases_sites`5513
22DESCRIBE `licopp`23236
23DESCRIBE `development_statuses`5534
24DESCRIBE `category`141410
25DESCRIBE `categories_sites`559
26DESCRIBE `categorisation`884
27DESCRIBE `licopps_sites`3338
28DESCRIBE `service`151555
29DESCRIBE `press_release`13138
30DESCRIBE `press_releases_sites`5510
31DESCRIBE `story`121219
32DESCRIBE `sites_stories`5520
33DESCRIBE `story_assoc`4412
34DESCRIBE `companies_sites`3328
35DESCRIBE `categories_users`228
36DESCRIBE `authority`331
37DESCRIBE `sites_users`5519
38DESCRIBE `sites`5536
39SELECT `Site`.`id`, `Site`.`name`, `Site`.`email_domain`, `Site`.`short_name`, `Site`.`brand` FROM `sites` AS `Site` WHERE `Site`.`id` = 1 LIMIT 11128
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 11127
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` = 21137 AND `Company`.`is_live` = 'y' LIMIT 11135
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`="21137" 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