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 177 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `event`26261
2DESCRIBE `company`272717
3DESCRIBE `condet`17175
4DESCRIBE `countrycode`441
5DESCRIBE `person`15151
6DESCRIBE `account`292910
7DESCRIBE `product_legacy`668
8DESCRIBE `sales_people`664
9DESCRIBE `profile`14146
10DESCRIBE `currencies`771
11DESCRIBE `update_rec`771
12DESCRIBE `user`242412
13DESCRIBE `enquiry`14141
14DESCRIBE `module_types`663
15DESCRIBE `dms_companies`26262
16DESCRIBE `dms_releases`10107
17DESCRIBE `dms_categories`446
18DESCRIBE `dms_clinical_areas`442
19DESCRIBE `dms_categories_dms_releases`221
20DESCRIBE `dms_clinical_areas_dms_releases`221
21DESCRIBE `dms_releases_sites`554
22DESCRIBE `licopp`23235
23DESCRIBE `development_statuses`553
24DESCRIBE `category`14143
25DESCRIBE `categories_sites`552
26DESCRIBE `categorisation`883
27DESCRIBE `licopps_sites`335
28DESCRIBE `service`15153
29DESCRIBE `press_release`13132
30DESCRIBE `press_releases_sites`553
31DESCRIBE `story`12122
32DESCRIBE `sites_stories`551
33DESCRIBE `story_assoc`443
34DESCRIBE `companies_sites`331
35DESCRIBE `categories_users`222
36DESCRIBE `authority`332
37DESCRIBE `sites_users`555
38DESCRIBE `sites`555
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 11117
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 1112
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, 100013