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

Out-licensing

Up-to-date access to technology licensing opportunities worldwide.

Licensing opportunities

Displaying 1..10 of 1018 - per page Next page
Order by
Collagen-based dressings for wound management More
25 and 50 mg diclofenac K film coated immediate release tablets More
The unique ORS effervescent tablet has been developed according to the latest guidelines of the WHO. It has a substantial marketshare in several countries. We are looking for partners to further expand this success. More
Conception aid, fertility cup More
Apitoxin is a new biological drug for pain & inflammation and arthritis, approved by the Korean FDA on May 3, 2003 after 14 years of preclinical, animal, and phase I, II & III clinical studies More
Adhesive Patch of 90 sq. cm. and containing as active ingredient 100 mg. of ketoprofen for the local treatment of traumatic injuries and extra-articular rheumatism More
25mg dosage strenght for the OTC market in film coated tablets More
Capsaicin, the active ingredient found in red-hot peppers, is used mainly for the relief of chronic pain of rheumatoid arthritis and osteoarthritis More
Collagen-based biodegradable matrices for localized drug delivery More
Novel patent pending in dermatology: combination of a well known topical antibiotic with a topical steroid indicated for skin infections with inflammatory process More
Displaying 1..10 of 1018 - 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 157 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `licopp`23231
2DESCRIBE `company`272712
3DESCRIBE `condet`17171
4DESCRIBE `countrycode`441
5DESCRIBE `person`15151
6DESCRIBE `account`29291
7DESCRIBE `product_legacy`6612
8DESCRIBE `sales_people`661
9DESCRIBE `profile`14141
10DESCRIBE `currencies`771
11DESCRIBE `update_rec`772
12DESCRIBE `user`24241
13DESCRIBE `enquiry`141411
14DESCRIBE `module_types`661
15DESCRIBE `dms_companies`26262
16DESCRIBE `dms_releases`10109
17DESCRIBE `dms_categories`441
18DESCRIBE `dms_clinical_areas`441
19DESCRIBE `dms_categories_dms_releases`221
20DESCRIBE `dms_clinical_areas_dms_releases`222
21DESCRIBE `dms_releases_sites`551
22DESCRIBE `development_statuses`556
23DESCRIBE `category`14141
24DESCRIBE `categories_sites`551
25DESCRIBE `categorisation`8812
26DESCRIBE `licopps_sites`332
27DESCRIBE `service`15159
28DESCRIBE `press_release`13135
29DESCRIBE `press_releases_sites`555
30DESCRIBE `story`12122
31DESCRIBE `sites_stories`551
32DESCRIBE `story_assoc`444
33DESCRIBE `companies_sites`332
34DESCRIBE `categories_users`2211
35DESCRIBE `authority`332
36DESCRIBE `sites_users`551
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 1112
39SELECT `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`.`parent` = 297 AND `Category`.`restricted` IS NULL ORDER BY `Category`.`name` ASC 882
40SELECT `Child`.`uid`, `Child`.`name`, `Child`.`parent`, `Child`.`has_children`, `Child`.`show_children`, `Child`.`show_grandchildren`, `Child`.`members`, `Child`.`num_children`, `Child`.`root`, `Child`.`restricted`, `Child`.`clan`, `Child`.`lft`, `Child`.`rgt`, `Child`.`level` FROM `category` AS `Child` WHERE `Child`.`parent` IN (505, 303, 432, 319, 798, 453, 298, 805) ORDER BY `name` ASC 67673
41SELECT `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`.`parent` = 560 AND `Category`.`restricted` IS NULL ORDER BY `Category`.`name` ASC 20202
42SELECT `Child`.`uid`, `Child`.`name`, `Child`.`parent`, `Child`.`has_children`, `Child`.`show_children`, `Child`.`show_grandchildren`, `Child`.`members`, `Child`.`num_children`, `Child`.`root`, `Child`.`restricted`, `Child`.`clan`, `Child`.`lft`, `Child`.`rgt`, `Child`.`level` FROM `category` AS `Child` WHERE `Child`.`parent` IN (1476, 561, 575, 582, 595, 603, 635, 616, 1477, 631, 641, 651, 562, 654, 662, 572, 1479, 670, 679, 689) ORDER BY `name` ASC 3163162
43SELECT `DevelopmentStatus`.`id`, `DevelopmentStatus`.`name` FROM `development_statuses` AS `DevelopmentStatus` WHERE `id` = 3 113
44SELECT `DevelopmentStatus`.`id`, `DevelopmentStatus`.`display_order` FROM `development_statuses` AS `DevelopmentStatus` WHERE `DevelopmentStatus`.`id` = 3 LIMIT 1113
45SELECT `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`.`company_id` IN (4156, 104, 4915, 4801, 4438, 1364, 223, 1318, 3221, 4342) AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="L" ORDER BY `Category`.`root` ASC, `Category`.`clan` ASC, `Category`.`parent` ASC, `Category`.`name` ASC 15615611
(website_slave) 2 queries took 385 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Outlicensing`.`uid`, `Outlicensing`.`slug`, `Outlicensing`.`title`, `Outlicensing`.`shortdesc` FROM `licopp` AS `Outlicensing` INNER JOIN company AS `ParentCompany` ON (`ParentCompany`.`uid`=`Outlicensing`.`company_id` AND `ParentCompany`.`is_live`="Y") LEFT JOIN `development_statuses` AS `DevelopmentStatus` ON (`Outlicensing`.`devstatus` = `DevelopmentStatus`.`id`) LEFT JOIN `licopps_sites` AS `OutlicensingSite` ON (`OutlicensingSite`.`licopp_id` = `Outlicensing`.`uid`) WHERE `OutlicensingSite`.`site_id` = 1 AND `Outlicensing`.`is_out` = 'Y' AND `DevelopmentStatus`.`display_order` >= 4 GROUP BY `Outlicensing`.`uid` ORDER BY `Outlicensing`.`viewed_counter` DESC, `Outlicensing`.`title` ASC LIMIT 101010237
2SELECT COUNT(DISTINCT Outlicensing.uid) AS `count` FROM `licopp` AS `Outlicensing` INNER JOIN company AS `ParentCompany` ON (`ParentCompany`.`uid`=`Outlicensing`.`company_id` AND `ParentCompany`.`is_live`="Y") LEFT JOIN `development_statuses` AS `DevelopmentStatus` ON (`Outlicensing`.`devstatus` = `DevelopmentStatus`.`id`) LEFT JOIN `licopps_sites` AS `OutlicensingSite` ON (`OutlicensingSite`.`licopp_id` = `Outlicensing`.`uid`) WHERE `OutlicensingSite`.`site_id` = 1 AND `Outlicensing`.`is_out` = 'Y' AND `DevelopmentStatus`.`display_order` >= 4 11148
(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 3 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 ("Phase I/II") ORDER BY MATCH (`MarketResearchReport`.`name`, `MarketResearchReport`.`description`, `MarketResearchReport`.`summary`, `MarketResearchReport`.`content`, `MarketResearchReport`.`isbn`, `MarketResearchReport`.`code`) AGAINST ("Phase I/II") DESC , MarketResearchReport.published DESC LIMIT 1010103