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