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

Browse By

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

(website) 42 queries took 170 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `event`262613
2DESCRIBE `company`27271
3DESCRIBE `condet`17171
4DESCRIBE `countrycode`440
5DESCRIBE `person`15151
6DESCRIBE `account`29291
7DESCRIBE `product_legacy`661
8DESCRIBE `sales_people`667
9DESCRIBE `profile`14149
10DESCRIBE `currencies`776
11DESCRIBE `update_rec`777
12DESCRIBE `user`24243
13DESCRIBE `enquiry`14147
14DESCRIBE `module_types`666
15DESCRIBE `dms_companies`26267
16DESCRIBE `dms_releases`10101
17DESCRIBE `dms_categories`442
18DESCRIBE `dms_clinical_areas`445
19DESCRIBE `dms_categories_dms_releases`226
20DESCRIBE `dms_clinical_areas_dms_releases`222
21DESCRIBE `dms_releases_sites`556
22DESCRIBE `licopp`23237
23DESCRIBE `development_statuses`555
24DESCRIBE `category`14145
25DESCRIBE `categories_sites`555
26DESCRIBE `categorisation`881
27DESCRIBE `licopps_sites`336
28DESCRIBE `service`15156
29DESCRIBE `press_release`13138
30DESCRIBE `press_releases_sites`556
31DESCRIBE `story`12128
32DESCRIBE `sites_stories`551
33DESCRIBE `story_assoc`440
34DESCRIBE `companies_sites`330
35DESCRIBE `categories_users`221
36DESCRIBE `authority`330
37DESCRIBE `sites_users`551
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 1118
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` = 21169 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`="21169" 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, 10008