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

Press releases

Stay current with the latest press releases from within the industry.

Press releases
GfK Bridgehead
Bridgehead International...

Bridgehead International Appoints Expert in Global Pricing and Market Access for Oncology Products

Release issued 20th October 2011

Melton Mowbray 17 October 2011 ......Bridgehead International is pleased to announce the appointment of Chris Teale as Principal Consultant.

Chris joins Bridgehead from AstraZeneca, where he was Director of Global Pricing and Market Access (Oncology) and brings with him extensive practical and academic experience within the pharmaceutical industry, across both Marketing and R&D. He has held a number of leadership positions at both a Global and European level, having previously been Director Health Economics, Pricing and Reimbursement and Access at Allergan and Portfolio Planning Manager at Ciba-Geigy in Switzerland.

In his market access roles, Chris has developed global pricing strategies for a wide range of products and therapy areas including personalised healthcare products and orphan drugs. He led the "Innovate for Access" programme at AstraZeneca which identified creative and innovative approaches to overcoming market access hurdles.

Chris has a BSc in Mathematics from Newcastle University, and has studied at Loughborough University (Management Information Systems) and INSEAD Business School (Marketing for International Business). He is also an occasional lecturer on health economics / pricing and reimbursement on the TOPRA / University of Wales MSc course.

Bridgehead International CEO, Timothy Fitzgerald commented; "Pricing, reimbursement and market access represents perhaps the greatest area of challenge for the pharmaceutical, device and diagnostics sectors". "Chris's experience and expertise will be invaluable to our clients as they seek to develop strategies which are up to the challenge".

Notes to editors:

About Bridgehead International Ltd

Bridgehead is a leading strategic healthcare consultancy group, providing a range of services designed to assist clients in achieving extraordinary growth across the product and technology value chain.

Bridgehead's mission is to work with commercial organisations, government agencies and the investment community to ensure that:
•· Companies have the funding, structure and strategic focus to deliver high levels of innovation and financial return
•· Patients have rapid and broad access to new innovative medicines, medical devices and diagnostic tools, particularly in areas of high unmet need.

With over 50 consultants and 60 associates in Europe, North America and Asia, Bridgehead provides a powerful combination of strategic, scientific, medical, technical, commercial, economic, decision support, modelling and intellectual property skills and experience.

Bridgehead is globally recognised for its expertise in:
•·         Market access strategy
•·         Pricing and reimbursement strategy
•·         Health economics and health technology assessment
•·         Opportunity evaluation
•·         Transaction support.

In 2007 and 2011, Bridgehead was honoured with The Queen's Award for Enterprise, for outstanding achievement in international trade. The Queen's Award for Enterprise is the highest honour that can be bestowed upon a UK company and is the UK's top award for business performance.

In 2009, Bridgehead was voted UK Strategic Advisor of the Year - Healthcare, in the ACQ Finance Magazine's Global Awards.

For more information about Bridgehead International, please see http://www.bridgehead.com
Contacts at Bridgehead International:

Wendy Daunt, Marketing Executive
Tel: +44 (0) 1664 503 719
Email: wendy.daunt@bridgehead.com

Timothy A J Fitzgerald, CEO
Tel: +44 (0)1664 503 700
Email: timothy.fitzgerald@bridgehead.com

Company details

If you want to find out more about the company visit GfK Bridgehead profile.

Latest GfK Bridgehead press releases

(20th October 2011) Bridgehead International announces publication by The Personalized Medicine Coalition (PMC) of a white paper entitled “Advancing Access to Personalized Medicine: A Comparative Assessment

(13th September 2011) Bridgehead International Appoints Marcus Deans as Principal Consultant

(1st August 2011) Bridgehead International Announces US West Coast Expansion

(14th June 2011) Bridgehead International appoints Nigel Seear as Vice President, Europe

(21st April 2011) Bridgehead International wins The Queen’s Award for Enterprise 2011

Related reports

Market Research Reports provided by reports.innovaro.com

US Oncology, Inc.: SWOT Analysis & Company Profile

Dec 2010 - 19 pages - $99

US Oncology, Inc. – Developmental Therapeutics Review – Q4 2010

Nov 2010 - 40 pages - $500

Southwest Oncology Group – Developmental Therapeutics Review – Q4 2010

Nov 2010 - 40 pages - $500

Children's Oncology Group – Developmental Therapeutics Review – Q4 2010

Nov 2010 - 40 pages - $500

Gynecologic Oncology Group – Developmental Therapeutics Review – Q4 2010

Nov 2010 - 40 pages - $500

Hellenic Oncology Research Group – Developmental Therapeutics Review – Q4 2010

Nov 2010 - 40 pages - $500

Radiation Therapy Oncology Group – Developmental Therapeutics Review – Q4 2010

Nov 2010 - 40 pages - $500

Japan Clinical Oncology Group – Developmental Therapeutics Review – Q4 2010

Nov 2010 - 40 pages - $500

Eastern Cooperative Oncology Group – Developmental Therapeutics Review – Q4 2010

Nov 2010 - 40 pages - $500

Accelerated Community Oncology Research Network, Inc. – Developmental Therapeutics Review – Q4 2010

Nov 2010 - 40 pages - $500

More Press Releases

Latest

Frost & Sullivan Award Highlights CIS Pharma’s Technology Innovation in Polymer Industry -- Award Recipient Recognised for its Innovative and Unique Cellophil

Innocoll Provides Update of Regulatory and Partnering Activities for CollaGUARD® Adhesion Barrier and Launches New Product Website

Development of Butyrylcholinesterase-targeted Radiopharmaceuticals for the Treatment of Cancer

19 March 2012 Cerca Insights Opens New Behavioural Pharmacology Laboratory in Penang, Malaysia

Alcon gains exclusive ex-US rights for ocriplasmin, potential first pharmacological treatment for symptomatic vitreomacular adhesion

Most viewed

euroPLX Introduces Tool to Overcome Reject vs. Accept Dilemma in Partnering

Discovery and validation of 13 diabetes biomarkers to be commercialized

Genesis Conference on target to exceed all previous years

Two papers on Neo-Penotran® Forte and Neo-Penotran® Forte-L have been accepted for presentation at the 4'th World Conference on Vaginitis, Costa Rica, 10-13 Jan 2004

TDS® TESTOSTERONE EXCEEDS ANDROGEL® OUTCOMES

Related categories

Industry sector

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) 58 queries took 176 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `press_release`	13	13	1
2	DESCRIBE `company`	27	27	1
3	DESCRIBE `condet`	17	17	1
4	DESCRIBE `countrycode`	4	4	1
5	DESCRIBE `person`	15	15	1
6	DESCRIBE `account`	29	29	1
7	DESCRIBE `product_legacy`	6	6	1
8	DESCRIBE `sales_people`	6	6	1
9	DESCRIBE `profile`	14	14	1
10	DESCRIBE `currencies`	7	7	1
11	DESCRIBE `update_rec`	7	7	1
12	DESCRIBE `user`	24	24	1
13	DESCRIBE `enquiry`	14	14	1
14	DESCRIBE `module_types`	6	6	1
15	DESCRIBE `dms_companies`	26	26	1
16	DESCRIBE `dms_releases`	10	10	1
17	DESCRIBE `dms_categories`	4	4	1
18	DESCRIBE `dms_clinical_areas`	4	4	1
19	DESCRIBE `dms_categories_dms_releases`	2	2	0
20	DESCRIBE `dms_clinical_areas_dms_releases`	2	2	0
21	DESCRIBE `dms_releases_sites`	5	5	1
22	DESCRIBE `licopp`	23	23	1
23	DESCRIBE `development_statuses`	5	5	1
24	DESCRIBE `category`	14	14	1
25	DESCRIBE `categories_sites`	5	5	1
26	DESCRIBE `categorisation`	8	8	1
27	DESCRIBE `licopps_sites`	3	3	0
28	DESCRIBE `service`	15	15	1
29	DESCRIBE `story`	12	12	1
30	DESCRIBE `sites_stories`	5	5	0
31	DESCRIBE `story_assoc`	4	4	0
32	DESCRIBE `companies_sites`	3	3	0
33	DESCRIBE `categories_users`	2	2	1
34	DESCRIBE `authority`	3	3	0
35	DESCRIBE `sites_users`	5	5	0
36	DESCRIBE `press_releases_sites`	5	5	0
37	DESCRIBE `sites`	5	5	0
38	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	0
39	SELECT `Press`.`uid`, `Press`.`slug`, `Press`.`company_id`, `Press`.`created`, `Press`.`lastmod`, `Press`.`issued`, `Press`.`headline`, `Press`.`summary`, `Press`.`body`, `Press`.`is_live`, `Press`.`is_attachment`, `Press`.`user_id`, `Press`.`viewed_counter`, `Company`.`uid`, `Company`.`slug`, `Company`.`name`, `Company`.`condet_id`, `Company`.`person_id`, `Company`.`billing_id`, `Company`.`parent`, `Company`.`has_children`, `Company`.`notes_id`, `Company`.`contact_status`, `Company`.`last_contacted`, `Company`.`profile_id`, `Company`.`account_id`, `Company`.`summary`, `Company`.`is_customer`, `Company`.`change_time`, `Company`.`flags`, `Company`.`is_anon`, `Company`.`is_resource`, `Company`.`satellite`, `Company`.`no_dms`, `Company`.`is_live`, `Company`.`viewed_counter`, `Company`.`created`, `Company`.`last_disabled`, `Company`.`no_trial`, `Company`.`trial_notification_sent`, `User`.`uid`, `User`.`email`, `User`.`name`, `User`.`password`, `User`.`lastlogin`, `User`.`currency`, `User`.`person`, `User`.`customer`, `User`.`operator`, `User`.`company`, `User`.`wantsmail`, `User`.`passwordclue`, `User`.`alias`, `User`.`username`, `User`.`person_id`, `User`.`condet_id`, `User`.`company_id`, `User`.`signup_date`, `User`.`alert_inlic`, `User`.`alert_outlic`, `User`.`alert_company`, `User`.`alert_events`, `User`.`alert_lasttime`, `User`.`stats_access`, `PressSite`.`id`, `PressSite`.`created`, `PressSite`.`modified`, `PressSite`.`press_release_id`, `PressSite`.`site_id` FROM `press_release` AS `Press` LEFT JOIN `company` AS `Company` ON (`Press`.`company_id` = `Company`.`uid`) LEFT JOIN `user` AS `User` ON (`Press`.`user_id` = `User`.`uid`) LEFT JOIN `press_releases_sites` AS `PressSite` ON (`PressSite`.`press_release_id` = `Press`.`uid`) WHERE `PressSite`.`site_id` = 1 AND `Press`.`uid` = '1319100585_4e9fe0a90f9db' LIMIT 1	1	1	8
40	SELECT `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`.`story_id` = '1319100585_4e9fe0a90f9db' AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="R" ORDER BY `Category`.`root` ASC, `Category`.`clan` ASC, `Category`.`parent` ASC, `Category`.`name` ASC	9	9	2
41	SELECT `Press`.`uid`, `Press`.`slug`, `Press`.`headline`, `Press`.`body`, `Press`.`issued` FROM `press_release` AS `Press` LEFT JOIN `company` AS `Company` ON (`Press`.`company_id` = `Company`.`uid`) LEFT JOIN `user` AS `User` ON (`Press`.`user_id` = `User`.`uid`) LEFT JOIN `press_releases_sites` AS `PressSite` ON (`PressSite`.`press_release_id` = `Press`.`uid`) WHERE `PressSite`.`site_id` = 1 AND `Press`.`company_id`='4555' AND `Press`.`is_live`=1 AND DATE(`Press`.`issued`) <= DATE(now()) AND `Press`.`uid` != "1319100585_4e9fe0a90f9db" ORDER BY `issued` DESC LIMIT 5	5	5	43
42	SELECT `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`.`story_id` IN ('1319100933_4e9fe205aecc4', '1315909545_4e6f2fa949b02', '1312190342_4e366f8698fb4', '1308065056_4df77d200a16b', '1303377151_4daff4ff8c962') AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="R" ORDER BY `Category`.`root` ASC, `Category`.`clan` ASC, `Category`.`parent` ASC, `Category`.`name` ASC	45	45	2
43	SELECT Press.uid, Press.slug, Press.issued, Press.headline, Press.summary FROM press_release AS Press WHERE Press.is_live = 1 AND Press.issued <= now() GROUP BY Press.uid ORDER BY Press.issued DESC LIMIT 5	5	5	0
44	SELECT `Press`.`uid`, `Press`.`issued`, `Press`.`headline`, `Press`.`slug` FROM `press_release` AS `Press` LEFT JOIN `company` AS `Company` ON (`Press`.`company_id` = `Company`.`uid`) LEFT JOIN `user` AS `User` ON (`Press`.`user_id` = `User`.`uid`) LEFT JOIN `press_releases_sites` AS `PressSite` ON (`PressSite`.`press_release_id` = `Press`.`uid`) WHERE `PressSite`.`site_id` = 1 AND `Press`.`is_live` = 1 AND DATE(`Press`.`issued`) <= DATE(now()) ORDER BY `Press`.`viewed_counter` DESC, `Press`.`issued` DESC LIMIT 5	5	5	63
45	SELECT Category.uid, Category.parent, Category.root, Category.name, Category.level, Category.lft, CASE Category.root WHEN '560' THEN 0 WHEN '297' THEN 1 ELSE CASE Category.uid WHEN '560' THEN 0 WHEN '297' THEN 1 ELSE NULL END END AS root_order FROM category AS RootCategory LEFT JOIN categorisation AS Categorisation ON Categorisation.category_id=RootCategory.uid AND Categorisation.story_id='1319100585_4e9fe0a90f9db' AND Categorisation.cat_type='R' LEFT JOIN category AS Category ON (Category.lft <= RootCategory.lft AND Category.rgt >= RootCategory.rgt AND Category.level > 0) WHERE Categorisation.id IS NOT NULL AND RootCategory.root IN (560, 297) GROUP BY Category.uid ORDER BY root_order,lft	6	6	7
46	SELECT `Press`.`uid`, `Press`.`company_id`, `Press`.`viewed_counter` FROM `press_release` AS `Press` LEFT JOIN `company` AS `Company` ON (`Press`.`company_id` = `Company`.`uid`) LEFT JOIN `user` AS `User` ON (`Press`.`user_id` = `User`.`uid`) LEFT JOIN `press_releases_sites` AS `PressSite` ON (`PressSite`.`press_release_id` = `Press`.`uid`) WHERE `PressSite`.`site_id` = 1 AND `Press`.`uid`="1319100585_4e9fe0a90f9db" AND `Press`.`is_live`>0 LIMIT 1	1	1	4
47	SELECT `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`.`story_id` = '1319100585_4e9fe0a90f9db' AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="R" ORDER BY `Category`.`root` ASC, `Category`.`clan` ASC, `Category`.`parent` ASC, `Category`.`name` ASC	9	9	0
48	SELECT COUNT(*) AS `count` FROM `press_release` AS `Press` WHERE `Press`.`uid` = '1319100585_4e9fe0a90f9db'	1	1	0
49	SELECT COUNT(*) AS `count` FROM `press_release` AS `Press` WHERE `Press`.`uid` = '1319100585_4e9fe0a90f9db'	1	1	0
50	UPDATE `press_release` SET `viewed_counter` = 453 WHERE `press_release`.`uid` = '1319100585_4e9fe0a90f9db'	1		6
51	SELECT `Press`.`uid` FROM `press_release` AS `Press` LEFT JOIN `company` AS `Company` ON (`Press`.`company_id` = `Company`.`uid`) LEFT JOIN `user` AS `User` ON (`Press`.`user_id` = `User`.`uid`) LEFT JOIN `press_releases_sites` AS `PressSite` ON (`PressSite`.`press_release_id` = `Press`.`uid`) WHERE `PressSite`.`site_id` = 1 AND `Press`.`uid` = '1319100585_4e9fe0a90f9db' LIMIT 1	1	1	3
52	SELECT `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`.`story_id` = '1319100585_4e9fe0a90f9db' AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="R" ORDER BY `Category`.`root` ASC, `Category`.`clan` ASC, `Category`.`parent` ASC, `Category`.`name` ASC	9	9	0
53	SELECT `PressSite`.`id`, `PressSite`.`created`, `PressSite`.`modified`, `PressSite`.`press_release_id`, `PressSite`.`site_id` FROM `press_releases_sites` AS `PressSite` WHERE `site_id` = 1 AND `press_release_id` = '1319100585_4e9fe0a90f9db'	1	1	0
54	DESCRIBE `statistics`	7	7	1
55	SELECT `ModuleType`.`id`, `ModuleType`.`handle`, `ModuleType`.`name`, `ModuleType`.`description`, `ModuleType`.`created`, `ModuleType`.`modified` FROM `module_types` AS `ModuleType` WHERE `ModuleType`.`handle` = 'press' LIMIT 1	1	1	0
56	SELECT `Statistic`.`id`, `Statistic`.`module_type_id`, `Statistic`.`company_id`, `Statistic`.`business_object_id`, `Statistic`.`count`, `Statistic`.`hit_date`, `Statistic`.`is_aggregated`, `ModuleType`.`id`, `ModuleType`.`handle`, `ModuleType`.`name`, `ModuleType`.`description`, `ModuleType`.`created`, `ModuleType`.`modified` FROM `statistics` AS `Statistic` LEFT JOIN `module_types` AS `ModuleType` ON (`Statistic`.`module_type_id` = `ModuleType`.`id`) WHERE `business_object_id` = '1319100585_4e9fe0a90f9db' AND `company_id` = 4555 AND `module_type_id` = '9' AND `hit_date` = '2012-05-24' LIMIT 1	0	0	10
57	INSERT INTO `statistics` (`is_aggregated`, `count`, `company_id`, `business_object_id`, `module_type_id`, `hit_date`) VALUES (0, 1, 4555, '1319100585_4e9fe0a90f9db', '9', '2012-05-24')	1		0
58	SELECT LAST_INSERT_ID() AS insertID	1	1	0

(website) 58 queries took 176 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `press_release`

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

DESCRIBE `sites_stories`

DESCRIBE `story_assoc`

DESCRIBE `companies_sites`

DESCRIBE `categories_users`

DESCRIBE `authority`

DESCRIBE `sites_users`

DESCRIBE `press_releases_sites`

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 `Press`.`uid`, `Press`.`slug`, `Press`.`company_id`, `Press`.`created`, `Press`.`lastmod`, `Press`.`issued`, `Press`.`headline`, `Press`.`summary`, `Press`.`body`, `Press`.`is_live`, `Press`.`is_attachment`, `Press`.`user_id`, `Press`.`viewed_counter`, `Company`.`uid`, `Company`.`slug`, `Company`.`name`, `Company`.`condet_id`, `Company`.`person_id`, `Company`.`billing_id`, `Company`.`parent`, `Company`.`has_children`, `Company`.`notes_id`, `Company`.`contact_status`, `Company`.`last_contacted`, `Company`.`profile_id`, `Company`.`account_id`, `Company`.`summary`, `Company`.`is_customer`, `Company`.`change_time`, `Company`.`flags`, `Company`.`is_anon`, `Company`.`is_resource`, `Company`.`satellite`, `Company`.`no_dms`, `Company`.`is_live`, `Company`.`viewed_counter`, `Company`.`created`, `Company`.`last_disabled`, `Company`.`no_trial`, `Company`.`trial_notification_sent`, `User`.`uid`, `User`.`email`, `User`.`name`, `User`.`password`, `User`.`lastlogin`, `User`.`currency`, `User`.`person`, `User`.`customer`, `User`.`operator`, `User`.`company`, `User`.`wantsmail`, `User`.`passwordclue`, `User`.`alias`, `User`.`username`, `User`.`person_id`, `User`.`condet_id`, `User`.`company_id`, `User`.`signup_date`, `User`.`alert_inlic`, `User`.`alert_outlic`, `User`.`alert_company`, `User`.`alert_events`, `User`.`alert_lasttime`, `User`.`stats_access`, `PressSite`.`id`, `PressSite`.`created`, `PressSite`.`modified`, `PressSite`.`press_release_id`, `PressSite`.`site_id` FROM `press_release` AS `Press` LEFT JOIN `company` AS `Company` ON (`Press`.`company_id` = `Company`.`uid`) LEFT JOIN `user` AS `User` ON (`Press`.`user_id` = `User`.`uid`) LEFT JOIN `press_releases_sites` AS `PressSite` ON (`PressSite`.`press_release_id` = `Press`.`uid`) WHERE `PressSite`.`site_id` = 1 AND `Press`.`uid` = '1319100585_4e9fe0a90f9db' LIMIT 1

SELECT `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`.`story_id` = '1319100585_4e9fe0a90f9db' AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="R" ORDER BY `Category`.`root` ASC, `Category`.`clan` ASC, `Category`.`parent` ASC, `Category`.`name` ASC

SELECT `Press`.`uid`, `Press`.`slug`, `Press`.`headline`, `Press`.`body`, `Press`.`issued` FROM `press_release` AS `Press` LEFT JOIN `company` AS `Company` ON (`Press`.`company_id` = `Company`.`uid`) LEFT JOIN `user` AS `User` ON (`Press`.`user_id` = `User`.`uid`) LEFT JOIN `press_releases_sites` AS `PressSite` ON (`PressSite`.`press_release_id` = `Press`.`uid`) WHERE `PressSite`.`site_id` = 1 AND `Press`.`company_id`='4555' AND `Press`.`is_live`=1 AND DATE(`Press`.`issued`) <= DATE(now()) AND `Press`.`uid` != "1319100585_4e9fe0a90f9db" ORDER BY `issued` DESC LIMIT 5

SELECT `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`.`story_id` IN ('1319100933_4e9fe205aecc4', '1315909545_4e6f2fa949b02', '1312190342_4e366f8698fb4', '1308065056_4df77d200a16b', '1303377151_4daff4ff8c962') AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="R" ORDER BY `Category`.`root` ASC, `Category`.`clan` ASC, `Category`.`parent` ASC, `Category`.`name` ASC

SELECT Press.uid, Press.slug, Press.issued, Press.headline, Press.summary FROM press_release AS Press WHERE Press.is_live = 1 AND Press.issued <= now() GROUP BY Press.uid ORDER BY Press.issued DESC LIMIT 5

SELECT `Press`.`uid`, `Press`.`issued`, `Press`.`headline`, `Press`.`slug` FROM `press_release` AS `Press` LEFT JOIN `company` AS `Company` ON (`Press`.`company_id` = `Company`.`uid`) LEFT JOIN `user` AS `User` ON (`Press`.`user_id` = `User`.`uid`) LEFT JOIN `press_releases_sites` AS `PressSite` ON (`PressSite`.`press_release_id` = `Press`.`uid`) WHERE `PressSite`.`site_id` = 1 AND `Press`.`is_live` = 1 AND DATE(`Press`.`issued`) <= DATE(now()) ORDER BY `Press`.`viewed_counter` DESC, `Press`.`issued` DESC LIMIT 5

SELECT Category.uid, Category.parent, Category.root, Category.name, Category.level, Category.lft, CASE Category.root WHEN '560' THEN 0 WHEN '297' THEN 1 ELSE CASE Category.uid WHEN '560' THEN 0 WHEN '297' THEN 1 ELSE NULL END END AS root_order FROM category AS RootCategory LEFT JOIN categorisation AS Categorisation ON Categorisation.category_id=RootCategory.uid AND Categorisation.story_id='1319100585_4e9fe0a90f9db' AND Categorisation.cat_type='R' LEFT JOIN category AS Category ON (Category.lft <= RootCategory.lft AND Category.rgt >= RootCategory.rgt AND Category.level > 0) WHERE Categorisation.id IS NOT NULL AND RootCategory.root IN (560, 297) GROUP BY Category.uid ORDER BY root_order,lft

SELECT `Press`.`uid`, `Press`.`company_id`, `Press`.`viewed_counter` FROM `press_release` AS `Press` LEFT JOIN `company` AS `Company` ON (`Press`.`company_id` = `Company`.`uid`) LEFT JOIN `user` AS `User` ON (`Press`.`user_id` = `User`.`uid`) LEFT JOIN `press_releases_sites` AS `PressSite` ON (`PressSite`.`press_release_id` = `Press`.`uid`) WHERE `PressSite`.`site_id` = 1 AND `Press`.`uid`="1319100585_4e9fe0a90f9db" AND `Press`.`is_live`>0 LIMIT 1

SELECT COUNT(*) AS `count` FROM `press_release` AS `Press` WHERE `Press`.`uid` = '1319100585_4e9fe0a90f9db'

UPDATE `press_release` SET `viewed_counter` = 453 WHERE `press_release`.`uid` = '1319100585_4e9fe0a90f9db'

SELECT `Press`.`uid` FROM `press_release` AS `Press` LEFT JOIN `company` AS `Company` ON (`Press`.`company_id` = `Company`.`uid`) LEFT JOIN `user` AS `User` ON (`Press`.`user_id` = `User`.`uid`) LEFT JOIN `press_releases_sites` AS `PressSite` ON (`PressSite`.`press_release_id` = `Press`.`uid`) WHERE `PressSite`.`site_id` = 1 AND `Press`.`uid` = '1319100585_4e9fe0a90f9db' LIMIT 1

SELECT `PressSite`.`id`, `PressSite`.`created`, `PressSite`.`modified`, `PressSite`.`press_release_id`, `PressSite`.`site_id` FROM `press_releases_sites` AS `PressSite` WHERE `site_id` = 1 AND `press_release_id` = '1319100585_4e9fe0a90f9db'

DESCRIBE `statistics`

SELECT `ModuleType`.`id`, `ModuleType`.`handle`, `ModuleType`.`name`, `ModuleType`.`description`, `ModuleType`.`created`, `ModuleType`.`modified` FROM `module_types` AS `ModuleType` WHERE `ModuleType`.`handle` = 'press' LIMIT 1

SELECT `Statistic`.`id`, `Statistic`.`module_type_id`, `Statistic`.`company_id`, `Statistic`.`business_object_id`, `Statistic`.`count`, `Statistic`.`hit_date`, `Statistic`.`is_aggregated`, `ModuleType`.`id`, `ModuleType`.`handle`, `ModuleType`.`name`, `ModuleType`.`description`, `ModuleType`.`created`, `ModuleType`.`modified` FROM `statistics` AS `Statistic` LEFT JOIN `module_types` AS `ModuleType` ON (`Statistic`.`module_type_id` = `ModuleType`.`id`) WHERE `business_object_id` = '1319100585_4e9fe0a90f9db' AND `company_id` = 4555 AND `module_type_id` = '9' AND `hit_date` = '2012-05-24' LIMIT 1

INSERT INTO `statistics` (`is_aggregated`, `count`, `company_id`, `business_object_id`, `module_type_id`, `hit_date`) VALUES (0, 1, 4555, '1319100585_4e9fe0a90f9db', '9', '2012-05-24')

SELECT LAST_INSERT_ID() AS insertID

(report) 2 queries took 646 ms
Nr	Query	Error	Affected	Num. rows	Took (ms)
1	DESCRIBE `reports`		17	17	1
2	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 ("Bridgehead International Appoints Expert in Global Pricing and Market Access for Oncology Products") ORDER BY MATCH (`MarketResearchReport`.`name`, `MarketResearchReport`.`description`, `MarketResearchReport`.`summary`, `MarketResearchReport`.`content`, `MarketResearchReport`.`isbn`, `MarketResearchReport`.`code`) AGAINST ("Bridgehead International Appoints Expert in Global Pricing and Market Access for Oncology Products") DESC , MarketResearchReport.published DESC LIMIT 10		10	10	645

(report) 2 queries took 646 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `reports`

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 ("Bridgehead International Appoints Expert in Global Pricing and Market Access for Oncology Products") ORDER BY MATCH (`MarketResearchReport`.`name`, `MarketResearchReport`.`description`, `MarketResearchReport`.`summary`, `MarketResearchReport`.`content`, `MarketResearchReport`.`isbn`, `MarketResearchReport`.`code`) AGAINST ("Bridgehead International Appoints Expert in Global Pricing and Market Access for Oncology Products") DESC , MarketResearchReport.published DESC LIMIT 10

645