SELECT MONTH(FROM_UNIXTIME(0) + INTERVAL datetime SECOND ) AS "_month", YEAR(FROM_UNIXTIME(0) + INTERVAL datetime SECOND) AS "_year" , count(MONTH(FROM_UNIXTIME(0) + INTERVAL datetime SECOND )) as count_month, count(YEAR(FROM_UNIXTIME(0) + INTERVAL datetime SECOND)) as count_year FROM tx_news_domain_model_news WHERE (((`tx_news_domain_model_news`.`type` = '0') OR (`tx_news_domain_model_news`.`type` = '2') OR (`tx_news_domain_model_news`.`type` = '1'))) AND (((`tx_news_domain_model_news`.`datetime` >= '1706396400') AND (`tx_news_domain_model_news`.`pid` IN ('64')))) AND (`tx_news_domain_model_news`.`sys_language_uid` IN (0, -1)) AND (`tx_news_domain_model_news`.`t3ver_oid` = 0) AND (((`tx_news_domain_model_news`.`deleted` = 0) AND (`tx_news_domain_model_news`.`t3ver_state` <= 0) AND (`tx_news_domain_model_news`.`t3ver_wsid` = 0) AND (((`tx_news_domain_model_news`.`t3ver_oid` = 0) OR (`tx_news_domain_model_news`.`t3ver_state` = 4))) AND (`tx_news_domain_model_news`.`hidden` = 0) AND (`tx_news_domain_model_news`.`starttime` <= 1761670620) AND (((`tx_news_domain_model_news`.`endtime` = 0) OR (`tx_news_domain_model_news`.`endtime` > 1761670620))) AND ((((`tx_news_domain_model_news`.`fe_group` = '') OR (`tx_news_domain_model_news`.`fe_group` IS NULL) OR (`tx_news_domain_model_news`.`fe_group` = '0') OR (FIND_IN_SET('0', `tx_news_domain_model_news`.`fe_group`)) OR (FIND_IN_SET('-1', `tx_news_domain_model_news`.`fe_group`))))))) AND ((`tx_news_domain_model_news`.`deleted` = 0) AND (`tx_news_domain_model_news`.`t3ver_state` <= 0) AND (`tx_news_domain_model_news`.`t3ver_wsid` = 0) AND (((`tx_news_domain_model_news`.`t3ver_oid` = 0) OR (`tx_news_domain_model_news`.`t3ver_state` = 4))) AND (`tx_news_domain_model_news`.`hidden` = 0) AND (`tx_news_domain_model_news`.`starttime` <= 1761670620) AND (((`tx_news_domain_model_news`.`endtime` = 0) OR (`tx_news_domain_model_news`.`endtime` > 1761670620))) AND ((((`tx_news_domain_model_news`.`fe_group` = '') OR (`tx_news_domain_model_news`.`fe_group` IS NULL) OR (`tx_news_domain_model_news`.`fe_group` = '0') OR (FIND_IN_SET('0', `tx_news_domain_model_news`.`fe_group`)) OR (FIND_IN_SET('-1', `tx_news_domain_model_news`.`fe_group`)))))) GROUP BY _month, _year ORDER BY _year desc, _month desc