Hi all, I haven't investigated this deep enough to open a Bugzilla report, but has anyone else had the experience of a limit in a subquery causing issues with the surrounding SQL query? I had a subquery in the select statement with a limit of 1, and it was causing my output to only display 1 row, and broke the paging. This was on an older version of Koha. Haven't tried with a newer one yet. David Cook Systems Librarian Prosentient Systems 72/330 Wattle St Ultimo, NSW 2007 Australia Office: 02 9212 0899 Online: 02 8005 0595