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` = 'social' OR `tag`.`name` = 'networking' OR `tag`.`name` = 'social networking' ) AND `post`.`state` = 'LIVE' AND `post`.`post_date` < '2010-03-16 12:44:13' AND `post`.`type` = 'PRESS_RELEASE'
UNION SELECT *, MATCH(body) AGAINST ('social networking') AS score FROM post WHERE MATCH(post.body) AGAINST ('social networking') AND `post`.`state` = 'LIVE' AND `post`.`post_date` < '2010-03-16 12:44:13' 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` = 'social' OR `tag`.`name` = 'networking' OR `tag`.`name` = 'social networking' ) AND `post`.`state` = 'LIVE' AND `post`.`post_date` < '2010-03-16 12:44:13' AND `post`.`type` = 'NEWS'
UNION SELECT *, MATCH(body) AGAINST ('social networking') AS score FROM post WHERE MATCH(post.body) AGAINST ('social networking') AND `post`.`state` = 'LIVE' AND `post`.`post_date` < '2010-03-16 12:44:13' 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 debate suggests 'pub hubs' are the future for flexible working
http://newsroom.orange.co.uk/2010/02/10/orange-debate-suggests-pub-hubs-are-the-future-for-flexible-working/
Orangecommentshttp://newsroom.orange.co.uk/2010/02/10/orange-debate-suggests-pub-hubs-are-the-future-for-flexible-working/2010-02-10 12:00:40Nominees are unveiled for the Orange Rising Star Award 2010
http://newsroom.orange.co.uk/2010/01/12/nominees-are-unveiled-for-the-orange-rising-star-award-2010/
Orangecommentshttp://newsroom.orange.co.uk/2010/01/12/nominees-are-unveiled-for-the-orange-rising-star-award-2010/2010-01-12 12:00:00Orange launches Application Shop, giving customers click-and-go access to thousands of applications, services and games
http://newsroom.orange.co.uk/2009/12/09/orange-launches-application-shop-giving-customers-click-and-go-access-to-thousands-of-applications-services-and-games/
Orangecommentshttp://newsroom.orange.co.uk/2009/12/09/orange-launches-application-shop-giving-customers-click-and-go-access-to-thousands-of-applications-services-and-games/2009-12-09 09:42:00Orange announces sponsorship campaign with Kiss 100’s breakfast show to promote Orange RockCorps Collective
http://newsroom.orange.co.uk/2009/12/07/orange-announces-sponsorship-campaign-with-kiss-100-s-breakfast-show-to-promote-orange-rockcorps-collective/
Orangecommentshttp://newsroom.orange.co.uk/2009/12/07/orange-announces-sponsorship-campaign-with-kiss-100-s-breakfast-show-to-promote-orange-rockcorps-collective/2009-12-07 14:13:07Orange launches People Projects: a new social media service designed to help people carry out a project
http://newsroom.orange.co.uk/2009/11/17/orange-launches-people-projects-a-new-social-media-service-designed-to-help-people-carry-out-a-project/
Orangecommentshttp://newsroom.orange.co.uk/2009/11/17/orange-launches-people-projects-a-new-social-media-service-designed-to-help-people-carry-out-a-project/2009-11-17 14:30:00