SELECT * FROM ( SELECT `news_id`, `news_head`, `news_date`, `url`, `url_ru, `our` FROM `site_21200`.`our_news` as `our` WHERE `on_off`=1 AND `news_id`!=51370 AND DATE_FORMAT(`our`.`news_date`, '%Y-%m-%d')=SUBDATE(CURDATE(), 1) LIMIT 100 ) as `news` ORDER BY `news`.`news_date` DESC LIMIT 5