{"now":"2025-01-11 20:50:25","code":"OK","message":"","result":{"sql":"SELECT `sp` `domain`, COUNT(`sp`) `count`\nFROM (\n SELECT `sp`, `user`\n FROM `access_user`\n WHERE `sp` LIKE '%th'\n  AND (`time` >= NOW() - INTERVAL 1 DAY)\n  AND `accept`>0 AND `user`<>'eduroam@eduroam-mon.uni.net.th'\n GROUP BY `user`) `access_user`\nGROUP BY `sp`\nORDER BY `count` DESC;","count":55,"list":[{"domain":"chula.ac.th","count":660},{"domain":"tu.ac.th","count":203},{"domain":"cmu.ac.th","count":157},{"domain":"kku.ac.th","count":116},{"domain":"ku.ac.th","count":103},{"domain":"su.ac.th","count":99},{"domain":"nstda.or.th","count":51},{"domain":"kmitl.ac.th","count":48},{"domain":"msu.ac.th","count":42},{"domain":"cmkl.ac.th","count":38},{"domain":"rmutp.ac.th","count":35},{"domain":"kmutt.ac.th","count":30},{"domain":"swu.ac.th","count":29},{"domain":"psu.ac.th","count":28},{"domain":"sut.ac.th","count":28},{"domain":"ru.ac.th","count":26},{"domain":"cdti.ac.th","count":25},{"domain":"buu.ac.th","count":22},{"domain":"rmutk.ac.th","count":14},{"domain":"nida.ac.th","count":14},{"domain":"up.ac.th","count":9},{"domain":"cri.or.th","count":9},{"domain":"rmutsb.ac.th","count":8},{"domain":"rmutr.ac.th","count":8},{"domain":"uni.net.th","count":7},{"domain":"dru.ac.th","count":7},{"domain":"udru.ac.th","count":6},{"domain":"snru.ac.th","count":6},{"domain":"rmuti.ac.th","count":6},{"domain":"rmutt.ac.th","count":6},{"domain":"siamu.ac.th","count":5},{"domain":"wu.ac.th","count":5},{"domain":"mfu.ac.th","count":5},{"domain":"rmu.ac.th","count":4},{"domain":"pkru.ac.th","count":4},{"domain":"stou.ac.th","count":4},{"domain":"yru.ac.th","count":4},{"domain":"rmutsv.ac.th","count":3},{"domain":"psru.ac.th","count":3},{"domain":"ubru.ac.th","count":3},{"domain":"lpru.ac.th","count":2},{"domain":"tru.ac.th","count":2},{"domain":"ubu.ac.th","count":2},{"domain":"npu.ac.th","count":2},{"domain":"nu.ac.th","count":2},{"domain":"nrru.ac.th","count":2},{"domain":"sru.ac.th","count":2},{"domain":"tsu.ac.th","count":1},{"domain":"bkkthon.ac.th","count":1},{"domain":"nsm.or.th","count":1},{"domain":"mju.ac.th","count":1},{"domain":"nxpo.or.th","count":1},{"domain":"mahidol.ac.th","count":1},{"domain":"lru.ac.th","count":1},{"domain":"srru.ac.th","count":1}]}}