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

Companies

Companies
Browse

Companies

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

Novartis Consumer Health, Inc.

Novartis Consumer Health is a world leader in self-medication products. The company welcomes the opportunity to review business opportunities for new products and technologies which bring innovations More

APR Applied Pharma Research S.A.

APR is a private, independent, integrated Healhcare Company focused on Delivering, Funding and Supporting Innovation in Healthcare. More

Zambon Company SpA

Zambon Company SpA is a privately-held multinational pharmaceutical and chemical company that looks for in-licensing products in late stage development or already in the market.. More

Alliance Pharmaceuticals (UK)

Alliance pharmaceuticals is a dynamic UK pharmaceutical company with a successful acquisition and partnership track record More

Ferndale Laboratories

Ferndale Laboratories is dedicated to discovering, developing and delivering unique, branded pharmaceuticals that provide therapeutic dermatology solutions to the under-served medical specialties. More

One Nucleus

One Nucleus is a membership organisation for international life science and healthcare companies, based in Cambridge and London UK, the heart of Europe’s largest life science cluster More

National Institutes of Health (NIH)

The NIH supports and conducts basic, clinical, and translational medical research, and investigates the causes, treatments, and cures for both common and rare diseases. More

Consejo Superior de Investigaciones Cientificas, CSIC (Spanish National Research Council)

Spanish public research organisation with 126 centres covering all knowledge areas and highly active in collaborating with the industry. More

Focus Care Pharmaceuticals B.V

Focus Care commercializes added value brands, generics and OTC products More

DESMA PHARMA Group

DESMA PHARMA Group manufactures and markets proprietary, branded, ethical and OTC products in more than 40 countries worldwide and we constantly increase our business by acquisition of mature brands. More

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

Related Reports

Market Research Reports provided by reports.innovaro.com

Gastrointestinal Drug Discoveries

Jan 2008 - 148 pages - $1,740

Hokkaido Gastrointestinal Cancer Study Group – Developmental Therapeutics Review – Q4 2010

Dec 2010 - 30 pages - $500

Spanish Cooperative Group for Gastrointestinal Tumour Therapy – Developmental Therapeutics Review – Q4 2010

Dec 2010 - 41 pages - $500

Spanish Cooperative Group for Gastrointestinal Tumour Therapy – Developmental Therapeutics Review – Q1 2011

Mar 2011 - 41 pages - $500

Osaka Gastrointestinal Cancer Chemotherapy Study Group (OGSG) – Developmental Therapeutics Review – Q4 2010

Dec 2010 - 40 pages - $500

Osaka Gastrointestinal Cancer Chemotherapy Study Group (OGSG) – Developmental Therapeutics Review – Q1 2011

Mar 2011 - 40 pages - $500

Gastrointestinal Disorders Therapy Area Pipeline Report

Nov 2010 - 933 pages - $1,495

Gastrointestinal (Stomach) Cancer Therapy Area Pipeline Report

Nov 2010 - 324 pages - $1,495

Gastrointestinal Pipeline Databook - November 2011

Nov 2011 - 7 pages - $3,835

Deals and alliances in gastrointestinal diseases

Jun 2006 - 278 pages - $2,495

Your selection

Therapeutic target: Gastrointestinal del

Browse By

Industry sector: Academic/Research; Animal health; Biotechnology; Diagnostic; Drug delivery; Drug discovery; Medical device; Non-profit org./Government; Pharmaceutical; Research tools; Service
Therapeutic target: Appendicitis; Cholangitis, sclerosing; Colitis; Colitis, ulcerative; Constipation; Crohn's disease; Diarrhea; Dyspepsia; Electrolyte replacement; Emesis; Emesis, motion; Esophagitis; Flatulence; Food poisoning; Gastritis; Gastroesophageal reflux disorder; Gastrointestinal (other); Gastrointestinal secretions; Gastroprokinetic; Helicobacter pylori; Inflammatory bowel disease; Irritable bowel syndrome; Nausea; Pancreatitis; Ulcer; Ulcer, gastric; Ulcer, gastroduodenal; Ulcer, peptic
Geographic location: Africa; Asia; Australia/New Zealand; Central America; Europe; Near & Far East; North America; South America

Products:	Partnering Search	Company Profiling	Pharmalicensing Intelligence	Reports	Comparision
In-licensing:	Latest records	Industry Sector	Therapeutic Target	Search	Profile your company	Pharma partnering
Out-licensing:	Latest records	Industry Sector	Therapeutic Target	Search	Profile your company	Pharma partnering
Companies:	Profiled companies	Industry Sector	Therapeutic Target	Geographic Location	Search	Add your company
Reports:	Biotechnology	Business Development	Management	Market & Sales	Medical Devices	Pharmaceuticals
News:	Deals & Alliances	Development	Financial Results	Financings	Intellectual Property	Regulatory
Events:	Pharma events	Calendar	Organizers	Featured events	Search
Articles:	Industrial Sector	Therapeutic Target	Articles date
Deals:	Industry Sector	Therapeutic Target	Deals Date	Search	Reports	Press releases
About us:	Our Audience	Case Studies	Newsletter	FAQ	Contact us	Site map

Products:

Partnering Search

Company Profiling

Pharmalicensing Intelligence

Intellectual Property

(website) 48 queries took 101 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `company`	27	27	2
2	DESCRIBE `condet`	17	17	1
3	DESCRIBE `countrycode`	4	4	1
4	DESCRIBE `person`	15	15	5
5	DESCRIBE `account`	29	29	2
6	DESCRIBE `product_legacy`	6	6	4
7	DESCRIBE `sales_people`	6	6	1
8	DESCRIBE `profile`	14	14	1
9	DESCRIBE `currencies`	7	7	1
10	DESCRIBE `update_rec`	7	7	1
11	DESCRIBE `user`	24	24	1
12	DESCRIBE `enquiry`	14	14	12
13	DESCRIBE `module_types`	6	6	1
14	DESCRIBE `dms_companies`	26	26	3
15	DESCRIBE `dms_releases`	10	10	5
16	DESCRIBE `dms_categories`	4	4	1
17	DESCRIBE `dms_clinical_areas`	4	4	1
18	DESCRIBE `dms_categories_dms_releases`	2	2	1
19	DESCRIBE `dms_clinical_areas_dms_releases`	2	2	3
20	DESCRIBE `dms_releases_sites`	5	5	2
21	DESCRIBE `licopp`	23	23	2
22	DESCRIBE `development_statuses`	5	5	2
23	DESCRIBE `category`	14	14	3
24	DESCRIBE `categories_sites`	5	5	1
25	DESCRIBE `categorisation`	8	8	2
26	DESCRIBE `licopps_sites`	3	3	1
27	DESCRIBE `service`	15	15	2
28	DESCRIBE `press_release`	13	13	3
29	DESCRIBE `press_releases_sites`	5	5	1
30	DESCRIBE `story`	12	12	1
31	DESCRIBE `sites_stories`	5	5	3
32	DESCRIBE `story_assoc`	4	4	2
33	DESCRIBE `companies_sites`	3	3	2
34	DESCRIBE `categories_users`	2	2	1
35	DESCRIBE `authority`	3	3	1
36	DESCRIBE `sites_users`	5	5	2
37	DESCRIBE `products`	8	8	5
38	DESCRIBE `sites`	5	5	1
39	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	1
40	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 ORDER BY `Category`.`name` ASC	11	11	1
41	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 (527, 505, 303, 432, 319, 798, 453, 514, 298, 805, 534) ORDER BY `name` ASC	111	111	1
42	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` = 616 ORDER BY `Category`.`name` ASC	28	28	1
43	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 (2050, 1793, 1794, 1795, 630, 1796, 619, 617, 626, 620, 1798, 1805, 621, 1799, 1800, 1801, 1802, 625, 627, 1803, 629, 623, 622, 1806, 624, 1808, 1809, 618) ORDER BY `name` ASC	0	0	1
44	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` = 1 ORDER BY `Category`.`name` ASC	8	8	6
45	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 (72, 46, 69, 212, 2, 119, 145, 244) ORDER BY `name` ASC	187	187	1
46	SELECT c.lft, c.rgt FROM category c WHERE c.uid = 616	1	1	4
47	SELECT c.uid, c.name, c.level FROM category c WHERE c.lft <= "3277" AND c.rgt >= "3334" AND c.level > 1 ORDER BY c.level	1	1	0
48	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` = 616 LIMIT 1	1	1	1

(website) 48 queries took 101 ms

Query

Error

Affected

Num. rows

Took (ms)

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 `licopp`

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 `products`

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 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 (527, 505, 303, 432, 319, 798, 453, 514, 298, 805, 534) ORDER BY `name` ASC

111

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 (2050, 1793, 1794, 1795, 630, 1796, 619, 617, 626, 620, 1798, 1805, 621, 1799, 1800, 1801, 1802, 625, 627, 1803, 629, 623, 622, 1806, 624, 1808, 1809, 618) ORDER BY `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 (72, 46, 69, 212, 2, 119, 145, 244) ORDER BY `name` ASC

187

SELECT c.lft, c.rgt FROM category c WHERE c.uid = 616

SELECT c.uid, c.name, c.level FROM category c WHERE c.lft <= "3277" AND c.rgt >= "3334" 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` = 616 LIMIT 1

(website_slave) 2 queries took 1214 ms
Nr	Query	Error	Affected	Num. rows	Took (ms)
1	SELECT `Company`.`uid`, `Company`.`slug`, `Company`.`name`, `Company`.`summary`, `Company`.`is_customer` FROM `company` AS `Company` INNER JOIN categorisation AS `CategorisationTherapeuticTarget` ON (`CategorisationTherapeuticTarget`.`company_id` = `Company`.`uid` AND `CategorisationTherapeuticTarget`.`cat_type` = 'C') INNER JOIN category AS `TherapeuticTarget` ON (`TherapeuticTarget`.`uid` = `CategorisationTherapeuticTarget`.`category_id` AND `TherapeuticTarget`.`lft` >= '3277' AND `TherapeuticTarget`.`rgt` <= '3334') LEFT JOIN `companies_sites` AS `CompanySite` ON (`CompanySite`.`company_id` = `Company`.`uid`) WHERE `CompanySite`.`site_id` = 1 AND ((`TherapeuticTarget`.`lft` >= 3277) AND (`TherapeuticTarget`.`rgt` <= 3334)) AND `Company`.`is_live` = 'Y' GROUP BY `Company`.`uid` ORDER BY `Company`.`is_customer` DESC, `Company`.`viewed_counter` DESC, `Company`.`name` ASC LIMIT 10		10	10	475
2	SELECT COUNT(DISTINCT Company.uid) AS `count` FROM `company` AS `Company` INNER JOIN categorisation AS `CategorisationTherapeuticTarget` ON (`CategorisationTherapeuticTarget`.`company_id` = `Company`.`uid` AND `CategorisationTherapeuticTarget`.`cat_type` = 'C') INNER JOIN category AS `TherapeuticTarget` ON (`TherapeuticTarget`.`uid` = `CategorisationTherapeuticTarget`.`category_id` AND `TherapeuticTarget`.`lft` >= '3277' AND `TherapeuticTarget`.`rgt` <= '3334') LEFT JOIN `companies_sites` AS `CompanySite` ON (`CompanySite`.`company_id` = `Company`.`uid`) WHERE `CompanySite`.`site_id` = 1 AND ((`TherapeuticTarget`.`lft` >= 3277) AND (`TherapeuticTarget`.`rgt` <= 3334)) AND `Company`.`is_live` = 'Y'		1	1	739

(website_slave) 2 queries took 1214 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT `Company`.`uid`, `Company`.`slug`, `Company`.`name`, `Company`.`summary`, `Company`.`is_customer` FROM `company` AS `Company` INNER JOIN categorisation AS `CategorisationTherapeuticTarget` ON (`CategorisationTherapeuticTarget`.`company_id` = `Company`.`uid` AND `CategorisationTherapeuticTarget`.`cat_type` = 'C') INNER JOIN category AS `TherapeuticTarget` ON (`TherapeuticTarget`.`uid` = `CategorisationTherapeuticTarget`.`category_id` AND `TherapeuticTarget`.`lft` >= '3277' AND `TherapeuticTarget`.`rgt` <= '3334') LEFT JOIN `companies_sites` AS `CompanySite` ON (`CompanySite`.`company_id` = `Company`.`uid`) WHERE `CompanySite`.`site_id` = 1 AND ((`TherapeuticTarget`.`lft` >= 3277) AND (`TherapeuticTarget`.`rgt` <= 3334)) AND `Company`.`is_live` = 'Y' GROUP BY `Company`.`uid` ORDER BY `Company`.`is_customer` DESC, `Company`.`viewed_counter` DESC, `Company`.`name` ASC LIMIT 10

475

SELECT COUNT(DISTINCT Company.uid) AS `count` FROM `company` AS `Company` INNER JOIN categorisation AS `CategorisationTherapeuticTarget` ON (`CategorisationTherapeuticTarget`.`company_id` = `Company`.`uid` AND `CategorisationTherapeuticTarget`.`cat_type` = 'C') INNER JOIN category AS `TherapeuticTarget` ON (`TherapeuticTarget`.`uid` = `CategorisationTherapeuticTarget`.`category_id` AND `TherapeuticTarget`.`lft` >= '3277' AND `TherapeuticTarget`.`rgt` <= '3334') LEFT JOIN `companies_sites` AS `CompanySite` ON (`CompanySite`.`company_id` = `Company`.`uid`) WHERE `CompanySite`.`site_id` = 1 AND ((`TherapeuticTarget`.`lft` >= 3277) AND (`TherapeuticTarget`.`rgt` <= 3334)) AND `Company`.`is_live` = 'Y'

739

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

(report_slave) 1 query took 3 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 ("Gastrointestinal") ORDER BY MATCH (`MarketResearchReport`.`name`, `MarketResearchReport`.`description`, `MarketResearchReport`.`summary`, `MarketResearchReport`.`content`, `MarketResearchReport`.`isbn`, `MarketResearchReport`.`code`) AGAINST ("Gastrointestinal") DESC , MarketResearchReport.published DESC LIMIT 10