Party Photos

select	photog_event.id as photog_event_id,
	photog_event.id as album,
	photog_event.media_vfolder_id,
	photog_event.venue_id,
	photog_event.event_id,
	photog_event.date,
	venue.id as venue_id,
	venue.name as venue_name,
	event.id as event_id,
	event.name
from photog_event
 LEFT JOIN venue on photog_event.venue_id = venue.id and venue.active = 1 
  LEFT JOIN event on photog_event.event_id = event.id and event.active = 1 
 
where photog_event.active = 1  and media_vfolder_id is not null
			and photog_event.approved is not null
			and ( 	   photog_event.date = '/2004' 
					or photog_event.date = '/2005' 
					or photog_event.date = '/2006' 
					or photog_event.date = '/2007' 
					or photog_event.date = '/2008' 
					or photog_event.date = '/2009' 
				)
		 and true
			and venue.market_id = 1
		 order by date desc, venue.pageviews DESC
		
ERROR:  invalid input syntax for type date: "/2004"

---

/home/hnycc/public_html/cravetix/pages/photos/default.php
Line: 55