Photos by our visitors in Frankfurt
Click on the images to see the photo.
SELECT userphoto.id AS id, events.name, photodate, filename, userphoto.description FROM userphoto LEFT JOIN events ON event_id=events.id LEFT JOIN venues ON location=venues.id WHERE status='ok' AND photodate>'2009-05-20' AND city_id='111' ORDER BY photodate DESC LIMIT 20