Warning (512): /home/pharma/website/current/cakephp/app/pharmalicensing/tmp/cache/ is not writable [CORE/cake/libs/cache/file.php, line 267]
Articles: Oral 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 254 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `feature_article`131317
2DESCRIBE `feature_author`13135
3DESCRIBE `user`24246
4DESCRIBE `condet`17171
5DESCRIBE `countrycode`441
6DESCRIBE `company`27271
7DESCRIBE `person`151516
8DESCRIBE `account`29297
9DESCRIBE `product_legacy`664
10DESCRIBE `sales_people`662
11DESCRIBE `profile`14141
12DESCRIBE `currencies`771
13DESCRIBE `update_rec`776
14DESCRIBE `dms_companies`26261
15DESCRIBE `dms_releases`10102
16DESCRIBE `dms_categories`441
17DESCRIBE `dms_clinical_areas`441
18DESCRIBE `dms_categories_dms_releases`2217
19DESCRIBE `dms_clinical_areas_dms_releases`220
20DESCRIBE `dms_releases_sites`550
21DESCRIBE `licopp`23231
22DESCRIBE `development_statuses`551
23DESCRIBE `category`14141
24DESCRIBE `categories_sites`551
25DESCRIBE `categorisation`881
26DESCRIBE `licopps_sites`330
27DESCRIBE `service`15151
28DESCRIBE `enquiry`14141
29DESCRIBE `module_types`660
30DESCRIBE `press_release`13131
31DESCRIBE `press_releases_sites`550
32DESCRIBE `story`12121
33DESCRIBE `sites_stories`550
34DESCRIBE `story_assoc`440
35DESCRIBE `companies_sites`3344
36DESCRIBE `categories_users`2235
37DESCRIBE `authority`331
38DESCRIBE `sites_users`551
39DESCRIBE `sites`553
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 = 1479 ORDER BY c.name 10106
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 13130
44SELECT c.lft, c.rgt FROM category c WHERE c.uid = 1479110
45SELECT c.uid, c.name, c.level FROM category c WHERE c.lft <= "4059" AND c.rgt >= "4080" AND c.level > 1 ORDER BY c.level 113
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 >= 4059 AND rgt <= 4080) ) WHERE feature_article.is_live > 0 GROUP BY feature_article.uid ORDER BY feature_article.viewed_counter DESC, feature_article.headline LIMIT 0, 10 0059
(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 ("Oral Health") ORDER BY MATCH (`MarketResearchReport`.`name`, `MarketResearchReport`.`description`, `MarketResearchReport`.`summary`, `MarketResearchReport`.`content`, `MarketResearchReport`.`isbn`, `MarketResearchReport`.`code`) AGAINST ("Oral Health") DESC , MarketResearchReport.published DESC LIMIT 1010103