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

Browse By

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

(website) 42 queries took 97 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `event`26261
2DESCRIBE `company`27271
3DESCRIBE `condet`17171
4DESCRIBE `countrycode`440
5DESCRIBE `person`15151
6DESCRIBE `account`29291
7DESCRIBE `product_legacy`660
8DESCRIBE `sales_people`661
9DESCRIBE `profile`14149
10DESCRIBE `currencies`771
11DESCRIBE `update_rec`771
12DESCRIBE `user`24241
13DESCRIBE `enquiry`14141
14DESCRIBE `module_types`661
15DESCRIBE `dms_companies`26261
16DESCRIBE `dms_releases`10101
17DESCRIBE `dms_categories`440
18DESCRIBE `dms_clinical_areas`440
19DESCRIBE `dms_categories_dms_releases`220
20DESCRIBE `dms_clinical_areas_dms_releases`220
21DESCRIBE `dms_releases_sites`551
22DESCRIBE `licopp`23235
23DESCRIBE `development_statuses`551
24DESCRIBE `category`14141
25DESCRIBE `categories_sites`552
26DESCRIBE `categorisation`881
27DESCRIBE `licopps_sites`339
28DESCRIBE `service`15151
29DESCRIBE `press_release`13136
30DESCRIBE `press_releases_sites`556
31DESCRIBE `story`12124
32DESCRIBE `sites_stories`552
33DESCRIBE `story_assoc`441
34DESCRIBE `companies_sites`331
35DESCRIBE `categories_users`221
36DESCRIBE `authority`331
37DESCRIBE `sites_users`551
38DESCRIBE `sites`559
39SELECT `Site`.`id`, `Site`.`name`, `Site`.`email_domain`, `Site`.`short_name`, `Site`.`brand` FROM `sites` AS `Site` WHERE `Site`.`id` = 1 LIMIT 1111
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 11113
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` = 4539 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`="4539" 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, 10007