testing offset, limit, quoting, subqueries, pseudo-views and cloning, plus performance improvement