Can Phalcon parse where in (select)?

I am trying following query and getting phalcon parsing exception: ```SELECT countryid FROM OffersCountries WHERE offerid IN ( SELECT offerid FROM OffersDomains WHERE domainid = ?0)```

Syntax error, unexpected token SELECT, near to offer_id FROM OffersDomains... when parsing

I am using mysql.

Is it possible to make Phalcon to work with such kind of query?

Which version of PHalcon are you using?

May want to see this post. http://phalcontip.com/discussion/36/how-to-use-subqueries-in-phalcon. Look in comments and subqueries should be supported for 2.0.2. Otherwise use a pdo connection with bound parameter.

I am using 2.0.1. Thanks.