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` = 'habits' ) AND `post`.`state` = 'LIVE' AND `post`.`post_date` < '2010-03-21 05:08:32' AND `post`.`type` = 'PRESS_RELEASE'
UNION SELECT *, MATCH(body) AGAINST ('habits') AS score FROM post WHERE MATCH(post.body) AGAINST ('habits') AND `post`.`state` = 'LIVE' AND `post`.`post_date` < '2010-03-21 05:08:32' 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` = 'habits' ) AND `post`.`state` = 'LIVE' AND `post`.`post_date` < '2010-03-21 05:08:32' AND `post`.`type` = 'NEWS'
UNION SELECT *, MATCH(body) AGAINST ('habits') AS score FROM post WHERE MATCH(post.body) AGAINST ('habits') AND `post`.`state` = 'LIVE' AND `post`.`post_date` < '2010-03-21 05:08:32' 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 feedOrange reveals digital media boom
http://newsroom.orange.co.uk/2009/05/14/orange-reveals-digital-media-boom/
Orangecommentshttp://newsroom.orange.co.uk/2009/05/14/orange-reveals-digital-media-boom/2009-05-14 10:00:00Orange sponsored research sees the mobile medium establish itself firmly in the marketing channel
http://newsroom.orange.co.uk/2009/03/24/orange-sponsored-research-sees-the-mobile-medium-establish-itself-firmly-in-the-marketing-channel/
Orangecommentshttp://newsroom.orange.co.uk/2009/03/24/orange-sponsored-research-sees-the-mobile-medium-establish-itself-firmly-in-the-marketing-channel/2009-03-24 09:45:00A SOCIALLY FRUSTRATED NATION
http://newsroom.orange.co.uk/2008/06/13/a-socially-frustrated-nation/
Orangecommentshttp://newsroom.orange.co.uk/2008/06/13/a-socially-frustrated-nation/2008-06-13 00:00:00Orange Evolves Animal Packages
http://newsroom.orange.co.uk/2008/02/29/orange-evolves-animal-packages/
Orangecommentshttp://newsroom.orange.co.uk/2008/02/29/orange-evolves-animal-packages/2008-02-29 00:00:00The Summer May Be Over But The UK's Workforce Is Hitting The Park
http://newsroom.orange.co.uk/2007/09/06/the-summer-may-be-over-but-the-uk-39-s-workforce-is-hitting-the-park/
Orangecommentshttp://newsroom.orange.co.uk/2007/09/06/the-summer-may-be-over-but-the-uk-39-s-workforce-is-hitting-the-park/2007-09-06 00:00:00