Warning (512): /home/pharma/website/current/cakephp/app/pharmalicensing/tmp/cache/ is not writable [CORE/cake/libs/cache/file.php, line 267]
Articles: Other therapeutic
RSS Feeds
Search

Articles

Innovaro Pharmalicensing brings you advice, commentary and analysis from industry experts.

Articles

No results found for given criteria.
Please try to put more general criteria into your selection.

Related Reports

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

(website) 46 queries took 204 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `feature_article`13131
2DESCRIBE `feature_author`13131
3DESCRIBE `user`24248
4DESCRIBE `condet`17171
5DESCRIBE `countrycode`441
6DESCRIBE `company`27272
7DESCRIBE `person`15152
8DESCRIBE `account`29291
9DESCRIBE `product_legacy`662
10DESCRIBE `sales_people`663
11DESCRIBE `profile`14141
12DESCRIBE `currencies`771
13DESCRIBE `update_rec`771
14DESCRIBE `dms_companies`26264
15DESCRIBE `dms_releases`10102
16DESCRIBE `dms_categories`441
17DESCRIBE `dms_clinical_areas`442
18DESCRIBE `dms_categories_dms_releases`223
19DESCRIBE `dms_clinical_areas_dms_releases`220
20DESCRIBE `dms_releases_sites`552
21DESCRIBE `licopp`23233
22DESCRIBE `development_statuses`556
23DESCRIBE `category`14149
24DESCRIBE `categories_sites`553
25DESCRIBE `categorisation`887
26DESCRIBE `licopps_sites`3311
27DESCRIBE `service`15151
28DESCRIBE `enquiry`14145
29DESCRIBE `module_types`661
30DESCRIBE `press_release`131317
31DESCRIBE `press_releases_sites`552
32DESCRIBE `story`12121
33DESCRIBE `sites_stories`551
34DESCRIBE `story_assoc`443
35DESCRIBE `companies_sites`3312
36DESCRIBE `categories_users`222
37DESCRIBE `authority`332
38DESCRIBE `sites_users`551
39DESCRIBE `sites`551
40SELECT `Site`.`id`, `Site`.`name`, `Site`.`email_domain`, `Site`.`short_name`, `Site`.`brand` FROM `sites` AS `Site` WHERE `Site`.`id` = 1 LIMIT 1110
41SELECT c.uid, c.name FROM category c WHERE c.parent = 297 ORDER BY c.name 11110
42SELECT c.uid, c.name FROM category c WHERE c.parent = 670 ORDER BY c.name 771
43SELECT DISTINCT SUBSTRING(issued, 1, 4) AS publication_year FROM feature_article AS Article WHERE is_live = 1 AND issued IS NOT NULL ORDER BY publication_year DESC 13131
44SELECT c.lft, c.rgt FROM category c WHERE c.uid = 670110
45SELECT c.uid, c.name, c.level FROM category c WHERE c.lft <= "4081" AND c.rgt >= "4096" AND c.level > 1 ORDER BY c.level 111
46SELECT feature_article.uid, feature_article.headline, feature_article.summary, feature_article.slug FROM feature_article INNER JOIN categorisation tt_ctg ON tt_ctg.story_id = feature_article.uid AND tt_ctg.cat_type = "F" AND tt_ctg.category_id IN (SELECT uid FROM category WHERE (lft >= 4081 AND rgt <= 4096) ) WHERE feature_article.is_live > 0 GROUP BY feature_article.uid ORDER BY feature_article.viewed_counter DESC, feature_article.headline LIMIT 0, 10 0074
(default) 0 query took ms
NrQueryErrorAffectedNum. rowsTook (ms)
(report) 1 query took 1 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `reports`17171
(report_slave) 1 query took 2 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `MarketResearchReport`.`id`, `MarketResearchReport`.`slug`, `MarketResearchReport`.`name`, `MarketResearchReport`.`description`, `MarketResearchReport`.`summary`, `MarketResearchReport`.`content`, `MarketResearchReport`.`isbn`, `MarketResearchReport`.`code`, `MarketResearchReport`.`pages`, `MarketResearchReport`.`published`, `MarketResearchReport`.`net_price_usd`, `MarketResearchReport`.`active`, `MarketResearchReport`.`publisher_id`, `MarketResearchReport`.`views`, `MarketResearchReport`.`tags`, `MarketResearchReport`.`created`, `MarketResearchReport`.`modified` FROM `reports` AS `MarketResearchReport` WHERE `MarketResearchReport`.`active` = 1 AND MATCH (`MarketResearchReport`.`name`, `MarketResearchReport`.`description`, `MarketResearchReport`.`summary`, `MarketResearchReport`.`content`, `MarketResearchReport`.`isbn`, `MarketResearchReport`.`code`) AGAINST ("Other therapeutic") ORDER BY MATCH (`MarketResearchReport`.`name`, `MarketResearchReport`.`description`, `MarketResearchReport`.`summary`, `MarketResearchReport`.`content`, `MarketResearchReport`.`isbn`, `MarketResearchReport`.`code`) AGAINST ("Other therapeutic") DESC , MarketResearchReport.published DESC LIMIT 1010102