{"action":"created","issue":{"url":"https://api.github.com/repos/phalcon/cphalcon/issues/496","labels_url":"https://api.github.com/repos/phalcon/cphalcon/issues/496/labels{/name}","comments_url":"https://api.github.com/repos/phalcon/cphalcon/issues/496/comments","events_url":"https://api.github.com/repos/phalcon/cphalcon/issues/496/events","html_url":"https://github.com/phalcon/cphalcon/issues/496","id":12237978,"number":496,"title":"[NFR] Subqueries in PHQL","user":{"login":"hugoduraes","id":1050268,"avatar_url":"https://avatars.githubusercontent.com/u/1050268?v=3","gravatar_id":"","url":"https://api.github.com/users/hugoduraes","html_url":"https://github.com/hugoduraes","followers_url":"https://api.github.com/users/hugoduraes/followers","following_url":"https://api.github.com/users/hugoduraes/following{/other_user}","gists_url":"https://api.github.com/users/hugoduraes/gists{/gist_id}","starred_url":"https://api.github.com/users/hugoduraes/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hugoduraes/subscriptions","organizations_url":"https://api.github.com/users/hugoduraes/orgs","repos_url":"https://api.github.com/users/hugoduraes/repos","events_url":"https://api.github.com/users/hugoduraes/events{/privacy}","received_events_url":"https://api.github.com/users/hugoduraes/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/phalcon/cphalcon/labels/Feature","name":"Feature","color":"0b02e1"}],"state":"open","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/phalcon/cphalcon/milestones/12","html_url":"https://github.com/phalcon/cphalcon/milestones/1.3.0","labels_url":"https://api.github.com/repos/phalcon/cphalcon/milestones/12/labels","id":366688,"number":12,"title":"1.3.0","description":"","creator":{"login":"phalcon","id":1221505,"avatar_url":"https://avatars.githubusercontent.com/u/1221505?v=3","gravatar_id":"","url":"https://api.github.com/users/phalcon","html_url":"https://github.com/phalcon","followers_url":"https://api.github.com/users/phalcon/followers","following_url":"https://api.github.com/users/phalcon/following{/other_user}","gists_url":"https://api.github.com/users/phalcon/gists{/gist_id}","starred_url":"https://api.github.com/users/phalcon/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/phalcon/subscriptions","organizations_url":"https://api.github.com/users/phalcon/orgs","repos_url":"https://api.github.com/users/phalcon/repos","events_url":"https://api.github.com/users/phalcon/events{/privacy}","received_events_url":"https://api.github.com/users/phalcon/received_events","type":"User","site_admin":false},"open_issues":4,"closed_issues":5,"state":"closed","created_at":"2013-06-28T20:19:23Z","updated_at":"2014-11-13T20:13:02Z","due_on":"2013-09-03T07:00:00Z","closed_at":"2014-11-13T20:13:02Z"},"comments":62,"created_at":"2013-03-20T17:16:04Z","updated_at":"2015-03-27T06:45:42Z","closed_at":null,"body":"Subqueries aren't still supported in PHQL. It would be nice to be able to do it instead of using raw sql.\r\n\r\n<bountysource-plugin>\r\n---\r\nWant to back this issue? **[Post a bounty on it!](https://www.bountysource.com/issues/1896404-nfr-subqueries-in-phql?utm_campaign=plugin&utm_content=tracker%2F50707&utm_medium=issues&utm_source=github)** We accept bounties via [Bountysource](https://www.bountysource.com/?utm_campaign=plugin&utm_content=tracker%2F50707&utm_medium=issues&utm_source=github).\r\n</bountysource-plugin>"},"comment":{"url":"https://api.github.com/repos/phalcon/cphalcon/issues/comments/86843366","html_url":"https://github.com/phalcon/cphalcon/issues/496#issuecomment-86843366","issue_url":"https://api.github.com/repos/phalcon/cphalcon/issues/496","id":86843366,"user":{"login":"sukobuto","id":1277008,"avatar_url":"https://avatars.githubusercontent.com/u/1277008?v=3","gravatar_id":"","url":"https://api.github.com/users/sukobuto","html_url":"https://github.com/sukobuto","followers_url":"https://api.github.com/users/sukobuto/followers","following_url":"https://api.github.com/users/sukobuto/following{/other_user}","gists_url":"https://api.github.com/users/sukobuto/gists{/gist_id}","starred_url":"https://api.github.com/users/sukobuto/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sukobuto/subscriptions","organizations_url":"https://api.github.com/users/sukobuto/orgs","repos_url":"https://api.github.com/users/sukobuto/repos","events_url":"https://api.github.com/users/sukobuto/events{/privacy}","received_events_url":"https://api.github.com/users/sukobuto/received_events","type":"User","site_admin":false},"created_at":"2015-03-27T06:45:42Z","updated_at":"2015-03-27T06:45:42Z","body":"+1"}}