In-licensing: Infectious diseases

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

Code

        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/20120317114903/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/20120317114903/cakephp/webroot/pharmalicensing/index.php, line 100

In-licensing

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

In-licensing
Browse

Licensing opportunities

Displaying 1..10 of 15 - per page Next page
Order by

Rx and /or OTC dermatology products

We are focused on licensing or acquiring new, late-stage technologies or existing prescription or OTC dermatology products More

Seeking development opportunities with novel delivery technologies for oral, topical and transdermal products

Delivery technologies for oral, topical and transdermal products which could be applicable to the consumer healthcare arena More

New Chemical Entities and innovative therapeutic targets

NCEs for innovative therapeutic targets in inflammatory/immunologic diseases. More

Seeking opportunities for consumer healthcare products and molecules with Rx-to-OTC switch potential

OTC products ready for registration or in late stage development and molecules with Rx-to-OTC switch potential. More

UK Marketing Partner

Are you a small to medium company seeking a UK presence? More

Acquisition of UK Hospital established brands

UK partner for strategic divestments More

Acquisition of UK Primary Care ethical brands

Strategic divestments of primary care sales focussed brands More

Generic molecules, OTC products and novel delivery technologies required for the Sub-Saharan African market.

Our client is a start up company that is looking for off patent generics indicated for oncology or respiratory disorders and innovative delivery platforms to which to incorporate them into. More

Injectables and oral medicines for hospital use

In-licensing injectables andoral medicines for the hospital market, originals for orphan/nichemarkets More

Seeking partners who want to divest well-established products in any therapeutic area.

If you are considering divesting one or more brands or the whole portfolio in any therapeutic or geographic area, please contact DESMA PHARMA Group for a preliminary assessment More

Displaying 1..10 of 15 - per page Next page
Order by

Related Reports

Market Research Reports provided by reports.innovaro.com

The National Institute of Allergy and Infectious Diseases – Developmental Therapeutics Review – Q4 2010

Nov 2010 - 40 pages - $500

Infectious Diseases Pipeline Databook - November 2011

Nov 2011 - 7 pages - $3,835

Deals and alliances in infectious diseases

Jun 2006 - 1458 pages - $2,495

Chronic Diseases on the Rise: Personal Health Systems to Play a Key Role in Disease Management

Oct 2009 - 17 pages - $500

Point of Care Diagnostics for Emerging Infectious Disease Threats (Market Analysis and Technical Considerations)

Oct 2011 - 150 pages - $3,500

Infectious Disease Research Institute – Developmental Therapeutics Review – Q4 2010

Dec 2010 - 28 pages - $500

The National Institute of Allergy and Infectious Diseases - Pharmaceuticals & Healthcare - Deals and Alliances Profile

Mar 2011 - 32 pages - $250

Meningitis - Pipeline Analysis and Market Forecasts to 2016

Mar 2010 - 39 pages - $2,000

Lyme Disease Global Clinical Trials Review, Q1, 2011

Feb 2011 - 26 pages - $1,000

Company Financials: Trinity Biotech plc

Apr 2011 - $75

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

Products:

Partnering Search

Company Profiling

Pharmalicensing Intelligence

Intellectual Property

(website) 48 queries took 152 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `licopp`	23	23	3
2	DESCRIBE `company`	27	27	1
3	DESCRIBE `condet`	17	17	4
4	DESCRIBE `countrycode`	4	4	18
5	DESCRIBE `person`	15	15	2
6	DESCRIBE `account`	29	29	2
7	DESCRIBE `product_legacy`	6	6	2
8	DESCRIBE `sales_people`	6	6	4
9	DESCRIBE `profile`	14	14	1
10	DESCRIBE `currencies`	7	7	2
11	DESCRIBE `update_rec`	7	7	1
12	DESCRIBE `user`	24	24	2
13	DESCRIBE `enquiry`	14	14	9
14	DESCRIBE `module_types`	6	6	1
15	DESCRIBE `dms_companies`	26	26	1
16	DESCRIBE `dms_releases`	10	10	2
17	DESCRIBE `dms_categories`	4	4	2
18	DESCRIBE `dms_clinical_areas`	4	4	2
19	DESCRIBE `dms_categories_dms_releases`	2	2	5
20	DESCRIBE `dms_clinical_areas_dms_releases`	2	2	4
21	DESCRIBE `dms_releases_sites`	5	5	2
22	DESCRIBE `development_statuses`	5	5	5
23	DESCRIBE `category`	14	14	2
24	DESCRIBE `categories_sites`	5	5	2
25	DESCRIBE `categorisation`	8	8	2
26	DESCRIBE `licopps_sites`	3	3	4
27	DESCRIBE `service`	15	15	3
28	DESCRIBE `press_release`	13	13	2
29	DESCRIBE `press_releases_sites`	5	5	1
30	DESCRIBE `story`	12	12	11
31	DESCRIBE `sites_stories`	5	5	2
32	DESCRIBE `story_assoc`	4	4	4
33	DESCRIBE `companies_sites`	3	3	2
34	DESCRIBE `categories_users`	2	2	2
35	DESCRIBE `authority`	3	3	4
36	DESCRIBE `sites_users`	5	5	1
37	DESCRIBE `sites`	5	5	2
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	5
39	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`.`parent` = 297 AND `Category`.`restricted` IS NULL ORDER BY `Category`.`name` ASC	8	8	1
40	SELECT `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	67	67	1
41	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`.`parent` = 562 AND `Category`.`restricted` IS NULL ORDER BY `Category`.`name` ASC	7	7	1
42	SELECT `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 (2137, 2064, 2135, 1665, 1683, 677, 2136) ORDER BY `name` ASC	79	79	3
43	SELECT `DevelopmentStatus`.`id`, `DevelopmentStatus`.`name` FROM `development_statuses` AS `DevelopmentStatus` WHERE 1 = 1 GROUP BY `DevelopmentStatus`.`id`, `DevelopmentStatus`.`name` ORDER BY `DevelopmentStatus`.`display_order` ASC	9	9	1
44	SELECT c.lft, c.rgt FROM category c WHERE c.uid = 562	1	1	4
45	SELECT c.uid, c.name, c.level FROM category c WHERE c.lft <= "3557" AND c.rgt >= "3730" AND c.level > 1 ORDER BY c.level	1	1	0
46	SELECT `TherapeuticTarget`.`lft`, `TherapeuticTarget`.`rgt`, `TherapeuticTarget`.`uid` FROM `category` AS `TherapeuticTarget` LEFT JOIN `category` AS `Parent` ON (`TherapeuticTarget`.`parent` = `Parent`.`uid`) LEFT JOIN `categories_sites` AS `CategorySite` ON (`CategorySite`.`category_id` = `TherapeuticTarget`.`uid`) WHERE `CategorySite`.`site_id` = 1 AND `TherapeuticTarget`.`uid` = 562 LIMIT 1	1	1	1
47	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`.`company_id` IN (1561, 3247, 1213, 3246, 2111, 2110, 2112, 6612, 5471, 5600) AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="P" ORDER BY `Category`.`root` ASC, `Category`.`clan` ASC, `Category`.`parent` ASC, `Category`.`name` ASC	278	278	15
48	SELECT `TherapeuticTarget`.`uid`, `TherapeuticTarget`.`name`, `TherapeuticTarget`.`parent`, `TherapeuticTarget`.`has_children`, `TherapeuticTarget`.`show_children`, `TherapeuticTarget`.`show_grandchildren`, `TherapeuticTarget`.`members`, `TherapeuticTarget`.`num_children`, `TherapeuticTarget`.`root`, `TherapeuticTarget`.`restricted`, `TherapeuticTarget`.`clan`, `TherapeuticTarget`.`lft`, `TherapeuticTarget`.`rgt`, `TherapeuticTarget`.`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 `TherapeuticTarget` JOIN `categorisation` AS `Categorisation` ON (`Categorisation`.`company_id` IN (1561, 3247, 1213, 3246, 2111, 2110, 2112, 6612, 5471, 5600) AND `Categorisation`.`category_id` = `TherapeuticTarget`.`uid`) WHERE `cat_type` = 'P' ORDER BY `TherapeuticTarget`.`root` ASC, `TherapeuticTarget`.`clan` ASC, `TherapeuticTarget`.`parent` ASC, `TherapeuticTarget`.`name` ASC	278	278	1

(website) 48 queries took 152 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `licopp`

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 `development_statuses`

DESCRIBE `category`

DESCRIBE `categories_sites`

DESCRIBE `categorisation`

DESCRIBE `licopps_sites`

DESCRIBE `service`

DESCRIBE `press_release`

DESCRIBE `press_releases_sites`

DESCRIBE `story`

DESCRIBE `sites_stories`

DESCRIBE `story_assoc`

DESCRIBE `companies_sites`

DESCRIBE `categories_users`

DESCRIBE `authority`

DESCRIBE `sites_users`

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 `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

SELECT `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

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`.`parent` = 562 AND `Category`.`restricted` IS NULL ORDER BY `Category`.`name` ASC

SELECT `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 (2137, 2064, 2135, 1665, 1683, 677, 2136) ORDER BY `name` ASC

SELECT `DevelopmentStatus`.`id`, `DevelopmentStatus`.`name` FROM `development_statuses` AS `DevelopmentStatus` WHERE 1 = 1 GROUP BY `DevelopmentStatus`.`id`, `DevelopmentStatus`.`name` ORDER BY `DevelopmentStatus`.`display_order` ASC

SELECT c.lft, c.rgt FROM category c WHERE c.uid = 562

SELECT c.uid, c.name, c.level FROM category c WHERE c.lft <= "3557" AND c.rgt >= "3730" AND c.level > 1 ORDER BY c.level

SELECT `TherapeuticTarget`.`lft`, `TherapeuticTarget`.`rgt`, `TherapeuticTarget`.`uid` FROM `category` AS `TherapeuticTarget` LEFT JOIN `category` AS `Parent` ON (`TherapeuticTarget`.`parent` = `Parent`.`uid`) LEFT JOIN `categories_sites` AS `CategorySite` ON (`CategorySite`.`category_id` = `TherapeuticTarget`.`uid`) WHERE `CategorySite`.`site_id` = 1 AND `TherapeuticTarget`.`uid` = 562 LIMIT 1

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`.`company_id` IN (1561, 3247, 1213, 3246, 2111, 2110, 2112, 6612, 5471, 5600) AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="P" ORDER BY `Category`.`root` ASC, `Category`.`clan` ASC, `Category`.`parent` ASC, `Category`.`name` ASC

278

SELECT `TherapeuticTarget`.`uid`, `TherapeuticTarget`.`name`, `TherapeuticTarget`.`parent`, `TherapeuticTarget`.`has_children`, `TherapeuticTarget`.`show_children`, `TherapeuticTarget`.`show_grandchildren`, `TherapeuticTarget`.`members`, `TherapeuticTarget`.`num_children`, `TherapeuticTarget`.`root`, `TherapeuticTarget`.`restricted`, `TherapeuticTarget`.`clan`, `TherapeuticTarget`.`lft`, `TherapeuticTarget`.`rgt`, `TherapeuticTarget`.`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 `TherapeuticTarget` JOIN `categorisation` AS `Categorisation` ON (`Categorisation`.`company_id` IN (1561, 3247, 1213, 3246, 2111, 2110, 2112, 6612, 5471, 5600) AND `Categorisation`.`category_id` = `TherapeuticTarget`.`uid`) WHERE `cat_type` = 'P' ORDER BY `TherapeuticTarget`.`root` ASC, `TherapeuticTarget`.`clan` ASC, `TherapeuticTarget`.`parent` ASC, `TherapeuticTarget`.`name` ASC

278

(website_slave) 2 queries took 74 ms
Nr	Query	Error	Affected	Num. rows	Took (ms)
1	SELECT `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 `CategorisationTherapeuticTarget` ON (`CategorisationTherapeuticTarget`.`company_id` = `Inlicensing`.`uid` AND `CategorisationTherapeuticTarget`.`cat_type` = 'P') INNER JOIN category AS `TherapeuticTarget` ON (`TherapeuticTarget`.`uid` = `CategorisationTherapeuticTarget`.`category_id` AND `TherapeuticTarget`.`lft` >= '3557' AND `TherapeuticTarget`.`rgt` <= '3730') 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' AND ((`TherapeuticTarget`.`lft` >= 3557) AND (`TherapeuticTarget`.`rgt` <= 3730)) GROUP BY `Inlicensing`.`uid` ORDER BY `Inlicensing`.`viewed_counter` DESC, `Inlicensing`.`title` ASC LIMIT 10		10	10	36
2	SELECT COUNT(DISTINCT Inlicensing.uid) AS `count` FROM `licopp` AS `Inlicensing` INNER JOIN company AS `ParentCompany` ON (`ParentCompany`.`uid`=`Inlicensing`.`company_id` AND `ParentCompany`.`is_live`="Y") INNER JOIN categorisation AS `CategorisationTherapeuticTarget` ON (`CategorisationTherapeuticTarget`.`company_id` = `Inlicensing`.`uid` AND `CategorisationTherapeuticTarget`.`cat_type` = 'P') INNER JOIN category AS `TherapeuticTarget` ON (`TherapeuticTarget`.`uid` = `CategorisationTherapeuticTarget`.`category_id` AND `TherapeuticTarget`.`lft` >= '3557' AND `TherapeuticTarget`.`rgt` <= '3730') 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' AND ((`TherapeuticTarget`.`lft` >= 3557) AND (`TherapeuticTarget`.`rgt` <= 3730))		1	1	38

(website_slave) 2 queries took 74 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT `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 `CategorisationTherapeuticTarget` ON (`CategorisationTherapeuticTarget`.`company_id` = `Inlicensing`.`uid` AND `CategorisationTherapeuticTarget`.`cat_type` = 'P') INNER JOIN category AS `TherapeuticTarget` ON (`TherapeuticTarget`.`uid` = `CategorisationTherapeuticTarget`.`category_id` AND `TherapeuticTarget`.`lft` >= '3557' AND `TherapeuticTarget`.`rgt` <= '3730') 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' AND ((`TherapeuticTarget`.`lft` >= 3557) AND (`TherapeuticTarget`.`rgt` <= 3730)) GROUP BY `Inlicensing`.`uid` ORDER BY `Inlicensing`.`viewed_counter` DESC, `Inlicensing`.`title` ASC LIMIT 10

SELECT COUNT(DISTINCT Inlicensing.uid) AS `count` FROM `licopp` AS `Inlicensing` INNER JOIN company AS `ParentCompany` ON (`ParentCompany`.`uid`=`Inlicensing`.`company_id` AND `ParentCompany`.`is_live`="Y") INNER JOIN categorisation AS `CategorisationTherapeuticTarget` ON (`CategorisationTherapeuticTarget`.`company_id` = `Inlicensing`.`uid` AND `CategorisationTherapeuticTarget`.`cat_type` = 'P') INNER JOIN category AS `TherapeuticTarget` ON (`TherapeuticTarget`.`uid` = `CategorisationTherapeuticTarget`.`category_id` AND `TherapeuticTarget`.`lft` >= '3557' AND `TherapeuticTarget`.`rgt` <= '3730') 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' AND ((`TherapeuticTarget`.`lft` >= 3557) AND (`TherapeuticTarget`.`rgt` <= 3730))

(report) 1 query took 1 ms
Nr	Query	Error	Affected	Num. rows	Took (ms)
1	DESCRIBE `reports`		17	17	1

(report) 1 query took 1 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `reports`

(report_slave) 1 query took 1 ms
Nr	Query	Error	Affected	Num. rows	Took (ms)
1	SELECT `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 ("Infectious diseases") ORDER BY MATCH (`MarketResearchReport`.`name`, `MarketResearchReport`.`description`, `MarketResearchReport`.`summary`, `MarketResearchReport`.`content`, `MarketResearchReport`.`isbn`, `MarketResearchReport`.`code`) AGAINST ("Infectious diseases") DESC , MarketResearchReport.published DESC LIMIT 10		10	10	1

(report_slave) 1 query took 1 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT `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 ("Infectious diseases") ORDER BY MATCH (`MarketResearchReport`.`name`, `MarketResearchReport`.`description`, `MarketResearchReport`.`summary`, `MarketResearchReport`.`content`, `MarketResearchReport`.`isbn`, `MarketResearchReport`.`code`) AGAINST ("Infectious diseases") DESC , MarketResearchReport.published DESC LIMIT 10

In-licensing

Licensing opportunities

Related Reports

Your selection

Browse By