Liverpool Show Tickets for From the Jam with Bruce Foxton

Privacy Policy

SQL = SELECT events.PRODUCT_CODE, events.PRODUCT_NAME AS PRODUCT_NAME, DATE_FORMAT(events.EVENTDATE,'%W %D %M') as formattedStartDate, events.BUYAT_SHORT_DEEPLINK_URL AS ShowLink,events.EVENTSTATUS,events.EVENTTIME AS ETime,events.VENUEID AS VENUEID,events.PRICERANGE as Price ,events.ARTISTID,events.EVENTDATE AS ShowDate, events.ShowPage as ShowPage, venues.PRODUCT_NAME as VenueName, venues.CITY as City, venues.BUYAT_SHORT_DEEPLINK_URL AS VenueLink, venues.Image as VImage, artists.Image as AImage, artists.BUYAT_SHORT_DEEPLINK_URL AS ArtistLink, showdetails.ShowDes as ShowDes, showdetails.MetaDesc as MetaDesc, showdetails.MetaKey as MetaKey, showdetails.ShowImage as ShowImage, showdetails.showID as ShowID, venues.PRODUCT_CODE as VCode, events.ARTISTID as ArtistID FROM events JOIN venues ON events.VENUEID = venues.PRODUCT_CODE JOIN artists ON events.ARTISTID = artists.PRODUCT_CODE JOIN showdetails ON events.ShowPage = showdetails.ShowPage WHERE (City = "Liverpool") AND (events.ShowPage = "From-the-Jam-with-Bruce-Foxton.htm") AND (events.EVENTDATE >= "2012-05-18") AND (events.EVENTSTATUS ='3') AND events.UpdateDate >='2012-05-17' ORDER BY events.EVENTDATE