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 398 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `press_release`13137
2DESCRIBE `company`27272
3DESCRIBE `condet`17172
4DESCRIBE `countrycode`4410
5DESCRIBE `person`15152
6DESCRIBE `account`29292
7DESCRIBE `product_legacy`6615
8DESCRIBE `sales_people`663
9DESCRIBE `profile`14142
10DESCRIBE `currencies`771
11DESCRIBE `update_rec`771
12DESCRIBE `user`24246
13DESCRIBE `enquiry`14142
14DESCRIBE `module_types`661
15DESCRIBE `dms_companies`26261
16DESCRIBE `dms_releases`10102
17DESCRIBE `dms_categories`442
18DESCRIBE `dms_clinical_areas`442
19DESCRIBE `dms_categories_dms_releases`222
20DESCRIBE `dms_clinical_areas_dms_releases`221
21DESCRIBE `dms_releases_sites`552
22DESCRIBE `licopp`23232
23DESCRIBE `development_statuses`552
24DESCRIBE `category`14142
25DESCRIBE `categories_sites`554
26DESCRIBE `categorisation`882
27DESCRIBE `licopps_sites`332
28DESCRIBE `service`15153
29DESCRIBE `story`12121
30DESCRIBE `sites_stories`552
31DESCRIBE `story_assoc`441
32DESCRIBE `companies_sites`332
33DESCRIBE `categories_users`224
34DESCRIBE `authority`331
35DESCRIBE `sites_users`553
36DESCRIBE `press_releases_sites`552
37DESCRIBE `sites`555
38SELECT `Site`.`id`, `Site`.`name`, `Site`.`email_domain`, `Site`.`short_name`, `Site`.`brand` FROM `sites` AS `Site` WHERE `Site`.`id` = 1 LIMIT 1115
39SELECT c.uid, c.name FROM category c WHERE c.parent = 297 ORDER BY c.name 11111
40SELECT c.uid, c.name FROM category c WHERE c.parent = 641 ORDER BY c.name 20207
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 = 641110
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 1010140
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)) 11137
(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 12 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 10101012