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

In-licensing

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

Licensing opportunities

No results found for given criteria.
Please try to put more general criteria into your selection.

Related Reports

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

(website) 47 queries took 543 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `licopp`23231
2DESCRIBE `company`272734
3DESCRIBE `condet`17178
4DESCRIBE `countrycode`4417
5DESCRIBE `person`151523
6DESCRIBE `account`29299
7DESCRIBE `product_legacy`6616
8DESCRIBE `sales_people`6623
9DESCRIBE `profile`14145
10DESCRIBE `currencies`7711
11DESCRIBE `update_rec`7713
12DESCRIBE `user`24244
13DESCRIBE `enquiry`14145
14DESCRIBE `module_types`667
15DESCRIBE `dms_companies`262629
16DESCRIBE `dms_releases`101021
17DESCRIBE `dms_categories`4411
18DESCRIBE `dms_clinical_areas`4410
19DESCRIBE `dms_categories_dms_releases`2210
20DESCRIBE `dms_clinical_areas_dms_releases`225
21DESCRIBE `dms_releases_sites`556
22DESCRIBE `development_statuses`5515
23DESCRIBE `category`14145
24DESCRIBE `categories_sites`5516
25DESCRIBE `categorisation`887
26DESCRIBE `licopps_sites`337
27DESCRIBE `service`151521
28DESCRIBE `press_release`131312
29DESCRIBE `press_releases_sites`552
30DESCRIBE `story`12121
31DESCRIBE `sites_stories`557
32DESCRIBE `story_assoc`448
33DESCRIBE `companies_sites`336
34DESCRIBE `categories_users`2210
35DESCRIBE `authority`335
36DESCRIBE `sites_users`552
37DESCRIBE `sites`5537
38SELECT `Site`.`id`, `Site`.`name`, `Site`.`email_domain`, `Site`.`short_name`, `Site`.`brand` FROM `sites` AS `Site` WHERE `Site`.`id` = 1 LIMIT 1114
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` = 805 AND `Category`.`restricted` IS NULL ORDER BY `Category`.`name` ASC 7729
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 (806, 807, 2054, 808, 809, 810, 811) ORDER BY `name` ASC 006
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 20208
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 3163169
43SELECT `DevelopmentStatus`.`id`, `DevelopmentStatus`.`name` FROM `development_statuses` AS `DevelopmentStatus` WHERE 1 = 1 GROUP BY `DevelopmentStatus`.`id`, `DevelopmentStatus`.`name` ORDER BY `DevelopmentStatus`.`display_order` ASC 991
44SELECT c.lft, c.rgt FROM category c WHERE c.uid = 805114
45SELECT c.uid, c.name, c.level FROM category c WHERE c.lft <= "1915" AND c.rgt >= "1930" AND c.level > 1 ORDER BY c.level 1123
46SELECT `IndustrySector`.`lft`, `IndustrySector`.`rgt`, `IndustrySector`.`uid` FROM `category` AS `IndustrySector` LEFT JOIN `category` AS `Parent` ON (`IndustrySector`.`parent` = `Parent`.`uid`) LEFT JOIN `categories_sites` AS `CategorySite` ON (`CategorySite`.`category_id` = `IndustrySector`.`uid`) WHERE `CategorySite`.`site_id` = 1 AND `IndustrySector`.`uid` = 805 LIMIT 11111
47SELECT `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` = (805) ORDER BY `name` ASC 7719
(website_slave) 1 query took 34 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Inlicensing`.`uid`, `Inlicensing`.`slug`, `Inlicensing`.`title`, `Inlicensing`.`shortdesc` FROM `licopp` AS `Inlicensing` INNER JOIN company AS `ParentCompany` ON (`ParentCompany`.`uid`=`Inlicensing`.`company_id` AND `ParentCompany`.`is_live`="Y") INNER JOIN categorisation AS `CategorisationIndustrySector` ON (`CategorisationIndustrySector`.`company_id` = `Inlicensing`.`uid` AND `CategorisationIndustrySector`.`cat_type` = 'P') INNER JOIN category AS `IndustrySector` ON (`IndustrySector`.`uid` = `CategorisationIndustrySector`.`category_id` AND `IndustrySector`.`lft` >= '1915' AND `IndustrySector`.`rgt` <= '1930') LEFT JOIN `development_statuses` AS `DevelopmentStatus` ON (`Inlicensing`.`devstatus` = `DevelopmentStatus`.`id`) LEFT JOIN `licopps_sites` AS `InlicensingSite` ON (`InlicensingSite`.`licopp_id` = `Inlicensing`.`uid`) WHERE `InlicensingSite`.`site_id` = 1 AND `Inlicensing`.`is_out` = 'N' GROUP BY `Inlicensing`.`uid` ORDER BY `Inlicensing`.`viewed_counter` DESC, `Inlicensing`.`title` ASC LIMIT 100034
(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 11 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 ("Research tools") ORDER BY MATCH (`MarketResearchReport`.`name`, `MarketResearchReport`.`description`, `MarketResearchReport`.`summary`, `MarketResearchReport`.`content`, `MarketResearchReport`.`isbn`, `MarketResearchReport`.`code`) AGAINST ("Research tools") DESC , MarketResearchReport.published DESC LIMIT 10101011