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

Dermatology: products/technologies for Acne

New Products/Technologies for Acne in early to late phases or already marketed required for acquisition or in-licensing for Mexico 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

Dermatology: Skin Cancer, Anti-fungals, Dermoceuticals & more

New Dermatology products in early to late phases or already marketed required for acquisition or in-licensing for Mexico More

UK Marketing Partner

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

Dermatology: products/Technologies for Atopic Dermatitis

New Products/technologies for Atopic Dermatitis in early to late phases or already marketed required for acquisition or in-licensing for Mexico More

Oral, Topical or Transdermal products in any therapeutical area

APR is interested to in-license new early stage, innovative and patent protected products/technologies (preferably off patent or close to expiry) for oral, topical or transdermal administration More

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

Related Reports

Market Research Reports provided by reports.innovaro.com

KV Pharmaceutical Company: SWOT Analysis & Company Profile

Nov 2010 - 27 pages - $99

Takeda Pharmaceutical Company Limited: SWOT Analysis & Company Profile

Apr 2010 - 17 pages - $99

Dong-A Pharmaceutical Co., Ltd.: SWOT Analysis & Company Profile

Nov 2010 - 23 pages - $99

Daewoong Pharmaceutical Co., Ltd.: SWOT Analysis & Company Profile

Nov 2010 - 24 pages - $99

Ono Pharmaceutical Co., Ltd.: SWOT Analysis & Company Profile

Sep 2010 - 24 pages - $99

BioMarin Pharmaceutical Inc.: SWOT Analysis & Company Profile

Sep 2010 - 27 pages - $99

Kissei Pharmaceutical Co., Ltd.: SWOT Analysis & Company Profile

Aug 2010 - 22 pages - $99

West Pharmaceutical Services, Inc.: SWOT Analysis & Company Profile

Dec 2010 - 26 pages - $99

Pharmaceutical Product Development, Inc.: SWOT Analysis & Company Profile

Nov 2010 - 26 pages - $99

Par Pharmaceutical Companies, Inc.: SWOT Analysis & Company Profile

Apr 2010 - 24 pages - $99

Your selection

Industry sector: Pharmaceutical del

Browse By

Industry sector: Generics; Nutrition; OTC/Non-Prescription; Pediatric; Personal Care; Prescription
Therapeutic target: Accident and Trauma; Allergy; Blood and forming organs; Cardiovascular; Central Nervous System; Dermatological; Endocrinology; Gastrointestinal; Genetic disorders; Genito-urinary; Hospital and Surgery; Immune related disorders; Infectious diseases; Metabolism; Musculoskeletal; Oncology; Oral Health; Other therapeutic; Respiratory; Sensory organ
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) 49 queries took 458 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `licopp`	23	23	2
2	DESCRIBE `company`	27	27	16
3	DESCRIBE `condet`	17	17	3
4	DESCRIBE `countrycode`	4	4	1
5	DESCRIBE `person`	15	15	19
6	DESCRIBE `account`	29	29	4
7	DESCRIBE `product_legacy`	6	6	11
8	DESCRIBE `sales_people`	6	6	7
9	DESCRIBE `profile`	14	14	1
10	DESCRIBE `currencies`	7	7	4
11	DESCRIBE `update_rec`	7	7	10
12	DESCRIBE `user`	24	24	3
13	DESCRIBE `enquiry`	14	14	2
14	DESCRIBE `module_types`	6	6	3
15	DESCRIBE `dms_companies`	26	26	8
16	DESCRIBE `dms_releases`	10	10	10
17	DESCRIBE `dms_categories`	4	4	16
18	DESCRIBE `dms_clinical_areas`	4	4	2
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	3
22	DESCRIBE `development_statuses`	5	5	4
23	DESCRIBE `category`	14	14	2
24	DESCRIBE `categories_sites`	5	5	8
25	DESCRIBE `categorisation`	8	8	6
26	DESCRIBE `licopps_sites`	3	3	10
27	DESCRIBE `service`	15	15	3
28	DESCRIBE `press_release`	13	13	5
29	DESCRIBE `press_releases_sites`	5	5	5
30	DESCRIBE `story`	12	12	7
31	DESCRIBE `sites_stories`	5	5	25
32	DESCRIBE `story_assoc`	4	4	1
33	DESCRIBE `companies_sites`	3	3	2
34	DESCRIBE `categories_users`	2	2	23
35	DESCRIBE `authority`	3	3	11
36	DESCRIBE `sites_users`	5	5	6
37	DESCRIBE `sites`	5	5	25
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	7
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` = 298 AND `Category`.`restricted` IS NULL ORDER BY `Category`.`name` ASC	6	6	5
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 (301, 2053, 300, 2063, 302, 299) ORDER BY `name` ASC	0	0	7
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` = 560 AND `Category`.`restricted` IS NULL ORDER BY `Category`.`name` ASC	20	20	11
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 (1476, 561, 575, 582, 595, 603, 635, 616, 1477, 631, 641, 651, 562, 654, 662, 572, 1479, 670, 679, 689) ORDER BY `name` ASC	316	316	20
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	42
44	SELECT c.lft, c.rgt FROM category c WHERE c.uid = 298	1	1	27
45	SELECT c.uid, c.name, c.level FROM category c WHERE c.lft <= "1901" AND c.rgt >= "1914" AND c.level > 1 ORDER BY c.level	1	1	1
46	SELECT `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` = 298 LIMIT 1	1	1	26
47	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` = (298) ORDER BY `name` ASC	6	6	3
48	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, 4338, 1213, 3246, 1362, 4340, 2111, 4339, 5002) AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="P" ORDER BY `Category`.`root` ASC, `Category`.`clan` ASC, `Category`.`parent` ASC, `Category`.`name` ASC	270	270	26
49	SELECT `IndustrySector`.`uid`, `IndustrySector`.`name`, `IndustrySector`.`parent`, `IndustrySector`.`has_children`, `IndustrySector`.`show_children`, `IndustrySector`.`show_grandchildren`, `IndustrySector`.`members`, `IndustrySector`.`num_children`, `IndustrySector`.`root`, `IndustrySector`.`restricted`, `IndustrySector`.`clan`, `IndustrySector`.`lft`, `IndustrySector`.`rgt`, `IndustrySector`.`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 `IndustrySector` JOIN `categorisation` AS `Categorisation` ON (`Categorisation`.`company_id` IN (1561, 3247, 4338, 1213, 3246, 1362, 4340, 2111, 4339, 5002) AND `Categorisation`.`category_id` = `IndustrySector`.`uid`) WHERE `cat_type` = 'P' ORDER BY `IndustrySector`.`root` ASC, `IndustrySector`.`clan` ASC, `IndustrySector`.`parent` ASC, `IndustrySector`.`name` ASC	270	270	13

(website) 49 queries took 458 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` = 298 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 (301, 2053, 300, 2063, 302, 299) 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` = 560 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 (1476, 561, 575, 582, 595, 603, 635, 616, 1477, 631, 641, 651, 562, 654, 662, 572, 1479, 670, 679, 689) ORDER BY `name` ASC

316

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 = 298

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

SELECT `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` = 298 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, 4338, 1213, 3246, 1362, 4340, 2111, 4339, 5002) AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="P" ORDER BY `Category`.`root` ASC, `Category`.`clan` ASC, `Category`.`parent` ASC, `Category`.`name` ASC

270

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

270

(website_slave) 2 queries took 15 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 `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` >= '1901' AND `IndustrySector`.`rgt` <= '1914') 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 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 `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` >= '1901' AND `IndustrySector`.`rgt` <= '1914') 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'		1	1	9

(website_slave) 2 queries took 15 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 `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` >= '1901' AND `IndustrySector`.`rgt` <= '1914') 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 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 `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` >= '1901' AND `IndustrySector`.`rgt` <= '1914') 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'

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

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