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` = 'music' ) AND `post`.`state` = 'LIVE' AND `post`.`post_date` < '2010-03-16 12:43:56' AND `post`.`type` = 'PRESS_RELEASE'
UNION SELECT *, MATCH(body) AGAINST ('music') AS score FROM post WHERE MATCH(post.body) AGAINST ('music') AND `post`.`state` = 'LIVE' AND `post`.`post_date` < '2010-03-16 12:43:56' 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` = 'music' ) AND `post`.`state` = 'LIVE' AND `post`.`post_date` < '2010-03-16 12:43:56' AND `post`.`type` = 'NEWS'
UNION SELECT *, MATCH(body) AGAINST ('music') AS score FROM post WHERE MATCH(post.body) AGAINST ('music') AND `post`.`state` = 'LIVE' AND `post`.`post_date` < '2010-03-16 12:43:56' AND `post`.`type` = 'NEWS'
) AS matches
GROUP BY matches.id ORDER BY matches.`post_date` DESC LIMIT 15 OFFSET 0
Orange newsroom | library
