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

In Vivo Non-Invasive Diagnostic Method Using Magnetic Resonance Spectroscopy of Aspartate Transaminase

A novel non-invasive method for using carbon-13 magnetization transfer effects to determine and evaluate in vivo aspartate transaminase (AST) activity and levels in an organ, as a biomarker of disease and certain neurological disorders. More

Automated Method for Rapid Detection of Sickle Cell Disease Inhibitors

A rapid and automated method for discovering potential drugs for the treatment of sickle cell anemia, using a combination of laser photolysis and statistical processing of digital images. More

New Method for Quantification of Allele-Specific RNA Expression that Can be Used for Detection of Various Genetic Disorders

A simple assay to validate and quantify allele-specific silencing More

Genes for Niemann-Pick Type C Disease

This invention provides the human gene for Niemann-Pick Type C disease and the nucleic acid sequences corresponding to the human gene for Niemann-Pick Type C disease. More

Efficient Gene Silencing Using tRNA Promoter in a Herpes Virus Vector to Deliver Small Interference RNAs (05-07)

An siRNA type therapeutics delevary system More

Epithelial Cell Line Expressing a Cystic Fibrosis Phenotype

This cell line may be used for elucidation of the mechanisms of CF, testing candidate complementary genes for correction of the observed CF abnormalities, and for developing and testing therapeutic CF drugs. More

Improved Method for Analysis of Microarray and Other Multidimensional Data (TID - 6)

Improved accuracy in pattern recognition of clustered multidimensional data More

Overexpressed in Werner's Syndrome Fibroblasts More

Farnesyltransferase Inhibitors for Treatment of Laminopathies, Cellular Aging and Atherosclerosis

A possible treatment of laminopathies, cellular aging and aging-related conditions such as HGPS through the use of farnesyltransferase inhibitors (FTIs) and other related compounds More

Medical Device for the Evaluation of Motor Development in Infants (TID - 153)

The early detection and treatment of motor developmental delays in infants is critical to future motor skill function. More

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

Related Reports

Market Research Reports provided by reports.innovaro.com

Epidemiology: Autism Spectrum Disorders - Increasing recognition drives growth of treatable population

Feb 2011 - 42 pages - $5,700

Genetic Immunity, LLC – Product Pipeline Review – Q1 2011

Apr 2011 - 26 pages - $500

Genetic Testing Global Market Briefing to 2016

Sep 2010 - 25 pages - $2,000

Genetic Immunity, LLC – Product Pipeline Review – H2 2011

Oct 2011 - 27 pages - $500

Opportunities in Malnutrition Management

Mar 2011 - 174 pages - $4,795

National Institute of Neurological Disorders and Stroke – Developmental Therapeutics Review – Q4 2010

Nov 2010 - 40 pages - $500

Myeloproliferative Disorders-Research Consortium – Developmental Therapeutics Review – Q4 2010

Dec 2010 - 22 pages - $500

Sleep Disorders - Pipeline Review, Q3 2011

Jul 2011 - 136 pages - $500

R&D Trends: Autism Spectrum Disorders - Unknown etiology and low industry interest hinders pipeline progression

Apr 2011 - 56 pages - $3,800

Epidemiology: Bipolar Disorders – Population growth to mean more patients with bipolar disorders

Jul 2011 - 39 pages - $5,700

Your selection

Therapeutic target: Genetic disorders del

Browse By

Industry sector: Animal health; Biotechnology; Diagnostic; Drug delivery; Drug discovery; Medical device; Pharmaceutical; Research tools
Therapeutic target: Birth defects; Blood clotting disorders; Fabry's disease; Gaucher's disease; Genetic disorder (other); Hunter's syndrome; Huntington's disease; Kawasaki disease; Klinefelter's syndrome; Phenylketonuria; Severe combined immunodeficiency; Turner's syndrome
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 27 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	1
4	DESCRIBE `countrycode`	4	4	1
5	DESCRIBE `person`	15	15	1
6	DESCRIBE `account`	29	29	1
7	DESCRIBE `product_legacy`	6	6	0
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	0
12	DESCRIBE `user`	24	24	1
13	DESCRIBE `enquiry`	14	14	1
14	DESCRIBE `module_types`	6	6	0
15	DESCRIBE `dms_companies`	26	26	1
16	DESCRIBE `dms_releases`	10	10	1
17	DESCRIBE `dms_categories`	4	4	0
18	DESCRIBE `dms_clinical_areas`	4	4	0
19	DESCRIBE `dms_categories_dms_releases`	2	2	0
20	DESCRIBE `dms_clinical_areas_dms_releases`	2	2	0
21	DESCRIBE `dms_releases_sites`	5	5	0
22	DESCRIBE `development_statuses`	5	5	0
23	DESCRIBE `category`	14	14	1
24	DESCRIBE `categories_sites`	5	5	0
25	DESCRIBE `categorisation`	8	8	9
26	DESCRIBE `licopps_sites`	3	3	0
27	DESCRIBE `service`	15	15	1
28	DESCRIBE `press_release`	13	13	1
29	DESCRIBE `press_releases_sites`	5	5	0
30	DESCRIBE `story`	12	12	1
31	DESCRIBE `sites_stories`	5	5	0
32	DESCRIBE `story_assoc`	4	4	0
33	DESCRIBE `companies_sites`	3	3	0
34	DESCRIBE `categories_users`	2	2	0
35	DESCRIBE `authority`	3	3	0
36	DESCRIBE `sites_users`	5	5	0
37	DESCRIBE `sites`	5	5	0
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	0
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	0
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	0
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` = 1477 AND `Category`.`restricted` IS NULL ORDER BY `Category`.`name` ASC	12	12	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 (1977, 1978, 1980, 1981, 1982, 1983, 1984, 1985, 1986, 2154, 1987, 1988) 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	0
44	SELECT c.lft, c.rgt FROM category c WHERE c.uid = 1477	1	1	0
45	SELECT c.uid, c.name, c.level FROM category c WHERE c.lft <= "3335" AND c.rgt >= "3360" AND c.level > 1 ORDER BY c.level	1	1	0
46	SELECT `TherapeuticTarget`.`lft`, `TherapeuticTarget`.`rgt`, `TherapeuticTarget`.`uid` FROM `category` AS `TherapeuticTarget` LEFT JOIN `category` AS `Parent` ON (`TherapeuticTarget`.`parent` = `Parent`.`uid`) LEFT JOIN `categories_sites` AS `CategorySite` ON (`CategorySite`.`category_id` = `TherapeuticTarget`.`uid`) WHERE `CategorySite`.`site_id` = 1 AND `TherapeuticTarget`.`uid` = 1477 LIMIT 1	1	1	0
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 (4505, 5762, 4344, 4206, 5393, 4701, 5571, 5347, 3617, 5925) AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="L" ORDER BY `Category`.`root` ASC, `Category`.`clan` ASC, `Category`.`parent` ASC, `Category`.`name` ASC	105	105	1
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 (4505, 5762, 4344, 4206, 5393, 4701, 5571, 5347, 3617, 5925) AND `Categorisation`.`category_id` = `TherapeuticTarget`.`uid`) WHERE `cat_type` = 'L' ORDER BY `TherapeuticTarget`.`root` ASC, `TherapeuticTarget`.`clan` ASC, `TherapeuticTarget`.`parent` ASC, `TherapeuticTarget`.`name` ASC	105	105	0

(website) 48 queries took 27 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` = 1477 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 (1977, 1978, 1980, 1981, 1982, 1983, 1984, 1985, 1986, 2154, 1987, 1988) 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 = 1477

SELECT c.uid, c.name, c.level FROM category c WHERE c.lft <= "3335" AND c.rgt >= "3360" 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` = 1477 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 (4505, 5762, 4344, 4206, 5393, 4701, 5571, 5347, 3617, 5925) AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="L" ORDER BY `Category`.`root` ASC, `Category`.`clan` ASC, `Category`.`parent` ASC, `Category`.`name` ASC

105

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 (4505, 5762, 4344, 4206, 5393, 4701, 5571, 5347, 3617, 5925) AND `Categorisation`.`category_id` = `TherapeuticTarget`.`uid`) WHERE `cat_type` = 'L' ORDER BY `TherapeuticTarget`.`root` ASC, `TherapeuticTarget`.`clan` ASC, `TherapeuticTarget`.`parent` ASC, `TherapeuticTarget`.`name` ASC

105

(website_slave) 2 queries took 646 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` >= '3335' AND `TherapeuticTarget`.`rgt` <= '3360') 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` >= 3335) AND (`TherapeuticTarget`.`rgt` <= 3360)) GROUP BY `Outlicensing`.`uid` ORDER BY `Outlicensing`.`viewed_counter` DESC, `Outlicensing`.`title` ASC LIMIT 10		10	10	356
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` >= '3335' AND `TherapeuticTarget`.`rgt` <= '3360') 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` >= 3335) AND (`TherapeuticTarget`.`rgt` <= 3360))		1	1	290

(website_slave) 2 queries took 646 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` >= '3335' AND `TherapeuticTarget`.`rgt` <= '3360') 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` >= 3335) AND (`TherapeuticTarget`.`rgt` <= 3360)) GROUP BY `Outlicensing`.`uid` ORDER BY `Outlicensing`.`viewed_counter` DESC, `Outlicensing`.`title` ASC LIMIT 10

356

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` >= '3335' AND `TherapeuticTarget`.`rgt` <= '3360') 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` >= 3335) AND (`TherapeuticTarget`.`rgt` <= 3360))

290

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