Thanks to this thread completed a very quick and dirty migration from Zenphoto for the Aikido Sangenkai Gallery. Was very straightforward once I imported everything into the new database and ran the query there.

Best,

Chris