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` = 'Sales' OR `tag`.`name` = 'Academy' OR `tag`.`name` = 'Sales Academy' ) AND `post`.`state` = 'LIVE' AND `post`.`post_date` < '2010-03-21 04:01:19' AND `post`.`type` = 'PRESS_RELEASE'
UNION SELECT *, MATCH(body) AGAINST ('Sales Academy') AS score FROM post WHERE MATCH(post.body) AGAINST ('Sales Academy') AND `post`.`state` = 'LIVE' AND `post`.`post_date` < '2010-03-21 04:01:19' AND `post`.`type` = 'PRESS_RELEASE'
) AS matches
GROUP BY matches.id ORDER BY matches.`post_date` DESC LIMIT 5 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` = 'Sales' OR `tag`.`name` = 'Academy' OR `tag`.`name` = 'Sales Academy' ) AND `post`.`state` = 'LIVE' AND `post`.`post_date` < '2010-03-21 04:01:19' AND `post`.`type` = 'NEWS'
UNION SELECT *, MATCH(body) AGAINST ('Sales Academy') AS score FROM post WHERE MATCH(post.body) AGAINST ('Sales Academy') AND `post`.`state` = 'LIVE' AND `post`.`post_date` < '2010-03-21 04:01:19' AND `post`.`type` = 'NEWS'
) AS matches
GROUP BY matches.id ORDER BY matches.`post_date` DESC LIMIT 5 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 feedMerger of T-Mobile UK and Orange UK cleared by EU Commission
http://newsroom.orange.co.uk/2010/03/01/merger-of-t-mobile-uk-and-orange-uk-cleared-by-eu-commission/
Orangecommentshttp://newsroom.orange.co.uk/2010/03/01/merger-of-t-mobile-uk-and-orange-uk-cleared-by-eu-commission/2010-03-01 17:18:13The National Business Awards now open to entries
http://newsroom.orange.co.uk/2010/02/23/the-national-business-awards-now-open-to-entries/
Orangecommentshttp://newsroom.orange.co.uk/2010/02/23/the-national-business-awards-now-open-to-entries/2010-02-23 17:18:08Kristen Stewart wins the Orange Rising Star Award
http://newsroom.orange.co.uk/2010/02/21/kristen-stewart-wins-the-orange-rising-star-award/
Orangecommentshttp://newsroom.orange.co.uk/2010/02/21/kristen-stewart-wins-the-orange-rising-star-award/2010-02-21 21:14:37Orange UK continues its Android rollout with the HTC Desire
http://newsroom.orange.co.uk/2010/02/16/orange-uk-continues-its-android-rollout-with-the-htc-desire/
Orangecommentshttp://newsroom.orange.co.uk/2010/02/16/orange-uk-continues-its-android-rollout-with-the-htc-desire/2010-02-16 09:42:39Orange frees up IT teams with launch of Total Resource
http://newsroom.orange.co.uk/2010/02/11/orange-frees-up-it-teams-with-launch-of-total-resource/
Orangecommentshttp://newsroom.orange.co.uk/2010/02/11/orange-frees-up-it-teams-with-launch-of-total-resource/2010-02-11 08:22:57Information: Guillaume van Gaver appointed as VP of Sales & Loyalty, Orange UK
http://newsroom.orange.co.uk/2009/09/23/information-guillaume-van-gaver-appointed-as-vp-sales-loyalty-orange-uk/
Orangecommentshttp://newsroom.orange.co.uk/2009/09/23/information-guillaume-van-gaver-appointed-as-vp-sales-loyalty-orange-uk/2009-09-23 16:45:57