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

Out-licensing

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

Out-licensing
Browse

Licensing opportunities

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

Diclofenac potassium immediate release tablets 25 and 50 mg

25 and 50 mg diclofenac K film coated immediate release tablets More

ORS effervescent tablet (Oral Rehydration Salts)

The unique ORS effervescent tablet has been developed according to the latest guidelines of the WHO. It has a substantial marketshare in several countries. We are looking for partners to further expand this success. More

Cellophil™ Biomedical Polymers - New and superior biomedical polymers for drug delivery and new standards in the medical device industry

Cellophil™ is a platform of novel polymers based on amino-acid groups. The platform polymers show superior biocompatibility and can be loaded with drugs for controlled release. More

Instead Fertility Cup

Conception aid, fertility cup More

Topical Diclofenac Products

Topical Diclofenac formulations for the treatment of inflammatory and painful conditions More

Ketoprofen Patch

Adhesive Patch of 90 sq. cm. and containing as active ingredient 100 mg. of ketoprofen for the local treatment of traumatic injuries and extra-articular rheumatism More

Diclofenac Sodium 25 mg. immediate release tablets

25mg dosage strenght for the OTC market in film coated tablets More

Capsaicin patch

Capsaicin, the active ingredient found in red-hot peppers, is used mainly for the relief of chronic pain of rheumatoid arthritis and osteoarthritis More

CollaRx® & LiquiColl® Technologies

Collagen-based biodegradable matrices for localized drug delivery More

Transdermal Fentanyl

Fentanyl patch for the management of severe pain in patients who require continuous opioid analgesia. More

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

Related Reports

Market Research Reports provided by reports.innovaro.com

Advanced Oral & Parenteral Drug Delivery Technologies Players, Products & Prospects to 2015

Jan 2011 - 124 pages - $1,740

Targeted Drug Delivery Technologies: Players, products & prospects to 2018 (Volume IV)

Jun 2009 - 118 pages - $1,040

Who's Developing What in Drug Delivery 2009

Nov 2009 - 830 pages - $1,040

Nucleic Acid Drug Delivery Technologies: Players, products & prospects to 2018 (Volume III)

Jun 2009 - 110 pages - $1,040

Drug Delivery Technologies: Players, products & prospects to 2018

Jun 2009 - 472 pages - $3,140

Leading Drug Delivery Companies and Technologies

Jun 2008 - 175 pages - $3,835

Drug Delivery Partnering Terms and Agreements in Pharma and Biotech

Nov 2010 - 428 pages - $2,695

Advances in the Transdermal Drug Delivery Market

Oct 2010 - 97 pages - $3,835

Drug Delivery Markets, Vol. IV: Transdermal and Trans Mucosal Drug Delivery

Apr 2007 - 118 pages - $2,495

Benchmarking the Pharmaceutical Market by Drug Delivery to 2014

Dec 2009 - 84 pages - $7,600

Your selection

Industry sector: Drug delivery del

Browse By

Industry sector: Intravesical; Nasal; Nasal topical; Ophthalmic; Oral liquid; Oral solid; Otic; Parenteral; Pulmonary; Rectal; Systemic; Topical; Vaginal
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 168 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `licopp`	23	23	1
2	DESCRIBE `company`	27	27	1
3	DESCRIBE `condet`	17	17	5
4	DESCRIBE `countrycode`	4	4	2
5	DESCRIBE `person`	15	15	3
6	DESCRIBE `account`	29	29	2
7	DESCRIBE `product_legacy`	6	6	3
8	DESCRIBE `sales_people`	6	6	14
9	DESCRIBE `profile`	14	14	7
10	DESCRIBE `currencies`	7	7	1
11	DESCRIBE `update_rec`	7	7	1
12	DESCRIBE `user`	24	24	2
13	DESCRIBE `enquiry`	14	14	4
14	DESCRIBE `module_types`	6	6	4
15	DESCRIBE `dms_companies`	26	26	3
16	DESCRIBE `dms_releases`	10	10	4
17	DESCRIBE `dms_categories`	4	4	5
18	DESCRIBE `dms_clinical_areas`	4	4	1
19	DESCRIBE `dms_categories_dms_releases`	2	2	2
20	DESCRIBE `dms_clinical_areas_dms_releases`	2	2	7
21	DESCRIBE `dms_releases_sites`	5	5	2
22	DESCRIBE `development_statuses`	5	5	5
23	DESCRIBE `category`	14	14	1
24	DESCRIBE `categories_sites`	5	5	5
25	DESCRIBE `categorisation`	8	8	3
26	DESCRIBE `licopps_sites`	3	3	3
27	DESCRIBE `service`	15	15	4
28	DESCRIBE `press_release`	13	13	3
29	DESCRIBE `press_releases_sites`	5	5	1
30	DESCRIBE `story`	12	12	1
31	DESCRIBE `sites_stories`	5	5	2
32	DESCRIBE `story_assoc`	4	4	1
33	DESCRIBE `companies_sites`	3	3	1
34	DESCRIBE `categories_users`	2	2	6
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	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` = 319 AND `Category`.`restricted` IS NULL ORDER BY `Category`.`name` ASC	13	13	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 (812, 362, 412, 400, 343, 320, 407, 353, 417, 369, 373, 379, 422) ORDER BY `name` ASC	74	74	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` = 560 AND `Category`.`restricted` IS NULL ORDER BY `Category`.`name` ASC	20	20	6
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	7
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	0
44	SELECT c.lft, c.rgt FROM category c WHERE c.uid = 319	1	1	3
45	SELECT c.uid, c.name, c.level FROM category c WHERE c.lft <= "1515" AND c.rgt >= "1752" 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` = 319 LIMIT 1	1	1	3
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` = (319) ORDER BY `name` ASC	13	13	2
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 (104, 4915, 4241, 4801, 4243, 1364, 223, 1318, 3221, 4242) AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="L" ORDER BY `Category`.`root` ASC, `Category`.`clan` ASC, `Category`.`parent` ASC, `Category`.`name` ASC	215	215	3
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 (104, 4915, 4241, 4801, 4243, 1364, 223, 1318, 3221, 4242) AND `Categorisation`.`category_id` = `IndustrySector`.`uid`) WHERE `cat_type` = 'L' ORDER BY `IndustrySector`.`root` ASC, `IndustrySector`.`clan` ASC, `IndustrySector`.`parent` ASC, `IndustrySector`.`name` ASC	215	215	23

(website) 49 queries took 168 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` = 319 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 (812, 362, 412, 400, 343, 320, 407, 353, 417, 369, 373, 379, 422) 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 = 319

SELECT c.uid, c.name, c.level FROM category c WHERE c.lft <= "1515" AND c.rgt >= "1752" 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` = 319 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 (104, 4915, 4241, 4801, 4243, 1364, 223, 1318, 3221, 4242) AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="L" ORDER BY `Category`.`root` ASC, `Category`.`clan` ASC, `Category`.`parent` ASC, `Category`.`name` ASC

215

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 (104, 4915, 4241, 4801, 4243, 1364, 223, 1318, 3221, 4242) AND `Categorisation`.`category_id` = `IndustrySector`.`uid`) WHERE `cat_type` = 'L' ORDER BY `IndustrySector`.`root` ASC, `IndustrySector`.`clan` ASC, `IndustrySector`.`parent` ASC, `IndustrySector`.`name` ASC

215

(website_slave) 2 queries took 3816 ms
Nr	Query	Error	Affected	Num. rows	Took (ms)
1	SELECT `Outlicensing`.`uid`, `Outlicensing`.`slug`, `Outlicensing`.`title`, `Outlicensing`.`shortdesc` FROM `licopp` AS `Outlicensing` INNER JOIN company AS `ParentCompany` ON (`ParentCompany`.`uid`=`Outlicensing`.`company_id` AND `ParentCompany`.`is_live`="Y") INNER JOIN categorisation AS `CategorisationIndustrySector` ON (`CategorisationIndustrySector`.`company_id` = `Outlicensing`.`uid` AND `CategorisationIndustrySector`.`cat_type` = 'L') INNER JOIN category AS `IndustrySector` ON (`IndustrySector`.`uid` = `CategorisationIndustrySector`.`category_id` AND `IndustrySector`.`lft` >= '1515' AND `IndustrySector`.`rgt` <= '1752') LEFT JOIN `development_statuses` AS `DevelopmentStatus` ON (`Outlicensing`.`devstatus` = `DevelopmentStatus`.`id`) LEFT JOIN `licopps_sites` AS `OutlicensingSite` ON (`OutlicensingSite`.`licopp_id` = `Outlicensing`.`uid`) WHERE `OutlicensingSite`.`site_id` = 1 AND `Outlicensing`.`is_out` = 'Y' GROUP BY `Outlicensing`.`uid` ORDER BY `Outlicensing`.`viewed_counter` DESC, `Outlicensing`.`title` ASC LIMIT 10		10	10	1778
2	SELECT COUNT(DISTINCT Outlicensing.uid) AS `count` FROM `licopp` AS `Outlicensing` INNER JOIN company AS `ParentCompany` ON (`ParentCompany`.`uid`=`Outlicensing`.`company_id` AND `ParentCompany`.`is_live`="Y") INNER JOIN categorisation AS `CategorisationIndustrySector` ON (`CategorisationIndustrySector`.`company_id` = `Outlicensing`.`uid` AND `CategorisationIndustrySector`.`cat_type` = 'L') INNER JOIN category AS `IndustrySector` ON (`IndustrySector`.`uid` = `CategorisationIndustrySector`.`category_id` AND `IndustrySector`.`lft` >= '1515' AND `IndustrySector`.`rgt` <= '1752') LEFT JOIN `development_statuses` AS `DevelopmentStatus` ON (`Outlicensing`.`devstatus` = `DevelopmentStatus`.`id`) LEFT JOIN `licopps_sites` AS `OutlicensingSite` ON (`OutlicensingSite`.`licopp_id` = `Outlicensing`.`uid`) WHERE `OutlicensingSite`.`site_id` = 1 AND `Outlicensing`.`is_out` = 'Y'		1	1	2038

(website_slave) 2 queries took 3816 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT `Outlicensing`.`uid`, `Outlicensing`.`slug`, `Outlicensing`.`title`, `Outlicensing`.`shortdesc` FROM `licopp` AS `Outlicensing` INNER JOIN company AS `ParentCompany` ON (`ParentCompany`.`uid`=`Outlicensing`.`company_id` AND `ParentCompany`.`is_live`="Y") INNER JOIN categorisation AS `CategorisationIndustrySector` ON (`CategorisationIndustrySector`.`company_id` = `Outlicensing`.`uid` AND `CategorisationIndustrySector`.`cat_type` = 'L') INNER JOIN category AS `IndustrySector` ON (`IndustrySector`.`uid` = `CategorisationIndustrySector`.`category_id` AND `IndustrySector`.`lft` >= '1515' AND `IndustrySector`.`rgt` <= '1752') LEFT JOIN `development_statuses` AS `DevelopmentStatus` ON (`Outlicensing`.`devstatus` = `DevelopmentStatus`.`id`) LEFT JOIN `licopps_sites` AS `OutlicensingSite` ON (`OutlicensingSite`.`licopp_id` = `Outlicensing`.`uid`) WHERE `OutlicensingSite`.`site_id` = 1 AND `Outlicensing`.`is_out` = 'Y' GROUP BY `Outlicensing`.`uid` ORDER BY `Outlicensing`.`viewed_counter` DESC, `Outlicensing`.`title` ASC LIMIT 10

1778

SELECT COUNT(DISTINCT Outlicensing.uid) AS `count` FROM `licopp` AS `Outlicensing` INNER JOIN company AS `ParentCompany` ON (`ParentCompany`.`uid`=`Outlicensing`.`company_id` AND `ParentCompany`.`is_live`="Y") INNER JOIN categorisation AS `CategorisationIndustrySector` ON (`CategorisationIndustrySector`.`company_id` = `Outlicensing`.`uid` AND `CategorisationIndustrySector`.`cat_type` = 'L') INNER JOIN category AS `IndustrySector` ON (`IndustrySector`.`uid` = `CategorisationIndustrySector`.`category_id` AND `IndustrySector`.`lft` >= '1515' AND `IndustrySector`.`rgt` <= '1752') LEFT JOIN `development_statuses` AS `DevelopmentStatus` ON (`Outlicensing`.`devstatus` = `DevelopmentStatus`.`id`) LEFT JOIN `licopps_sites` AS `OutlicensingSite` ON (`OutlicensingSite`.`licopp_id` = `Outlicensing`.`uid`) WHERE `OutlicensingSite`.`site_id` = 1 AND `Outlicensing`.`is_out` = 'Y'

2038

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

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