SELECT v.* from sn_victim as v WHERE v.publish=1 AND 1=1 AND (v.victim_date between 1640974500 AND 1672510500) group by state_id,country_idarray(0) { }