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` = 'GoSpoken' ) AND `post`.`state` = 'LIVE' AND `post`.`post_date` < '2010-03-16 17:51:54' AND `post`.`type` = 'PRESS_RELEASE' UNION SELECT *, MATCH(body) AGAINST ('GoSpoken') AS score FROM post WHERE MATCH(post.body) AGAINST ('GoSpoken') AND `post`.`state` = 'LIVE' AND `post`.`post_date` < '2010-03-16 17:51:54' 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` = 'GoSpoken' ) AND `post`.`state` = 'LIVE' AND `post`.`post_date` < '2010-03-16 17:51:54' AND `post`.`type` = 'NEWS' UNION SELECT *, MATCH(body) AGAINST ('GoSpoken') AS score FROM post WHERE MATCH(post.body) AGAINST ('GoSpoken') AND `post`.`state` = 'LIVE' AND `post`.`post_date` < '2010-03-16 17:51:54' 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 feed Orange Prize for Fiction announces 2009 shortlist http://newsroom.orange.co.uk/2009/04/21/orange-prize-for-fiction-announces-2009-shortlist/ Orange comments http://newsroom.orange.co.uk/2009/04/21/orange-prize-for-fiction-announces-2009-shortlist/ 2009-04-21 09:30:00