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 208 - per page Next page
Order by

Advanced Wound Care Products

Collagen-based dressings for wound management 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

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

CollaRx® & LiquiColl® Technologies

Collagen-based biodegradable matrices for localized drug delivery More

Surgical Adhesion Barrier

Collagen-based adhesion barrier for the prevention of surgical adhesions More

APR BioFilm

Biotechnology Product for Wound Healing More

Two Piece Wrist-Hand-Finger Splint for Treatment of Non-rigid Contractures (TID - 102)

A better fitting two piece wrist-hand-finger orthosis and a simple and effective method by which to cast the splint. More

Naloxone 0,4 mg/ml ampoule

Opioid receptor antagonist reducing opioid induced respiratory depression More

A2 Adenosine Receptor Agonists

Compositions and methods of use of A2 adenosine receptor (AR) agonists for treating conditions modulated by A2A and A2B ARs including myocardial ischemia, reperfusion injury, cystic fibrosis, erectile dysfunction, inflammation, restenosis and septic shock More

NU Bite Block – a mouth guard medical device to protect endotracheal tubes for patients that require mechanical ventilation post surgical or trauma (10-02)

Prevents oral trauma to surgical or long term ventilated patients due to insertion of endotracheal tube; additionally this novel device is beneficial in endoscope labs for both bronchoscope and transesophageal echocardiogram (TEE) procedures. More

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

Related Reports

Market Research Reports provided by reports.innovaro.com

Deals and alliances in hospital, accident and trauma

Jun 2006 - 952 pages - $2,495

Transport Accident Commission - Company Capsule

Aug 2011 - 7 pages - $75

Motor Accident Commission - Company Capsule

Aug 2011 - 7 pages - $75

Transport Accident Commission - Company Capsule

Nov 2011 - 7 pages - $75

Performance Ratio Benchmarking in UK Accident & Health Insurance 2007

Sep 2007 - 18 pages - $1,695

Performance Ratio Benchmarking in UK Accident & Health Insurance 2008

Jan 2009 - 14 pages - $1,695

Performance Ratio Benchmarking in UK Accident & Health Insurance 2009

Dec 2009 - 10 pages - $1,695

Stryker Trauma Sa - Strategic SWOT Analysis Review

May 2011 - 15 pages - $250

Motor Accident Commission - Strategic SWOT Analysis Review

May 2011 - 15 pages - $125

Trauma Fixation - Global Pipeline Analysis, Opportunity Assessment and Market Forecasts to 2016

Oct 2010 - 72 pages - $3,500

Your selection

Therapeutic target: Accident and Trauma del

Browse By

Industry sector: Animal health; Biotechnology; Diagnostic; Drug delivery; Drug discovery; Medical device; Pharmaceutical; Research tools
Therapeutic target: Accident & Trauma (other); Back Pain; Bone fractures; Burns; CNS trauma; Drug overdose; Hemorraghic trauma; Muscle sprain/strain; Poisioning; Reperfusion injury (lung/heart); Stroke/traumatic brain injury; Tissue grafting; Wound closure/surgical adhesive; Wound/ulcer healing
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 110 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	6
4	DESCRIBE `countrycode`	4	4	1
5	DESCRIBE `person`	15	15	1
6	DESCRIBE `account`	29	29	12
7	DESCRIBE `product_legacy`	6	6	1
8	DESCRIBE `sales_people`	6	6	1
9	DESCRIBE `profile`	14	14	3
10	DESCRIBE `currencies`	7	7	1
11	DESCRIBE `update_rec`	7	7	6
12	DESCRIBE `user`	24	24	1
13	DESCRIBE `enquiry`	14	14	5
14	DESCRIBE `module_types`	6	6	1
15	DESCRIBE `dms_companies`	26	26	4
16	DESCRIBE `dms_releases`	10	10	7
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	5
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	4
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	2
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	3
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	2
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	2
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	2
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` = 1476 AND `Category`.`restricted` IS NULL ORDER BY `Category`.`name` ASC	14	14	2
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 (1962, 1963, 1964, 1965, 1966, 1967, 1968, 1969, 1970, 1971, 1972, 1973, 1975, 1976) 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	3
44	SELECT c.lft, c.rgt FROM category c WHERE c.uid = 1476	1	1	0
45	SELECT c.uid, c.name, c.level FROM category c WHERE c.lft <= "2779" AND c.rgt >= "2808" 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` = 1476 LIMIT 1	1	1	3
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 (4156, 4241, 1364, 3221, 4157, 3915, 4773, 4711, 5678, 6642) AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="L" ORDER BY `Category`.`root` ASC, `Category`.`clan` ASC, `Category`.`parent` ASC, `Category`.`name` ASC	188	188	2
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 (4156, 4241, 1364, 3221, 4157, 3915, 4773, 4711, 5678, 6642) AND `Categorisation`.`category_id` = `TherapeuticTarget`.`uid`) WHERE `cat_type` = 'L' ORDER BY `TherapeuticTarget`.`root` ASC, `TherapeuticTarget`.`clan` ASC, `TherapeuticTarget`.`parent` ASC, `TherapeuticTarget`.`name` ASC	188	188	9

(website) 48 queries took 110 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` = 1476 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 (1962, 1963, 1964, 1965, 1966, 1967, 1968, 1969, 1970, 1971, 1972, 1973, 1975, 1976) 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 = 1476

SELECT c.uid, c.name, c.level FROM category c WHERE c.lft <= "2779" AND c.rgt >= "2808" 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` = 1476 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 (4156, 4241, 1364, 3221, 4157, 3915, 4773, 4711, 5678, 6642) AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="L" ORDER BY `Category`.`root` ASC, `Category`.`clan` ASC, `Category`.`parent` ASC, `Category`.`name` ASC

188

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 (4156, 4241, 1364, 3221, 4157, 3915, 4773, 4711, 5678, 6642) AND `Categorisation`.`category_id` = `TherapeuticTarget`.`uid`) WHERE `cat_type` = 'L' ORDER BY `TherapeuticTarget`.`root` ASC, `TherapeuticTarget`.`clan` ASC, `TherapeuticTarget`.`parent` ASC, `TherapeuticTarget`.`name` ASC

188

(website_slave) 2 queries took 842 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 `CategorisationTherapeuticTarget` ON (`CategorisationTherapeuticTarget`.`company_id` = `Outlicensing`.`uid` AND `CategorisationTherapeuticTarget`.`cat_type` = 'L') INNER JOIN category AS `TherapeuticTarget` ON (`TherapeuticTarget`.`uid` = `CategorisationTherapeuticTarget`.`category_id` AND `TherapeuticTarget`.`lft` >= '2779' AND `TherapeuticTarget`.`rgt` <= '2808') 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' AND ((`TherapeuticTarget`.`lft` >= 2779) AND (`TherapeuticTarget`.`rgt` <= 2808)) GROUP BY `Outlicensing`.`uid` ORDER BY `Outlicensing`.`viewed_counter` DESC, `Outlicensing`.`title` ASC LIMIT 10		10	10	364
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 `CategorisationTherapeuticTarget` ON (`CategorisationTherapeuticTarget`.`company_id` = `Outlicensing`.`uid` AND `CategorisationTherapeuticTarget`.`cat_type` = 'L') INNER JOIN category AS `TherapeuticTarget` ON (`TherapeuticTarget`.`uid` = `CategorisationTherapeuticTarget`.`category_id` AND `TherapeuticTarget`.`lft` >= '2779' AND `TherapeuticTarget`.`rgt` <= '2808') 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' AND ((`TherapeuticTarget`.`lft` >= 2779) AND (`TherapeuticTarget`.`rgt` <= 2808))		1	1	478

(website_slave) 2 queries took 842 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 `CategorisationTherapeuticTarget` ON (`CategorisationTherapeuticTarget`.`company_id` = `Outlicensing`.`uid` AND `CategorisationTherapeuticTarget`.`cat_type` = 'L') INNER JOIN category AS `TherapeuticTarget` ON (`TherapeuticTarget`.`uid` = `CategorisationTherapeuticTarget`.`category_id` AND `TherapeuticTarget`.`lft` >= '2779' AND `TherapeuticTarget`.`rgt` <= '2808') 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' AND ((`TherapeuticTarget`.`lft` >= 2779) AND (`TherapeuticTarget`.`rgt` <= 2808)) GROUP BY `Outlicensing`.`uid` ORDER BY `Outlicensing`.`viewed_counter` DESC, `Outlicensing`.`title` ASC LIMIT 10

364

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 `CategorisationTherapeuticTarget` ON (`CategorisationTherapeuticTarget`.`company_id` = `Outlicensing`.`uid` AND `CategorisationTherapeuticTarget`.`cat_type` = 'L') INNER JOIN category AS `TherapeuticTarget` ON (`TherapeuticTarget`.`uid` = `CategorisationTherapeuticTarget`.`category_id` AND `TherapeuticTarget`.`lft` >= '2779' AND `TherapeuticTarget`.`rgt` <= '2808') 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' AND ((`TherapeuticTarget`.`lft` >= 2779) AND (`TherapeuticTarget`.`rgt` <= 2808))

478

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