{"data":[{"DT_RowId":"row_4","users":{"first_name":"Sophia","last_name":"Morris","phone":"1-463-224-1405","site":"10"},"sites":{"name":"jefvil"}},{"DT_RowId":"row_15","users":{"first_name":"Veronica","last_name":"Marks","phone":"1-750-981-6759","site":"3"},"sites":{"name":"Paris"}},{"DT_RowId":"row_16","users":{"first_name":"Wynne","last_name":"Ruiz","phone":"1-983-744-5362","site":"4"},"sites":{"name":"New York"}},{"DT_RowId":"row_35","users":{"first_name":"Vincent","last_name":"Banks","phone":"1-225-418-0941","site":"5"},"sites":{"name":"Singapore"}},{"DT_RowId":"row_39","users":{"first_name":"Tina","last_name":"Nizich","phone":"5097751212","site":"1"},"sites":{"name":null}},{"DT_RowId":"row_49","users":{"first_name":"vjv","last_name":"jvjv","phone":"6665","site":"1"},"sites":{"name":null}},{"DT_RowId":"row_57","users":{"first_name":"omar","last_name":"nazih","phone":"","site":"10"},"sites":{"name":"jefvil"}}],"options":{"users.site":[{"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":[],"searchPanes":{"options":{"users.first_name":[{"label":"Sophia","total":"1","value":"Sophia","count":"1"},{"label":"Tina","total":"1","value":"Tina","count":"1"},{"label":"Veronica","total":"1","value":"Veronica","count":"1"},{"label":"Vincent","total":"1","value":"Vincent","count":"1"},{"label":"Wynne","total":"1","value":"Wynne","count":"1"},{"label":"omar","total":"1","value":"omar","count":"1"},{"label":"vjv","total":"1","value":"vjv","count":"1"}],"users.last_name":[{"label":"Banks","total":"1","value":"Banks","count":"1"},{"label":"Marks","total":"1","value":"Marks","count":"1"},{"label":"Morris","total":"1","value":"Morris","count":"1"},{"label":"Nizich","total":"1","value":"Nizich","count":"1"},{"label":"Ruiz","total":"1","value":"Ruiz","count":"1"},{"label":"jvjv","total":"1","value":"jvjv","count":"1"},{"label":"nazih","total":"1","value":"nazih","count":"1"}],"users.phone":[{"label":"","total":"1","value":"","count":"1"},{"label":"1-225-418-0941","total":"1","value":"1-225-418-0941","count":"1"},{"label":"1-463-224-1405","total":"1","value":"1-463-224-1405","count":"1"},{"label":"1-750-981-6759","total":"1","value":"1-750-981-6759","count":"1"},{"label":"1-983-744-5362","total":"1","value":"1-983-744-5362","count":"1"},{"label":"6665","total":"1","value":"6665","count":"1"},{"label":"5097751212","total":"1","value":"5097751212","count":"1"}],"sites.name":[{"label":null,"total":"2","value":null,"count":"2"},{"label":"New York","total":"1","value":"New York","count":"1"},{"label":"Paris","total":"1","value":"Paris","count":"1"},{"label":"Singapore","total":"1","value":"Singapore","count":"1"},{"label":"jefvil","total":"2","value":"jefvil","count":"2"}]}},"debug":[{"query":"SELECT `users`.`id` as 'users.id', `users`.`first_name` as 'users.first_name', `users`.`last_name` as 'users.last_name', `users`.`phone` as 'users.phone', `users`.`site` as 'users.site', `sites`.`name` as 'sites.name' FROM `users` LEFT JOIN `sites` ON `sites`.`id` = `users`.`site` ","bindings":[]},{"query":"SELECT `users`.`first_name` as 'value', COUNT(*) as count FROM `users` LEFT JOIN `sites` ON `sites`.`id` = `users`.`site` GROUP BY users.first_name","bindings":[]},{"query":"SELECT `users`.`first_name` as 'label', `users`.`first_name` as 'value', COUNT(*) as total FROM `users` LEFT JOIN `sites` ON `sites`.`id` = `users`.`site` GROUP BY users.first_name","bindings":[]},{"query":"SELECT `users`.`last_name` as 'value', COUNT(*) as count FROM `users` LEFT JOIN `sites` ON `sites`.`id` = `users`.`site` GROUP BY users.last_name","bindings":[]},{"query":"SELECT `users`.`last_name` as 'label', `users`.`last_name` as 'value', COUNT(*) as total FROM `users` LEFT JOIN `sites` ON `sites`.`id` = `users`.`site` GROUP BY users.last_name","bindings":[]},{"query":"SELECT `phone` as 'value', COUNT(*) as count FROM `users` LEFT JOIN `sites` ON `sites`.`id` = `users`.`site` GROUP BY phone","bindings":[]},{"query":"SELECT `phone` as 'label', `phone` as 'value', COUNT(*) as total FROM `users` LEFT JOIN `sites` ON `sites`.`id` = `users`.`site` GROUP BY phone","bindings":[]},{"query":"SELECT DISTINCT `id` as 'id', `name` as 'name' FROM `sites` ","bindings":[]},{"query":"SELECT `sites`.`name` as 'value', COUNT(*) as count FROM `users` LEFT JOIN `sites` ON `sites`.`id` = `users`.`site` GROUP BY sites.name","bindings":[]},{"query":"SELECT `sites`.`name` as 'label', `sites`.`name` as 'value', COUNT(*) as total FROM `users` LEFT JOIN `sites` ON `sites`.`id` = `users`.`site` GROUP BY sites.name","bindings":[]}]}