{"action":"opened","issue":{"url":"https://api.github.com/repos/RhubarbPHP/Module.Stem/issues/5","labels_url":"https://api.github.com/repos/RhubarbPHP/Module.Stem/issues/5/labels{/name}","comments_url":"https://api.github.com/repos/RhubarbPHP/Module.Stem/issues/5/comments","events_url":"https://api.github.com/repos/RhubarbPHP/Module.Stem/issues/5/events","html_url":"https://github.com/RhubarbPHP/Module.Stem/issues/5","id":57859100,"number":5,"title":"Filtering by sub query","user":{"login":"acuthbert","id":408400,"avatar_url":"https://avatars.githubusercontent.com/u/408400?v=3","gravatar_id":"","url":"https://api.github.com/users/acuthbert","html_url":"https://github.com/acuthbert","followers_url":"https://api.github.com/users/acuthbert/followers","following_url":"https://api.github.com/users/acuthbert/following{/other_user}","gists_url":"https://api.github.com/users/acuthbert/gists{/gist_id}","starred_url":"https://api.github.com/users/acuthbert/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/acuthbert/subscriptions","organizations_url":"https://api.github.com/users/acuthbert/orgs","repos_url":"https://api.github.com/users/acuthbert/repos","events_url":"https://api.github.com/users/acuthbert/events{/privacy}","received_events_url":"https://api.github.com/users/acuthbert/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/RhubarbPHP/Module.Stem/labels/enhancement","name":"enhancement","color":"84b6eb"}],"state":"open","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/RhubarbPHP/Module.Stem/milestones/1","labels_url":"https://api.github.com/repos/RhubarbPHP/Module.Stem/milestones/1/labels","id":982006,"number":1,"title":"1.0","description":"","creator":{"login":"acuthbert","id":408400,"avatar_url":"https://avatars.githubusercontent.com/u/408400?v=3","gravatar_id":"","url":"https://api.github.com/users/acuthbert","html_url":"https://github.com/acuthbert","followers_url":"https://api.github.com/users/acuthbert/followers","following_url":"https://api.github.com/users/acuthbert/following{/other_user}","gists_url":"https://api.github.com/users/acuthbert/gists{/gist_id}","starred_url":"https://api.github.com/users/acuthbert/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/acuthbert/subscriptions","organizations_url":"https://api.github.com/users/acuthbert/orgs","repos_url":"https://api.github.com/users/acuthbert/repos","events_url":"https://api.github.com/users/acuthbert/events{/privacy}","received_events_url":"https://api.github.com/users/acuthbert/received_events","type":"User","site_admin":false},"open_issues":4,"closed_issues":0,"state":"open","created_at":"2015-02-16T22:24:01Z","updated_at":"2015-02-16T22:32:24Z","due_on":"2015-04-29T23:00:00Z","closed_at":null},"comments":0,"created_at":"2015-02-16T22:32:24Z","updated_at":"2015-02-16T22:32:24Z","closed_at":null,"body":"We need a filter that matches for rows found in another collection. For repositories that support joins this could be handled by doing a JOIN with a GROUP BY."}}