xPDO query bounding and getResources snippet pagination interoperability
Goal is to bound large resource result sets in ModX Revolution using xPDO limit/offset and present them via the getResources snippet pagination controls. Assumptions are ModX Revolution with xPDO ORM and MySQL. getResources builds xPDO queries from limit, offset and page parameters. Offset-based paging is simple to configure but database scans skipped rows a