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