{"data":[{"DT_RowId":"row_1cab5f07e2016-08-12","users_visits":{"user_id":"1","site_id":"1","visit_date":"2016-08-12"},"sites":{"name":"Edinburgh"},"users":{"first_name":"Quynn","last_name":"Contreras"}},{"DT_RowId":"row_1cab5f07e2016-08-14","users_visits":{"user_id":"1","site_id":"4","visit_date":"2016-08-14"},"sites":{"name":"New York"},"users":{"first_name":"Quynn","last_name":"Contreras"}},{"DT_RowId":"row_1cab5f07e2016-08-19","users_visits":{"user_id":"1","site_id":"7","visit_date":"2016-08-19"},"sites":{"name":null},"users":{"first_name":"Quynn","last_name":"Contreras"}},{"DT_RowId":"row_2cab5f07e2016-07-01","users_visits":{"user_id":"2","site_id":"6","visit_date":"2016-07-01"},"sites":{"name":"Los Angeles"},"users":{"first_name":"Kaitlin","last_name":"Smith"}},{"DT_RowId":"row_2cab5f07e2016-07-07","users_visits":{"user_id":"2","site_id":"2","visit_date":"2016-07-07"},"sites":{"name":"London"},"users":{"first_name":"Kaitlin","last_name":"Smith"}},{"DT_RowId":"row_2cab5f07e2016-07-12","users_visits":{"user_id":"2","site_id":"3","visit_date":"2016-07-12"},"sites":{"name":"Paris"},"users":{"first_name":"Kaitlin","last_name":"Smith"}},{"DT_RowId":"row_2cab5f07e2016-07-30","users_visits":{"user_id":"2","site_id":"1","visit_date":"2016-07-30"},"sites":{"name":"Edinburgh"},"users":{"first_name":"Kaitlin","last_name":"Smith"}},{"DT_RowId":"row_3cab5f07e2016-06-26","users_visits":{"user_id":"3","site_id":"1","visit_date":"2016-06-26"},"sites":{"name":"Edinburgh"},"users":{"first_name":"Cruz","last_name":"Reynolds"}},{"DT_RowId":"row_3cab5f07e2016-12-05","users_visits":{"user_id":"3","site_id":"2","visit_date":"2016-12-05"},"sites":{"name":"London"},"users":{"first_name":"Cruz","last_name":"Reynolds"}},{"DT_RowId":"row_4cab5f07e2016-10-10","users_visits":{"user_id":"4","site_id":"4","visit_date":"2016-10-10"},"sites":{"name":"New York"},"users":{"first_name":"Sophia","last_name":"Morris"}},{"DT_RowId":"row_4cab5f07e2016-11-21","users_visits":{"user_id":"4","site_id":"3","visit_date":"2016-11-21"},"sites":{"name":"Paris"},"users":{"first_name":"Sophia","last_name":"Morris"}},{"DT_RowId":"row_5cab5f07e2016-08-02","users_visits":{"user_id":"5","site_id":"5","visit_date":"2016-08-02"},"sites":{"name":"Singapore"},"users":{"first_name":"Kamal","last_name":"Roberson"}},{"DT_RowId":"row_6cab5f07e2016-08-05","users_visits":{"user_id":"6","site_id":"6","visit_date":"2016-08-05"},"sites":{"name":"Los Angeles"},"users":{"first_name":"Dustin","last_name":"Rosa"}}],"options":{"users_visits.user_id":[{"label":"Alexa Wilder","value":"32"},{"label":"Avram Allison2","value":"11"},{"label":"Basia Harrell","value":"28"},{"label":"Bryar Long","value":"8"},{"label":"Cruz Reynolds","value":"3"},{"label":"Dexter Burton","value":"30"},{"label":"Dustin Rosa","value":"6"},{"label":"Hamilton Blackburn","value":"29"},{"label":"Ifeoma Mays","value":"27"},{"label":"Indigo Brennan","value":"10"},{"label":"Ishmael Crosby","value":"25"},{"label":"Jessica Bryan","value":"17"},{"label":"Jocelyn England","value":"34"},{"label":"Kaitlin Smith","value":"2"},{"label":"Kamal Roberson","value":"5"},{"label":"Kuame Wynn","value":"9"},{"label":"Lael Kim","value":"13"},{"label":"Lyle Lewis","value":"14"},{"label":"Maris Leblanc","value":"24"},{"label":"Martha Burgess","value":"12"},{"label":"Medge Patterson","value":"20"},{"label":"Mona Terry","value":"19"},{"label":"Pandora Armstrong","value":"22"},{"label":"Pandora Briggs","value":"23"},{"label":"Perry Gamble","value":"21"},{"label":"Quinlan Hyde","value":"18"},{"label":"Quinn Mccall","value":"31"},{"label":"Quintessa Pickett","value":"26"},{"label":"Quynn Contreras","value":"1"},{"label":"Rhonda Harrell","value":"33"},{"label":"Sophia Morris","value":"4"},{"label":"Stewart Chan","value":"36"},{"label":"Veronica Marks","value":"15"},{"label":"Vincent Banks","value":"35"},{"label":"Wynne Ruiz","value":"16"},{"label":"Xantha George","value":"7"}],"users_visits.site_id":[{"label":"Edinburgh","value":"1"},{"label":"London","value":"2"},{"label":"Los Angeles","value":"6"},{"label":"New York","value":"4"},{"label":"Paris","value":"3"},{"label":"Singapore","value":"5"}]},"files":[],"debug":[{"query":"SELECT  `users_visits`.`user_id` as 'users_visits.user_id', `users_visits`.`visit_date` as 'users_visits.visit_date', `users_visits`.`site_id` as 'users_visits.site_id', `sites`.`name` as 'sites.name', `users`.`first_name` as 'users.first_name', `users`.`last_name` as 'users.last_name' FROM  `users_visits` LEFT JOIN `sites` ON `users_visits`.`site_id` = `sites`.`id`  LEFT JOIN `users` ON `users_visits`.`user_id` = `users`.`id` ","bindings":[]},{"query":"SELECT DISTINCT  `id` as 'id', `first_name` as 'first_name', `last_name` as 'last_name' FROM  `users` ","bindings":[]},{"query":"SELECT DISTINCT  `id` as 'id', `name` as 'name' FROM  `sites` ","bindings":[]}]}