{"number":30,"pull_request":{"number":30,"issue_url":"https://github.com/whiteoctober/Pagerfanta/issues/30","head":{"label":"crackcomm:patch-1","repo":{"master_branch":null,"name":"Pagerfanta","created_at":"2011-10-18T15:28:19Z","size":140,"clone_url":"https://github.com/crackcomm/Pagerfanta.git","private":false,"updated_at":"2011-10-18T15:29:57Z","watchers":1,"ssh_url":"git@github.com:crackcomm/Pagerfanta.git","url":"https://api.github.com/repos/crackcomm/Pagerfanta","git_url":"git://github.com/crackcomm/Pagerfanta.git","language":"PHP","fork":true,"svn_url":"https://svn.github.com/crackcomm/Pagerfanta","id":2599802,"pushed_at":"2011-10-18T15:29:52Z","open_issues":0,"homepage":"","description":"","forks":0,"html_url":"https://github.com/crackcomm/Pagerfanta","owner":{"avatar_url":"https://secure.gravatar.com/avatar/de1d68f9442a25ab7c923c4dcf13969d?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","gravatar_id":"de1d68f9442a25ab7c923c4dcf13969d","url":"https://api.github.com/users/crackcomm","id":206368,"login":"crackcomm"}},"sha":"011c2a23c831cdf0efe01cdde036d296eb20de35","ref":"patch-1","user":{"avatar_url":"https://secure.gravatar.com/avatar/de1d68f9442a25ab7c923c4dcf13969d?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","gravatar_id":"de1d68f9442a25ab7c923c4dcf13969d","url":"https://api.github.com/users/crackcomm","id":206368,"login":"crackcomm"}},"merged_by":null,"created_at":"2011-10-18T15:30:57Z","changed_files":1,"merged":false,"body":"It doesn't affect results but it's much faster. I'm not sure that regex is good (for all cases) but it's working for me.","comments":0,"title":"Remove JOIN from DoctrineORMAdapter::getNbResults()","additions":2,"diff_url":"https://github.com/whiteoctober/Pagerfanta/pull/30.diff","updated_at":"2011-10-18T15:30:57Z","url":"https://api.github.com/repos/whiteoctober/Pagerfanta/pulls/30","id":411848,"patch_url":"https://github.com/whiteoctober/Pagerfanta/pull/30.patch","mergeable":null,"merged_at":null,"commits":1,"closed_at":null,"user":{"avatar_url":"https://secure.gravatar.com/avatar/de1d68f9442a25ab7c923c4dcf13969d?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","gravatar_id":"de1d68f9442a25ab7c923c4dcf13969d","url":"https://api.github.com/users/crackcomm","id":206368,"login":"crackcomm"},"deletions":0,"html_url":"https://github.com/whiteoctober/Pagerfanta/pull/30","base":{"label":"whiteoctober:master","repo":{"master_branch":null,"name":"Pagerfanta","created_at":"2011-04-26T18:55:28Z","size":292,"clone_url":"https://github.com/whiteoctober/Pagerfanta.git","private":false,"updated_at":"2011-10-18T15:30:57Z","watchers":68,"ssh_url":"git@github.com:whiteoctober/Pagerfanta.git","url":"https://api.github.com/repos/whiteoctober/Pagerfanta","git_url":"git://github.com/whiteoctober/Pagerfanta.git","language":"PHP","fork":false,"svn_url":"https://svn.github.com/whiteoctober/Pagerfanta","id":1666651,"pushed_at":"2011-10-18T15:30:57Z","open_issues":3,"homepage":"","description":"","forks":16,"html_url":"https://github.com/whiteoctober/Pagerfanta","owner":{"avatar_url":"https://secure.gravatar.com/avatar/9bf5adc2d1dcbb9d140a7a9ce1c468ba?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-orgs.png","gravatar_id":"9bf5adc2d1dcbb9d140a7a9ce1c468ba","url":"https://api.github.com/users/whiteoctober","id":595822,"login":"whiteoctober"}},"sha":"62bc2c0a90480c8b4f0eb4d634e6fce0338282aa","ref":"master","user":{"avatar_url":"https://secure.gravatar.com/avatar/9bf5adc2d1dcbb9d140a7a9ce1c468ba?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-orgs.png","gravatar_id":"9bf5adc2d1dcbb9d140a7a9ce1c468ba","url":"https://api.github.com/users/whiteoctober","id":595822,"login":"whiteoctober"}},"state":"open"},"action":"opened"}