SELECT SQL_CALC_FOUND_ROWS * FROM (
SELECT post.*, 'tag' FROM `post`, `post_tag`, `tag`
WHERE
`post_tag`.`tag_id` = `tag`.`id` AND
`post_tag`.`post_id` = `post`.`id` AND
( `tag`.`name` = 'arpu' ) AND `post`.`state` = 'LIVE' AND `post`.`post_date` < '2010-03-21 16:44:18' AND `post`.`type` = 'PRESS_RELEASE'
UNION SELECT *, MATCH(body) AGAINST ('arpu') AS score FROM post WHERE MATCH(post.body) AGAINST ('arpu') AND `post`.`state` = 'LIVE' AND `post`.`post_date` < '2010-03-21 16:44:18' AND `post`.`type` = 'PRESS_RELEASE'
) AS matches
GROUP BY matches.id ORDER BY matches.`post_date` DESC LIMIT 15 OFFSET 0
SELECT SQL_CALC_FOUND_ROWS * FROM (
SELECT post.*, 'tag' FROM `post`, `post_tag`, `tag`
WHERE
`post_tag`.`tag_id` = `tag`.`id` AND
`post_tag`.`post_id` = `post`.`id` AND
( `tag`.`name` = 'arpu' ) AND `post`.`state` = 'LIVE' AND `post`.`post_date` < '2010-03-21 16:44:18' AND `post`.`type` = 'NEWS'
UNION SELECT *, MATCH(body) AGAINST ('arpu') AS score FROM post WHERE MATCH(post.body) AGAINST ('arpu') AND `post`.`state` = 'LIVE' AND `post`.`post_date` < '2010-03-21 16:44:18' AND `post`.`type` = 'NEWS'
) AS matches
GROUP BY matches.id ORDER BY matches.`post_date` DESC LIMIT 15 OFFSET 0
Warning: Cannot modify header information - headers already sent by (output started at /poke/data/www/orange/newsroom/live_current/includes/orange_pr/classes/search/PostSearch.class.php:41) in /poke/data/www/orange/newsroom/live_current/tmp/compiled/poke/data/www/orange/newsroom/live/includes/gorvc/frontend/templates/rss_feed.html.d15.php on line 2 Orange Newsroom
http://newsroom.orange.co.uk/library/
Orange Newsroom RSS feedOrange Q3 2008 Financials
http://newsroom.orange.co.uk/2008/10/30/orange-q3-2008-financials/
Orangecommentshttp://newsroom.orange.co.uk/2008/10/30/orange-q3-2008-financials/2008-10-30 00:00:00Orange UK named Best Entertainment Operator in Europe
http://newsroom.orange.co.uk/2008/05/09/orange-uk-named-best-entertainment-operator-in-europe/
Orangecommentshttp://newsroom.orange.co.uk/2008/05/09/orange-uk-named-best-entertainment-operator-in-europe/2008-05-09 00:00:00"Sony Ericsson and Orange Announce Exclusive Download of Christina Aguilera's New Single ""Ain't No Other Man"""
http://newsroom.orange.co.uk/2006/06/14/quot-sony-ericsson-and-orange-announce-exclusive-download-of-christina-aguilera-s-new-single-quot-quot-ain-t-no-other-man-quot-quot-quot/
Orangecommentshttp://newsroom.orange.co.uk/2006/06/14/quot-sony-ericsson-and-orange-announce-exclusive-download-of-christina-aguilera-s-new-single-quot-quot-ain-t-no-other-man-quot-quot-quot/2006-06-14 00:00:00Orange launches world's smallest Smartphone — SPV C500 — as part of new Signature phone portfolio
http://newsroom.orange.co.uk/2004/06/08/orange-launches-world-39-s-smallest-smartphone-mdash-spv-c500-mdash-as-part-of-new-signature-phone-portfolio/
Orangecommentshttp://newsroom.orange.co.uk/2004/06/08/orange-launches-world-39-s-smallest-smartphone-mdash-spv-c500-mdash-as-part-of-new-signature-phone-portfolio/2004-06-08 00:00:00Top Orange Signature phones deliver double the revenue of average non-Signature phones
http://newsroom.orange.co.uk/2004/02/12/top-orange-signature-phones-deliver-double-the-revenue-of-average-non-signature-phones/
Orangecommentshttp://newsroom.orange.co.uk/2004/02/12/top-orange-signature-phones-deliver-double-the-revenue-of-average-non-signature-phones/2004-02-12 00:00:00Orange announces strong performance in first half 2003
http://newsroom.orange.co.uk/2003/07/29/orange-announces-strong-performance-in-first-half-2003/
Orangecommentshttp://newsroom.orange.co.uk/2003/07/29/orange-announces-strong-performance-in-first-half-2003/2003-07-29 00:00:00Orange full year 2002 financial results
http://newsroom.orange.co.uk/2003/03/05/orange-full-year-2002-financial-results/
Orangecommentshttp://newsroom.orange.co.uk/2003/03/05/orange-full-year-2002-financial-results/2003-03-05 00:00:00Strong first half performance from Orange
http://newsroom.orange.co.uk/2002/07/25/strong-first-half-performance-from-orange/
Orangecommentshttp://newsroom.orange.co.uk/2002/07/25/strong-first-half-performance-from-orange/2002-07-25 00:00:00Orange today announced strong customer and revenue growth for the three months ended
http://newsroom.orange.co.uk/2002/04/30/orange-today-announced-strong-customer-and-revenue-growth-for-the-three-months-ended/
Orangecommentshttp://newsroom.orange.co.uk/2002/04/30/orange-today-announced-strong-customer-and-revenue-growth-for-the-three-months-ended/2002-04-30 00:00:00Orange full year 2001 financial results
http://newsroom.orange.co.uk/2002/03/21/orange-full-year-2001-financial-results/
Orangecommentshttp://newsroom.orange.co.uk/2002/03/21/orange-full-year-2001-financial-results/2002-03-21 00:00:00Orange announces strong customer and revenue growth year ended 31 December 2001
http://newsroom.orange.co.uk/2002/01/29/orange-announces-strong-customer-and-revenue-growth-year-ended-31-december-2001/
Orangecommentshttp://newsroom.orange.co.uk/2002/01/29/orange-announces-strong-customer-and-revenue-growth-year-ended-31-december-2001/2002-01-29 00:00:00Orange SA 2001 interim results
http://newsroom.orange.co.uk/2001/09/06/orange-sa-2001-interim-results/
Orangecommentshttp://newsroom.orange.co.uk/2001/09/06/orange-sa-2001-interim-results/2001-09-06 00:00:00