Syntax for using Koha report

We are using a curated list to populate our book river on our catalog ( http://www.catalog.mydpl.org ) but, the report we use there, does not work for our website book river.
This is the code used by Koha for the catalog to pull the titles from the list:
SELECT biblionumber, SUBSTRING_INDEX(isbn, ‘ ‘, 1) AS isbn, title
FROM virtualshelfcontents
LEFT JOIN biblioitems USING (biblionumber)
LEFT JOIN biblio USING (biblionumber)
WHERE shelfnumber=715
ORDER BY rand()
LIMIT 25

Any idea what syntax I need to use to get bookshelves to populate based on this report?

The page I need help with: [log in to see the link]