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

Articles

Innovaro Pharmalicensing brings you advice, commentary and analysis from industry experts.

Articles Search

Search the Innovaro Pharmalicensing articles directory by keyword. Alternatively our advanced search allows you to query by category, author and year of publishing.
 
Industrial sector Therapeutic target
Author
To choose more then one item on the list hold CTRL button while selecting. To deselect items press CTRL button and deselect.

Recently Added

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
Taking place on the 19th-20th January, BioBusiness 2011 will comprise industry debates, keynote addresses, informal networking and peer-to-peer roundtable discussions. More
This meeting was a great opportunity to listen to the experience of various stakeholders about the current environment in a very open and friendly atmosphere’ More
BioBusiness has been carefully designed to offer you maximum formal and informal networking time. More
The 4th edition of BIO-Europe Spring® will attract leaders from the international biotech industry to Barcelona, Spain on March 8-10. More

Most Viewed

Epilepsy, one of the oldest conditions known to mankind, is a neurological disorder characterised by recurrent, transient seizures caused by a disturbance in the electrical activity of the central nervous system. More
In today's fervently age-conscious society, where maturity is widely regarded as a social handicap on a par with halitosis, why should women hoping to maintain their youthful good looks spend their days at sea level? More
This article examines exclusive, sole and non-exclusive licences of intellectual property rights and the respective meanings of the terms. More
A survey of softgel drug delivery systems. More
In the news and around the water cooler, people are talking about the price of health care and prescription drugs. More

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

(website) 49 queries took 421 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `feature_article`131317
2DESCRIBE `feature_author`13133
3DESCRIBE `user`24241
4DESCRIBE `condet`17171
5DESCRIBE `countrycode`443
6DESCRIBE `company`27272
7DESCRIBE `person`15153
8DESCRIBE `account`29292
9DESCRIBE `product_legacy`663
10DESCRIBE `sales_people`662
11DESCRIBE `profile`141422
12DESCRIBE `currencies`773
13DESCRIBE `update_rec`7713
14DESCRIBE `dms_companies`26265
15DESCRIBE `dms_releases`10101
16DESCRIBE `dms_categories`442
17DESCRIBE `dms_clinical_areas`446
18DESCRIBE `dms_categories_dms_releases`222
19DESCRIBE `dms_clinical_areas_dms_releases`224
20DESCRIBE `dms_releases_sites`552
21DESCRIBE `licopp`23237
22DESCRIBE `development_statuses`5526
23DESCRIBE `category`14141
24DESCRIBE `categories_sites`5512
25DESCRIBE `categorisation`883
26DESCRIBE `licopps_sites`331
27DESCRIBE `service`15151
28DESCRIBE `enquiry`14142
29DESCRIBE `module_types`663
30DESCRIBE `press_release`131315
31DESCRIBE `press_releases_sites`552
32DESCRIBE `story`12122
33DESCRIBE `sites_stories`552
34DESCRIBE `story_assoc`443
35DESCRIBE `companies_sites`334
36DESCRIBE `categories_users`222
37DESCRIBE `authority`332
38DESCRIBE `sites_users`553
39DESCRIBE `sites`5513
40SELECT `Site`.`id`, `Site`.`name`, `Site`.`email_domain`, `Site`.`short_name`, `Site`.`brand` FROM `sites` AS `Site` WHERE `Site`.`id` = 1 LIMIT 1112
41SELECT uid, name FROM category WHERE parent = 297 AND (restricted = "C" OR restricted IS NULL) ORDER BY name 11111
42SELECT uid, name FROM category WHERE parent = 560 AND (restricted = "C" OR restricted IS NULL) ORDER BY name 20201
43SELECT fa.uid, fa.headline FROM feature_author fa ORDER BY fa.headline 73733
44SELECT Article.uid,Article.slug,Article.headline,Article.summary,Article.viewed_counter FROM feature_article AS Article WHERE Article.is_live>0 GROUP BY Article.uid ORDER BY viewed_counter DESC, Article.headline LIMIT 5552
45SELECT `Article`.`uid`, `Article`.`slug`, `Article`.`issued`, `Article`.`headline`, `Article`.`summary`, `Category`.`uid` FROM `feature_article` AS `Article` LEFT JOIN categorisation AS `Categorisation` ON (`Categorisation`.`story_id` = `Article`.`uid`) LEFT JOIN category AS `Category` ON (`Category`.`uid` = `Categorisation`.`category_id`) LEFT JOIN `feature_author` AS `Author` ON (`Article`.`author` = `Author`.`uid`) LEFT JOIN `user` AS `User` ON (`Article`.`user_id` = `User`.`uid`) WHERE `Article`.`is_live` = 1 AND `Article`.`issued` <= '2012-02-22T22:09:50' GROUP BY `Article`.`uid` ORDER BY `Article`.`issued` DESC LIMIT 555206
46SELECT `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 ('1320403760_4eb3c330c8165', '1288873128_4cd2a4a89f3e9', '1281112259_4c5c38c30dfa9', '1256664303_4ae72cef092f9', '1263552474_4b5047da07a48') AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="F" ORDER BY `Category`.`lft` ASC 12121
47SELECT c.uid, c.name FROM category c WHERE c.parent = 297 ORDER BY c.name 11111
48SELECT c.uid, c.name FROM category c WHERE c.parent = 560 ORDER BY c.name 20202
49SELECT 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