Warning (512): /home/pharma/website/current/cakephp/app/pharmalicensing/tmp/cache/ is not writable [CORE/cake/libs/cache/file.php, line 267]
Innovaro Pharmalicensing
RSS Feeds
Search

Your Personal Innovaro Pharmalicensing

Welcome to your personalized Innovaro Pharmalicensing homepage.

From here you can access all of the benefits the website has to offer. Tailor your homepage to your personal requirements by selecting up to 3 categorisation filters below.

Reports

See the latest reports in your area from our Reports Store. More

PL Recommends

See what Innovaro Pharmalicensing Recommends in your area. More

Out-licensing

See the latest out-licensing opportunities in your area from our profiling clients. More

In-licensing

See the latest in-licensing opportunities in your area from our profiling clients. More

Companies

See the latest company profiles in your area from our profiling clients. More

Categorisation Filters

To personalize your home page you have to be logged in. If you haven't got an account with us yet, please register now FREE OF CHARGE.


Login   Register

Innovaro Pharmalicensing Recommends...

The latest opportunities Innovaro Pharmalicensing Recommends in your area:

Innovaro Pharmalicensing Recommends...
‘Combiflex’ three-chamber parenteral nutritional lipid bag, ready to... more
Adipose tissue derived stem cells available for development to treat... more
Well established UK company seeks finished prescription products to add to... more
Novel and innovative animal health products sought for distribution and/or... more
Pure, safe, concentrated and effective Carbo-Hydrate Derived Fulvic Acid... more
Small molecule platform capable of enhancing osteogenic differentiation of... more
Early stage controlled dose measuring device capable of delivering oral... more
Unique “Plant Milking” Technology capable of producing high value active... more
EU patent for the preparation of an injectable form of anti-ulcer drug... more
Novel anti-inflammatory omega-3 fatty acids sourced from green lipped mussels. more
Omega-3 fatty acids to treat joint care, asthma and dermatitis in animals. more
Technology to source new APIs from plant species more
Seeking novel delivery technologies for oral solid (tablets and capsules)... more

Out-licensing

The latest out-licensing opportunities from our profiling clients:

Out-licensing
Ultrasonic Guided Catheter Deployment System (02-14) more
Dressing - Skin Closure for Eyelids (90-02) more
Immunotherapy for Warts (10-09) more
Single Shot Microscopic Imaging more
Metformin Hydrochloride extended release tablets 750mg more
New naphthyridine derivatives with diverse biological activities to treat... more
Peptides derived from hepatitis G virus for treatment of HIV more
Treatment of emerging viral encephalitis with valproic acid, an... more
HUMAN PANCREATIC PROGENITOR CELL LINES more
CHONDROPROGENITOR DIRECTED DIFFERENTIATION PROTOCOL more
ANIMAL-FREE COLLAGEN AND GELATIN more
Cold Fleece Patch more
5 and 10 mg Donepezil RapidFilm more

In-licensing

The latest in-licensing requirements from our profiling clients:

In-licensing
Dermatology: products/technologies for Acne more
Dermatology: Skin Cancer, Anti-fungals, Dermoceuticals & more more
Seeking development opportunities with novel delivery technologies for... more
Long lasting adhesion to mucosa of the upper and lower respiratory tracts more
NCEs, new patented formulations and products more
Almirall is seeking M&A and in-licensing opportunities in Dermatology more
Topical infection control – including surgery preps, scrubs and sealants more
Wound closure systems – including sealants, devices and dressings more
Oral dissolving thin film technology with high API loading capabilities more
Seeking Rx/prescription only drugs in any therapeutic area, including... more
Oral, Topical or Transdermal products in any therapeutical area more
Seeking opportunities for OTC female healthcare products. more
Seeking opportunities for new and unique OTC products for Psoriasis, or... more

Latest Companies

The latest company profiles from our company directory:

University of Manchester Intellectual Property

University of Manchester Intellectual Property

UMIP is The University of Manchester’s Intellectual Property (IP) commercialisation company. more

One Nucleus

One Nucleus is a membership organisation for international life science and healthcare... more

Almirall Hermal GmbH

Almirall Hermal GmbH

Almirall Hermal GmbH, The Dermatology Unit of Almirall, S.A. more

Eloquest Healthcare, Inc.

Eloquest Healthcare, Inc.

Eloquest™ Healthcare, Inc. is a dermatology specialty company promoting a unique product... more

Latest updates

Personalize your Innovaro Pharmalicensing experience!
After years of providing what many users claim to be the most effective source of innovative partnering opportunities across the lifesciences industry we have made it even better! We have responded to the needs of our Registered Users to help them save time and effort by delivering only specifically relevant opportunities to them based on their bespoke partnering requirements. We are therefore proud to introduce the new Innovaro Pharmalicensing home page (see above), providing a fully personalized destination for our 200,000+ unique visitors every month. To enable our visitors to drill down to those opportunities which most closely match their specific partnering needs; we have... More...

BIO-Europe Spring 2012; Book your place in Amsterdam
The sixth annual BIO-Europe Spring® conference is the premier springtime partnering conference for the biotechnology industry. For its 2012 edition, BIO-Europe Spring comes to Amsterdam, The Netherlands on March 19-21, 2012. Based on attendance at previous events, BIO-Europe Spring 2012 will bring together close to 2,000 executives from biotechnology, pharmaceutical and finance companies from around the world, who will engage in some 10,000 partnering meetings. For further information or to register, please visit the event page. More...

Maximize your pharmaceutical licensing opportunities
For an increasingly risk-averse industry, licensing deals represent a more affordable, less risky alternative to M&A transactions. They are being used to strengthen pipelines, manage major brand life-cycles, expand or restructure portfolios, access new technologies, and enter new geographical markets. This newly published report reviews the key trends in pharmaceutical licensing, examining deal volumes, values and structure. Therapeutic focus is also covered along with detailed profiles of the strategies of 10 leading pharmaceutical companies. The report also sets out future directions for licensing and alliance activity. Order your copy today. Licensing opportunities not what you... More...

Our Services

Partnering Search

Our Partnering Search offers advanced and enhanced partnering support.

Actively working for you, our service enables you to utilize the knowledge and expertise of Innovaro Pharmalicensing.

Partnering Search service

Company Profiling

Our profiling service maximizes your potential of finding the most suitable partner for your opportunities by targeting our focused global business development and licensing audience.

Company Profiling service

Reports

Our Biopharma Reports Store offers a diverse collection of biopharma and pharmaceutical reports to support and improve your life science decisions.

Biopharma Reports Store

Pharma Transfer

Licensing Opportunities in Life Sciences - Delivering Concise Abstracts Summarizing Innovations Within Developing Pharma Research.

Pharma Transfer service

Deal Negotiation

Innovaro Pharmalicensing now offers expert support to assist and guide you through the entire deal negotiation process.

Deal Negotiation service

PL Intelligence

A one-stop environment for time-conscious executives. Keeping you abreast of the latest developments in the life sciences industry, saving you time and money when you need it most.

PL Intelligence service

© Copyright 1998-2012 Innovaro Europe Ltd Innovaro Corporation All rights reserved. Terms and Conditions | Contact us

(website) 59 queries took 508 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `dms_releases`10102
2DESCRIBE `dms_categories`442
3DESCRIBE `dms_clinical_areas`444
4DESCRIBE `dms_categories_dms_releases`222
5DESCRIBE `dms_clinical_areas_dms_releases`2212
6DESCRIBE `dms_releases_sites`5518
7DESCRIBE `category`14142
8DESCRIBE `categories_sites`5514
9DESCRIBE `story`12122
10DESCRIBE `categorisation`881
11DESCRIBE `sites_stories`551
12DESCRIBE `licopp`23231
13DESCRIBE `company`27279
14DESCRIBE `condet`17174
15DESCRIBE `countrycode`441
16DESCRIBE `person`15159
17DESCRIBE `account`29291
18DESCRIBE `product_legacy`661
19DESCRIBE `sales_people`662
20DESCRIBE `profile`14142
21DESCRIBE `currencies`776
22DESCRIBE `update_rec`771
23DESCRIBE `user`24241
24DESCRIBE `enquiry`141414
25DESCRIBE `module_types`662
26DESCRIBE `dms_companies`262628
27DESCRIBE `development_statuses`556
28DESCRIBE `licopps_sites`331
29DESCRIBE `service`15152
30DESCRIBE `press_release`13138
31DESCRIBE `press_releases_sites`557
32DESCRIBE `story_assoc`446
33DESCRIBE `companies_sites`335
34DESCRIBE `categories_users`223
35DESCRIBE `authority`331
36DESCRIBE `sites_users`552
37DESCRIBE `feature_article`13134
38DESCRIBE `feature_author`13135
39DESCRIBE `newsml`992
40DESCRIBE `prnsubjects`444
41DESCRIBE `newsml_prnsubjects`228
42DESCRIBE `sites`554
43SELECT `Site`.`id`, `Site`.`name`, `Site`.`email_domain`, `Site`.`short_name`, `Site`.`brand` FROM `sites` AS `Site` WHERE `Site`.`id` = 1 LIMIT 1112
44SELECT `Outlicensing`.`uid`, `Outlicensing`.`slug`, `Outlicensing`.`title`, `Outlicensing`.`change_time`, `Category`.`uid` FROM `licopp` AS `Outlicensing` LEFT JOIN categorisation AS `Categorisation` ON (`Categorisation`.`company_id` = `Outlicensing`.`uid` AND `Categorisation`.`cat_type` = 'L') LEFT JOIN category AS `Category` ON (`Category`.`uid` = `Categorisation`.`category_id`) LEFT JOIN `person` AS `Person` ON (`Outlicensing`.`contact_id` = `Person`.`uid`) LEFT JOIN `development_statuses` AS `DevelopmentStatus` ON (`Outlicensing`.`devstatus` = `DevelopmentStatus`.`id`) LEFT JOIN `update_rec` AS `UpdateRecord` ON (`Outlicensing`.`update_id` = `UpdateRecord`.`uid`) LEFT JOIN `company` AS `Company` ON (`Outlicensing`.`company_id` = `Company`.`uid`) LEFT JOIN `licopps_sites` AS `OutlicensingSite` ON (`OutlicensingSite`.`licopp_id` = `Outlicensing`.`uid`) WHERE `OutlicensingSite`.`site_id` = 1 AND ((`Outlicensing`.`is_out` = 'Y') AND (`Company`.`is_live` = 'Y')) GROUP BY `Outlicensing`.`uid` ORDER BY `Outlicensing`.`change_time` DESC LIMIT 13131328
45SELECT `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 (5563, 5344, 19131, 19261, 19330, 18695, 19262, 18782, 19384, 19385, 19383, 1365, 4651) AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="L" ORDER BY `Category`.`root` ASC, `Category`.`clan` ASC, `Category`.`parent` ASC, `Category`.`name` ASC 79799
46SELECT `Inlicensing`.`uid`, `Inlicensing`.`slug`, `Inlicensing`.`title`, `Inlicensing`.`change_time`, `Category`.`uid` FROM `licopp` AS `Inlicensing` LEFT JOIN categorisation AS `Categorisation` ON (`Categorisation`.`company_id` = `Inlicensing`.`uid` AND `Categorisation`.`cat_type` = 'P') LEFT JOIN category AS `Category` ON (`Category`.`uid` = `Categorisation`.`category_id`) LEFT JOIN `person` AS `Person` ON (`Inlicensing`.`contact_id` = `Person`.`uid`) LEFT JOIN `development_statuses` AS `DevelopmentStatus` ON (`Inlicensing`.`devstatus` = `DevelopmentStatus`.`id`) LEFT JOIN `update_rec` AS `UpdateRecord` ON (`Inlicensing`.`update_id` = `UpdateRecord`.`uid`) LEFT JOIN `company` AS `Company` ON (`Inlicensing`.`company_id` = `Company`.`uid`) LEFT JOIN `licopps_sites` AS `InlicensingSite` ON (`InlicensingSite`.`licopp_id` = `Inlicensing`.`uid`) WHERE `InlicensingSite`.`site_id` = 1 AND ((`Inlicensing`.`is_out` = 'N') AND (`Company`.`is_live` = 'Y')) GROUP BY `Inlicensing`.`uid` ORDER BY `Inlicensing`.`change_time` DESC LIMIT 1313135
47SELECT `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 (4338, 4340, 3247, 19302, 1362, 18662, 5627, 5626, 19299, 19291, 5002, 19251, 19252) AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="P" ORDER BY `Category`.`root` ASC, `Category`.`clan` ASC, `Category`.`parent` ASC, `Category`.`name` ASC 18718719
48 SELECT Company.uid, Company.slug, Company.name, Company.summary, Company.change_time FROM company AS Company INNER JOIN companies_sites AS CompanySite ON CompanySite.company_id = Company.uid AND CompanySite.site_id = 1 WHERE Company.is_customer="Y" AND Company.is_live="Y" GROUP BY Company.uid ORDER BY Company.change_time DESC LIMIT 44438
49SELECT `Outlicensing`.`uid`, `Outlicensing`.`slug`, `Outlicensing`.`title`, `Outlicensing`.`change_time`, `Category`.`uid` FROM `licopp` AS `Outlicensing` LEFT JOIN categorisation AS `Categorisation` ON (`Categorisation`.`company_id` = `Outlicensing`.`uid` AND `Categorisation`.`cat_type` = 'L') LEFT JOIN category AS `Category` ON (`Category`.`uid` = `Categorisation`.`category_id`) LEFT JOIN `person` AS `Person` ON (`Outlicensing`.`contact_id` = `Person`.`uid`) LEFT JOIN `development_statuses` AS `DevelopmentStatus` ON (`Outlicensing`.`devstatus` = `DevelopmentStatus`.`id`) LEFT JOIN `update_rec` AS `UpdateRecord` ON (`Outlicensing`.`update_id` = `UpdateRecord`.`uid`) LEFT JOIN `company` AS `Company` ON (`Outlicensing`.`company_id` = `Company`.`uid`) LEFT JOIN `licopps_sites` AS `OutlicensingSite` ON (`OutlicensingSite`.`licopp_id` = `Outlicensing`.`uid`) WHERE `OutlicensingSite`.`site_id` = 1 AND ((`Outlicensing`.`is_out` = 'Y') AND (`Company`.`is_live` = 'Y')) AND `Company`.`uid` = 1139 GROUP BY `Outlicensing`.`uid` ORDER BY `Outlicensing`.`change_time` DESC LIMIT 13131318
50SELECT `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 (19341, 19331, 19295, 19281, 19246, 18788, 19250, 19280, 19263, 18789, 18729, 18727, 18658) AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="L" ORDER BY `Category`.`root` ASC, `Category`.`clan` ASC, `Category`.`parent` ASC, `Category`.`name` ASC 11211216
51SELECT `Inlicensing`.`uid`, `Inlicensing`.`slug`, `Inlicensing`.`title`, `Inlicensing`.`change_time`, `Category`.`uid` FROM `licopp` AS `Inlicensing` LEFT JOIN categorisation AS `Categorisation` ON (`Categorisation`.`company_id` = `Inlicensing`.`uid` AND `Categorisation`.`cat_type` = 'P') LEFT JOIN category AS `Category` ON (`Category`.`uid` = `Categorisation`.`category_id`) LEFT JOIN `person` AS `Person` ON (`Inlicensing`.`contact_id` = `Person`.`uid`) LEFT JOIN `development_statuses` AS `DevelopmentStatus` ON (`Inlicensing`.`devstatus` = `DevelopmentStatus`.`id`) LEFT JOIN `update_rec` AS `UpdateRecord` ON (`Inlicensing`.`update_id` = `UpdateRecord`.`uid`) LEFT JOIN `company` AS `Company` ON (`Inlicensing`.`company_id` = `Company`.`uid`) LEFT JOIN `licopps_sites` AS `InlicensingSite` ON (`InlicensingSite`.`licopp_id` = `Inlicensing`.`uid`) WHERE `InlicensingSite`.`site_id` = 1 AND ((`Inlicensing`.`is_out` = 'N') AND (`Company`.`is_live` = 'Y')) AND `Company`.`uid` = 1139 GROUP BY `Inlicensing`.`uid` ORDER BY `Inlicensing`.`change_time` DESC LIMIT 138845
52SELECT `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 (18815, 19303, 18794, 19120, 18606, 6612, 18793, 18791) AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="P" ORDER BY `Category`.`root` ASC, `Category`.`clan` ASC, `Category`.`parent` ASC, `Category`.`name` ASC 595929
53SELECT `Person`.`salutation` FROM `person` AS `Person` LEFT JOIN `condet` AS `Contact` ON (`Person`.`condet_id` = `Contact`.`uid`) LEFT JOIN `company` AS `Company` ON (`Person`.`company_id` = `Company`.`uid`) WHERE `Person`.`uid`="" LIMIT 1001
54DESCRIBE `blurb`991
55SELECT `Blurb`.`id`, `Blurb`.`headline`, `Blurb`.`body` FROM `blurb` AS `Blurb` WHERE `Blurb`.`id` LIKE "PL%" AND `Blurb`.`headline` <> "" ORDER BY `Blurb`.`id` ASC 338
56SELECT `Outlicensing`.`uid`, `Outlicensing`.`slug`, `Outlicensing`.`title`, `Outlicensing`.`change_time`, `Category`.`uid` FROM `licopp` AS `Outlicensing` LEFT JOIN categorisation AS `Categorisation` ON (`Categorisation`.`company_id` = `Outlicensing`.`uid` AND `Categorisation`.`cat_type` = 'L') LEFT JOIN category AS `Category` ON (`Category`.`uid` = `Categorisation`.`category_id`) LEFT JOIN `person` AS `Person` ON (`Outlicensing`.`contact_id` = `Person`.`uid`) LEFT JOIN `development_statuses` AS `DevelopmentStatus` ON (`Outlicensing`.`devstatus` = `DevelopmentStatus`.`id`) LEFT JOIN `update_rec` AS `UpdateRecord` ON (`Outlicensing`.`update_id` = `UpdateRecord`.`uid`) LEFT JOIN `company` AS `Company` ON (`Outlicensing`.`company_id` = `Company`.`uid`) LEFT JOIN `licopps_sites` AS `OutlicensingSite` ON (`OutlicensingSite`.`licopp_id` = `Outlicensing`.`uid`) WHERE `OutlicensingSite`.`site_id` = 1 AND ((`Outlicensing`.`is_out` = 'Y') AND (`Company`.`is_live` = 'Y')) AND `Company`.`uid` = 1139 GROUP BY `Outlicensing`.`uid` ORDER BY `Outlicensing`.`change_time` DESC LIMIT 33324
57SELECT `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 (19341, 19331, 19295) AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="L" ORDER BY `Category`.`root` ASC, `Category`.`clan` ASC, `Category`.`parent` ASC, `Category`.`name` ASC 21216
58SELECT `Inlicensing`.`uid`, `Inlicensing`.`slug`, `Inlicensing`.`title`, `Inlicensing`.`change_time`, `Category`.`uid` FROM `licopp` AS `Inlicensing` LEFT JOIN categorisation AS `Categorisation` ON (`Categorisation`.`company_id` = `Inlicensing`.`uid` AND `Categorisation`.`cat_type` = 'P') LEFT JOIN category AS `Category` ON (`Category`.`uid` = `Categorisation`.`category_id`) LEFT JOIN `person` AS `Person` ON (`Inlicensing`.`contact_id` = `Person`.`uid`) LEFT JOIN `development_statuses` AS `DevelopmentStatus` ON (`Inlicensing`.`devstatus` = `DevelopmentStatus`.`id`) LEFT JOIN `update_rec` AS `UpdateRecord` ON (`Inlicensing`.`update_id` = `UpdateRecord`.`uid`) LEFT JOIN `company` AS `Company` ON (`Inlicensing`.`company_id` = `Company`.`uid`) LEFT JOIN `licopps_sites` AS `InlicensingSite` ON (`InlicensingSite`.`licopp_id` = `Inlicensing`.`uid`) WHERE `InlicensingSite`.`site_id` = 1 AND ((`Inlicensing`.`is_out` = 'N') AND (`Company`.`is_live` = 'Y')) AND `Company`.`uid` = 1139 GROUP BY `Inlicensing`.`uid` ORDER BY `Inlicensing`.`change_time` DESC LIMIT 33342
59SELECT `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 (18815, 19303, 18794) AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="P" ORDER BY `Category`.`root` ASC, `Category`.`clan` ASC, `Category`.`parent` ASC, `Category`.`name` ASC 22227
(default) 0 query took ms
NrQueryErrorAffectedNum. rowsTook (ms)
(report) 1 query took 23 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `reports`171723
(report_slave) 1 query took 29 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `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 10101029