{"action":"opened","number":2452,"pull_request":{"url":"https://api.github.com/repos/PrestaShop/PrestaShop/pulls/2452","id":28810653,"html_url":"https://github.com/PrestaShop/PrestaShop/pull/2452","diff_url":"https://github.com/PrestaShop/PrestaShop/pull/2452.diff","patch_url":"https://github.com/PrestaShop/PrestaShop/pull/2452.patch","issue_url":"https://api.github.com/repos/PrestaShop/PrestaShop/issues/2452","number":2452,"state":"open","locked":false,"title":"// Sql optimizations","user":{"login":"jeromenadaud","id":4747745,"avatar_url":"https://avatars.githubusercontent.com/u/4747745?v=3","gravatar_id":"","url":"https://api.github.com/users/jeromenadaud","html_url":"https://github.com/jeromenadaud","followers_url":"https://api.github.com/users/jeromenadaud/followers","following_url":"https://api.github.com/users/jeromenadaud/following{/other_user}","gists_url":"https://api.github.com/users/jeromenadaud/gists{/gist_id}","starred_url":"https://api.github.com/users/jeromenadaud/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jeromenadaud/subscriptions","organizations_url":"https://api.github.com/users/jeromenadaud/orgs","repos_url":"https://api.github.com/users/jeromenadaud/repos","events_url":"https://api.github.com/users/jeromenadaud/events{/privacy}","received_events_url":"https://api.github.com/users/jeromenadaud/received_events","type":"User","site_admin":false},"body":"","created_at":"2015-02-06T14:08:42Z","updated_at":"2015-02-06T14:08:42Z","closed_at":null,"merged_at":null,"merge_commit_sha":null,"assignee":null,"milestone":null,"commits_url":"https://api.github.com/repos/PrestaShop/PrestaShop/pulls/2452/commits","review_comments_url":"https://api.github.com/repos/PrestaShop/PrestaShop/pulls/2452/comments","review_comment_url":"https://api.github.com/repos/PrestaShop/PrestaShop/pulls/comments/{number}","comments_url":"https://api.github.com/repos/PrestaShop/PrestaShop/issues/2452/comments","statuses_url":"https://api.github.com/repos/PrestaShop/PrestaShop/statuses/18480a81ac7e1df68d32855c5e7740387a8d2a5c","head":{"label":"jocel1:sql-optimizations","ref":"sql-optimizations","sha":"18480a81ac7e1df68d32855c5e7740387a8d2a5c","user":{"login":"jocel1","id":1429072,"avatar_url":"https://avatars.githubusercontent.com/u/1429072?v=3","gravatar_id":"","url":"https://api.github.com/users/jocel1","html_url":"https://github.com/jocel1","followers_url":"https://api.github.com/users/jocel1/followers","following_url":"https://api.github.com/users/jocel1/following{/other_user}","gists_url":"https://api.github.com/users/jocel1/gists{/gist_id}","starred_url":"https://api.github.com/users/jocel1/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jocel1/subscriptions","organizations_url":"https://api.github.com/users/jocel1/orgs","repos_url":"https://api.github.com/users/jocel1/repos","events_url":"https://api.github.com/users/jocel1/events{/privacy}","received_events_url":"https://api.github.com/users/jocel1/received_events","type":"User","site_admin":false},"repo":{"id":28959759,"name":"PrestaShop","full_name":"jocel1/PrestaShop","owner":{"login":"jocel1","id":1429072,"avatar_url":"https://avatars.githubusercontent.com/u/1429072?v=3","gravatar_id":"","url":"https://api.github.com/users/jocel1","html_url":"https://github.com/jocel1","followers_url":"https://api.github.com/users/jocel1/followers","following_url":"https://api.github.com/users/jocel1/following{/other_user}","gists_url":"https://api.github.com/users/jocel1/gists{/gist_id}","starred_url":"https://api.github.com/users/jocel1/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jocel1/subscriptions","organizations_url":"https://api.github.com/users/jocel1/orgs","repos_url":"https://api.github.com/users/jocel1/repos","events_url":"https://api.github.com/users/jocel1/events{/privacy}","received_events_url":"https://api.github.com/users/jocel1/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/jocel1/PrestaShop","description":"PrestaShop offers a free, fully scalable, Open-source e-commerce solution.","fork":true,"url":"https://api.github.com/repos/jocel1/PrestaShop","forks_url":"https://api.github.com/repos/jocel1/PrestaShop/forks","keys_url":"https://api.github.com/repos/jocel1/PrestaShop/keys{/key_id}","collaborators_url":"https://api.github.com/repos/jocel1/PrestaShop/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/jocel1/PrestaShop/teams","hooks_url":"https://api.github.com/repos/jocel1/PrestaShop/hooks","issue_events_url":"https://api.github.com/repos/jocel1/PrestaShop/issues/events{/number}","events_url":"https://api.github.com/repos/jocel1/PrestaShop/events","assignees_url":"https://api.github.com/repos/jocel1/PrestaShop/assignees{/user}","branches_url":"https://api.github.com/repos/jocel1/PrestaShop/branches{/branch}","tags_url":"https://api.github.com/repos/jocel1/PrestaShop/tags","blobs_url":"https://api.github.com/repos/jocel1/PrestaShop/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/jocel1/PrestaShop/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/jocel1/PrestaShop/git/refs{/sha}","trees_url":"https://api.github.com/repos/jocel1/PrestaShop/git/trees{/sha}","statuses_url":"https://api.github.com/repos/jocel1/PrestaShop/statuses/{sha}","languages_url":"https://api.github.com/repos/jocel1/PrestaShop/languages","stargazers_url":"https://api.github.com/repos/jocel1/PrestaShop/stargazers","contributors_url":"https://api.github.com/repos/jocel1/PrestaShop/contributors","subscribers_url":"https://api.github.com/repos/jocel1/PrestaShop/subscribers","subscription_url":"https://api.github.com/repos/jocel1/PrestaShop/subscription","commits_url":"https://api.github.com/repos/jocel1/PrestaShop/commits{/sha}","git_commits_url":"https://api.github.com/repos/jocel1/PrestaShop/git/commits{/sha}","comments_url":"https://api.github.com/repos/jocel1/PrestaShop/comments{/number}","issue_comment_url":"https://api.github.com/repos/jocel1/PrestaShop/issues/comments/{number}","contents_url":"https://api.github.com/repos/jocel1/PrestaShop/contents/{+path}","compare_url":"https://api.github.com/repos/jocel1/PrestaShop/compare/{base}...{head}","merges_url":"https://api.github.com/repos/jocel1/PrestaShop/merges","archive_url":"https://api.github.com/repos/jocel1/PrestaShop/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/jocel1/PrestaShop/downloads","issues_url":"https://api.github.com/repos/jocel1/PrestaShop/issues{/number}","pulls_url":"https://api.github.com/repos/jocel1/PrestaShop/pulls{/number}","milestones_url":"https://api.github.com/repos/jocel1/PrestaShop/milestones{/number}","notifications_url":"https://api.github.com/repos/jocel1/PrestaShop/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/jocel1/PrestaShop/labels{/name}","releases_url":"https://api.github.com/repos/jocel1/PrestaShop/releases{/id}","created_at":"2015-01-08T09:56:51Z","updated_at":"2015-01-28T00:07:38Z","pushed_at":"2015-02-01T22:42:58Z","git_url":"git://github.com/jocel1/PrestaShop.git","ssh_url":"git@github.com:jocel1/PrestaShop.git","clone_url":"https://github.com/jocel1/PrestaShop.git","svn_url":"https://github.com/jocel1/PrestaShop","homepage":"http://www.prestashop.com/","size":185937,"stargazers_count":0,"watchers_count":0,"language":"PHP","has_issues":false,"has_downloads":true,"has_wiki":false,"has_pages":false,"forks_count":0,"mirror_url":null,"open_issues_count":0,"forks":0,"open_issues":0,"watchers":0,"default_branch":"1.6"}},"base":{"label":"PrestaShop:opti","ref":"opti","sha":"8c48fb0a3706cc580dfa1bd64ad6a38a95cb5323","user":{"login":"PrestaShop","id":2815696,"avatar_url":"https://avatars.githubusercontent.com/u/2815696?v=3","gravatar_id":"","url":"https://api.github.com/users/PrestaShop","html_url":"https://github.com/PrestaShop","followers_url":"https://api.github.com/users/PrestaShop/followers","following_url":"https://api.github.com/users/PrestaShop/following{/other_user}","gists_url":"https://api.github.com/users/PrestaShop/gists{/gist_id}","starred_url":"https://api.github.com/users/PrestaShop/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/PrestaShop/subscriptions","organizations_url":"https://api.github.com/users/PrestaShop/orgs","repos_url":"https://api.github.com/users/PrestaShop/repos","events_url":"https://api.github.com/users/PrestaShop/events{/privacy}","received_events_url":"https://api.github.com/users/PrestaShop/received_events","type":"Organization","site_admin":false},"repo":{"id":6763587,"name":"PrestaShop","full_name":"PrestaShop/PrestaShop","owner":{"login":"PrestaShop","id":2815696,"avatar_url":"https://avatars.githubusercontent.com/u/2815696?v=3","gravatar_id":"","url":"https://api.github.com/users/PrestaShop","html_url":"https://github.com/PrestaShop","followers_url":"https://api.github.com/users/PrestaShop/followers","following_url":"https://api.github.com/users/PrestaShop/following{/other_user}","gists_url":"https://api.github.com/users/PrestaShop/gists{/gist_id}","starred_url":"https://api.github.com/users/PrestaShop/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/PrestaShop/subscriptions","organizations_url":"https://api.github.com/users/PrestaShop/orgs","repos_url":"https://api.github.com/users/PrestaShop/repos","events_url":"https://api.github.com/users/PrestaShop/events{/privacy}","received_events_url":"https://api.github.com/users/PrestaShop/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/PrestaShop/PrestaShop","description":"PrestaShop offers a free, fully scalable, Open-source e-commerce solution.","fork":false,"url":"https://api.github.com/repos/PrestaShop/PrestaShop","forks_url":"https://api.github.com/repos/PrestaShop/PrestaShop/forks","keys_url":"https://api.github.com/repos/PrestaShop/PrestaShop/keys{/key_id}","collaborators_url":"https://api.github.com/repos/PrestaShop/PrestaShop/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/PrestaShop/PrestaShop/teams","hooks_url":"https://api.github.com/repos/PrestaShop/PrestaShop/hooks","issue_events_url":"https://api.github.com/repos/PrestaShop/PrestaShop/issues/events{/number}","events_url":"https://api.github.com/repos/PrestaShop/PrestaShop/events","assignees_url":"https://api.github.com/repos/PrestaShop/PrestaShop/assignees{/user}","branches_url":"https://api.github.com/repos/PrestaShop/PrestaShop/branches{/branch}","tags_url":"https://api.github.com/repos/PrestaShop/PrestaShop/tags","blobs_url":"https://api.github.com/repos/PrestaShop/PrestaShop/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/PrestaShop/PrestaShop/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/PrestaShop/PrestaShop/git/refs{/sha}","trees_url":"https://api.github.com/repos/PrestaShop/PrestaShop/git/trees{/sha}","statuses_url":"https://api.github.com/repos/PrestaShop/PrestaShop/statuses/{sha}","languages_url":"https://api.github.com/repos/PrestaShop/PrestaShop/languages","stargazers_url":"https://api.github.com/repos/PrestaShop/PrestaShop/stargazers","contributors_url":"https://api.github.com/repos/PrestaShop/PrestaShop/contributors","subscribers_url":"https://api.github.com/repos/PrestaShop/PrestaShop/subscribers","subscription_url":"https://api.github.com/repos/PrestaShop/PrestaShop/subscription","commits_url":"https://api.github.com/repos/PrestaShop/PrestaShop/commits{/sha}","git_commits_url":"https://api.github.com/repos/PrestaShop/PrestaShop/git/commits{/sha}","comments_url":"https://api.github.com/repos/PrestaShop/PrestaShop/comments{/number}","issue_comment_url":"https://api.github.com/repos/PrestaShop/PrestaShop/issues/comments/{number}","contents_url":"https://api.github.com/repos/PrestaShop/PrestaShop/contents/{+path}","compare_url":"https://api.github.com/repos/PrestaShop/PrestaShop/compare/{base}...{head}","merges_url":"https://api.github.com/repos/PrestaShop/PrestaShop/merges","archive_url":"https://api.github.com/repos/PrestaShop/PrestaShop/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/PrestaShop/PrestaShop/downloads","issues_url":"https://api.github.com/repos/PrestaShop/PrestaShop/issues{/number}","pulls_url":"https://api.github.com/repos/PrestaShop/PrestaShop/pulls{/number}","milestones_url":"https://api.github.com/repos/PrestaShop/PrestaShop/milestones{/number}","notifications_url":"https://api.github.com/repos/PrestaShop/PrestaShop/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/PrestaShop/PrestaShop/labels{/name}","releases_url":"https://api.github.com/repos/PrestaShop/PrestaShop/releases{/id}","created_at":"2012-11-19T16:41:31Z","updated_at":"2015-02-06T11:42:24Z","pushed_at":"2015-02-06T13:55:05Z","git_url":"git://github.com/PrestaShop/PrestaShop.git","ssh_url":"git@github.com:PrestaShop/PrestaShop.git","clone_url":"https://github.com/PrestaShop/PrestaShop.git","svn_url":"https://github.com/PrestaShop/PrestaShop","homepage":"http://www.prestashop.com/","size":259428,"stargazers_count":1014,"watchers_count":1014,"language":"PHP","has_issues":false,"has_downloads":true,"has_wiki":false,"has_pages":false,"forks_count":1211,"mirror_url":null,"open_issues_count":148,"forks":1211,"open_issues":148,"watchers":1014,"default_branch":"1.6"}},"_links":{"self":{"href":"https://api.github.com/repos/PrestaShop/PrestaShop/pulls/2452"},"html":{"href":"https://github.com/PrestaShop/PrestaShop/pull/2452"},"issue":{"href":"https://api.github.com/repos/PrestaShop/PrestaShop/issues/2452"},"comments":{"href":"https://api.github.com/repos/PrestaShop/PrestaShop/issues/2452/comments"},"review_comments":{"href":"https://api.github.com/repos/PrestaShop/PrestaShop/pulls/2452/comments"},"review_comment":{"href":"https://api.github.com/repos/PrestaShop/PrestaShop/pulls/comments/{number}"},"commits":{"href":"https://api.github.com/repos/PrestaShop/PrestaShop/pulls/2452/commits"},"statuses":{"href":"https://api.github.com/repos/PrestaShop/PrestaShop/statuses/18480a81ac7e1df68d32855c5e7740387a8d2a5c"}},"merged":false,"mergeable":null,"mergeable_state":"unknown","merged_by":null,"comments":0,"review_comments":0,"commits":36,"additions":439,"deletions":365,"changed_files":47}}