Warning (512): /home/pharma/website/current/cakephp/app/pharmalicensing/tmp/cache/ is not writable [CORE/cake/libs/cache/file.php, line 267]
Articles: Animal health
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 170 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `feature_article`13131
2DESCRIBE `feature_author`13131
3DESCRIBE `user`24241
4DESCRIBE `condet`17171
5DESCRIBE `countrycode`441
6DESCRIBE `company`27272
7DESCRIBE `person`15154
8DESCRIBE `account`292914
9DESCRIBE `product_legacy`6610
10DESCRIBE `sales_people`661
11DESCRIBE `profile`14141
12DESCRIBE `currencies`771
13DESCRIBE `update_rec`771
14DESCRIBE `dms_companies`26264
15DESCRIBE `dms_releases`10106
16DESCRIBE `dms_categories`441
17DESCRIBE `dms_clinical_areas`441
18DESCRIBE `dms_categories_dms_releases`221
19DESCRIBE `dms_clinical_areas_dms_releases`221
20DESCRIBE `dms_releases_sites`5510
21DESCRIBE `licopp`23232
22DESCRIBE `development_statuses`553
23DESCRIBE `category`14141
24DESCRIBE `categories_sites`554
25DESCRIBE `categorisation`881
26DESCRIBE `licopps_sites`331
27DESCRIBE `service`15153
28DESCRIBE `enquiry`14143
29DESCRIBE `module_types`662
30DESCRIBE `press_release`13132
31DESCRIBE `press_releases_sites`553
32DESCRIBE `story`12122
33DESCRIBE `sites_stories`550
34DESCRIBE `story_assoc`441
35DESCRIBE `companies_sites`333
36DESCRIBE `categories_users`223
37DESCRIBE `authority`331
38DESCRIBE `sites_users`551
39DESCRIBE `sites`554
40SELECT `Site`.`id`, `Site`.`name`, `Site`.`email_domain`, `Site`.`short_name`, `Site`.`brand` FROM `sites` AS `Site` WHERE `Site`.`id` = 1 LIMIT 1113
41SELECT c.uid, c.name FROM category c WHERE c.parent = 505 ORDER BY c.name 882
42SELECT c.uid, c.name FROM category c WHERE c.parent = 560 ORDER BY c.name 20200
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 13132
44SELECT c.lft, c.rgt FROM category c WHERE c.uid = 505113
45SELECT c.uid, c.name, c.level FROM category c WHERE c.lft <= "1427" AND c.rgt >= "1444" AND c.level > 1 ORDER BY c.level 110
46SELECT feature_article.uid, feature_article.headline, feature_article.summary, feature_article.slug FROM feature_article INNER JOIN categorisation is_ctg ON is_ctg.story_id = feature_article.uid AND is_ctg.cat_type = "F" AND is_ctg.category_id IN (SELECT uid FROM category WHERE (lft >= 1427 AND rgt <= 1444) ) WHERE feature_article.is_live > 0 GROUP BY feature_article.uid ORDER BY feature_article.viewed_counter DESC, feature_article.headline LIMIT 0, 10 0057
(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 3 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 ("Animal health") ORDER BY MATCH (`MarketResearchReport`.`name`, `MarketResearchReport`.`description`, `MarketResearchReport`.`summary`, `MarketResearchReport`.`content`, `MarketResearchReport`.`isbn`, `MarketResearchReport`.`code`) AGAINST ("Animal health") DESC , MarketResearchReport.published DESC LIMIT 1010103