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

        if ($this->_init && !is_writable($this->settings['path'])) {
            $this->_init = false;
            trigger_error(sprintf(__('%s is not writable', true), $this->settings['path']), E_USER_WARNING);

FileEngine::__active() - CORE/cake/libs/cache/file.php, line 267
FileEngine::init() - CORE/cake/libs/cache/file.php, line 94
Cache::_buildEngine() - CORE/cake/libs/cache.php, line 151
Cache::config() - CORE/cake/libs/cache.php, line 126
include - /home/pharma/website/releases/20111112181849/cakephp/app/pharmalicensing/config/core.php, line 345
Configure::__loadBootstrap() - CORE/cake/libs/configure.php, line 391
Configure::getInstance() - CORE/cake/libs/configure.php, line 52
include - CORE/cake/bootstrap.php, line 38
[main] - /home/pharma/website/releases/20111112181849/cakephp/webroot/pharmalicensing/index.php, line 100

Press releases

Stay current with the latest press releases from within the industry.

Submit Press Release

A Pharmalicensing Intelligence subscription will allow you to submit press release drafts. Press release drafts are assessed and published by our Pharmalicensing Intelligence team.

Pharmalicensing Intelligence

Latest Press Releases

Innocoll Announces Successful End-of-Phase 2 Meeting with FDA for XaraColl® and Agreement of the Phase 3 Program

Innocoll Announces Successful End-of-Phase 2 Meeting with FDA for XaraColl® and Agreement of the Phase 3 Program more

Innocoll Enters CollaGUARD® Distribution Partnership with Flynn Pharma Ltd in the UK and Inresa Arzneimittel GmbH in Germany

Innocoll Enters CollaGUARD® Distribution Partnership with Flynn Pharma Ltd in the UK and Inresa Arzneimittel GmbH in Germany more

APR Applied Pharma Research s.a., Labtec GmbH and Norgine BV Announce the Signature of an Exclusive Licensing Agreement under Which Norgine Will Market and Distribute Setofilm™

APR Applied Pharma Research s.a. (“APR”), Labtec GmbH (“Labtec”) and Norgine BV (“Norgine”) announce the signature of an exclusive licensing agreement under which Norgine will market and... more

APR Applied Pharma Research s.a. , Labtec GmbH and Norgine announce the signature of an exclusive licensing agreement under which Norgine will market and distribute Setofilm(TM)

Norgine and APR, together with its joint venture partner Labtec, today announced that they have entered into an exclusive licensing agreement under which Norgine has acquired the commercialization... more

Press release search

Year	Industrial sector
Search the Innovaro Pharmalicensing Press Releases by keyword. Alternatively our advanced search allows you to query by therapeutic target and industry sector.


Therapeutic target


To choose more then one item on the list hold CTRL button while selecting. To deselect items press CTRL button and deselect.

Most viewed press releases

euroPLX Introduces Tool to Overcome Reject vs. Accept Dilemma in Partnering

Genesis Conference on target to exceed all previous years

Two papers on Neo-Penotran® Forte and Neo-Penotran® Forte-L have been accepted for presentation at the 4'th World Conference on Vaginitis, Costa Rica, 10-13 Jan 2004

TDS® TESTOSTERONE EXCEEDS ANDROGEL® OUTCOMES

Labtec´s sufentanil patch for chronic pain enters phase II in cooperation with hameln rds GmbH

RSS Feed...

More recent press releases

The Most Important Business Platform for Many Life Science Companies

Returning customers make euroPLX the most often attended partnering conference. (more)

Innovaro Announces Successful Sale of the Waycool Portfolio of Patents by CUI Global, Inc.

Tampa, FL -- (Business Wire) – January 5, 2012 – Innovaro, Inc (NYSE Amex: INV), a leading IP licensing and innovation services company, is pleased to announce that its client CUI Global, Inc. (formerly Waytronx) has completed the sale of selected patents (more)

UAMS BioVentures company Myeloma Health, LLC continues to grow its diversified menu of cancer diagnostic signatures

Signal Genetics to launch second generation Myeloma product, MyPRS Plus (more)

Health Protection Agency welcomes the Approval of ERWINAZE™ Biologics License Application for Treatment of Acute Lymphoblastic Leukemia

Salisbury, UK – 18th November 2011 – the Health Protection Agency (HPA) today welcomed the news that the U.S. Food and Drug Administration (FDA) has approved the Biologics License Application (BLA) for ERWINAZE™. The application was made by the HPA’s dev (more)

Innocoll Enters Partnership with Merus Labs in Canada for the Distribution of CollaGUARD

ASHBURN, VA., November 15, 2011 /PRNewswire/ –– Innocoll Inc. announced it has entered into a License and Distribution Agreement with Merus Labs Inc. in Canada for CollaGUARD surgical adhesion barrier for the prevention of postoperative adhesions follow (more)

New Building for Amarin Technologies S.A.

Amarin Technologies S.A. is proud to announce its moving to a new building located in Sanchez 2045, C1416BQG Buenos Aires, Argentina. (more)

Bridgehead International Appoints Expert in Global Pricing and Market Access for Oncology Products

Melton Mowbray 17 October 2011 ......Bridgehead International is pleased to announce the appointment of Chris Teale as Principal Consultant. (more)

Bridgehead International announces publication by The Personalized Medicine Coalition (PMC) of a white paper entitled “Advancing Access to Personalized Medicine: A Comparative Assessment

London 17 October 2011 ……Bridgehead International is pleased to announce publication by The Personalized Medicine Coalition (PMC) of a white paper entitled “Advancing Access to Personalized Medicine: A Comparative Assessment of European Reimbursement Syst (more)

Innocoll Enters Partnership with Pioneer Pharma in China for the Distribution of CollaGUARD

Innocoll Enters Partnership with Pioneer Pharma in China for the Distribution of CollaGUARD (more)

Working demonstration of the Gamlen Tablet Press planned for AAPS Exposition

Gamlen Tableting Limited will be demonstrating the latest model of the Gamlen Tablet Press at the AAPS exposition in Washington DC (Stand 1346, 23rd - 27th October 2011, Washington Convention Center, Washington DC, USA.) (more)

Browse By

Industry sector: Academic/Research; Animal health; Biotechnology; Diagnostic; Drug delivery; Drug discovery; Medical device; Non-profit org./Government; Pharmaceutical; Research tools; Service
Therapeutic target: Accident and Trauma; Allergy; Blood and forming organs; Cardiovascular; Central Nervous System; Dermatological; Endocrinology; Gastrointestinal; Genetic disorders; Genito-urinary; Hospital and Surgery; Immune related disorders; Infectious diseases; Metabolism; Musculoskeletal; Oncology; Oral Health; Other therapeutic; Respiratory; Sensory organ
Year: 2012; 2011; 2010; 2009; 2008; 2007; 2006; 2005; 2004; 2003; 2002; 2001; 2000; 1999

Products:	Partnering Search	Company Profiling	Pharmalicensing Intelligence	Reports	Comparision
In-licensing:	Latest records	Industry Sector	Therapeutic Target	Search	Profile your company	Pharma partnering
Out-licensing:	Latest records	Industry Sector	Therapeutic Target	Search	Profile your company	Pharma partnering
Companies:	Profiled companies	Industry Sector	Therapeutic Target	Geographic Location	Search	Add your company
Reports:	Biotechnology	Business Development	Management	Market & Sales	Medical Devices	Pharmaceuticals
News:	Deals & Alliances	Development	Financial Results	Financings	Intellectual Property	Regulatory
Events:	Pharma events	Calendar	Organizers	Featured events	Search
Articles:	Industrial Sector	Therapeutic Target	Articles date
Deals:	Industry Sector	Therapeutic Target	Deals Date	Search	Reports	Press releases
About us:	Our Audience	Case Studies	Newsletter	FAQ	Contact us	Site map

(website) 50 queries took 1896 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `press_release`	13	13	6
2	DESCRIBE `company`	27	27	2
3	DESCRIBE `condet`	17	17	2
4	DESCRIBE `countrycode`	4	4	9
5	DESCRIBE `person`	15	15	1
6	DESCRIBE `account`	29	29	14
7	DESCRIBE `product_legacy`	6	6	1
8	DESCRIBE `sales_people`	6	6	1
9	DESCRIBE `profile`	14	14	1
10	DESCRIBE `currencies`	7	7	2
11	DESCRIBE `update_rec`	7	7	8
12	DESCRIBE `user`	24	24	4
13	DESCRIBE `enquiry`	14	14	15
14	DESCRIBE `module_types`	6	6	3
15	DESCRIBE `dms_companies`	26	26	2
16	DESCRIBE `dms_releases`	10	10	7
17	DESCRIBE `dms_categories`	4	4	1
18	DESCRIBE `dms_clinical_areas`	4	4	3
19	DESCRIBE `dms_categories_dms_releases`	2	2	1
20	DESCRIBE `dms_clinical_areas_dms_releases`	2	2	1
21	DESCRIBE `dms_releases_sites`	5	5	32
22	DESCRIBE `licopp`	23	23	2
23	DESCRIBE `development_statuses`	5	5	1
24	DESCRIBE `category`	14	14	1
25	DESCRIBE `categories_sites`	5	5	4
26	DESCRIBE `categorisation`	8	8	1
27	DESCRIBE `licopps_sites`	3	3	1
28	DESCRIBE `service`	15	15	8
29	DESCRIBE `story`	12	12	1
30	DESCRIBE `sites_stories`	5	5	2
31	DESCRIBE `story_assoc`	4	4	1
32	DESCRIBE `companies_sites`	3	3	1
33	DESCRIBE `categories_users`	2	2	37
34	DESCRIBE `authority`	3	3	1
35	DESCRIBE `sites_users`	5	5	1
36	DESCRIBE `press_releases_sites`	5	5	1
37	DESCRIBE `sites`	5	5	1
38	SELECT `Site`.`id`, `Site`.`name`, `Site`.`email_domain`, `Site`.`short_name`, `Site`.`brand` FROM `sites` AS `Site` WHERE `Site`.`id` = 1 LIMIT 1	1	1	1
39	SELECT DISTINCT SUBSTRING(issued, 1, 4) AS publication_year FROM press_release INNER JOIN press_releases_sites Site ON press_release.uid = Site.press_release_id AND Site.site_id = 1 WHERE is_live = 1 AND issued IS NOT NULL ORDER BY publication_year DESC	14	14	0
40	SELECT uid, name FROM category INNER JOIN categories_sites Site ON category.uid = Site.category_id AND Site.site_id = 1 WHERE parent = 297 AND (restricted = "C" OR restricted IS NULL) ORDER BY name	11	11	1
41	SELECT uid, name FROM category INNER JOIN categories_sites Site ON category.uid = Site.category_id AND Site.site_id = 1 WHERE parent = 560 AND (restricted = "C" OR restricted IS NULL) ORDER BY name	20	20	1
42	SELECT c.uid, c.name FROM category c WHERE c.parent = 297 ORDER BY c.name	11	11	1
43	SELECT c.uid, c.name FROM category c WHERE c.parent = 560 ORDER BY c.name	20	20	1
44	SELECT 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	14	14	1
45	SELECT `Press`.`uid`, `Press`.`slug`, `Press`.`company_id`, `Press`.`created`, `Press`.`lastmod`, `Press`.`issued`, `Press`.`headline`, `Press`.`summary`, `Press`.`body`, `Press`.`is_live`, `Press`.`is_attachment`, `Press`.`user_id`, `Press`.`viewed_counter`, `Company`.`uid`, `Company`.`slug`, `Company`.`name`, `Company`.`condet_id`, `Company`.`person_id`, `Company`.`billing_id`, `Company`.`parent`, `Company`.`has_children`, `Company`.`notes_id`, `Company`.`contact_status`, `Company`.`last_contacted`, `Company`.`profile_id`, `Company`.`account_id`, `Company`.`summary`, `Company`.`is_customer`, `Company`.`change_time`, `Company`.`flags`, `Company`.`is_anon`, `Company`.`is_resource`, `Company`.`satellite`, `Company`.`no_dms`, `Company`.`is_live`, `Company`.`viewed_counter`, `Company`.`created`, `Company`.`last_disabled`, `Company`.`no_trial`, `Company`.`trial_notification_sent`, `User`.`uid`, `User`.`email`, `User`.`name`, `User`.`password`, `User`.`lastlogin`, `User`.`currency`, `User`.`person`, `User`.`customer`, `User`.`operator`, `User`.`company`, `User`.`wantsmail`, `User`.`passwordclue`, `User`.`alias`, `User`.`username`, `User`.`person_id`, `User`.`condet_id`, `User`.`company_id`, `User`.`signup_date`, `User`.`alert_inlic`, `User`.`alert_outlic`, `User`.`alert_company`, `User`.`alert_events`, `User`.`alert_lasttime`, `User`.`stats_access`, `PressSite`.`id`, `PressSite`.`created`, `PressSite`.`modified`, `PressSite`.`press_release_id`, `PressSite`.`site_id` FROM `press_release` AS `Press` LEFT JOIN `company` AS `Company` ON (`Press`.`company_id` = `Company`.`uid`) LEFT JOIN `user` AS `User` ON (`Press`.`user_id` = `User`.`uid`) LEFT JOIN `press_releases_sites` AS `PressSite` ON (`PressSite`.`press_release_id` = `Press`.`uid`) WHERE `PressSite`.`site_id` = 1 AND `Press`.`is_live`="1" AND `Press`.`issued` <= now() AND (`Press`.`company_id` IS NULL OR (`Press`.`company_id` IS NOT NULL AND `Company`.`is_live`="Y")) ORDER BY `Press`.`issued` DESC LIMIT 14	14	14	1221
46	SELECT `Category`.`uid`, `Category`.`name`, `Category`.`parent`, `Category`.`has_children`, `Category`.`show_children`, `Category`.`show_grandchildren`, `Category`.`members`, `Category`.`num_children`, `Category`.`root`, `Category`.`restricted`, `Category`.`clan`, `Category`.`lft`, `Category`.`rgt`, `Category`.`level`, `Categorisation`.`id`, `Categorisation`.`company_id`, `Categorisation`.`buysell`, `Categorisation`.`category_id`, `Categorisation`.`browse_category_id`, `Categorisation`.`cat_type`, `Categorisation`.`story_id`, `Categorisation`.`network_id` FROM `category` AS `Category` JOIN `categorisation` AS `Categorisation` ON (`Categorisation`.`story_id` IN ('1329480732_4f3e441cc2e60', '1328089169_4f290851cf01d', '1326985104_4f182f906aa9e', '1326893322_4f16c90a1054c', '1326122303_4f0b053fa0ab3', '1325773429_4f05b2751fc19', '1324473732_4ef1dd84d7af4', '1321896942_4eca8beed70e6', '1321358440_4ec25468ba113', '1319566262_4ea6fbb63a557', '1319100585_4e9fe0a90f9db', '1319100933_4e9fe205aecc4', '1319018074_4e9e9e5a8039f', '1318932066_4e9d4e62cd666') AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="R" ORDER BY `Category`.`root` ASC, `Category`.`clan` ASC, `Category`.`parent` ASC, `Category`.`name` ASC	57	57	2
47	SELECT `Category`.`uid`, `Category`.`name` FROM `category` AS `Category` LEFT JOIN `category` AS `Parent` ON (`Category`.`parent` = `Parent`.`uid`) LEFT JOIN `categories_sites` AS `CategorySite` ON (`CategorySite`.`category_id` = `Category`.`uid`) WHERE `CategorySite`.`site_id` = 1 AND `Category`.`root`="560" AND `Category`.`level`="2" ORDER BY `Category`.`name` ASC	20	20	15
48	SELECT `Category`.`uid`, `Category`.`name` FROM `category` AS `Category` LEFT JOIN `category` AS `Parent` ON (`Category`.`parent` = `Parent`.`uid`) LEFT JOIN `categories_sites` AS `CategorySite` ON (`CategorySite`.`category_id` = `Category`.`uid`) WHERE `CategorySite`.`site_id` = 1 AND `Category`.`root`="297" AND `Category`.`level`="2" ORDER BY `Category`.`name` ASC	11	11	38
49	SELECT DISTINCT SUBSTRING(issued, 1, 4) AS publication_year FROM press_release WHERE is_live = 1 AND issued IS NOT NULL ORDER BY publication_year DESC	14	14	1
50	SELECT `Press`.`uid`, `Press`.`headline`, `Press`.`slug` FROM `press_release` AS `Press` LEFT JOIN `company` AS `Company` ON (`Press`.`company_id` = `Company`.`uid`) LEFT JOIN `user` AS `User` ON (`Press`.`user_id` = `User`.`uid`) LEFT JOIN `press_releases_sites` AS `PressSite` ON (`PressSite`.`press_release_id` = `Press`.`uid`) WHERE `PressSite`.`site_id` = 1 AND `Press`.`is_live`="1" AND (`Press`.`company_id` IS NULL OR (`Press`.`company_id` IS NOT NULL AND `Company`.`is_live`="Y")) ORDER BY `Press`.`viewed_counter` DESC, `Press`.`issued` DESC LIMIT 5	5	5	433

(website) 50 queries took 1896 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `press_release`

DESCRIBE `company`

DESCRIBE `condet`

DESCRIBE `countrycode`

DESCRIBE `person`

DESCRIBE `account`

DESCRIBE `product_legacy`

DESCRIBE `sales_people`

DESCRIBE `profile`

DESCRIBE `currencies`

DESCRIBE `update_rec`

DESCRIBE `user`

DESCRIBE `enquiry`

DESCRIBE `module_types`

DESCRIBE `dms_companies`

DESCRIBE `dms_releases`

DESCRIBE `dms_categories`

DESCRIBE `dms_clinical_areas`

DESCRIBE `dms_categories_dms_releases`

DESCRIBE `dms_clinical_areas_dms_releases`

DESCRIBE `dms_releases_sites`

DESCRIBE `licopp`

DESCRIBE `development_statuses`

DESCRIBE `category`

DESCRIBE `categories_sites`

DESCRIBE `categorisation`

DESCRIBE `licopps_sites`

DESCRIBE `service`

DESCRIBE `story`

DESCRIBE `sites_stories`

DESCRIBE `story_assoc`

DESCRIBE `companies_sites`

DESCRIBE `categories_users`

DESCRIBE `authority`

DESCRIBE `sites_users`

DESCRIBE `press_releases_sites`

DESCRIBE `sites`

SELECT `Site`.`id`, `Site`.`name`, `Site`.`email_domain`, `Site`.`short_name`, `Site`.`brand` FROM `sites` AS `Site` WHERE `Site`.`id` = 1 LIMIT 1

SELECT DISTINCT SUBSTRING(issued, 1, 4) AS publication_year FROM press_release INNER JOIN press_releases_sites Site ON press_release.uid = Site.press_release_id AND Site.site_id = 1 WHERE is_live = 1 AND issued IS NOT NULL ORDER BY publication_year DESC

SELECT uid, name FROM category INNER JOIN categories_sites Site ON category.uid = Site.category_id AND Site.site_id = 1 WHERE parent = 297 AND (restricted = "C" OR restricted IS NULL) ORDER BY name

SELECT uid, name FROM category INNER JOIN categories_sites Site ON category.uid = Site.category_id AND Site.site_id = 1 WHERE parent = 560 AND (restricted = "C" OR restricted IS NULL) ORDER BY name

SELECT c.uid, c.name FROM category c WHERE c.parent = 297 ORDER BY c.name

SELECT c.uid, c.name FROM category c WHERE c.parent = 560 ORDER BY c.name

SELECT 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

SELECT `Press`.`uid`, `Press`.`slug`, `Press`.`company_id`, `Press`.`created`, `Press`.`lastmod`, `Press`.`issued`, `Press`.`headline`, `Press`.`summary`, `Press`.`body`, `Press`.`is_live`, `Press`.`is_attachment`, `Press`.`user_id`, `Press`.`viewed_counter`, `Company`.`uid`, `Company`.`slug`, `Company`.`name`, `Company`.`condet_id`, `Company`.`person_id`, `Company`.`billing_id`, `Company`.`parent`, `Company`.`has_children`, `Company`.`notes_id`, `Company`.`contact_status`, `Company`.`last_contacted`, `Company`.`profile_id`, `Company`.`account_id`, `Company`.`summary`, `Company`.`is_customer`, `Company`.`change_time`, `Company`.`flags`, `Company`.`is_anon`, `Company`.`is_resource`, `Company`.`satellite`, `Company`.`no_dms`, `Company`.`is_live`, `Company`.`viewed_counter`, `Company`.`created`, `Company`.`last_disabled`, `Company`.`no_trial`, `Company`.`trial_notification_sent`, `User`.`uid`, `User`.`email`, `User`.`name`, `User`.`password`, `User`.`lastlogin`, `User`.`currency`, `User`.`person`, `User`.`customer`, `User`.`operator`, `User`.`company`, `User`.`wantsmail`, `User`.`passwordclue`, `User`.`alias`, `User`.`username`, `User`.`person_id`, `User`.`condet_id`, `User`.`company_id`, `User`.`signup_date`, `User`.`alert_inlic`, `User`.`alert_outlic`, `User`.`alert_company`, `User`.`alert_events`, `User`.`alert_lasttime`, `User`.`stats_access`, `PressSite`.`id`, `PressSite`.`created`, `PressSite`.`modified`, `PressSite`.`press_release_id`, `PressSite`.`site_id` FROM `press_release` AS `Press` LEFT JOIN `company` AS `Company` ON (`Press`.`company_id` = `Company`.`uid`) LEFT JOIN `user` AS `User` ON (`Press`.`user_id` = `User`.`uid`) LEFT JOIN `press_releases_sites` AS `PressSite` ON (`PressSite`.`press_release_id` = `Press`.`uid`) WHERE `PressSite`.`site_id` = 1 AND `Press`.`is_live`="1" AND `Press`.`issued` <= now() AND (`Press`.`company_id` IS NULL OR (`Press`.`company_id` IS NOT NULL AND `Company`.`is_live`="Y")) ORDER BY `Press`.`issued` DESC LIMIT 14

1221

SELECT `Category`.`uid`, `Category`.`name`, `Category`.`parent`, `Category`.`has_children`, `Category`.`show_children`, `Category`.`show_grandchildren`, `Category`.`members`, `Category`.`num_children`, `Category`.`root`, `Category`.`restricted`, `Category`.`clan`, `Category`.`lft`, `Category`.`rgt`, `Category`.`level`, `Categorisation`.`id`, `Categorisation`.`company_id`, `Categorisation`.`buysell`, `Categorisation`.`category_id`, `Categorisation`.`browse_category_id`, `Categorisation`.`cat_type`, `Categorisation`.`story_id`, `Categorisation`.`network_id` FROM `category` AS `Category` JOIN `categorisation` AS `Categorisation` ON (`Categorisation`.`story_id` IN ('1329480732_4f3e441cc2e60', '1328089169_4f290851cf01d', '1326985104_4f182f906aa9e', '1326893322_4f16c90a1054c', '1326122303_4f0b053fa0ab3', '1325773429_4f05b2751fc19', '1324473732_4ef1dd84d7af4', '1321896942_4eca8beed70e6', '1321358440_4ec25468ba113', '1319566262_4ea6fbb63a557', '1319100585_4e9fe0a90f9db', '1319100933_4e9fe205aecc4', '1319018074_4e9e9e5a8039f', '1318932066_4e9d4e62cd666') AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="R" ORDER BY `Category`.`root` ASC, `Category`.`clan` ASC, `Category`.`parent` ASC, `Category`.`name` ASC

SELECT `Category`.`uid`, `Category`.`name` FROM `category` AS `Category` LEFT JOIN `category` AS `Parent` ON (`Category`.`parent` = `Parent`.`uid`) LEFT JOIN `categories_sites` AS `CategorySite` ON (`CategorySite`.`category_id` = `Category`.`uid`) WHERE `CategorySite`.`site_id` = 1 AND `Category`.`root`="560" AND `Category`.`level`="2" ORDER BY `Category`.`name` ASC

SELECT `Category`.`uid`, `Category`.`name` FROM `category` AS `Category` LEFT JOIN `category` AS `Parent` ON (`Category`.`parent` = `Parent`.`uid`) LEFT JOIN `categories_sites` AS `CategorySite` ON (`CategorySite`.`category_id` = `Category`.`uid`) WHERE `CategorySite`.`site_id` = 1 AND `Category`.`root`="297" AND `Category`.`level`="2" ORDER BY `Category`.`name` ASC

SELECT DISTINCT SUBSTRING(issued, 1, 4) AS publication_year FROM press_release WHERE is_live = 1 AND issued IS NOT NULL ORDER BY publication_year DESC

SELECT `Press`.`uid`, `Press`.`headline`, `Press`.`slug` FROM `press_release` AS `Press` LEFT JOIN `company` AS `Company` ON (`Press`.`company_id` = `Company`.`uid`) LEFT JOIN `user` AS `User` ON (`Press`.`user_id` = `User`.`uid`) LEFT JOIN `press_releases_sites` AS `PressSite` ON (`PressSite`.`press_release_id` = `Press`.`uid`) WHERE `PressSite`.`site_id` = 1 AND `Press`.`is_live`="1" AND (`Press`.`company_id` IS NULL OR (`Press`.`company_id` IS NOT NULL AND `Company`.`is_live`="Y")) ORDER BY `Press`.`viewed_counter` DESC, `Press`.`issued` DESC LIMIT 5

433

Accident and Trauma
Allergy
Blood and forming organs
Cardiovascular
Central Nervous System
Dermatological
Endocrinology
Gastrointestinal
Genetic disorders
Genito-urinary
Hospital and Surgery
Immune related disorders
Infectious diseases
Metabolism
Musculoskeletal
Oncology
Oral Health
Other therapeutic
Respiratory
Sensory organ