Warning (512): /home/pharma/website/current/cakephp/app/pharmalicensing/tmp/cache/ is not writable [CORE/cake/libs/cache/file.php, line 267]
Events: OBN
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 231 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `event`26262
2DESCRIBE `company`27271
3DESCRIBE `condet`171714
4DESCRIBE `countrycode`447
5DESCRIBE `person`15152
6DESCRIBE `account`29292
7DESCRIBE `product_legacy`669
8DESCRIBE `sales_people`662
9DESCRIBE `profile`14142
10DESCRIBE `currencies`773
11DESCRIBE `update_rec`771
12DESCRIBE `user`24242
13DESCRIBE `enquiry`14142
14DESCRIBE `module_types`665
15DESCRIBE `dms_companies`26265
16DESCRIBE `dms_releases`10106
17DESCRIBE `dms_categories`443
18DESCRIBE `dms_clinical_areas`444
19DESCRIBE `dms_categories_dms_releases`222
20DESCRIBE `dms_clinical_areas_dms_releases`223
21DESCRIBE `dms_releases_sites`553
22DESCRIBE `licopp`23234
23DESCRIBE `development_statuses`555
24DESCRIBE `category`14142
25DESCRIBE `categories_sites`556
26DESCRIBE `categorisation`8810
27DESCRIBE `licopps_sites`333
28DESCRIBE `service`151518
29DESCRIBE `press_release`131310
30DESCRIBE `press_releases_sites`555
31DESCRIBE `story`121218
32DESCRIBE `sites_stories`553
33DESCRIBE `story_assoc`444
34DESCRIBE `companies_sites`331
35DESCRIBE `categories_users`2215
36DESCRIBE `authority`333
37DESCRIBE `sites_users`551
38DESCRIBE `sites`552
39SELECT `Site`.`id`, `Site`.`name`, `Site`.`email_domain`, `Site`.`short_name`, `Site`.`brand` FROM `sites` AS `Site` WHERE `Site`.`id` = 1 LIMIT 11110
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` = 21166 AND `Company`.`is_live` = 'y' LIMIT 1117
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`="21166" 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, 100015