SELECT SUBSTRING(`LastModifiedDate`,1,7) AS `LastModifiedDate` FROM `news_data` WHERE SUBSTRING(`LastModifiedDate`,1,7) != '0000-00' AND `LastModifiedDate` IS NOT NULL AND `TypeId` LIKE '6' AND `GroupId` LIKE '%%' GROUP BY SUBSTRING(`LastModifiedDate`,1,7 ) ORDER BY `LastModifiedDate` DESC;