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/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 10 - per page
Order by

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

NCEs, new patented formulations and products

Respiratory; women's care; dermatology; pain relief; GI More

UK Marketing Partner

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

Acquisition of UK Primary Care ethical brands

Strategic divestments of primary care sales focussed brands More

Almirall is seeking M&A and in-licensing opportunities in Dermatology

M&A and in-licensing opportunities in Respiratory at Phase 2 or later stages. Main target territories are Europe and Mexico. Almirall is also open to discuss in licensing deals an R&D co-operation. More

Celsis Pharmaceuticals in-licensing needs

Pediatrics; OB/GYN More

Products for Otorinilaryngology, Pediatrics, Dermatology, Gynecology and Ophthalmology

Products for Otorinilaryngology, Pediatrics, Dermatology, Gynecology and Ophthalmology More

Speciality Pharmaceutical products with no Canadian presence

Zinda Pharma is seeking speciality products in any therapeutic area for distribution in Canada. Zinda Pharma can act as an exclusive distributor, agent, marketing partner, joint venture partner or co-development partner for the Canadian Market. More

Displaying 1..10 of 10 - per 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

Allergy Therapy Area Pipeline Report

Nov 2010 - 1517 pages - $1,495

Grass Pollen Allergy - Pipeline Review, Q2 2011

May 2011 - 34 pages - $500

Allergy Therapeutics plc – Product Pipeline Review – Q4 2010

Dec 2010 - 48 pages - $500

Birch Pollen Allergy - Pipeline Review, Q2 2011

May 2011 - 39 pages - $500

Enjoy Life Natural Brands Case Study: capitalizing on rising consumer interest in anti-allergy foods

Aug 2009 - 11 pages - $295

Allergy Research Group, Inc.-Detailed Product Pipeline

Jul 2010 - 180 pages - $750

Allergy Therapeutics plc (AGY) - Financial and Strategic SWOT Analysis Review

May 2011 - 35 pages - $125

Allergy Therapeutics plc (AGY) - Financial and Strategic SWOT Analysis Review

Feb 2011 - 28 pages - $125

Allergy Therapeutics-Therapeutic Competitors Report

Nov 2010 - 37 pages - $600

Your selection

Therapeutic target: Allergy del

Browse By

Industry sector: Animal health; Biotechnology; Diagnostic; Drug delivery; Drug discovery; Medical device; Pharmaceutical; Research tools
Therapeutic target: Allergic rhinitis (hay fever); Allergies (other); Allergy, ophthalmic; Allergy, skin; Anaphylaxis
Development phase: Early Stage; Preclinical; Phase I; Phase I/II; Phase II; Phase III; Phase III/IV; Preregistration; Registered

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 85 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `licopp`	23	23	8
2	DESCRIBE `company`	27	27	1
3	DESCRIBE `condet`	17	17	1
4	DESCRIBE `countrycode`	4	4	1
5	DESCRIBE `person`	15	15	1
6	DESCRIBE `account`	29	29	1
7	DESCRIBE `product_legacy`	6	6	1
8	DESCRIBE `sales_people`	6	6	0
9	DESCRIBE `profile`	14	14	1
10	DESCRIBE `currencies`	7	7	1
11	DESCRIBE `update_rec`	7	7	1
12	DESCRIBE `user`	24	24	1
13	DESCRIBE `enquiry`	14	14	2
14	DESCRIBE `module_types`	6	6	1
15	DESCRIBE `dms_companies`	26	26	1
16	DESCRIBE `dms_releases`	10	10	1
17	DESCRIBE `dms_categories`	4	4	1
18	DESCRIBE `dms_clinical_areas`	4	4	1
19	DESCRIBE `dms_categories_dms_releases`	2	2	1
20	DESCRIBE `dms_clinical_areas_dms_releases`	2	2	0
21	DESCRIBE `dms_releases_sites`	5	5	1
22	DESCRIBE `development_statuses`	5	5	1
23	DESCRIBE `category`	14	14	1
24	DESCRIBE `categories_sites`	5	5	1
25	DESCRIBE `categorisation`	8	8	1
26	DESCRIBE `licopps_sites`	3	3	1
27	DESCRIBE `service`	15	15	1
28	DESCRIBE `press_release`	13	13	1
29	DESCRIBE `press_releases_sites`	5	5	1
30	DESCRIBE `story`	12	12	1
31	DESCRIBE `sites_stories`	5	5	1
32	DESCRIBE `story_assoc`	4	4	1
33	DESCRIBE `companies_sites`	3	3	0
34	DESCRIBE `categories_users`	2	2	1
35	DESCRIBE `authority`	3	3	1
36	DESCRIBE `sites_users`	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 `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` = 561 AND `Category`.`restricted` IS NULL ORDER BY `Category`.`name` ASC	5	5	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 (1482, 1483, 1481, 1485, 2148) ORDER BY `name` ASC	0	0	1
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 = 561	1	1	1
45	SELECT c.uid, c.name, c.level FROM category c WHERE c.lft <= "2809" AND c.rgt >= "2820" 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` = 561 LIMIT 1	1	1	19
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 (3247, 1213, 3246, 1362, 2111, 2112, 18662, 18652, 19247, 19292) 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	10
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 (3247, 1213, 3246, 1362, 2111, 2112, 18662, 18652, 19247, 19292) 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	7

(website) 48 queries took 85 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` = 561 AND `Category`.`restricted` IS NULL ORDER BY `Category`.`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 = 561

SELECT c.uid, c.name, c.level FROM category c WHERE c.lft <= "2809" AND c.rgt >= "2820" 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` = 561 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 (3247, 1213, 3246, 1362, 2111, 2112, 18662, 18652, 19247, 19292) 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 (3247, 1213, 3246, 1362, 2111, 2112, 18662, 18652, 19247, 19292) 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 11 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` >= '2809' AND `TherapeuticTarget`.`rgt` <= '2820') 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` >= 2809) AND (`TherapeuticTarget`.`rgt` <= 2820)) GROUP BY `Inlicensing`.`uid` ORDER BY `Inlicensing`.`viewed_counter` DESC, `Inlicensing`.`title` ASC LIMIT 10		10	10	6
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` >= '2809' AND `TherapeuticTarget`.`rgt` <= '2820') 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` >= 2809) AND (`TherapeuticTarget`.`rgt` <= 2820))		1	1	5

(website_slave) 2 queries took 11 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` >= '2809' AND `TherapeuticTarget`.`rgt` <= '2820') 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` >= 2809) AND (`TherapeuticTarget`.`rgt` <= 2820)) 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` >= '2809' AND `TherapeuticTarget`.`rgt` <= '2820') 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` >= 2809) AND (`TherapeuticTarget`.`rgt` <= 2820))

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

(report_slave) 1 query took 14 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 ("Allergy") ORDER BY MATCH (`MarketResearchReport`.`name`, `MarketResearchReport`.`description`, `MarketResearchReport`.`summary`, `MarketResearchReport`.`content`, `MarketResearchReport`.`isbn`, `MarketResearchReport`.`code`) AGAINST ("Allergy") DESC , MarketResearchReport.published DESC LIMIT 10