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 311 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `feature_article`13135
2DESCRIBE `feature_author`13131
3DESCRIBE `user`24241
4DESCRIBE `condet`17171
5DESCRIBE `countrycode`441
6DESCRIBE `company`27271
7DESCRIBE `person`15157
8DESCRIBE `account`29292
9DESCRIBE `product_legacy`664
10DESCRIBE `sales_people`662
11DESCRIBE `profile`14141
12DESCRIBE `currencies`772
13DESCRIBE `update_rec`772
14DESCRIBE `dms_companies`26262
15DESCRIBE `dms_releases`10103
16DESCRIBE `dms_categories`441
17DESCRIBE `dms_clinical_areas`4420
18DESCRIBE `dms_categories_dms_releases`222
19DESCRIBE `dms_clinical_areas_dms_releases`221
20DESCRIBE `dms_releases_sites`551
21DESCRIBE `licopp`23233
22DESCRIBE `development_statuses`552
23DESCRIBE `category`14143
24DESCRIBE `categories_sites`553
25DESCRIBE `categorisation`881
26DESCRIBE `licopps_sites`331
27DESCRIBE `service`15152
28DESCRIBE `enquiry`14142
29DESCRIBE `module_types`663
30DESCRIBE `press_release`13137
31DESCRIBE `press_releases_sites`553
32DESCRIBE `story`12122
33DESCRIBE `sites_stories`555
34DESCRIBE `story_assoc`442
35DESCRIBE `companies_sites`331
36DESCRIBE `categories_users`223
37DESCRIBE `authority`333
38DESCRIBE `sites_users`552
39DESCRIBE `sites`552
40SELECT `Site`.`id`, `Site`.`name`, `Site`.`email_domain`, `Site`.`short_name`, `Site`.`brand` FROM `sites` AS `Site` WHERE `Site`.`id` = 1 LIMIT 1112
41SELECT c.uid, c.name FROM category c WHERE c.parent = 297 ORDER BY c.name 11111
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 = 670111
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 00194
(default) 0 query took ms
NrQueryErrorAffectedNum. rowsTook (ms)
(report) 1 query took 2 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `reports`17172
(report_slave) 1 query took 1 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 1010101