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 283 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `dms_releases`10102
2DESCRIBE `dms_categories`441
3DESCRIBE `dms_clinical_areas`441
4DESCRIBE `dms_categories_dms_releases`2215
5DESCRIBE `dms_clinical_areas_dms_releases`226
6DESCRIBE `dms_releases_sites`552
7DESCRIBE `category`141411
8DESCRIBE `categories_sites`551
9DESCRIBE `story`12124
10DESCRIBE `categorisation`882
11DESCRIBE `sites_stories`556
12DESCRIBE `licopp`23238
13DESCRIBE `company`27272
14DESCRIBE `condet`17173
15DESCRIBE `countrycode`4416
16DESCRIBE `person`15157
17DESCRIBE `account`29291
18DESCRIBE `product_legacy`6618
19DESCRIBE `sales_people`661
20DESCRIBE `profile`141410
21DESCRIBE `currencies`772
22DESCRIBE `update_rec`7712
23DESCRIBE `user`24242
24DESCRIBE `enquiry`14142
25DESCRIBE `module_types`661
26DESCRIBE `dms_companies`26268
27DESCRIBE `development_statuses`552
28DESCRIBE `licopps_sites`332
29DESCRIBE `service`15155
30DESCRIBE `press_release`13132
31DESCRIBE `press_releases_sites`551
32DESCRIBE `story_assoc`443
33DESCRIBE `companies_sites`333
34DESCRIBE `categories_users`222
35DESCRIBE `authority`332
36DESCRIBE `sites_users`552
37DESCRIBE `feature_article`13132
38DESCRIBE `feature_author`13133
39DESCRIBE `newsml`995
40DESCRIBE `prnsubjects`4410
41DESCRIBE `newsml_prnsubjects`225
42DESCRIBE `sites`552
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 13131310
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 797913
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 1313131
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 1871878
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 44413
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 13131312
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 1121124
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 13884
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 59593
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 1003
54DESCRIBE `blurb`992
55SELECT `Blurb`.`id`, `Blurb`.`headline`, `Blurb`.`body` FROM `blurb` AS `Blurb` WHERE `Blurb`.`id` LIKE "PL%" AND `Blurb`.`headline` <> "" ORDER BY `Blurb`.`id` ASC 331
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 3336
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 21210
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 3331
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 22225
(default) 0 query took ms
NrQueryErrorAffectedNum. rowsTook (ms)
(report) 1 query took 2 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `reports`17172
(report_slave) 1 query took 2 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 1010102