{"data":[{"DT_RowId":"row_86","users":{"first_name":"11111111555","last_name":"3","phone":"3","site":"3"},"sites":{"name":"Paris"}},{"DT_RowId":"row_88","users":{"first_name":"\u0e23\u0e38\u0e48\u0e07\u0e42\u0e23\u0e08\u0e19\u0e4c","last_name":"\u0e1e\u0e36\u0e48\u0e07\u0e1c\u0e25","phone":"0818393023","site":"4"},"sites":{"name":"New York"}},{"DT_RowId":"row_89","users":{"first_name":"12","last_name":"","phone":"1234567890","site":"3"},"sites":{"name":"Paris"}},{"DT_RowId":"row_90","users":{"first_name":"","last_name":"","phone":"","site":"18"},"sites":{"name":null}}],"options":{"users.site":[{"label":"New York","value":"4"},{"label":"Paris","value":"3"},{"label":"Pohj","value":"8"},{"label":"Singapore","value":"5"},{"label":"Test","value":"20"},{"label":"rrr","value":"12"},{"label":"sdf","value":"21"},{"label":"test2","value":"22"}]},"files":[],"searchPanes":{"options":{"users.first_name":[{"label":"","total":"1","value":"","count":"1"},{"label":"12","total":"1","value":"12","count":"1"},{"label":"11111111555","total":"1","value":"11111111555","count":"1"},{"label":"\u0e23\u0e38\u0e48\u0e07\u0e42\u0e23\u0e08\u0e19\u0e4c","total":"1","value":"\u0e23\u0e38\u0e48\u0e07\u0e42\u0e23\u0e08\u0e19\u0e4c","count":"1"}],"users.last_name":[{"label":"","total":"2","value":"","count":"2"},{"label":"3","total":"1","value":"3","count":"1"},{"label":"\u0e1e\u0e36\u0e48\u0e07\u0e1c\u0e25","total":"1","value":"\u0e1e\u0e36\u0e48\u0e07\u0e1c\u0e25","count":"1"}],"users.phone":[{"label":"","total":"1","value":"","count":"1"},{"label":"3","total":"1","value":"3","count":"1"},{"label":"0818393023","total":"1","value":"0818393023","count":"1"},{"label":"1234567890","total":"1","value":"1234567890","count":"1"}],"sites.name":[{"label":null,"total":"1","value":null,"count":"1"},{"label":"New York","total":"1","value":"New York","count":"1"},{"label":"Paris","total":"2","value":"Paris","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":[]}]}