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(6) {
  [0]=>
  array(14) {
    ["id"]=>
    string(3) "339"
    ["victim_date"]=>
    string(10) "1549304100"
    ["country_id"]=>
    string(1) "9"
    ["state_id"]=>
    string(1) "7"
    ["name"]=>
    string(27) "Shafiq Areya and Rahimullah"
    ["affiliation"]=>
    string(0) ""
    ["violation_id"]=>
    string(2) "11"
    ["target_id"]=>
    string(1) "1"
    ["headline"]=>
    string(222) "On the evening of February 5, 2019, gunmen stormed office of local radio station Hamsada in the center of city of Talegan, provincial capital of Takhar Province. The unidentified gunmen killed two employees in their office"
    ["tags"]=>
    string(0) ""
    ["link"]=>
    string(0) ""
    ["image"]=>
    string(0) ""
    ["timestamp"]=>
    string(19) "2019-02-11 06:25:19"
    ["publish"]=>
    string(1) "1"
  }
  [1]=>
  array(14) {
    ["id"]=>
    string(3) "338"
    ["victim_date"]=>
    string(10) "1549044900"
    ["country_id"]=>
    string(1) "6"
    ["state_id"]=>
    string(2) "22"
    ["name"]=>
    string(27) "Suman Pandey &Vinod Dongre "
    ["affiliation"]=>
    string(0) ""
    ["violation_id"]=>
    string(1) "7"
    ["target_id"]=>
    string(1) "4"
    ["headline"]=>
    string(237) "Pandey, a journalist with The Voices filmed a scuffle that broke out between BJP officials. He said that following, he was attacked and beaten by BJP officials, demanding that he delete the footage. Vinod was also injured in the attack. "
    ["tags"]=>
    string(0) ""
    ["link"]=>
    string(80) "https://samsn.ifj.org/journalist-attacked-by-officials-from-indias-ruling-party/"
    ["image"]=>
    string(0) ""
    ["timestamp"]=>
    string(19) "2019-02-07 05:51:10"
    ["publish"]=>
    string(1) "1"
  }
  [2]=>
  array(14) {
    ["id"]=>
    string(3) "340"
    ["victim_date"]=>
    string(10) "1549649700"
    ["country_id"]=>
    string(1) "5"
    ["state_id"]=>
    string(2) "47"
    ["name"]=>
    string(21) "Rizwan Ur Rehman Razi"
    ["affiliation"]=>
    string(0) ""
    ["violation_id"]=>
    string(1) "8"
    ["target_id"]=>
    string(1) "4"
    ["headline"]=>
    string(272) "Razi a TV anchor for Din News, an Urdu-language news station, was detained and arrested in his home in Lahore on Saturday. He was arrested by the Cyber Crime Wing of Federal Investigation Agency (FIA) for allegedly posting defamatory and obnoxious content on social media."
    ["tags"]=>
    string(0) ""
    ["link"]=>
    string(76) "https://samsn.ifj.org/pakistani-journalist-arrested-over-social-media-posts/"
    ["image"]=>
    string(0) ""
    ["timestamp"]=>
    string(19) "2019-02-12 09:28:38"
    ["publish"]=>
    string(1) "1"
  }
  [3]=>
  array(14) {
    ["id"]=>
    string(3) "342"
    ["victim_date"]=>
    string(10) "1550513700"
    ["country_id"]=>
    string(1) "2"
    ["state_id"]=>
    string(2) "71"
    ["name"]=>
    string(19) "Nadarajah Kugarajah"
    ["affiliation"]=>
    string(0) ""
    ["violation_id"]=>
    string(1) "7"
    ["target_id"]=>
    string(1) "4"
    ["headline"]=>
    string(251) "Nadarajah Kugarajah, a journalist from Tamil television channel 'Dan TV' was filming an incident for his reportage. He had been threatened not to film the incident and attacked by the Acting Officer-in-Charge of Kopay police station, Kugarajah stated."
    ["tags"]=>
    string(0) ""
    ["link"]=>
    string(0) ""
    ["image"]=>
    string(0) ""
    ["timestamp"]=>
    string(19) "2019-02-20 10:31:53"
    ["publish"]=>
    string(1) "1"
  }
  [4]=>
  array(14) {
    ["id"]=>
    string(3) "337"
    ["victim_date"]=>
    string(10) "1548180900"
    ["country_id"]=>
    string(1) "2"
    ["state_id"]=>
    string(2) "74"
    ["name"]=>
    string(28) "Rahul Samantha Hettiarachchi"
    ["affiliation"]=>
    string(0) ""
    ["violation_id"]=>
    string(1) "5"
    ["target_id"]=>
    string(1) "4"
    ["headline"]=>
    string(327) "Journalist Rahul Samantha Hettiarachchi was obstructed from reporting on a protest by workers on a salt production site on January 23, 2019 in Habmantota, southern Sri Lanka. During the protest, a group claiming to be supporters of the country’s ruling United National Party started to intimidate and obstruct Hettiarachchi. "
    ["tags"]=>
    string(0) ""
    ["link"]=>
    string(73) "https://samsn.ifj.org/sri-lankan-journalist-intimidated-covering-protest/"
    ["image"]=>
    string(0) ""
    ["timestamp"]=>
    string(19) "2019-02-06 11:02:14"
    ["publish"]=>
    string(1) "1"
  }
  [5]=>
  array(14) {
    ["id"]=>
    string(3) "341"
    ["victim_date"]=>
    string(10) "1546625700"
    ["country_id"]=>
    string(1) "9"
    ["state_id"]=>
    string(2) "79"
    ["name"]=>
    string(11) "Javid Noori"
    ["affiliation"]=>
    string(0) ""
    ["violation_id"]=>
    string(2) "11"
    ["target_id"]=>
    string(1) "4"
    ["headline"]=>
    string(238) "Part-time journalist Jabid Noori was killed after he was abducted by Taliban in Afghanistan's western province of Farah. He was taken out of car and searched and killed by Taliban in an area called Bagh-e-pol 15Km distant from Farah city."
    ["tags"]=>
    string(0) ""
    ["link"]=>
    string(0) ""
    ["image"]=>
    string(0) ""
    ["timestamp"]=>
    string(19) "2019-02-20 06:43:57"
    ["publish"]=>
    string(1) "1"
  }
}