RSS Feeds
Search

Your Innovaro Medical Device Licensing

Welcome to your Innovaro Medical Device Licensing homepage.

From here you can access all of the benefits the website has to offer.

Reports

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

MDL Recommends

See what Innovaro Medical Device Licensing 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

Innovaro Medical Device Licensing Recommends...

The latest opportunities Innovaro Medical Device Licensing Recommends in your area:

Innovaro Medical Device Licensing Recommends...
‘Combiflex’ three-chamber parenteral nutritional lipid bag, ready to... more
Early stage controlled dose measuring device capable of delivering oral... more
EU patent for the preparation of an injectable form of anti-ulcer drug... more
Seeking novel delivery technologies for oral solid (tablets and capsules)... more
Generic molecules, OTC products and novel delivery technologies required for... more
Tension free vaginal support (TVS) medical device indicated for stress... more
Frozen lozenge drug delivery technology, capable of encapsulating... more
Seeking very late stage and market ready prescription products or medical... more
Anti-microbial Monocaprin emulsion, available for use as a cleaning solvent... 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
Single Shot Microscopic Imaging more
Metformin Hydrochloride extended release tablets 750mg more
Cold Fleece Patch more
5 and 10 mg Donepezil RapidFilm more
Microneedle roller system for maximizing cosmeceutical’s absorption into... more
Highly infectious nucleic acid molecules from pepper mottle virus and... more
Composition for glucose sensing comprising of nanofibrous membrane and... more
Medical adhesive available for home care & veterinary market more
NexACT® multi-route drug delivery technology (esp. topical, oral,... more
PsoriaVa™ (Pre-IND- Calcipotriene 0.005%/Betamethasone 0.64%, Psoriasis) more
Tackling challenges of poor solubility 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
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
Topical wound care treatments for burns, trauma & diabetic wounds 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

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

NexMed (U.S.A.), Inc.

NexMed (U.S.A.), Inc.

NexMed (U.S.A.) Inc. (“NexMed”) has leveraged the flexibility of its proven NexACT® drug... more

Latest updates

Medtech Start-Ups/Innovators Partner with Top Investors & Corporate Acquisition Leaders at IN3 Summit
Hear from Medtronic, Boston Scientific, the FDA, and more to get the facts straight about what corporate buyers are looking for in modern times; changes to the 510(k) program and the new requirements you must implement going forward; the hot device deals now and in the future; the current philosophy/approach to investments; the role M&A plays at your company; what current technology/therapeutic areas are considered the "sweet spot"; how start-ups can get key investor attention; and including recent M&A case studies. www.IN3Summit.com or IN3@Elsevier.com.   More...

Global Medical Devices Industry Outlook Survey 2011–2012
This report is the result of an extensive survey drawn from ICD Research's exclusive panel of leading medical device industry executives. It analyzes how medical device companies' procurement expenditure, business strategies and practices are set to change in 2011-2012. This report gives you access to the category-level spending outlooks, budgets, supplier selection criteria, business challenges and investment opportunities of leading purchase decision makers. The report also identifies future growth of buyers and suppliers, M&A and e-procurement. View the report and order today. See other medical device reports.   More...

Providing you with a prospect list of partners
As a developer of an innovative product or technology in the pharmaceutical industry it is inevitable that one day you will require the services of a partner.The Partnering Search service from Innovaro Medical Device Licensing is designed to move the workload associated with finding partners from you over to us.Following your instructions and based entirely on your criteria, the Partnering Search Team at Innovaro Medical Device Licensing will actively search for partners on your behalf and provide you with a qualified list of target companies. Find out more Contact our team to arrange your partner search More...

Clients in focus...

Get the Flash Player to see this rotator.

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 Medical Device Licensing.

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 Medical Device Licensing now offers expert support to assist and guide you through the entire deal negotiation process.

Deal Negotiation service

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

(website) 59 queries took 2457 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `dms_releases`10101
2DESCRIBE `dms_categories`446
3DESCRIBE `dms_clinical_areas`449
4DESCRIBE `dms_categories_dms_releases`226
5DESCRIBE `dms_clinical_areas_dms_releases`227
6DESCRIBE `dms_releases_sites`5516
7DESCRIBE `category`141412
8DESCRIBE `categories_sites`5521
9DESCRIBE `story`121255
10DESCRIBE `categorisation`886
11DESCRIBE `sites_stories`559
12DESCRIBE `licopp`23232
13DESCRIBE `company`272712
14DESCRIBE `condet`17173
15DESCRIBE `countrycode`4434
16DESCRIBE `person`151530
17DESCRIBE `account`292918
18DESCRIBE `product_legacy`663
19DESCRIBE `sales_people`667
20DESCRIBE `profile`141436
21DESCRIBE `currencies`7714
22DESCRIBE `update_rec`772
23DESCRIBE `user`24249
24DESCRIBE `enquiry`141456
25DESCRIBE `module_types`665
26DESCRIBE `dms_companies`262646
27DESCRIBE `development_statuses`5553
28DESCRIBE `licopps_sites`3311
29DESCRIBE `service`151523
30DESCRIBE `press_release`131329
31DESCRIBE `press_releases_sites`5535
32DESCRIBE `story_assoc`4420
33DESCRIBE `companies_sites`337
34DESCRIBE `categories_users`223
35DESCRIBE `authority`339
36DESCRIBE `sites_users`5518
37DESCRIBE `feature_article`131330
38DESCRIBE `feature_author`131323
39DESCRIBE `newsml`9913
40DESCRIBE `prnsubjects`443
41DESCRIBE `newsml_prnsubjects`223
42DESCRIBE `sites`5511
43SELECT `Site`.`id`, `Site`.`name`, `Site`.`email_domain`, `Site`.`short_name`, `Site`.`brand` FROM `sites` AS `Site` WHERE `Site`.`id` = 2 LIMIT 1114
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` = 2 AND ((`Outlicensing`.`is_out` = 'Y') AND (`Company`.`is_live` = 'Y')) GROUP BY `Outlicensing`.`uid` ORDER BY `Outlicensing`.`change_time` DESC LIMIT 1313131575
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, 19261, 19330, 1365, 4651, 19213, 6025, 6028, 5630, 18726, 18725, 19287) AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="L" ORDER BY `Category`.`root` ASC, `Category`.`clan` ASC, `Category`.`parent` ASC, `Category`.`name` ASC 29529512
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` = 2 AND ((`Inlicensing`.`is_out` = 'N') AND (`Company`.`is_live` = 'Y')) GROUP BY `Inlicensing`.`uid` ORDER BY `Inlicensing`.`change_time` DESC LIMIT 13131318
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, 5002, 19251, 19252, 5628) AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="P" ORDER BY `Category`.`root` ASC, `Category`.`clan` ASC, `Category`.`parent` ASC, `Category`.`name` ASC 1901902
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 = 2 WHERE Company.is_customer="Y" AND Company.is_live="Y" GROUP BY Company.uid ORDER BY Company.change_time DESC LIMIT 4447
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` = 2 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 136628
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, 19246, 19250, 18729, 18658, 18648) AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="L" ORDER BY `Category`.`root` ASC, `Category`.`clan` ASC, `Category`.`parent` ASC, `Category`.`name` ASC 55559
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` = 2 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 13335
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 (18794, 6612, 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 333319
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`997
55SELECT `Blurb`.`id`, `Blurb`.`headline`, `Blurb`.`body` FROM `blurb` AS `Blurb` WHERE `Blurb`.`id` LIKE "MDL%" AND `Blurb`.`headline` <> "" ORDER BY `Blurb`.`id` ASC 3318
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` = 2 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 3334
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, 19246, 19250) AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="L" ORDER BY `Category`.`root` ASC, `Category`.`clan` ASC, `Category`.`parent` ASC, `Category`.`name` ASC 28283
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` = 2 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 33325
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 (18794, 6612, 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 33332
(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 8 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 ("Medical Devices") ORDER BY MATCH (`MarketResearchReport`.`name`, `MarketResearchReport`.`description`, `MarketResearchReport`.`summary`, `MarketResearchReport`.`content`, `MarketResearchReport`.`isbn`, `MarketResearchReport`.`code`) AGAINST ("Medical Devices") DESC , MarketResearchReport.published DESC LIMIT 1010108