{"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":"2","subject":"\u0e44\u0e1f\u0e1f\u0e49\u0e32\u0e2a\u0e32\u0e18\u0e32\u0e23\u0e13\u0e30","sumInform":"7"},{"id":"11","subject":"\u0e1e\u0e48\u0e19\u0e22\u0e38\u0e07","sumInform":"3"},{"id":"19","subject":"\u0e2d\u0e37\u0e48\u0e19\u0e46","sumInform":"3"},{"id":"12","subject":"\u0e01\u0e25\u0e34\u0e48\u0e19\u0e04\u0e27\u0e31\u0e19\/\u0e40\u0e2a\u0e35\u0e22\u0e07\u0e23\u0e1a\u0e01\u0e27\u0e19","sumInform":"2"},{"id":"4","subject":"\u0e16\u0e19\u0e19\/\u0e17\u0e32\u0e07\u0e40\u0e17\u0e49\u0e32","sumInform":"2"},{"id":"7","subject":"\u0e41\u0e08\u0e49\u0e07\u0e40\u0e2b\u0e15\u0e38\u0e23\u0e33\u0e04\u0e32\u0e0d","sumInform":"1"},{"id":"18","subject":"\u0e02\u0e2d\u0e16\u0e31\u0e07\u0e02\u0e22\u0e30\/\u0e41\u0e08\u0e49\u0e07\u0e40\u0e01\u0e47\u0e1a\u0e02\u0e22\u0e30","sumInform":"1"},{"id":"3","subject":"\u0e17\u0e48\u0e2d\u0e23\u0e30\u0e1a\u0e32\u0e22\u0e19\u0e49\u0e33","sumInform":"1"},{"id":"17","subject":"\u0e2a\u0e38\u0e19\u0e31\u0e02\u0e08\u0e23\u0e08\u0e31\u0e14","sumInform":"0"},{"id":"16","subject":"\u0e25\u0e2d\u0e01\u0e04\u0e25\u0e2d\u0e07","sumInform":"0"},{"id":"15","subject":"\u0e15\u0e31\u0e14\u0e15\u0e49\u0e19\u0e44\u0e21\u0e49","sumInform":"0"},{"id":"14","subject":"\u0e20\u0e32\u0e29\u0e35\u0e41\u0e25\u0e30\u0e04\u0e48\u0e32\u0e18\u0e23\u0e23\u0e21\u0e40\u0e19\u0e35\u0e22\u0e21","sumInform":"0"},{"id":"13","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":"0"},{"id":"5","subject":"\u0e19\u0e49\u0e33\u0e40\u0e2a\u0e35\u0e22","sumInform":"0"},{"id":"10","subject":"\u0e15\u0e23\u0e27\u0e08\u0e2a\u0e2d\u0e1a\u0e2d\u0e32\u0e04\u0e32\u0e23","sumInform":"0"},{"id":"9","subject":"\u0e02\u0e32\u0e22\u0e02\u0e2d\u0e07\u0e1a\u0e19\u0e17\u0e32\u0e07\u0e40\u0e17\u0e49\u0e32","sumInform":"0"},{"id":"8","subject":"\u0e1d\u0e32\u0e17\u0e48\u0e2d\u0e23\u0e30\u0e1a\u0e32\u0e22\u0e19\u0e49\u0e33","sumInform":"0"},{"id":"6","subject":"\u0e14\u0e39\u0e14\u0e2a\u0e34\u0e48\u0e07\u0e1b\u0e0f\u0e34\u0e01\u0e39\u0e25","sumInform":"0"}],"sql":"<pre>SELECT t.id,t.subject , (SELECT COUNT(id) FROM inform_information WHERE local_id ='10' AND status != '2' AND cid = t.id ) AS sumInform\n        FROM inform_type AS t \n        WHERE    t.status = '1' \n            AND \t\tt.local_id='10'\n            AND \t\tt.parent_id = '1'\n        ORDER BY sumInform DESC<\/pre>"}