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

Browse By

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

(website) 42 queries took 240 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `event`26261
2DESCRIBE `company`27272
3DESCRIBE `condet`171719
4DESCRIBE `countrycode`441
5DESCRIBE `person`15151
6DESCRIBE `account`292913
7DESCRIBE `product_legacy`668
8DESCRIBE `sales_people`661
9DESCRIBE `profile`14146
10DESCRIBE `currencies`778
11DESCRIBE `update_rec`771
12DESCRIBE `user`24241
13DESCRIBE `enquiry`141412
14DESCRIBE `module_types`662
15DESCRIBE `dms_companies`26263
16DESCRIBE `dms_releases`10103
17DESCRIBE `dms_categories`444
18DESCRIBE `dms_clinical_areas`441
19DESCRIBE `dms_categories_dms_releases`227
20DESCRIBE `dms_clinical_areas_dms_releases`2211
21DESCRIBE `dms_releases_sites`556
22DESCRIBE `licopp`23235
23DESCRIBE `development_statuses`5514
24DESCRIBE `category`14146
25DESCRIBE `categories_sites`553
26DESCRIBE `categorisation`882
27DESCRIBE `licopps_sites`3311
28DESCRIBE `service`151514
29DESCRIBE `press_release`131315
30DESCRIBE `press_releases_sites`554
31DESCRIBE `story`12122
32DESCRIBE `sites_stories`555
33DESCRIBE `story_assoc`441
34DESCRIBE `companies_sites`333
35DESCRIBE `categories_users`221
36DESCRIBE `authority`332
37DESCRIBE `sites_users`553
38DESCRIBE `sites`557
39SELECT `Site`.`id`, `Site`.`name`, `Site`.`email_domain`, `Site`.`short_name`, `Site`.`brand` FROM `sites` AS `Site` WHERE `Site`.`id` = 1 LIMIT 1119
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` = 118 AND `Company`.`is_live` = 'y' LIMIT 1113
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`="118" 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, 100010