Photos by our visitors in Auckland
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-26' AND city_id='85' ORDER BY photodate DESC LIMIT 20
