
Hello,
I have a query like
SELECT a.* FROM tbl_tableA a
WHERE a.id IN (SELECT b.id FROM tbl_tableB b)
That works perfectly when I call $dbConnection->query();
However, I want to have limit in my statement, so I adjusted it to:
SELECT a.* FROM tbl_tableA a
WHERE a.id IN (SELECT b.id FROM tbl_tableB b)
LIMIT 20 OFFSET 0
In order for this to work, I need to use translatedQuery() instead of query(). But translatedQuery() does not seem to accept the statement "WHERE a.id IN (SELECT b.id FROM tbl_tableB b)"