Warning (512): /home/pharma/website/current/cakephp/app/pharmalicensing/tmp/cache/ is not writable [CORE/cake/libs/cache/file.php, line 267]
Articles: Hospital and Surgery
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
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
International senior biopharma professionals gather in London to deconstruct deal trends and get the low-down and insider knowledge of successful partnering deals at this leading European bio-partnering event. 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 328 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `feature_article`13131
2DESCRIBE `feature_author`13134
3DESCRIBE `user`24242
4DESCRIBE `condet`171711
5DESCRIBE `countrycode`441
6DESCRIBE `company`27272
7DESCRIBE `person`15159
8DESCRIBE `account`29292
9DESCRIBE `product_legacy`663
10DESCRIBE `sales_people`663
11DESCRIBE `profile`14143
12DESCRIBE `currencies`771
13DESCRIBE `update_rec`778
14DESCRIBE `dms_companies`26265
15DESCRIBE `dms_releases`10102
16DESCRIBE `dms_categories`442
17DESCRIBE `dms_clinical_areas`441
18DESCRIBE `dms_categories_dms_releases`222
19DESCRIBE `dms_clinical_areas_dms_releases`225
20DESCRIBE `dms_releases_sites`553
21DESCRIBE `licopp`23233
22DESCRIBE `development_statuses`556
23DESCRIBE `category`14141
24DESCRIBE `categories_sites`555
25DESCRIBE `categorisation`882
26DESCRIBE `licopps_sites`332
27DESCRIBE `service`15151
28DESCRIBE `enquiry`14144
29DESCRIBE `module_types`664
30DESCRIBE `press_release`13132
31DESCRIBE `press_releases_sites`559
32DESCRIBE `story`12127
33DESCRIBE `sites_stories`551
34DESCRIBE `story_assoc`448
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 11110
42SELECT c.uid, c.name FROM category c WHERE c.parent = 641 ORDER BY c.name 20201
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 = 641111
45SELECT c.uid, c.name, c.level FROM category c WHERE c.lft <= "3463" AND c.rgt >= "3504" 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 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 >= 3463 AND rgt <= 3504) ) WHERE feature_article.is_live > 0 GROUP BY feature_article.uid ORDER BY feature_article.viewed_counter DESC, feature_article.headline LIMIT 0, 10 22125
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 >= 3463 AND rgt <= 3504) ) WHERE feature_article.is_live > 0 1171
(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 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 ("Hospital and Surgery") ORDER BY MATCH (`MarketResearchReport`.`name`, `MarketResearchReport`.`description`, `MarketResearchReport`.`summary`, `MarketResearchReport`.`content`, `MarketResearchReport`.`isbn`, `MarketResearchReport`.`code`) AGAINST ("Hospital and Surgery") DESC , MarketResearchReport.published DESC LIMIT 1010102