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..3 of 3 - per page
Order by

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

Displaying 1..3 of 3 - per page
Order by

Related Reports

Market Research Reports provided by reports.innovaro.com

Therapeutic Cancer Vaccines - A New Paradigm in Cancer Therapy

Feb 2011 - 7 pages - $500

HELP S.A.-Therapeutic Competitors Report

Nov 2010 - 411 pages - $600

BL&H Co., Ltd.-Therapeutic Competitors Report

Nov 2010 - 379 pages - $600

PH&T S.p.A.-Therapeutic Competitors Report

Nov 2010 - 205 pages - $600

AB Science-Therapeutic Competitors Report

Nov 2010 - 63 pages - $600

IDEA AG-Therapeutic Competitors Report

Nov 2010 - 52 pages - $600

PepTx, Inc.-Therapeutic Competitors Report

Nov 2010 - 55 pages - $600

Camurus AB-Therapeutic Competitors Report

Nov 2010 - 106 pages - $600

S.L.A. Pharma AG-Therapeutic Competitors Report

Nov 2010 - 75 pages - $600

PharmaEngine, Inc.-Therapeutic Competitors Report

Nov 2010 - 51 pages - $600

Your selection

Therapeutic target: Other therapeutic del

Browse By

Industry sector: Animal health; Biotechnology; Diagnostic; Drug delivery; Drug discovery; Medical device; Pharmaceutical; Research tools
Therapeutic target: Ayuverdic medicine; Chinese medicine; Dietetic; Homeopathy; Iron excess; Kanpo medicine; Other
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

(website) 48 queries took 72 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `licopp`	23	23	2
2	DESCRIBE `company`	27	27	4
3	DESCRIBE `condet`	17	17	1
4	DESCRIBE `countrycode`	4	4	2
5	DESCRIBE `person`	15	15	1
6	DESCRIBE `account`	29	29	1
7	DESCRIBE `product_legacy`	6	6	11
8	DESCRIBE `sales_people`	6	6	1
9	DESCRIBE `profile`	14	14	1
10	DESCRIBE `currencies`	7	7	1
11	DESCRIBE `update_rec`	7	7	1
12	DESCRIBE `user`	24	24	9
13	DESCRIBE `enquiry`	14	14	3
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	1
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	0
27	DESCRIBE `service`	15	15	2
28	DESCRIBE `press_release`	13	13	1
29	DESCRIBE `press_releases_sites`	5	5	1
30	DESCRIBE `story`	12	12	2
31	DESCRIBE `sites_stories`	5	5	1
32	DESCRIBE `story_assoc`	4	4	1
33	DESCRIBE `companies_sites`	3	3	1
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	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	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` = 670 AND `Category`.`restricted` IS NULL ORDER BY `Category`.`name` ASC	7	7	0
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 (1753, 671, 676, 672, 1755, 673, 674) ORDER BY `name` ASC	0	0	0
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 = 670	1	1	1
45	SELECT c.uid, c.name, c.level FROM category c WHERE c.lft <= "4081" AND c.rgt >= "4096" AND c.level > 1 ORDER BY c.level	1	1	1
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` = 670 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 (2111, 2110, 2112) AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="P" ORDER BY `Category`.`root` ASC, `Category`.`clan` ASC, `Category`.`parent` ASC, `Category`.`name` ASC	65	65	0
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 (2111, 2110, 2112) AND `Categorisation`.`category_id` = `TherapeuticTarget`.`uid`) WHERE `cat_type` = 'P' ORDER BY `TherapeuticTarget`.`root` ASC, `TherapeuticTarget`.`clan` ASC, `TherapeuticTarget`.`parent` ASC, `TherapeuticTarget`.`name` ASC	65	65	1

(website) 48 queries took 72 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` = 670 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 (1753, 671, 676, 672, 1755, 673, 674) 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 = 670

SELECT c.uid, c.name, c.level FROM category c WHERE c.lft <= "4081" AND c.rgt >= "4096" 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` = 670 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 (2111, 2110, 2112) AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="P" ORDER BY `Category`.`root` ASC, `Category`.`clan` ASC, `Category`.`parent` ASC, `Category`.`name` ASC

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 (2111, 2110, 2112) AND `Categorisation`.`category_id` = `TherapeuticTarget`.`uid`) WHERE `cat_type` = 'P' ORDER BY `TherapeuticTarget`.`root` ASC, `TherapeuticTarget`.`clan` ASC, `TherapeuticTarget`.`parent` ASC, `TherapeuticTarget`.`name` ASC

(website_slave) 2 queries took 9 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` >= '4081' AND `TherapeuticTarget`.`rgt` <= '4096') 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` >= 4081) AND (`TherapeuticTarget`.`rgt` <= 4096)) GROUP BY `Inlicensing`.`uid` ORDER BY `Inlicensing`.`viewed_counter` DESC, `Inlicensing`.`title` ASC LIMIT 10		3	3	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` >= '4081' AND `TherapeuticTarget`.`rgt` <= '4096') 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` >= 4081) AND (`TherapeuticTarget`.`rgt` <= 4096))		1	1	3

(website_slave) 2 queries took 9 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` >= '4081' AND `TherapeuticTarget`.`rgt` <= '4096') 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` >= 4081) AND (`TherapeuticTarget`.`rgt` <= 4096)) 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` >= '4081' AND `TherapeuticTarget`.`rgt` <= '4096') 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` >= 4081) AND (`TherapeuticTarget`.`rgt` <= 4096))

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

(report) 1 query took 2 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `reports`

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

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