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

Articles

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

Articles

Displaying 1..2 of 2 - per page
Order by
An online directory that gives up to date licensing opportunities as well as real-time information on the industry at the touch of a button…. Martha Clancy, Innocoll. More
A very wide variety of sites exist for the field of wound care, from those selling quack products to erudite sites for the learned researcher. More
Displaying 1..2 of 2 - per page
Order by

Related Reports

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

(website) 47 queries took 423 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `feature_article`13132
2DESCRIBE `feature_author`13134
3DESCRIBE `user`24242
4DESCRIBE `condet`17174
5DESCRIBE `countrycode`444
6DESCRIBE `company`27279
7DESCRIBE `person`15152
8DESCRIBE `account`292910
9DESCRIBE `product_legacy`667
10DESCRIBE `sales_people`661
11DESCRIBE `profile`14142
12DESCRIBE `currencies`7711
13DESCRIBE `update_rec`776
14DESCRIBE `dms_companies`26262
15DESCRIBE `dms_releases`10101
16DESCRIBE `dms_categories`444
17DESCRIBE `dms_clinical_areas`443
18DESCRIBE `dms_categories_dms_releases`223
19DESCRIBE `dms_clinical_areas_dms_releases`221
20DESCRIBE `dms_releases_sites`5516
21DESCRIBE `licopp`23232
22DESCRIBE `development_statuses`553
23DESCRIBE `category`14141
24DESCRIBE `categories_sites`5513
25DESCRIBE `categorisation`889
26DESCRIBE `licopps_sites`333
27DESCRIBE `service`151514
28DESCRIBE `enquiry`14143
29DESCRIBE `module_types`661
30DESCRIBE `press_release`131313
31DESCRIBE `press_releases_sites`551
32DESCRIBE `story`121215
33DESCRIBE `sites_stories`551
34DESCRIBE `story_assoc`443
35DESCRIBE `companies_sites`336
36DESCRIBE `categories_users`2214
37DESCRIBE `authority`331
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 11113
42SELECT c.uid, c.name FROM category c WHERE c.parent = 1476 ORDER BY c.name 14141
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 131313
44SELECT c.lft, c.rgt FROM category c WHERE c.uid = 1476112
45SELECT c.uid, c.name, c.level FROM category c WHERE c.lft <= "2779" AND c.rgt >= "2808" 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 >= 2779 AND rgt <= 2808) ) WHERE feature_article.is_live > 0 GROUP BY feature_article.uid ORDER BY feature_article.viewed_counter DESC, feature_article.headline LIMIT 0, 10 22109
47SELECT count(DISTINCT feature_article.uid) AS total 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 >= 2779 AND rgt <= 2808) ) WHERE feature_article.is_live > 0 1195
(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 4 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 ("Accident and Trauma") ORDER BY MATCH (`MarketResearchReport`.`name`, `MarketResearchReport`.`description`, `MarketResearchReport`.`summary`, `MarketResearchReport`.`content`, `MarketResearchReport`.`isbn`, `MarketResearchReport`.`code`) AGAINST ("Accident and Trauma") DESC , MarketResearchReport.published DESC LIMIT 1010104