{"data":[{"DT_RowId":"row_1cab5f07e2016-08-12","users_visits":{"user_id":"1","site_id":"1","visit_date":"2016-08-12"},"sites":{"name":null},"users":{"first_name":null,"last_name":null}},{"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":null,"last_name":null}},{"DT_RowId":"row_1cab5f07e2016-08-19","users_visits":{"user_id":"1","site_id":"7","visit_date":"2016-08-19"},"sites":{"name":"bucu"},"users":{"first_name":null,"last_name":null}},{"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":null,"last_name":null}},{"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":null,"last_name":null}},{"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":null,"last_name":null}},{"DT_RowId":"row_2cab5f07e2016-07-30","users_visits":{"user_id":"2","site_id":"1","visit_date":"2016-07-30"},"sites":{"name":null},"users":{"first_name":null,"last_name":null}},{"DT_RowId":"row_3cab5f07e2016-06-26","users_visits":{"user_id":"3","site_id":"1","visit_date":"2016-06-26"},"sites":{"name":null},"users":{"first_name":null,"last_name":null}},{"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":null,"last_name":null}},{"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":null,"last_name":null}},{"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":null,"last_name":null}}],"options":{"users_visits.user_id":[{"label":"Sophia Morris","value":"4"},{"label":"Tina Nizich","value":"39"},{"label":"Veronica Marks","value":"15"},{"label":"Vincent Banks","value":"35"},{"label":"Wynne Ruiz","value":"16"},{"label":"omar nazih","value":"57"},{"label":"vjv jvjv","value":"49"}],"users_visits.site_id":[{"label":"London","value":"2"},{"label":"Los Angeles","value":"6"},{"label":"New York","value":"4"},{"label":"Paris","value":"3"},{"label":"Pohj","value":"8"},{"label":"Singapore","value":"5"},{"label":"bucu","value":"7"},{"label":"jefvil","value":"10"}]},"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":[]}]}