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