{"action":"created","issue":{"url":"https://api.github.com/repos/fjordllc/bootcamp/issues/635","repository_url":"https://api.github.com/repos/fjordllc/bootcamp","labels_url":"https://api.github.com/repos/fjordllc/bootcamp/issues/635/labels{/name}","comments_url":"https://api.github.com/repos/fjordllc/bootcamp/issues/635/comments","events_url":"https://api.github.com/repos/fjordllc/bootcamp/issues/635/events","html_url":"https://github.com/fjordllc/bootcamp/pull/635","id":383013242,"node_id":"MDExOlB1bGxSZXF1ZXN0MjMyNTgxMTI0","number":635,"title":"通知の中で同じURLのものが複数あったら、一つにまとめたい","user":{"login":"ycoda","id":3740249,"node_id":"MDQ6VXNlcjM3NDAyNDk=","avatar_url":"https://avatars1.githubusercontent.com/u/3740249?v=4","gravatar_id":"","url":"https://api.github.com/users/ycoda","html_url":"https://github.com/ycoda","followers_url":"https://api.github.com/users/ycoda/followers","following_url":"https://api.github.com/users/ycoda/following{/other_user}","gists_url":"https://api.github.com/users/ycoda/gists{/gist_id}","starred_url":"https://api.github.com/users/ycoda/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ycoda/subscriptions","organizations_url":"https://api.github.com/users/ycoda/orgs","repos_url":"https://api.github.com/users/ycoda/repos","events_url":"https://api.github.com/users/ycoda/events{/privacy}","received_events_url":"https://api.github.com/users/ycoda/received_events","type":"User","site_admin":false},"labels":[{"id":1004348358,"node_id":"MDU6TGFiZWwxMDA0MzQ4MzU4","url":"https://api.github.com/repos/fjordllc/bootcamp/labels/WIP","name":"WIP","color":"e99695","default":false}],"state":"open","locked":false,"assignee":{"login":"ycoda","id":3740249,"node_id":"MDQ6VXNlcjM3NDAyNDk=","avatar_url":"https://avatars1.githubusercontent.com/u/3740249?v=4","gravatar_id":"","url":"https://api.github.com/users/ycoda","html_url":"https://github.com/ycoda","followers_url":"https://api.github.com/users/ycoda/followers","following_url":"https://api.github.com/users/ycoda/following{/other_user}","gists_url":"https://api.github.com/users/ycoda/gists{/gist_id}","starred_url":"https://api.github.com/users/ycoda/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ycoda/subscriptions","organizations_url":"https://api.github.com/users/ycoda/orgs","repos_url":"https://api.github.com/users/ycoda/repos","events_url":"https://api.github.com/users/ycoda/events{/privacy}","received_events_url":"https://api.github.com/users/ycoda/received_events","type":"User","site_admin":false},"assignees":[{"login":"ycoda","id":3740249,"node_id":"MDQ6VXNlcjM3NDAyNDk=","avatar_url":"https://avatars1.githubusercontent.com/u/3740249?v=4","gravatar_id":"","url":"https://api.github.com/users/ycoda","html_url":"https://github.com/ycoda","followers_url":"https://api.github.com/users/ycoda/followers","following_url":"https://api.github.com/users/ycoda/following{/other_user}","gists_url":"https://api.github.com/users/ycoda/gists{/gist_id}","starred_url":"https://api.github.com/users/ycoda/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ycoda/subscriptions","organizations_url":"https://api.github.com/users/ycoda/orgs","repos_url":"https://api.github.com/users/ycoda/repos","events_url":"https://api.github.com/users/ycoda/events{/privacy}","received_events_url":"https://api.github.com/users/ycoda/received_events","type":"User","site_admin":false}],"milestone":null,"comments":11,"created_at":"2018-11-21T08:50:38Z","updated_at":"2018-11-27T02:00:27Z","closed_at":null,"author_association":"CONTRIBUTOR","pull_request":{"url":"https://api.github.com/repos/fjordllc/bootcamp/pulls/635","html_url":"https://github.com/fjordllc/bootcamp/pull/635","diff_url":"https://github.com/fjordllc/bootcamp/pull/635.diff","patch_url":"https://github.com/fjordllc/bootcamp/pull/635.patch"},"body":"fixes #564"},"comment":{"url":"https://api.github.com/repos/fjordllc/bootcamp/issues/comments/441869503","html_url":"https://github.com/fjordllc/bootcamp/pull/635#issuecomment-441869503","issue_url":"https://api.github.com/repos/fjordllc/bootcamp/issues/635","id":441869503,"node_id":"MDEyOklzc3VlQ29tbWVudDQ0MTg2OTUwMw==","user":{"login":"ycoda","id":3740249,"node_id":"MDQ6VXNlcjM3NDAyNDk=","avatar_url":"https://avatars1.githubusercontent.com/u/3740249?v=4","gravatar_id":"","url":"https://api.github.com/users/ycoda","html_url":"https://github.com/ycoda","followers_url":"https://api.github.com/users/ycoda/followers","following_url":"https://api.github.com/users/ycoda/following{/other_user}","gists_url":"https://api.github.com/users/ycoda/gists{/gist_id}","starred_url":"https://api.github.com/users/ycoda/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ycoda/subscriptions","organizations_url":"https://api.github.com/users/ycoda/orgs","repos_url":"https://api.github.com/users/ycoda/repos","events_url":"https://api.github.com/users/ycoda/events{/privacy}","received_events_url":"https://api.github.com/users/ycoda/received_events","type":"User","site_admin":false},"created_at":"2018-11-27T02:00:27Z","updated_at":"2018-11-27T02:00:27Z","author_association":"CONTRIBUTOR","body":"@bluerabbit \r\n> subqueryは２つに分割できます。\r\n\r\nSQLを書いて説明して頂き、ありがとうございます。\r\n\r\n`and (path, created_at) IN (?, ?);`\r\nこのように書けることを知りませんでした。\r\nこれで `path` と `created_at` が受け取れることが理解できました。\r\n\r\n> group by pathの時点でdistinctは不要です。\r\n\r\nもう一度、確認してみます。\r\n\r\n> 好みの差ですが、SQLを書く時に一貫性がある方が読みやすいです。\r\n\r\n予約語と関数を大文字にして書くことにします。\r\nありがとうございます。"}}
{"actor":{"display_login":"ycoda"}}