Deprecated: Creation of dynamic property DataTables\Database::$type is deprecated in /users/stefangreising/www/Test/lib/Database.php on line 62

Deprecated: Creation of dynamic property DataTables\Database::$query_driver is deprecated in /users/stefangreising/www/Test/lib/Database.php on line 63

Deprecated: Creation of dynamic property DataTables\Database\Driver\MysqlQuery::$_dbHost is deprecated in /users/stefangreising/www/Test/lib/Database/Query.php on line 55

Deprecated: Creation of dynamic property DataTables\Database\Driver\MysqlQuery::$_dbHost is deprecated in /users/stefangreising/www/Test/lib/Database/Query.php on line 55

Deprecated: Creation of dynamic property DataTables\Database\Driver\MysqlQuery::$_dbHost is deprecated in /users/stefangreising/www/Test/lib/Database/Query.php on line 55
{"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":[]}]}