{"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":"23","subject":"\u0e44\u0e1f\u0e1f\u0e49\u0e32\u0e2a\u0e32\u0e18\u0e32\u0e23\u0e13\u0e30","sumInform":"1"},{"id":"30","subject":"\u0e02\u0e32\u0e22\u0e02\u0e2d\u0e07\u0e1a\u0e19\u0e17\u0e32\u0e07\u0e40\u0e17\u0e49\u0e32","sumInform":"0"},{"id":"31","subject":"\u0e15\u0e23\u0e27\u0e08\u0e2a\u0e2d\u0e1a\u0e2d\u0e32\u0e04\u0e32\u0e23","sumInform":"0"},{"id":"32","subject":"\u0e1e\u0e48\u0e19\u0e22\u0e38\u0e07","sumInform":"0"},{"id":"33","subject":"\u0e01\u0e25\u0e34\u0e48\u0e19\u0e04\u0e27\u0e31\u0e19\/\u0e40\u0e2a\u0e35\u0e22\u0e07\u0e23\u0e1a\u0e01\u0e27\u0e19","sumInform":"0"},{"id":"34","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":"35","subject":"\u0e20\u0e32\u0e29\u0e35\u0e41\u0e25\u0e30\u0e04\u0e48\u0e32\u0e18\u0e23\u0e23\u0e21\u0e40\u0e19\u0e35\u0e22\u0e21","sumInform":"0"},{"id":"36","subject":"\u0e15\u0e31\u0e14\u0e15\u0e49\u0e19\u0e44\u0e21\u0e49","sumInform":"0"},{"id":"37","subject":"\u0e2a\u0e38\u0e19\u0e31\u0e02\u0e08\u0e23\u0e08\u0e31\u0e14","sumInform":"0"},{"id":"38","subject":"\u0e02\u0e2d\u0e16\u0e31\u0e07\u0e02\u0e22\u0e30\/\u0e41\u0e08\u0e49\u0e07\u0e40\u0e01\u0e47\u0e1a\u0e02\u0e22\u0e30","sumInform":"0"},{"id":"22","subject":"\u0e2d\u0e37\u0e48\u0e19\u0e46","sumInform":"0"},{"id":"24","subject":"\u0e17\u0e48\u0e2d\u0e23\u0e30\u0e1a\u0e32\u0e22\u0e19\u0e49\u0e33","sumInform":"0"},{"id":"25","subject":"\u0e16\u0e19\u0e19\/\u0e17\u0e32\u0e07\u0e40\u0e17\u0e49\u0e32","sumInform":"0"},{"id":"26","subject":"\u0e19\u0e49\u0e33\u0e40\u0e2a\u0e35\u0e22","sumInform":"0"},{"id":"27","subject":"\u0e14\u0e39\u0e14\u0e2a\u0e34\u0e48\u0e07\u0e1b\u0e0f\u0e34\u0e01\u0e39\u0e25","sumInform":"0"},{"id":"28","subject":"\u0e41\u0e08\u0e49\u0e07\u0e40\u0e2b\u0e15\u0e38\u0e23\u0e33\u0e04\u0e32\u0e0d","sumInform":"0"}],"sql":"<pre>SELECT t.id,t.subject , (SELECT COUNT(id) FROM inform_information WHERE local_id ='2' 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='2'\n            AND \t\tt.parent_id = '1'\n        ORDER BY sumInform DESC<\/pre>"}