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

Press releases

Press releases

Displaying 1..10 of 87 - per page Next page
Order by
Genesis 2010, Westminster, Thursday 9 December is on track to attract a larger than ever attendance to debate new medicines and healthcare products research. More
BIOMEDICA FOSCAMA's leading drug Esafosfina® has been acknowledged as a safe and effective phosphorus source in total parenteral nutrition More
New Clinical Study results on SULIDIN® 1% Nimesulide LPS gel presented at the 8'th World Congress on Clinical Pharamacology and Therapeutics, Brisbane, Australia, 1-6 August 2004. More
APR has successfully designed and completed the development of Veloderm, an innovative Biotechnology device for wound healing and licensed to Medestea the exclusive worldwide marketing rights More
Cambridge, 4 November 2010 - One Nucleus, the not-for-profit membership company for international life science and healthcare companies, is to launch a series of high level conferences focused on specific technology areas, replacing its annual BioPartneri More
GlaxoSmithKline obtains exclusive rights for an innovative topical patch to treat cold sores More
tesa AG, based in Hamburg, has acquired Labtec Gesellschaft für technologische Forschung und Entwicklung mbH More
A dozen University of Western Ontario research projects, including ensuring innovative research on Metabolic Syndrome and personalized medicine, have received $19-million from the Ontario Research Fund. More
New summary from Partneringdesk highlights trends in dealmaking from the top pharma and biotech companies More
Bridgehead International has been honoured with The Queen's Award for Enterprise 2007, in the International Trade section, for outstanding achievement in international trade More
Displaying 1..10 of 87 - per page Next page
Order by

Related Reports

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

(website) 45 queries took 541 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `press_release`13131
2DESCRIBE `company`27271
3DESCRIBE `condet`17171
4DESCRIBE `countrycode`442
5DESCRIBE `person`15152
6DESCRIBE `account`29291
7DESCRIBE `product_legacy`661
8DESCRIBE `sales_people`667
9DESCRIBE `profile`14141
10DESCRIBE `currencies`771
11DESCRIBE `update_rec`771
12DESCRIBE `user`24242
13DESCRIBE `enquiry`14143
14DESCRIBE `module_types`661
15DESCRIBE `dms_companies`26261
16DESCRIBE `dms_releases`10108
17DESCRIBE `dms_categories`447
18DESCRIBE `dms_clinical_areas`441
19DESCRIBE `dms_categories_dms_releases`221
20DESCRIBE `dms_clinical_areas_dms_releases`221
21DESCRIBE `dms_releases_sites`551
22DESCRIBE `licopp`23231
23DESCRIBE `development_statuses`551
24DESCRIBE `category`14141
25DESCRIBE `categories_sites`550
26DESCRIBE `categorisation`881
27DESCRIBE `licopps_sites`330
28DESCRIBE `service`15151
29DESCRIBE `story`12121
30DESCRIBE `sites_stories`551
31DESCRIBE `story_assoc`441
32DESCRIBE `companies_sites`331
33DESCRIBE `categories_users`221
34DESCRIBE `authority`331
35DESCRIBE `sites_users`551
36DESCRIBE `press_releases_sites`552
37DESCRIBE `sites`551
38SELECT `Site`.`id`, `Site`.`name`, `Site`.`email_domain`, `Site`.`short_name`, `Site`.`brand` FROM `sites` AS `Site` WHERE `Site`.`id` = 1 LIMIT 1111
39SELECT c.uid, c.name FROM category c WHERE c.parent = 297 ORDER BY c.name 11110
40SELECT c.uid, c.name FROM category c WHERE c.parent = 641 ORDER BY c.name 20201
41SELECT DISTINCT SUBSTRING(issued, 1, 4) AS publication_year FROM press_release AS Press WHERE is_live = 1 AND issued IS NOT NULL ORDER BY publication_year DESC 14141
42SELECT c.lft, c.rgt FROM category c WHERE c.uid = 641111
43SELECT 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 111
44SELECT press_release.uid, press_release.slug, press_release.headline, press_release.summary FROM press_release JOIN company AS Company ON press_release.company_id=Company.uid INNER JOIN categorisation tt_ctg ON tt_ctg.story_id = press_release.uid AND tt_ctg.cat_type = "R" AND tt_ctg.category_id IN (SELECT uid FROM category WHERE (lft >= 3463 AND rgt <= 3504) ) WHERE press_release.is_live > 0 AND (press_release.company_id IS NULL OR (Company.is_live="y" AND press_release.company_id=Company.uid)) GROUP BY press_release.uid ORDER BY press_release.viewed_counter DESC, press_release.headline LIMIT 0, 10 1010277
45SELECT count(DISTINCT press_release.uid) AS total FROM press_release JOIN company AS Company ON press_release.company_id=Company.uid INNER JOIN categorisation tt_ctg ON tt_ctg.story_id = press_release.uid AND tt_ctg.cat_type = "R" AND tt_ctg.category_id IN (SELECT uid FROM category WHERE (lft >= 3463 AND rgt <= 3504) ) WHERE press_release.is_live > 0 AND (press_release.company_id IS NULL OR (Company.is_live="y" AND press_release.company_id=Company.uid)) 11199
(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 ("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