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 82 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `event`26261
2DESCRIBE `company`27271
3DESCRIBE `condet`17171
4DESCRIBE `countrycode`441
5DESCRIBE `person`15152
6DESCRIBE `account`29291
7DESCRIBE `product_legacy`661
8DESCRIBE `sales_people`661
9DESCRIBE `profile`14141
10DESCRIBE `currencies`771
11DESCRIBE `update_rec`771
12DESCRIBE `user`24241
13DESCRIBE `enquiry`14142
14DESCRIBE `module_types`661
15DESCRIBE `dms_companies`26261
16DESCRIBE `dms_releases`10102
17DESCRIBE `dms_categories`442
18DESCRIBE `dms_clinical_areas`442
19DESCRIBE `dms_categories_dms_releases`221
20DESCRIBE `dms_clinical_areas_dms_releases`221
21DESCRIBE `dms_releases_sites`552
22DESCRIBE `licopp`23232
23DESCRIBE `development_statuses`553
24DESCRIBE `category`14142
25DESCRIBE `categories_sites`551
26DESCRIBE `categorisation`881
27DESCRIBE `licopps_sites`333
28DESCRIBE `service`15153
29DESCRIBE `press_release`13132
30DESCRIBE `press_releases_sites`552
31DESCRIBE `story`12123
32DESCRIBE `sites_stories`553
33DESCRIBE `story_assoc`441
34DESCRIBE `companies_sites`331
35DESCRIBE `categories_users`222
36DESCRIBE `authority`331
37DESCRIBE `sites_users`552
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 1113
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 11110
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, 10008