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

Browse By

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

(website) 42 queries took 322 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `event`262611
2DESCRIBE `company`27272
3DESCRIBE `condet`17177
4DESCRIBE `countrycode`442
5DESCRIBE `person`15153
6DESCRIBE `account`292918
7DESCRIBE `product_legacy`662
8DESCRIBE `sales_people`664
9DESCRIBE `profile`14144
10DESCRIBE `currencies`776
11DESCRIBE `update_rec`773
12DESCRIBE `user`24242
13DESCRIBE `enquiry`141410
14DESCRIBE `module_types`6611
15DESCRIBE `dms_companies`26262
16DESCRIBE `dms_releases`10104
17DESCRIBE `dms_categories`441
18DESCRIBE `dms_clinical_areas`4412
19DESCRIBE `dms_categories_dms_releases`221
20DESCRIBE `dms_clinical_areas_dms_releases`221
21DESCRIBE `dms_releases_sites`5519
22DESCRIBE `licopp`23231
23DESCRIBE `development_statuses`552
24DESCRIBE `category`14141
25DESCRIBE `categories_sites`554
26DESCRIBE `categorisation`881
27DESCRIBE `licopps_sites`336
28DESCRIBE `service`15152
29DESCRIBE `press_release`13138
30DESCRIBE `press_releases_sites`551
31DESCRIBE `story`121220
32DESCRIBE `sites_stories`551
33DESCRIBE `story_assoc`442
34DESCRIBE `companies_sites`337
35DESCRIBE `categories_users`221
36DESCRIBE `authority`338
37DESCRIBE `sites_users`552
38DESCRIBE `sites`5513
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 11166
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` = 21164 AND `Company`.`is_live` = 'y' LIMIT 1118
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`="21164" 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, 100040