{"action":"created","issue":{"url":"https://api.github.com/repos/zariczhu/Comdesign/issues/92","labels_url":"https://api.github.com/repos/zariczhu/Comdesign/issues/92/labels{/name}","comments_url":"https://api.github.com/repos/zariczhu/Comdesign/issues/92/comments","events_url":"https://api.github.com/repos/zariczhu/Comdesign/issues/92/events","html_url":"https://github.com/zariczhu/Comdesign/issues/92","id":103392551,"number":92,"title":"京王観光05038163842 着信呼集計スキル別(着信呼集計v3） skill change","user":{"login":"zariczhu","id":8265166,"avatar_url":"https://avatars.githubusercontent.com/u/8265166?v=3","gravatar_id":"","url":"https://api.github.com/users/zariczhu","html_url":"https://github.com/zariczhu","followers_url":"https://api.github.com/users/zariczhu/followers","following_url":"https://api.github.com/users/zariczhu/following{/other_user}","gists_url":"https://api.github.com/users/zariczhu/gists{/gist_id}","starred_url":"https://api.github.com/users/zariczhu/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/zariczhu/subscriptions","organizations_url":"https://api.github.com/users/zariczhu/orgs","repos_url":"https://api.github.com/users/zariczhu/repos","events_url":"https://api.github.com/users/zariczhu/events{/privacy}","received_events_url":"https://api.github.com/users/zariczhu/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/zariczhu/Comdesign/labels/%E6%B5%85%E9%87%8E%E3%81%95%E3%82%93","name":"浅野さん","color":"bfdadc"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-08-27T00:17:29Z","updated_at":"2015-08-27T00:17:45Z","closed_at":null,"body":"京王観光05038163842で、着信スキルグループの設定が間違っていて、帳票に間違ったスキルグループの値が表示されてしまっているのですが、"},"comment":{"url":"https://api.github.com/repos/zariczhu/Comdesign/issues/comments/135215359","html_url":"https://github.com/zariczhu/Comdesign/issues/92#issuecomment-135215359","issue_url":"https://api.github.com/repos/zariczhu/Comdesign/issues/92","id":135215359,"user":{"login":"zariczhu","id":8265166,"avatar_url":"https://avatars.githubusercontent.com/u/8265166?v=3","gravatar_id":"","url":"https://api.github.com/users/zariczhu","html_url":"https://github.com/zariczhu","followers_url":"https://api.github.com/users/zariczhu/followers","following_url":"https://api.github.com/users/zariczhu/following{/other_user}","gists_url":"https://api.github.com/users/zariczhu/gists{/gist_id}","starred_url":"https://api.github.com/users/zariczhu/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/zariczhu/subscriptions","organizations_url":"https://api.github.com/users/zariczhu/orgs","repos_url":"https://api.github.com/users/zariczhu/repos","events_url":"https://api.github.com/users/zariczhu/events{/privacy}","received_events_url":"https://api.github.com/users/zariczhu/received_events","type":"User","site_admin":false},"created_at":"2015-08-27T00:17:45Z","updated_at":"2015-08-27T00:17:45Z","body":"select call.*\r\ninto tbCpfCallDetailV3Bak\r\nfrom tbCpfCallDetailV3 call \r\ninner join tbCPFGroupPersonalProfile gpp on gpp.iGroupProfileID = call.iGroupID\r\ninner join tbCPFPersonalProfile pp on pp.iPersonalProfileID  = gpp.iPersonalProfileID\r\n\r\nwhere pp.vLogin = '05038163842'\r\nand call.dtCreatedCall between '2015/07/09' and '2015/08/27'\r\nand call.iGroupID in (5990,5991) and call.iSkillGroupID in (5993,5994,5995)"}}