I think this should be it:

query=db((db.things.id>0)&(db.photos_things.id==db.photos_things.thing_id)).select()

for row in query:

list = [row.things.title, row.photos_things.photo_id.image]

Reply via email to