SELECT * FROM news WHERE news_cid = AND news_id != AND (news_draft IS NULL OR news_draft != 'Yes' OR news_draft = '' OR news_draft = '0')AND news_date REGEXP '^[1-2][0-9]{3}-[0-1][0-9]-[0-3][0-9]$' ORDER BY STR_TO_DATE(news_date, '%Y-%m-%d') DESC LIMIT 6