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

Browse By

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

(website) 42 queries took 79 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `event`26263
2DESCRIBE `company`27271
3DESCRIBE `condet`17171
4DESCRIBE `countrycode`440
5DESCRIBE `person`15151
6DESCRIBE `account`29291
7DESCRIBE `product_legacy`660
8DESCRIBE `sales_people`660
9DESCRIBE `profile`14141
10DESCRIBE `currencies`770
11DESCRIBE `update_rec`771
12DESCRIBE `user`24241
13DESCRIBE `enquiry`14146
14DESCRIBE `module_types`664
15DESCRIBE `dms_companies`26266
16DESCRIBE `dms_releases`10105
17DESCRIBE `dms_categories`446
18DESCRIBE `dms_clinical_areas`442
19DESCRIBE `dms_categories_dms_releases`224
20DESCRIBE `dms_clinical_areas_dms_releases`223
21DESCRIBE `dms_releases_sites`552
22DESCRIBE `licopp`23234
23DESCRIBE `development_statuses`550
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`556
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 1118
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` = 5770 AND `Company`.`is_live` = 'y' LIMIT 1110
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`="5770" 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, 10007