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 217 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `feature_article`13131
2DESCRIBE `feature_author`13132
3DESCRIBE `user`242417
4DESCRIBE `condet`17172
5DESCRIBE `countrycode`448
6DESCRIBE `company`27274
7DESCRIBE `person`15151
8DESCRIBE `account`29293
9DESCRIBE `product_legacy`664
10DESCRIBE `sales_people`662
11DESCRIBE `profile`141415
12DESCRIBE `currencies`7711
13DESCRIBE `update_rec`771
14DESCRIBE `dms_companies`26264
15DESCRIBE `dms_releases`10101
16DESCRIBE `dms_categories`441
17DESCRIBE `dms_clinical_areas`440
18DESCRIBE `dms_categories_dms_releases`221
19DESCRIBE `dms_clinical_areas_dms_releases`221
20DESCRIBE `dms_releases_sites`552
21DESCRIBE `licopp`23232
22DESCRIBE `development_statuses`553
23DESCRIBE `category`14143
24DESCRIBE `categories_sites`557
25DESCRIBE `categorisation`881
26DESCRIBE `licopps_sites`331
27DESCRIBE `service`15151
28DESCRIBE `enquiry`14141
29DESCRIBE `module_types`661
30DESCRIBE `press_release`13131
31DESCRIBE `press_releases_sites`551
32DESCRIBE `story`12121
33DESCRIBE `sites_stories`550
34DESCRIBE `story_assoc`441
35DESCRIBE `companies_sites`331
36DESCRIBE `categories_users`220
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 1111
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 = 1476 ORDER BY c.name 14140
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 = 1476111
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 2245
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 1158
(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 ("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 1010102