Photos by our visitors in Salvador
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-06-21' AND city_id='106' ORDER BY photodate DESC LIMIT 20