{"comment":{"url":"https://api.github.com/repos/LuyaoC/psrecert/comments/20985736","html_url":"https://github.com/LuyaoC/psrecert/commit/00cb59147e2dfe6e3a86d1a279a6ddcaaa1a3265#commitcomment-20985736","id":20985736,"user":{"login":"LuyaoC","id":20056438,"avatar_url":"https://avatars.githubusercontent.com/u/20056438?v=3","gravatar_id":"","url":"https://api.github.com/users/LuyaoC","html_url":"https://github.com/LuyaoC","followers_url":"https://api.github.com/users/LuyaoC/followers","following_url":"https://api.github.com/users/LuyaoC/following{/other_user}","gists_url":"https://api.github.com/users/LuyaoC/gists{/gist_id}","starred_url":"https://api.github.com/users/LuyaoC/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/LuyaoC/subscriptions","organizations_url":"https://api.github.com/users/LuyaoC/orgs","repos_url":"https://api.github.com/users/LuyaoC/repos","events_url":"https://api.github.com/users/LuyaoC/events{/privacy}","received_events_url":"https://api.github.com/users/LuyaoC/received_events","type":"User","site_admin":false},"position":11,"line":294,"path":"application/models/Psrecert_model.php","commit_id":"00cb59147e2dfe6e3a86d1a279a6ddcaaa1a3265","created_at":"2017-02-22T00:16:20Z","updated_at":"2017-02-22T00:16:20Z","body":"SELECT DISTINCT t2.AGENCY, t2.MODULENAME, t2.SUBMODULENAME, t1.BSCID, t1.LASTSIGNOFF, t1.RECERTYEAR, t2.FULLNAME\r\n                FROM ORADMIN.RECERT_SIGNOFF t1, ORADMIN.RECERT_ASSIGNMENTS t2\r\n                WHERE t1.AGENCY = t2.AGENCY\r\n                AND t1.MODULENAME = t2.MODULENAME\r\n                AND t1.SUBMODULENAME = t2.SUBMODULENAME\r\n"}}
{"actor":{"display_login":"LuyaoC"}}