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. 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.