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

Articles

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

Articles

Displaying 1..5 of 5 - per page
Order by
Bile has had a very bad press over the years More
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
An innovative approach using evidence-based medicine to provide a systemic appraisal of research findings to facilitate clinical decision making. More
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 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

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

(website) 47 queries took 705 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `feature_article`13132
2DESCRIBE `feature_author`13131
3DESCRIBE `user`24242
4DESCRIBE `condet`171710
5DESCRIBE `countrycode`444
6DESCRIBE `company`27272
7DESCRIBE `person`15156
8DESCRIBE `account`29293
9DESCRIBE `product_legacy`662
10DESCRIBE `sales_people`662
11DESCRIBE `profile`14142
12DESCRIBE `currencies`778
13DESCRIBE `update_rec`771
14DESCRIBE `dms_companies`26263
15DESCRIBE `dms_releases`10106
16DESCRIBE `dms_categories`441
17DESCRIBE `dms_clinical_areas`441
18DESCRIBE `dms_categories_dms_releases`224
19DESCRIBE `dms_clinical_areas_dms_releases`221
20DESCRIBE `dms_releases_sites`5510
21DESCRIBE `licopp`23233
22DESCRIBE `development_statuses`554
23DESCRIBE `category`14142
24DESCRIBE `categories_sites`5515
25DESCRIBE `categorisation`882
26DESCRIBE `licopps_sites`337
27DESCRIBE `service`15154
28DESCRIBE `enquiry`14145
29DESCRIBE `module_types`665
30DESCRIBE `press_release`13131
31DESCRIBE `press_releases_sites`5510
32DESCRIBE `story`12122
33DESCRIBE `sites_stories`557
34DESCRIBE `story_assoc`446
35DESCRIBE `companies_sites`332
36DESCRIBE `categories_users`221
37DESCRIBE `authority`331
38DESCRIBE `sites_users`5515
39DESCRIBE `sites`551
40SELECT `Site`.`id`, `Site`.`name`, `Site`.`email_domain`, `Site`.`short_name`, `Site`.`brand` FROM `sites` AS `Site` WHERE `Site`.`id` = 1 LIMIT 11115
41SELECT c.uid, c.name FROM category c WHERE c.parent = 297 ORDER BY c.name 11111
42SELECT c.uid, c.name FROM category c WHERE c.parent = 616 ORDER BY c.name 28280
43SELECT 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 13130
44SELECT c.lft, c.rgt FROM category c WHERE c.uid = 616110
45SELECT 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 110
46SELECT 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 55275
47SELECT 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 11250
(default) 0 query took ms
NrQueryErrorAffectedNum. rowsTook (ms)
(report) 1 query took 1 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `reports`17171
(report_slave) 1 query took 1 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 ("Gastrointestinal") ORDER BY MATCH (`MarketResearchReport`.`name`, `MarketResearchReport`.`description`, `MarketResearchReport`.`summary`, `MarketResearchReport`.`content`, `MarketResearchReport`.`isbn`, `MarketResearchReport`.`code`) AGAINST ("Gastrointestinal") DESC , MarketResearchReport.published DESC LIMIT 1010101