miss q : select `T1`.`entry_id`,`T1`.`entry_title`,T1.`entry_author_id`,`T1`.`entry_authored_on`,`T1`.`entry_text`,`T1`.`entry_text_more`,`T2`.`placement_category_id`,`T3`.`category_label` from `mt_entry` as `T1` left join `mt_placement` as `T2` on T1.`entry_id` = T2.`placement_entry_id` and T2.`placement_blog_id` = 5 and T2.`placement_is_primary` =1 left join `mt_category` as `T3` on `T2`.`placement_category_id` = `T3`.`category_id` and `T3`.`category_blog_id` = 5 where `T1`.`entry_blog_id` = 5 and `T1`.`entry_status` = 2 and DATE_FORMAT(T1.`entry_authored_on`, '%Y%m') = '201407' order by `T1`.`entry_authored_on` desc limit 2 offset -2;