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