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

Browse By

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

(website) 42 queries took 131 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `event`26269
2DESCRIBE `company`27274
3DESCRIBE `condet`171711
4DESCRIBE `countrycode`445
5DESCRIBE `person`15151
6DESCRIBE `account`292943
7DESCRIBE `product_legacy`663
8DESCRIBE `sales_people`668
9DESCRIBE `profile`14142
10DESCRIBE `currencies`772
11DESCRIBE `update_rec`772
12DESCRIBE `user`24244
13DESCRIBE `enquiry`14141
14DESCRIBE `module_types`660
15DESCRIBE `dms_companies`26261
16DESCRIBE `dms_releases`10101
17DESCRIBE `dms_categories`441
18DESCRIBE `dms_clinical_areas`440
19DESCRIBE `dms_categories_dms_releases`220
20DESCRIBE `dms_clinical_areas_dms_releases`221
21DESCRIBE `dms_releases_sites`551
22DESCRIBE `licopp`23231
23DESCRIBE `development_statuses`551
24DESCRIBE `category`14141
25DESCRIBE `categories_sites`550
26DESCRIBE `categorisation`881
27DESCRIBE `licopps_sites`330
28DESCRIBE `service`15151
29DESCRIBE `press_release`13131
30DESCRIBE `press_releases_sites`550
31DESCRIBE `story`12121
32DESCRIBE `sites_stories`550
33DESCRIBE `story_assoc`440
34DESCRIBE `companies_sites`330
35DESCRIBE `categories_users`220
36DESCRIBE `authority`330
37DESCRIBE `sites_users`550
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 11111
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` = 3205 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`="3205" 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, 100011