{"table":{"info":"inform_information","file":"inform_attachments","users":"users","category":"","type":"inform_type","level":"inform_level","damage":"inform_damage"},"request":{"start_date":"","end_date":""},"rankList":[{"id":"6","subject":"\u0e02\u0e2d\u0e16\u0e31\u0e07\u0e02\u0e22\u0e30\/\u0e41\u0e08\u0e49\u0e07\u0e40\u0e01\u0e47\u0e1a\u0e02\u0e22\u0e30","sumInform":"2523"},{"id":"8","subject":"\u0e2d\u0e37\u0e48\u0e19\u0e46","sumInform":"1425"},{"id":"3","subject":"\u0e16\u0e19\u0e19\/\u0e17\u0e32\u0e07\u0e40\u0e17\u0e49\u0e32\u0e0a\u0e33\u0e23\u0e38\u0e14","sumInform":"1228"},{"id":"1","subject":"\u0e44\u0e1f\u0e1f\u0e49\u0e32\u0e2a\u0e32\u0e18\u0e32\u0e23\u0e13\u0e30","sumInform":"1202"},{"id":"22","subject":"\u0e01\u0e35\u0e14\u0e02\u0e27\u0e32\u0e07\u0e16\u0e19\u0e19\/\u0e17\u0e32\u0e07\u0e40\u0e17\u0e49\u0e32","sumInform":"1032"},{"id":"7","subject":"\u0e41\u0e08\u0e49\u0e07\u0e40\u0e2b\u0e15\u0e38\u0e23\u0e33\u0e04\u0e32\u0e0d","sumInform":"863"},{"id":"14","subject":"\u0e01\u0e25\u0e34\u0e48\u0e19\u0e04\u0e27\u0e31\u0e19\/\u0e40\u0e2a\u0e35\u0e22\u0e07\u0e23\u0e1a\u0e01\u0e27\u0e19","sumInform":"663"},{"id":"17","subject":"\u0e15\u0e31\u0e14\u0e15\u0e49\u0e19\u0e44\u0e21\u0e49","sumInform":"451"},{"id":"9","subject":"\u0e1d\u0e32\u0e17\u0e48\u0e2d\u0e23\u0e30\u0e1a\u0e32\u0e22\u0e19\u0e49\u0e33\u0e0a\u0e33\u0e23\u0e38\u0e14","sumInform":"412"},{"id":"19","subject":"\u0e2a\u0e38\u0e19\u0e31\u0e02\u0e08\u0e23\u0e08\u0e31\u0e14","sumInform":"405"},{"id":"11","subject":"\u0e2d\u0e32\u0e04\u0e32\u0e23","sumInform":"381"},{"id":"2","subject":"\u0e17\u0e48\u0e2d\u0e23\u0e30\u0e1a\u0e32\u0e22\u0e19\u0e49\u0e33","sumInform":"334"},{"id":"23","subject":"\u0e19\u0e49\u0e33\u0e17\u0e48\u0e27\u0e21","sumInform":"273"},{"id":"10","subject":"\u0e02\u0e32\u0e22\u0e02\u0e2d\u0e07\u0e1a\u0e19\u0e17\u0e32\u0e07\u0e40\u0e17\u0e49\u0e32","sumInform":"248"},{"id":"13","subject":"\u0e1e\u0e48\u0e19\u0e22\u0e38\u0e07","sumInform":"181"},{"id":"16","subject":"\u0e20\u0e32\u0e29\u0e35\u0e41\u0e25\u0e30\u0e04\u0e48\u0e32\u0e18\u0e23\u0e23\u0e21\u0e40\u0e19\u0e35\u0e22\u0e21","sumInform":"102"},{"id":"18","subject":"\u0e25\u0e2d\u0e01\u0e04\u0e25\u0e2d\u0e07","sumInform":"99"},{"id":"4","subject":"\u0e19\u0e49\u0e33\u0e40\u0e2a\u0e35\u0e22","sumInform":"83"},{"id":"20","subject":"\u0e41\u0e08\u0e49\u0e07\u0e0b\u0e48\u0e2d\u0e21\u0e1b\u0e49\u0e32\u0e22\u0e0b\u0e2d\u0e22","sumInform":"69"},{"id":"21","subject":"\u0e02\u0e38\u0e14\u0e14\u0e34\u0e19\/\u0e16\u0e21\u0e14\u0e34\u0e19","sumInform":"59"},{"id":"15","subject":"\u0e41\u0e08\u0e49\u0e07\u0e01\u0e32\u0e23\u0e17\u0e38\u0e08\u0e23\u0e34\u0e15\u0e02\u0e2d\u0e07\u0e40\u0e08\u0e49\u0e32\u0e2b\u0e19\u0e49\u0e32\u0e17\u0e35\u0e48\/\u0e1e\u0e19\u0e31\u0e01\u0e07\u0e32\u0e19","sumInform":"17"},{"id":"24","subject":"\u0e23\u0e49\u0e2d\u0e07\u0e40\u0e23\u0e35\u0e22\u0e19\u0e23\u0e49\u0e2d\u0e07\u0e17\u0e38\u0e01\u0e02\u0e4c(\u0e28\u0e14\u0e18.)","sumInform":"0"}],"sql":"<pre>SELECT t.id,t.subject , (SELECT COUNT(id) FROM inform_information WHERE local_id ='1' AND status != '2' AND cid = t.id ) AS sumInform\n        FROM inform_type AS t \n        WHERE t.local_id ='1' \n        AND t.status != '2'\n        ORDER BY sumInform DESC<\/pre>"}