As far as I can tell, you can't use offset [# to offset] or the abbreviated limit [# to offset], [# to limit] shorthand to offset your results in Koha's SQL reports. These features are available in MySQL and Mariadb, so it would be nice if you could use one of them on the front end. Here are two simple examples that don't work: select borrowernumber from borrowers limit 10, 10 select borrowernumber from borrowers limit 10 offset 10
Noting this feature is available as of mariadb 10.6.
It looks like the MariaDB version on ktd is too old to test this: 10.5.19-MariaDB-1:10.5.19+maria~ubu2004 The error I get indicates that the SQL statement was used as I entered it, but that the DBMS doesn't support it. So I think a change in Koha might not be needed: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '10 Joe, can you verify you were testing with 10.6 or later? MariaDB: https://mariadb.com/kb/en/select-offset-fetch/ MySQL seems to have had it for a while: https://dev.mysql.com/doc/refman/8.0/en/select.html https://dev.mysql.com/doc/refman/5.7/en/select.html
I believe this was a DBMS version related problem.