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

Articles

Innovaro Pharmalicensing brings you advice, commentary and analysis from industry experts.

Articles
Browse

Articles

Displaying 1..5 of 5 - per page
Order by

A tour around bile

Bile has had a very bad press over the years More

A Tour around the Pancreas

Many people are unfamiliar with the position and function of the pancreas beyond knowing that "it has something to do with diabetes, doesn't it?" In fact, this organ plays important roles in both digestion and homeostasis. More

Evidence-Based Analyses Demonstrate Benefits of New Proton Pump Inhibitor

An innovative approach using evidence-based medicine to provide a systemic appraisal of research findings to facilitate clinical decision making. More

A Tour around Constipation

Most people experience constipation at one time or another, with estimates as high as 10% of the adult population at any one time. More

A Tour around Coeliac Disease

A look at some of the internet resources available concerning Coeliac Disease, a chronic inflammatory disorder of the lining of the small intestine resulting from ingestion of the protein gluten. More

Displaying 1..5 of 5 - per 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
Year: 2011; 2010; 2009; 2008; 2007; 2006; 2005; 2004; 2003; 2002; 2001; 2000; 1999

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) 47 queries took 227 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `feature_article`	13	13	3
2	DESCRIBE `feature_author`	13	13	1
3	DESCRIBE `user`	24	24	7
4	DESCRIBE `condet`	17	17	1
5	DESCRIBE `countrycode`	4	4	1
6	DESCRIBE `company`	27	27	1
7	DESCRIBE `person`	15	15	3
8	DESCRIBE `account`	29	29	7
9	DESCRIBE `product_legacy`	6	6	8
10	DESCRIBE `sales_people`	6	6	1
11	DESCRIBE `profile`	14	14	1
12	DESCRIBE `currencies`	7	7	7
13	DESCRIBE `update_rec`	7	7	2
14	DESCRIBE `dms_companies`	26	26	2
15	DESCRIBE `dms_releases`	10	10	2
16	DESCRIBE `dms_categories`	4	4	12
17	DESCRIBE `dms_clinical_areas`	4	4	1
18	DESCRIBE `dms_categories_dms_releases`	2	2	0
19	DESCRIBE `dms_clinical_areas_dms_releases`	2	2	0
20	DESCRIBE `dms_releases_sites`	5	5	1
21	DESCRIBE `licopp`	23	23	2
22	DESCRIBE `development_statuses`	5	5	3
23	DESCRIBE `category`	14	14	1
24	DESCRIBE `categories_sites`	5	5	1
25	DESCRIBE `categorisation`	8	8	9
26	DESCRIBE `licopps_sites`	3	3	1
27	DESCRIBE `service`	15	15	1
28	DESCRIBE `enquiry`	14	14	1
29	DESCRIBE `module_types`	6	6	1
30	DESCRIBE `press_release`	13	13	1
31	DESCRIBE `press_releases_sites`	5	5	1
32	DESCRIBE `story`	12	12	2
33	DESCRIBE `sites_stories`	5	5	1
34	DESCRIBE `story_assoc`	4	4	1
35	DESCRIBE `companies_sites`	3	3	1
36	DESCRIBE `categories_users`	2	2	1
37	DESCRIBE `authority`	3	3	1
38	DESCRIBE `sites_users`	5	5	1
39	DESCRIBE `sites`	5	5	2
40	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
41	SELECT c.uid, c.name FROM category c WHERE c.parent = 297 ORDER BY c.name	11	11	1
42	SELECT c.uid, c.name FROM category c WHERE c.parent = 616 ORDER BY c.name	28	28	1
43	SELECT DISTINCT SUBSTRING(issued, 1, 4) AS publication_year FROM feature_article AS Article WHERE is_live = 1 AND issued IS NOT NULL ORDER BY publication_year DESC	13	13	1
44	SELECT c.lft, c.rgt FROM category c WHERE c.uid = 616	1	1	1
45	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
46	SELECT feature_article.uid, feature_article.headline, feature_article.summary, feature_article.slug FROM feature_article INNER JOIN categorisation tt_ctg ON tt_ctg.story_id = feature_article.uid AND tt_ctg.cat_type = "F" AND tt_ctg.category_id IN (SELECT uid FROM category WHERE (lft >= 3277 AND rgt <= 3334) ) WHERE feature_article.is_live > 0 GROUP BY feature_article.uid ORDER BY feature_article.viewed_counter DESC, feature_article.headline LIMIT 0, 10	5	5	100
47	SELECT count(DISTINCT feature_article.uid) AS total FROM feature_article INNER JOIN categorisation tt_ctg ON tt_ctg.story_id = feature_article.uid AND tt_ctg.cat_type = "F" AND tt_ctg.category_id IN (SELECT uid FROM category WHERE (lft >= 3277 AND rgt <= 3334) ) WHERE feature_article.is_live > 0	1	1	29

(website) 47 queries took 227 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `feature_article`

DESCRIBE `feature_author`

DESCRIBE `user`

DESCRIBE `condet`

DESCRIBE `countrycode`

DESCRIBE `company`

DESCRIBE `person`

DESCRIBE `account`

DESCRIBE `product_legacy`

DESCRIBE `sales_people`

DESCRIBE `profile`

DESCRIBE `currencies`

DESCRIBE `update_rec`

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

DESCRIBE `module_types`

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 c.uid, c.name FROM category c WHERE c.parent = 297 ORDER BY c.name

SELECT c.uid, c.name FROM category c WHERE c.parent = 616 ORDER BY c.name

SELECT DISTINCT SUBSTRING(issued, 1, 4) AS publication_year FROM feature_article AS Article WHERE is_live = 1 AND issued IS NOT NULL ORDER BY publication_year DESC

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 feature_article.uid, feature_article.headline, feature_article.summary, feature_article.slug FROM feature_article INNER JOIN categorisation tt_ctg ON tt_ctg.story_id = feature_article.uid AND tt_ctg.cat_type = "F" AND tt_ctg.category_id IN (SELECT uid FROM category WHERE (lft >= 3277 AND rgt <= 3334) ) WHERE feature_article.is_live > 0 GROUP BY feature_article.uid ORDER BY feature_article.viewed_counter DESC, feature_article.headline LIMIT 0, 10

100

SELECT count(DISTINCT feature_article.uid) AS total FROM feature_article INNER JOIN categorisation tt_ctg ON tt_ctg.story_id = feature_article.uid AND tt_ctg.cat_type = "F" AND tt_ctg.category_id IN (SELECT uid FROM category WHERE (lft >= 3277 AND rgt <= 3334) ) WHERE feature_article.is_live > 0

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