I had pared it down to that simple query from

select username, uid, key_file from authorized_keys join users using (uid)

and was still not getting the snapshot - is your version preferable in some way zwass?