Please help me to build DAL expression to create this query: select * from addresses t1 join (select id from addresses order by address) t2 on t1.id = t2.id limit %d offset %d
FYI, this query does the same as 'select * from addresses order by address limit offset' but works 10x faster (simple query refuses to use index on 'address' field). Thank you!
