{"action":"created","issue":{"url":"https://api.github.com/repos/xbmc/xbmc/issues/6538","labels_url":"https://api.github.com/repos/xbmc/xbmc/issues/6538/labels{/name}","comments_url":"https://api.github.com/repos/xbmc/xbmc/issues/6538/comments","events_url":"https://api.github.com/repos/xbmc/xbmc/issues/6538/events","html_url":"https://github.com/xbmc/xbmc/pull/6538","id":58751111,"number":6538,"title":"[videodatabase] made some SQL statements more readable","user":{"login":"Rechi","id":5367567,"avatar_url":"https://avatars.githubusercontent.com/u/5367567?v=3","gravatar_id":"","url":"https://api.github.com/users/Rechi","html_url":"https://github.com/Rechi","followers_url":"https://api.github.com/users/Rechi/followers","following_url":"https://api.github.com/users/Rechi/following{/other_user}","gists_url":"https://api.github.com/users/Rechi/gists{/gist_id}","starred_url":"https://api.github.com/users/Rechi/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Rechi/subscriptions","organizations_url":"https://api.github.com/users/Rechi/orgs","repos_url":"https://api.github.com/users/Rechi/repos","events_url":"https://api.github.com/users/Rechi/events{/privacy}","received_events_url":"https://api.github.com/users/Rechi/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-02-24T15:06:43Z","updated_at":"2015-02-25T07:44:03Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/xbmc/xbmc/pulls/6538","html_url":"https://github.com/xbmc/xbmc/pull/6538","diff_url":"https://github.com/xbmc/xbmc/pull/6538.diff","patch_url":"https://github.com/xbmc/xbmc/pull/6538.patch"},"body":"replaced implicit joins with explicit joins and some 'join on' with 'join using'"},"comment":{"url":"https://api.github.com/repos/xbmc/xbmc/issues/comments/75918524","html_url":"https://github.com/xbmc/xbmc/pull/6538#issuecomment-75918524","issue_url":"https://api.github.com/repos/xbmc/xbmc/issues/6538","id":75918524,"user":{"login":"mkortstiege","id":475281,"avatar_url":"https://avatars.githubusercontent.com/u/475281?v=3","gravatar_id":"","url":"https://api.github.com/users/mkortstiege","html_url":"https://github.com/mkortstiege","followers_url":"https://api.github.com/users/mkortstiege/followers","following_url":"https://api.github.com/users/mkortstiege/following{/other_user}","gists_url":"https://api.github.com/users/mkortstiege/gists{/gist_id}","starred_url":"https://api.github.com/users/mkortstiege/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mkortstiege/subscriptions","organizations_url":"https://api.github.com/users/mkortstiege/orgs","repos_url":"https://api.github.com/users/mkortstiege/repos","events_url":"https://api.github.com/users/mkortstiege/events{/privacy}","received_events_url":"https://api.github.com/users/mkortstiege/received_events","type":"User","site_admin":false},"created_at":"2015-02-25T07:44:03Z","updated_at":"2015-02-25T07:44:03Z","body":"Looks good. @xhaggi since you're more familiar with SQL mind having a look as well?"}}