SELECT Listings.ListingID, Ent.Rating, EventStartDateTime,EventEndDateTime, Listings.seatingPlanID, Listings.ExtTicketsAttached, Ent.Votes, Listings.MinAge, Listings.EventCode,Listings.TicketsAttached, CityCode, ListingInstance.iEventDate AS iEventDate, ListingInstance.goingto, EntryPrice, ListingInstance.iListingInstance AS iListingInstance,ListingInstance.fbeid, ListingInstance.iListingInstance as ListingInstanceID,MIN( ListingInstance.iListingInstance ) AS MinListingInstanceID,ListingInstance.iListingID, ListingInstance.ticketStatus, ListingInstance.ticketsAdded, Ent.c_Type, Ent.Town, Ent.PostCode, Ent.postcode_lookup,Ent.majorCity,Ent.Name, Ent.safeName,Ent.Country, Ent.Address, Ent.EntID, Ent.Logo, Listings.EventName, Listings.EventDescShort, DayOfWeek(ListingInstance.iEventDate) AS iEventDay, Listings.Feature,FeatureDays, Ent.latitude, Ent.longitude, Listings.DoorsOpen, Listings.DoorsClose, Listings.LastEntry, Listings.EntryPrice, Listings.canonicalurl, Listings.canonicaldesc,Listings.PromotorID, Listings.DateAdded, Listings.DateEdited, Listings.imgName, Listings.imgVersion, Listings.cancelled, Listings.rescheduledDate, Listings.eventCurrency, Listings.izettleMerchantAccountId, Listings.qualityFlag_image, Ent.imgName as entImgName, Ent.imgVersion as entImgVersion,ListingInstance.shortUrl, eventStartDate, eventEndDate, Listings.waitingListListingEnabled, Listings.groupingID FROM Ent INNER JOIN ListingInstance ON Ent.EntID = ListingInstance.iEntID INNER JOIN Listings ON ListingInstance.iListingID = Listings.ListingID WHERE 1=1 AND MBRContains(st_geomfromtext('POLYGON((-1.6916517400619 54.708536231884, -1.6916517400619 54.853463768116,-1.4403482599381 54.853463768116,-1.4403482599381 54.708536231884,-1.6916517400619 54.708536231884))'),Ent.location) AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Listings.PromotorID != '28722' GROUP BY Listings.PromotorID ORDER BY salesCountLast7Days DESC, FeatureSpecial DESC LIMIT 12 OFFSET 0
SELECT Listings.ListingID, Ent.Rating, EventStartDateTime,EventEndDateTime, Listings.seatingPlanID, Listings.ExtTicketsAttached, Ent.Votes, Listings.MinAge, Listings.EventCode,Listings.TicketsAttached, CityCode, ListingInstance.iEventDate AS iEventDate, ListingInstance.goingto, EntryPrice, ListingInstance.iListingInstance AS iListingInstance,ListingInstance.fbeid, ListingInstance.iListingInstance as ListingInstanceID,MIN( ListingInstance.iListingInstance ) AS MinListingInstanceID,ListingInstance.iListingID, ListingInstance.ticketStatus, ListingInstance.ticketsAdded, Ent.c_Type, Ent.Town, Ent.PostCode, Ent.postcode_lookup,Ent.majorCity,Ent.Name, Ent.safeName,Ent.Country, Ent.Address, Ent.EntID, Ent.Logo, Listings.EventName, Listings.EventDescShort, DayOfWeek(ListingInstance.iEventDate) AS iEventDay, Listings.Feature,FeatureDays, Ent.latitude, Ent.longitude, Listings.DoorsOpen, Listings.DoorsClose, Listings.LastEntry, Listings.EntryPrice, Listings.canonicalurl, Listings.canonicaldesc,Listings.PromotorID, Listings.DateAdded, Listings.DateEdited, Listings.imgName, Listings.imgVersion, Listings.cancelled, Listings.rescheduledDate, Listings.eventCurrency, Listings.izettleMerchantAccountId, Listings.qualityFlag_image, Ent.imgName as entImgName, Ent.imgVersion as entImgVersion,ListingInstance.shortUrl, eventStartDate, eventEndDate, Listings.waitingListListingEnabled, Listings.groupingID FROM Ent INNER JOIN ListingInstance ON Ent.EntID = ListingInstance.iEntID INNER JOIN Listings ON ListingInstance.iListingID = Listings.ListingID WHERE 1=1 AND MBRContains(st_geomfromtext('POLYGON((-1.6916517400619 54.708536231884, -1.6916517400619 54.853463768116,-1.4403482599381 54.853463768116,-1.4403482599381 54.708536231884,-1.6916517400619 54.708536231884))'),Ent.location) AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '38684' AND Listings.PromotorID != '28722' GROUP BY Listings.PromotorID ORDER BY salesCountLast7Days DESC, FeatureSpecial DESC LIMIT 4 OFFSET 0
SELECT Listings.ListingID, Ent.Rating, EventStartDateTime,EventEndDateTime, Listings.seatingPlanID, Listings.ExtTicketsAttached, Ent.Votes, Listings.MinAge, Listings.EventCode,Listings.TicketsAttached, CityCode, ListingInstance.iEventDate AS iEventDate, ListingInstance.goingto, EntryPrice, ListingInstance.iListingInstance AS iListingInstance,ListingInstance.fbeid, ListingInstance.iListingInstance as ListingInstanceID,MIN( ListingInstance.iListingInstance ) AS MinListingInstanceID,ListingInstance.iListingID, ListingInstance.ticketStatus, ListingInstance.ticketsAdded, Ent.c_Type, Ent.Town, Ent.PostCode, Ent.postcode_lookup,Ent.majorCity,Ent.Name, Ent.safeName,Ent.Country, Ent.Address, Ent.EntID, Ent.Logo, Listings.EventName, Listings.EventDescShort, DayOfWeek(ListingInstance.iEventDate) AS iEventDay, Listings.Feature,FeatureDays, Ent.latitude, Ent.longitude, Listings.DoorsOpen, Listings.DoorsClose, Listings.LastEntry, Listings.EntryPrice, Listings.canonicalurl, Listings.canonicaldesc,Listings.PromotorID, Listings.DateAdded, Listings.DateEdited, Listings.imgName, Listings.imgVersion, Listings.cancelled, Listings.rescheduledDate, Listings.eventCurrency, Listings.izettleMerchantAccountId, Listings.qualityFlag_image, Ent.imgName as entImgName, Ent.imgVersion as entImgVersion,ListingInstance.shortUrl, eventStartDate, eventEndDate, Listings.waitingListListingEnabled, Listings.groupingID FROM Ent INNER JOIN ListingInstance ON Ent.EntID = ListingInstance.iEntID INNER JOIN Listings ON ListingInstance.iListingID = Listings.ListingID WHERE 1=1 AND MBRContains(st_geomfromtext('POLYGON((-1.6916517400619 54.708536231884, -1.6916517400619 54.853463768116,-1.4403482599381 54.853463768116,-1.4403482599381 54.708536231884,-1.6916517400619 54.708536231884))'),Ent.location) AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '6191' AND Listings.PromotorID != '28722' GROUP BY Listings.PromotorID ORDER BY salesCountLast7Days DESC, FeatureSpecial DESC LIMIT 4 OFFSET 0
SELECT Listings.ListingID, Ent.Rating, EventStartDateTime,EventEndDateTime, Listings.seatingPlanID, Listings.ExtTicketsAttached, Ent.Votes, Listings.MinAge, Listings.EventCode,Listings.TicketsAttached, CityCode, ListingInstance.iEventDate AS iEventDate, ListingInstance.goingto, EntryPrice, ListingInstance.iListingInstance AS iListingInstance,ListingInstance.fbeid, ListingInstance.iListingInstance as ListingInstanceID,MIN( ListingInstance.iListingInstance ) AS MinListingInstanceID,ListingInstance.iListingID, ListingInstance.ticketStatus, ListingInstance.ticketsAdded, Ent.c_Type, Ent.Town, Ent.PostCode, Ent.postcode_lookup,Ent.majorCity,Ent.Name, Ent.safeName,Ent.Country, Ent.Address, Ent.EntID, Ent.Logo, Listings.EventName, Listings.EventDescShort, DayOfWeek(ListingInstance.iEventDate) AS iEventDay, Listings.Feature,FeatureDays, Ent.latitude, Ent.longitude, Listings.DoorsOpen, Listings.DoorsClose, Listings.LastEntry, Listings.EntryPrice, Listings.canonicalurl, Listings.canonicaldesc,Listings.PromotorID, Listings.DateAdded, Listings.DateEdited, Listings.imgName, Listings.imgVersion, Listings.cancelled, Listings.rescheduledDate, Listings.eventCurrency, Listings.izettleMerchantAccountId, Listings.qualityFlag_image, Ent.imgName as entImgName, Ent.imgVersion as entImgVersion,ListingInstance.shortUrl, eventStartDate, eventEndDate, Listings.waitingListListingEnabled, Listings.groupingID FROM Ent INNER JOIN ListingInstance ON Ent.EntID = ListingInstance.iEntID INNER JOIN Listings ON ListingInstance.iListingID = Listings.ListingID WHERE 1=1 AND MBRContains(st_geomfromtext('POLYGON((-1.6916517400619 54.708536231884, -1.6916517400619 54.853463768116,-1.4403482599381 54.853463768116,-1.4403482599381 54.708536231884,-1.6916517400619 54.708536231884))'),Ent.location) AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '1654' AND Listings.PromotorID != '28722' GROUP BY Listings.PromotorID ORDER BY salesCountLast7Days DESC, FeatureSpecial DESC LIMIT 4 OFFSET 0
SELECT Listings.ListingID, Ent.Rating, EventStartDateTime,EventEndDateTime, Listings.seatingPlanID, Listings.ExtTicketsAttached, Ent.Votes, Listings.MinAge, Listings.EventCode,Listings.TicketsAttached, CityCode, ListingInstance.iEventDate AS iEventDate, ListingInstance.goingto, EntryPrice, ListingInstance.iListingInstance AS iListingInstance,ListingInstance.fbeid, ListingInstance.iListingInstance as ListingInstanceID,MIN( ListingInstance.iListingInstance ) AS MinListingInstanceID,ListingInstance.iListingID, ListingInstance.ticketStatus, ListingInstance.ticketsAdded, Ent.c_Type, Ent.Town, Ent.PostCode, Ent.postcode_lookup,Ent.majorCity,Ent.Name, Ent.safeName,Ent.Country, Ent.Address, Ent.EntID, Ent.Logo, Listings.EventName, Listings.EventDescShort, DayOfWeek(ListingInstance.iEventDate) AS iEventDay, Listings.Feature,FeatureDays, Ent.latitude, Ent.longitude, Listings.DoorsOpen, Listings.DoorsClose, Listings.LastEntry, Listings.EntryPrice, Listings.canonicalurl, Listings.canonicaldesc,Listings.PromotorID, Listings.DateAdded, Listings.DateEdited, Listings.imgName, Listings.imgVersion, Listings.cancelled, Listings.rescheduledDate, Listings.eventCurrency, Listings.izettleMerchantAccountId, Listings.qualityFlag_image, Ent.imgName as entImgName, Ent.imgVersion as entImgVersion,ListingInstance.shortUrl, eventStartDate, eventEndDate, Listings.waitingListListingEnabled, Listings.groupingID FROM Ent INNER JOIN ListingInstance ON Ent.EntID = ListingInstance.iEntID INNER JOIN Listings ON ListingInstance.iListingID = Listings.ListingID WHERE 1=1 AND MBRContains(st_geomfromtext('POLYGON((-1.6916517400619 54.708536231884, -1.6916517400619 54.853463768116,-1.4403482599381 54.853463768116,-1.4403482599381 54.708536231884,-1.6916517400619 54.708536231884))'),Ent.location) AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '18003' AND Listings.PromotorID != '28722' GROUP BY Listings.PromotorID ORDER BY salesCountLast7Days DESC, FeatureSpecial DESC LIMIT 4 OFFSET 0
SELECT Listings.ListingID, Ent.Rating, EventStartDateTime,EventEndDateTime, Listings.seatingPlanID, Listings.ExtTicketsAttached, Ent.Votes, Listings.MinAge, Listings.EventCode,Listings.TicketsAttached, CityCode, ListingInstance.iEventDate AS iEventDate, ListingInstance.goingto, EntryPrice, ListingInstance.iListingInstance AS iListingInstance,ListingInstance.fbeid, ListingInstance.iListingInstance as ListingInstanceID,MIN( ListingInstance.iListingInstance ) AS MinListingInstanceID,ListingInstance.iListingID, ListingInstance.ticketStatus, ListingInstance.ticketsAdded, Ent.c_Type, Ent.Town, Ent.PostCode, Ent.postcode_lookup,Ent.majorCity,Ent.Name, Ent.safeName,Ent.Country, Ent.Address, Ent.EntID, Ent.Logo, Listings.EventName, Listings.EventDescShort, DayOfWeek(ListingInstance.iEventDate) AS iEventDay, Listings.Feature,FeatureDays, Ent.latitude, Ent.longitude, Listings.DoorsOpen, Listings.DoorsClose, Listings.LastEntry, Listings.EntryPrice, Listings.canonicalurl, Listings.canonicaldesc,Listings.PromotorID, Listings.DateAdded, Listings.DateEdited, Listings.imgName, Listings.imgVersion, Listings.cancelled, Listings.rescheduledDate, Listings.eventCurrency, Listings.izettleMerchantAccountId, Listings.qualityFlag_image, Ent.imgName as entImgName, Ent.imgVersion as entImgVersion,ListingInstance.shortUrl, eventStartDate, eventEndDate, Listings.waitingListListingEnabled, Listings.groupingID FROM Ent INNER JOIN ListingInstance ON Ent.EntID = ListingInstance.iEntID INNER JOIN Listings ON ListingInstance.iListingID = Listings.ListingID WHERE 1=1 AND MBRContains(st_geomfromtext('POLYGON((-1.6916517400619 54.708536231884, -1.6916517400619 54.853463768116,-1.4403482599381 54.853463768116,-1.4403482599381 54.708536231884,-1.6916517400619 54.708536231884))'),Ent.location) AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '56234' AND Listings.PromotorID != '28722' GROUP BY Listings.PromotorID ORDER BY salesCountLast7Days DESC, FeatureSpecial DESC LIMIT 4 OFFSET 0
SELECT Listings.ListingID, Ent.Rating, EventStartDateTime,EventEndDateTime, Listings.seatingPlanID, Listings.ExtTicketsAttached, Ent.Votes, Listings.MinAge, Listings.EventCode,Listings.TicketsAttached, CityCode, ListingInstance.iEventDate AS iEventDate, ListingInstance.goingto, EntryPrice, ListingInstance.iListingInstance AS iListingInstance,ListingInstance.fbeid, ListingInstance.iListingInstance as ListingInstanceID,MIN( ListingInstance.iListingInstance ) AS MinListingInstanceID,ListingInstance.iListingID, ListingInstance.ticketStatus, ListingInstance.ticketsAdded, Ent.c_Type, Ent.Town, Ent.PostCode, Ent.postcode_lookup,Ent.majorCity,Ent.Name, Ent.safeName,Ent.Country, Ent.Address, Ent.EntID, Ent.Logo, Listings.EventName, Listings.EventDescShort, DayOfWeek(ListingInstance.iEventDate) AS iEventDay, Listings.Feature,FeatureDays, Ent.latitude, Ent.longitude, Listings.DoorsOpen, Listings.DoorsClose, Listings.LastEntry, Listings.EntryPrice, Listings.canonicalurl, Listings.canonicaldesc,Listings.PromotorID, Listings.DateAdded, Listings.DateEdited, Listings.imgName, Listings.imgVersion, Listings.cancelled, Listings.rescheduledDate, Listings.eventCurrency, Listings.izettleMerchantAccountId, Listings.qualityFlag_image, Ent.imgName as entImgName, Ent.imgVersion as entImgVersion,ListingInstance.shortUrl, eventStartDate, eventEndDate, Listings.waitingListListingEnabled, Listings.groupingID FROM Ent INNER JOIN ListingInstance ON Ent.EntID = ListingInstance.iEntID INNER JOIN Listings ON ListingInstance.iListingID = Listings.ListingID WHERE 1=1 AND MBRContains(st_geomfromtext('POLYGON((-1.6916517400619 54.708536231884, -1.6916517400619 54.853463768116,-1.4403482599381 54.853463768116,-1.4403482599381 54.708536231884,-1.6916517400619 54.708536231884))'),Ent.location) AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '64914' AND Listings.PromotorID != '28722' GROUP BY Listings.PromotorID ORDER BY salesCountLast7Days DESC, FeatureSpecial DESC LIMIT 4 OFFSET 0
SELECT Listings.ListingID, Ent.Rating, EventStartDateTime,EventEndDateTime, Listings.seatingPlanID, Listings.ExtTicketsAttached, Ent.Votes, Listings.MinAge, Listings.EventCode,Listings.TicketsAttached, CityCode, ListingInstance.iEventDate AS iEventDate, ListingInstance.goingto, EntryPrice, ListingInstance.iListingInstance AS iListingInstance,ListingInstance.fbeid, ListingInstance.iListingInstance as ListingInstanceID,MIN( ListingInstance.iListingInstance ) AS MinListingInstanceID,ListingInstance.iListingID, ListingInstance.ticketStatus, ListingInstance.ticketsAdded, Ent.c_Type, Ent.Town, Ent.PostCode, Ent.postcode_lookup,Ent.majorCity,Ent.Name, Ent.safeName,Ent.Country, Ent.Address, Ent.EntID, Ent.Logo, Listings.EventName, Listings.EventDescShort, DayOfWeek(ListingInstance.iEventDate) AS iEventDay, Listings.Feature,FeatureDays, Ent.latitude, Ent.longitude, Listings.DoorsOpen, Listings.DoorsClose, Listings.LastEntry, Listings.EntryPrice, Listings.canonicalurl, Listings.canonicaldesc,Listings.PromotorID, Listings.DateAdded, Listings.DateEdited, Listings.imgName, Listings.imgVersion, Listings.cancelled, Listings.rescheduledDate, Listings.eventCurrency, Listings.izettleMerchantAccountId, Listings.qualityFlag_image, Ent.imgName as entImgName, Ent.imgVersion as entImgVersion,ListingInstance.shortUrl, eventStartDate, eventEndDate, Listings.waitingListListingEnabled, Listings.groupingID FROM Ent INNER JOIN ListingInstance ON Ent.EntID = ListingInstance.iEntID INNER JOIN Listings ON ListingInstance.iListingID = Listings.ListingID WHERE 1=1 AND MBRContains(st_geomfromtext('POLYGON((-1.6916517400619 54.708536231884, -1.6916517400619 54.853463768116,-1.4403482599381 54.853463768116,-1.4403482599381 54.708536231884,-1.6916517400619 54.708536231884))'),Ent.location) AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '58319' AND Listings.PromotorID != '28722' GROUP BY Listings.PromotorID ORDER BY salesCountLast7Days DESC, FeatureSpecial DESC LIMIT 4 OFFSET 0
SELECT Listings.ListingID, Ent.Rating, EventStartDateTime,EventEndDateTime, Listings.seatingPlanID, Listings.ExtTicketsAttached, Ent.Votes, Listings.MinAge, Listings.EventCode,Listings.TicketsAttached, CityCode, ListingInstance.iEventDate AS iEventDate, ListingInstance.goingto, EntryPrice, ListingInstance.iListingInstance AS iListingInstance,ListingInstance.fbeid, ListingInstance.iListingInstance as ListingInstanceID,MIN( ListingInstance.iListingInstance ) AS MinListingInstanceID,ListingInstance.iListingID, ListingInstance.ticketStatus, ListingInstance.ticketsAdded, Ent.c_Type, Ent.Town, Ent.PostCode, Ent.postcode_lookup,Ent.majorCity,Ent.Name, Ent.safeName,Ent.Country, Ent.Address, Ent.EntID, Ent.Logo, Listings.EventName, Listings.EventDescShort, DayOfWeek(ListingInstance.iEventDate) AS iEventDay, Listings.Feature,FeatureDays, Ent.latitude, Ent.longitude, Listings.DoorsOpen, Listings.DoorsClose, Listings.LastEntry, Listings.EntryPrice, Listings.canonicalurl, Listings.canonicaldesc,Listings.PromotorID, Listings.DateAdded, Listings.DateEdited, Listings.imgName, Listings.imgVersion, Listings.cancelled, Listings.rescheduledDate, Listings.eventCurrency, Listings.izettleMerchantAccountId, Listings.qualityFlag_image, Ent.imgName as entImgName, Ent.imgVersion as entImgVersion,ListingInstance.shortUrl, eventStartDate, eventEndDate, Listings.waitingListListingEnabled, Listings.groupingID FROM Ent INNER JOIN ListingInstance ON Ent.EntID = ListingInstance.iEntID INNER JOIN Listings ON ListingInstance.iListingID = Listings.ListingID WHERE 1=1 AND MBRContains(st_geomfromtext('POLYGON((-1.6916517400619 54.708536231884, -1.6916517400619 54.853463768116,-1.4403482599381 54.853463768116,-1.4403482599381 54.708536231884,-1.6916517400619 54.708536231884))'),Ent.location) AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '59761' AND Listings.PromotorID != '28722' GROUP BY Listings.PromotorID ORDER BY salesCountLast7Days DESC, FeatureSpecial DESC LIMIT 4 OFFSET 0
SELECT Listings.ListingID, Ent.Rating, EventStartDateTime,EventEndDateTime, Listings.seatingPlanID, Listings.ExtTicketsAttached, Ent.Votes, Listings.MinAge, Listings.EventCode,Listings.TicketsAttached, CityCode, ListingInstance.iEventDate AS iEventDate, ListingInstance.goingto, EntryPrice, ListingInstance.iListingInstance AS iListingInstance,ListingInstance.fbeid, ListingInstance.iListingInstance as ListingInstanceID,MIN( ListingInstance.iListingInstance ) AS MinListingInstanceID,ListingInstance.iListingID, ListingInstance.ticketStatus, ListingInstance.ticketsAdded, Ent.c_Type, Ent.Town, Ent.PostCode, Ent.postcode_lookup,Ent.majorCity,Ent.Name, Ent.safeName,Ent.Country, Ent.Address, Ent.EntID, Ent.Logo, Listings.EventName, Listings.EventDescShort, DayOfWeek(ListingInstance.iEventDate) AS iEventDay, Listings.Feature,FeatureDays, Ent.latitude, Ent.longitude, Listings.DoorsOpen, Listings.DoorsClose, Listings.LastEntry, Listings.EntryPrice, Listings.canonicalurl, Listings.canonicaldesc,Listings.PromotorID, Listings.DateAdded, Listings.DateEdited, Listings.imgName, Listings.imgVersion, Listings.cancelled, Listings.rescheduledDate, Listings.eventCurrency, Listings.izettleMerchantAccountId, Listings.qualityFlag_image, Ent.imgName as entImgName, Ent.imgVersion as entImgVersion,ListingInstance.shortUrl, eventStartDate, eventEndDate, Listings.waitingListListingEnabled, Listings.groupingID FROM Ent INNER JOIN ListingInstance ON Ent.EntID = ListingInstance.iEntID INNER JOIN Listings ON ListingInstance.iListingID = Listings.ListingID WHERE 1=1 AND MBRContains(st_geomfromtext('POLYGON((-1.6916517400619 54.708536231884, -1.6916517400619 54.853463768116,-1.4403482599381 54.853463768116,-1.4403482599381 54.708536231884,-1.6916517400619 54.708536231884))'),Ent.location) AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '55911' AND Listings.PromotorID != '28722' GROUP BY Listings.PromotorID ORDER BY salesCountLast7Days DESC, FeatureSpecial DESC LIMIT 4 OFFSET 0
SELECT Listings.ListingID, Ent.Rating, EventStartDateTime,EventEndDateTime, Listings.seatingPlanID, Listings.ExtTicketsAttached, Ent.Votes, Listings.MinAge, Listings.EventCode,Listings.TicketsAttached, CityCode, ListingInstance.iEventDate AS iEventDate, ListingInstance.goingto, EntryPrice, ListingInstance.iListingInstance AS iListingInstance,ListingInstance.fbeid, ListingInstance.iListingInstance as ListingInstanceID,MIN( ListingInstance.iListingInstance ) AS MinListingInstanceID,ListingInstance.iListingID, ListingInstance.ticketStatus, ListingInstance.ticketsAdded, Ent.c_Type, Ent.Town, Ent.PostCode, Ent.postcode_lookup,Ent.majorCity,Ent.Name, Ent.safeName,Ent.Country, Ent.Address, Ent.EntID, Ent.Logo, Listings.EventName, Listings.EventDescShort, DayOfWeek(ListingInstance.iEventDate) AS iEventDay, Listings.Feature,FeatureDays, Ent.latitude, Ent.longitude, Listings.DoorsOpen, Listings.DoorsClose, Listings.LastEntry, Listings.EntryPrice, Listings.canonicalurl, Listings.canonicaldesc,Listings.PromotorID, Listings.DateAdded, Listings.DateEdited, Listings.imgName, Listings.imgVersion, Listings.cancelled, Listings.rescheduledDate, Listings.eventCurrency, Listings.izettleMerchantAccountId, Listings.qualityFlag_image, Ent.imgName as entImgName, Ent.imgVersion as entImgVersion,ListingInstance.shortUrl, eventStartDate, eventEndDate, Listings.waitingListListingEnabled, Listings.groupingID FROM Ent INNER JOIN ListingInstance ON Ent.EntID = ListingInstance.iEntID INNER JOIN Listings ON ListingInstance.iListingID = Listings.ListingID WHERE 1=1 AND MBRContains(st_geomfromtext('POLYGON((-1.6916517400619 54.708536231884, -1.6916517400619 54.853463768116,-1.4403482599381 54.853463768116,-1.4403482599381 54.708536231884,-1.6916517400619 54.708536231884))'),Ent.location) AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '40904' AND Listings.PromotorID != '28722' GROUP BY Listings.PromotorID ORDER BY salesCountLast7Days DESC, FeatureSpecial DESC LIMIT 4 OFFSET 0
SELECT Listings.ListingID, Ent.Rating, EventStartDateTime,EventEndDateTime, Listings.seatingPlanID, Listings.ExtTicketsAttached, Ent.Votes, Listings.MinAge, Listings.EventCode,Listings.TicketsAttached, CityCode, ListingInstance.iEventDate AS iEventDate, ListingInstance.goingto, EntryPrice, ListingInstance.iListingInstance AS iListingInstance,ListingInstance.fbeid, ListingInstance.iListingInstance as ListingInstanceID,MIN( ListingInstance.iListingInstance ) AS MinListingInstanceID,ListingInstance.iListingID, ListingInstance.ticketStatus, ListingInstance.ticketsAdded, Ent.c_Type, Ent.Town, Ent.PostCode, Ent.postcode_lookup,Ent.majorCity,Ent.Name, Ent.safeName,Ent.Country, Ent.Address, Ent.EntID, Ent.Logo, Listings.EventName, Listings.EventDescShort, DayOfWeek(ListingInstance.iEventDate) AS iEventDay, Listings.Feature,FeatureDays, Ent.latitude, Ent.longitude, Listings.DoorsOpen, Listings.DoorsClose, Listings.LastEntry, Listings.EntryPrice, Listings.canonicalurl, Listings.canonicaldesc,Listings.PromotorID, Listings.DateAdded, Listings.DateEdited, Listings.imgName, Listings.imgVersion, Listings.cancelled, Listings.rescheduledDate, Listings.eventCurrency, Listings.izettleMerchantAccountId, Listings.qualityFlag_image, Ent.imgName as entImgName, Ent.imgVersion as entImgVersion,ListingInstance.shortUrl, eventStartDate, eventEndDate, Listings.waitingListListingEnabled, Listings.groupingID FROM Ent INNER JOIN ListingInstance ON Ent.EntID = ListingInstance.iEntID INNER JOIN Listings ON ListingInstance.iListingID = Listings.ListingID WHERE 1=1 AND MBRContains(st_geomfromtext('POLYGON((-1.6916517400619 54.708536231884, -1.6916517400619 54.853463768116,-1.4403482599381 54.853463768116,-1.4403482599381 54.708536231884,-1.6916517400619 54.708536231884))'),Ent.location) AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '55569' AND Listings.PromotorID != '28722' GROUP BY Listings.PromotorID ORDER BY salesCountLast7Days DESC, FeatureSpecial DESC LIMIT 4 OFFSET 0
SELECT Listings.ListingID, Ent.Rating, EventStartDateTime,EventEndDateTime, Listings.seatingPlanID, Listings.ExtTicketsAttached, Ent.Votes, Listings.MinAge, Listings.EventCode,Listings.TicketsAttached, CityCode, ListingInstance.iEventDate AS iEventDate, ListingInstance.goingto, EntryPrice, ListingInstance.iListingInstance AS iListingInstance,ListingInstance.fbeid, ListingInstance.iListingInstance as ListingInstanceID,MIN( ListingInstance.iListingInstance ) AS MinListingInstanceID,ListingInstance.iListingID, ListingInstance.ticketStatus, ListingInstance.ticketsAdded, Ent.c_Type, Ent.Town, Ent.PostCode, Ent.postcode_lookup,Ent.majorCity,Ent.Name, Ent.safeName,Ent.Country, Ent.Address, Ent.EntID, Ent.Logo, Listings.EventName, Listings.EventDescShort, DayOfWeek(ListingInstance.iEventDate) AS iEventDay, Listings.Feature,FeatureDays, Ent.latitude, Ent.longitude, Listings.DoorsOpen, Listings.DoorsClose, Listings.LastEntry, Listings.EntryPrice, Listings.canonicalurl, Listings.canonicaldesc,Listings.PromotorID, Listings.DateAdded, Listings.DateEdited, Listings.imgName, Listings.imgVersion, Listings.cancelled, Listings.rescheduledDate, Listings.eventCurrency, Listings.izettleMerchantAccountId, Listings.qualityFlag_image, Ent.imgName as entImgName, Ent.imgVersion as entImgVersion,ListingInstance.shortUrl, eventStartDate, eventEndDate, Listings.waitingListListingEnabled, Listings.groupingID FROM Ent INNER JOIN ListingInstance ON Ent.EntID = ListingInstance.iEntID INNER JOIN Listings ON ListingInstance.iListingID = Listings.ListingID WHERE 1=1 AND MBRContains(st_geomfromtext('POLYGON((-1.6916517400619 54.708536231884, -1.6916517400619 54.853463768116,-1.4403482599381 54.853463768116,-1.4403482599381 54.708536231884,-1.6916517400619 54.708536231884))'),Ent.location) AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '33640' AND Listings.PromotorID != '28722' GROUP BY Listings.PromotorID ORDER BY salesCountLast7Days DESC, FeatureSpecial DESC LIMIT 4 OFFSET 0
SELECT Listings.ListingID, Ent.Rating, EventStartDateTime,EventEndDateTime, Listings.seatingPlanID, Listings.ExtTicketsAttached, Ent.Votes, Listings.MinAge, Listings.EventCode,Listings.TicketsAttached, CityCode, ListingInstance.iEventDate AS iEventDate, ListingInstance.goingto, EntryPrice, ListingInstance.iListingInstance AS iListingInstance,ListingInstance.fbeid, ListingInstance.iListingInstance as ListingInstanceID,MIN( ListingInstance.iListingInstance ) AS MinListingInstanceID,ListingInstance.iListingID, ListingInstance.ticketStatus, ListingInstance.ticketsAdded, Ent.c_Type, Ent.Town, Ent.PostCode, Ent.postcode_lookup,Ent.majorCity,Ent.Name, Ent.safeName,Ent.Country, Ent.Address, Ent.EntID, Ent.Logo, Listings.EventName, Listings.EventDescShort, DayOfWeek(ListingInstance.iEventDate) AS iEventDay, Listings.Feature,FeatureDays, Ent.latitude, Ent.longitude, Listings.DoorsOpen, Listings.DoorsClose, Listings.LastEntry, Listings.EntryPrice, Listings.canonicalurl, Listings.canonicaldesc,Listings.PromotorID, Listings.DateAdded, Listings.DateEdited, Listings.imgName, Listings.imgVersion, Listings.cancelled, Listings.rescheduledDate, Listings.eventCurrency, Listings.izettleMerchantAccountId, Listings.qualityFlag_image, Ent.imgName as entImgName, Ent.imgVersion as entImgVersion,ListingInstance.shortUrl, eventStartDate, eventEndDate, Listings.waitingListListingEnabled, Listings.groupingID FROM Ent INNER JOIN ListingInstance ON Ent.EntID = ListingInstance.iEntID INNER JOIN Listings ON ListingInstance.iListingID = Listings.ListingID WHERE 1=1 AND MBRContains(st_geomfromtext('POLYGON((-1.6916517400619 54.708536231884, -1.6916517400619 54.853463768116,-1.4403482599381 54.853463768116,-1.4403482599381 54.708536231884,-1.6916517400619 54.708536231884))'),Ent.location) AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '45032' AND Listings.PromotorID != '28722' GROUP BY Listings.PromotorID ORDER BY salesCountLast7Days DESC, FeatureSpecial DESC LIMIT 4 OFFSET 0
SELECT Listings.ListingID, Ent.Rating, EventStartDateTime,EventEndDateTime, Listings.seatingPlanID, Listings.ExtTicketsAttached, Ent.Votes, Listings.MinAge, Listings.EventCode,Listings.TicketsAttached, CityCode, ListingInstance.iEventDate AS iEventDate, ListingInstance.goingto, EntryPrice, ListingInstance.iListingInstance AS iListingInstance,ListingInstance.fbeid, ListingInstance.iListingInstance as ListingInstanceID,MIN( ListingInstance.iListingInstance ) AS MinListingInstanceID,ListingInstance.iListingID, ListingInstance.ticketStatus, ListingInstance.ticketsAdded, Ent.c_Type, Ent.Town, Ent.PostCode, Ent.postcode_lookup,Ent.majorCity,Ent.Name, Ent.safeName,Ent.Country, Ent.Address, Ent.EntID, Ent.Logo, Listings.EventName, Listings.EventDescShort, DayOfWeek(ListingInstance.iEventDate) AS iEventDay, Listings.Feature,FeatureDays, Ent.latitude, Ent.longitude, Listings.DoorsOpen, Listings.DoorsClose, Listings.LastEntry, Listings.EntryPrice, Listings.canonicalurl, Listings.canonicaldesc,Listings.PromotorID, Listings.DateAdded, Listings.DateEdited, Listings.imgName, Listings.imgVersion, Listings.cancelled, Listings.rescheduledDate, Listings.eventCurrency, Listings.izettleMerchantAccountId, Listings.qualityFlag_image, Ent.imgName as entImgName, Ent.imgVersion as entImgVersion,ListingInstance.shortUrl, eventStartDate, eventEndDate, Listings.waitingListListingEnabled, Listings.groupingID FROM Ent INNER JOIN ListingInstance ON Ent.EntID = ListingInstance.iEntID INNER JOIN Listings ON ListingInstance.iListingID = Listings.ListingID WHERE 1=1 AND MBRContains(st_geomfromtext('POLYGON((-1.6916517400619 54.708536231884, -1.6916517400619 54.853463768116,-1.4403482599381 54.853463768116,-1.4403482599381 54.708536231884,-1.6916517400619 54.708536231884))'),Ent.location) AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '79380' AND Listings.PromotorID != '28722' GROUP BY Listings.PromotorID ORDER BY salesCountLast7Days DESC, FeatureSpecial DESC LIMIT 4 OFFSET 0
SELECT Listings.ListingID, Ent.Rating, EventStartDateTime,EventEndDateTime, Listings.seatingPlanID, Listings.ExtTicketsAttached, Ent.Votes, Listings.MinAge, Listings.EventCode,Listings.TicketsAttached, CityCode, ListingInstance.iEventDate AS iEventDate, ListingInstance.goingto, EntryPrice, ListingInstance.iListingInstance AS iListingInstance,ListingInstance.fbeid, ListingInstance.iListingInstance as ListingInstanceID,MIN( ListingInstance.iListingInstance ) AS MinListingInstanceID,ListingInstance.iListingID, ListingInstance.ticketStatus, ListingInstance.ticketsAdded, Ent.c_Type, Ent.Town, Ent.PostCode, Ent.postcode_lookup,Ent.majorCity,Ent.Name, Ent.safeName,Ent.Country, Ent.Address, Ent.EntID, Ent.Logo, Listings.EventName, Listings.EventDescShort, DayOfWeek(ListingInstance.iEventDate) AS iEventDay, Listings.Feature,FeatureDays, Ent.latitude, Ent.longitude, Listings.DoorsOpen, Listings.DoorsClose, Listings.LastEntry, Listings.EntryPrice, Listings.canonicalurl, Listings.canonicaldesc,Listings.PromotorID, Listings.DateAdded, Listings.DateEdited, Listings.imgName, Listings.imgVersion, Listings.cancelled, Listings.rescheduledDate, Listings.eventCurrency, Listings.izettleMerchantAccountId, Listings.qualityFlag_image, Ent.imgName as entImgName, Ent.imgVersion as entImgVersion,ListingInstance.shortUrl, eventStartDate, eventEndDate, Listings.waitingListListingEnabled, Listings.groupingID FROM Ent INNER JOIN ListingInstance ON Ent.EntID = ListingInstance.iEntID INNER JOIN Listings ON ListingInstance.iListingID = Listings.ListingID WHERE 1=1 AND MBRContains(st_geomfromtext('POLYGON((-1.6916517400619 54.708536231884, -1.6916517400619 54.853463768116,-1.4403482599381 54.853463768116,-1.4403482599381 54.708536231884,-1.6916517400619 54.708536231884))'),Ent.location) AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '79381' AND Listings.PromotorID != '28722' GROUP BY Listings.PromotorID ORDER BY salesCountLast7Days DESC, FeatureSpecial DESC LIMIT 4 OFFSET 0
SELECT Listings.ListingID, Ent.Rating, EventStartDateTime,EventEndDateTime, Listings.seatingPlanID, Listings.ExtTicketsAttached, Ent.Votes, Listings.MinAge, Listings.EventCode,Listings.TicketsAttached, CityCode, ListingInstance.iEventDate AS iEventDate, ListingInstance.goingto, EntryPrice, ListingInstance.iListingInstance AS iListingInstance,ListingInstance.fbeid, ListingInstance.iListingInstance as ListingInstanceID,MIN( ListingInstance.iListingInstance ) AS MinListingInstanceID,ListingInstance.iListingID, ListingInstance.ticketStatus, ListingInstance.ticketsAdded, Ent.c_Type, Ent.Town, Ent.PostCode, Ent.postcode_lookup,Ent.majorCity,Ent.Name, Ent.safeName,Ent.Country, Ent.Address, Ent.EntID, Ent.Logo, Listings.EventName, Listings.EventDescShort, DayOfWeek(ListingInstance.iEventDate) AS iEventDay, Listings.Feature,FeatureDays, Ent.latitude, Ent.longitude, Listings.DoorsOpen, Listings.DoorsClose, Listings.LastEntry, Listings.EntryPrice, Listings.canonicalurl, Listings.canonicaldesc,Listings.PromotorID, Listings.DateAdded, Listings.DateEdited, Listings.imgName, Listings.imgVersion, Listings.cancelled, Listings.rescheduledDate, Listings.eventCurrency, Listings.izettleMerchantAccountId, Listings.qualityFlag_image, Ent.imgName as entImgName, Ent.imgVersion as entImgVersion,ListingInstance.shortUrl, eventStartDate, eventEndDate, Listings.waitingListListingEnabled, Listings.groupingID FROM Ent INNER JOIN ListingInstance ON Ent.EntID = ListingInstance.iEntID INNER JOIN Listings ON ListingInstance.iListingID = Listings.ListingID WHERE 1=1 AND MBRContains(st_geomfromtext('POLYGON((-1.6916517400619 54.708536231884, -1.6916517400619 54.853463768116,-1.4403482599381 54.853463768116,-1.4403482599381 54.708536231884,-1.6916517400619 54.708536231884))'),Ent.location) AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '79138' AND Listings.PromotorID != '28722' GROUP BY Listings.PromotorID ORDER BY salesCountLast7Days DESC, FeatureSpecial DESC LIMIT 4 OFFSET 0
SELECT Listings.ListingID, Ent.Rating, EventStartDateTime,EventEndDateTime, Listings.seatingPlanID, Listings.ExtTicketsAttached, Ent.Votes, Listings.MinAge, Listings.EventCode,Listings.TicketsAttached, CityCode, ListingInstance.iEventDate AS iEventDate, ListingInstance.goingto, EntryPrice, ListingInstance.iListingInstance AS iListingInstance,ListingInstance.fbeid, ListingInstance.iListingInstance as ListingInstanceID,MIN( ListingInstance.iListingInstance ) AS MinListingInstanceID,ListingInstance.iListingID, ListingInstance.ticketStatus, ListingInstance.ticketsAdded, Ent.c_Type, Ent.Town, Ent.PostCode, Ent.postcode_lookup,Ent.majorCity,Ent.Name, Ent.safeName,Ent.Country, Ent.Address, Ent.EntID, Ent.Logo, Listings.EventName, Listings.EventDescShort, DayOfWeek(ListingInstance.iEventDate) AS iEventDay, Listings.Feature,FeatureDays, Ent.latitude, Ent.longitude, Listings.DoorsOpen, Listings.DoorsClose, Listings.LastEntry, Listings.EntryPrice, Listings.canonicalurl, Listings.canonicaldesc,Listings.PromotorID, Listings.DateAdded, Listings.DateEdited, Listings.imgName, Listings.imgVersion, Listings.cancelled, Listings.rescheduledDate, Listings.eventCurrency, Listings.izettleMerchantAccountId, Listings.qualityFlag_image, Ent.imgName as entImgName, Ent.imgVersion as entImgVersion,ListingInstance.shortUrl, eventStartDate, eventEndDate, Listings.waitingListListingEnabled, Listings.groupingID FROM Ent INNER JOIN ListingInstance ON Ent.EntID = ListingInstance.iEntID INNER JOIN Listings ON ListingInstance.iListingID = Listings.ListingID WHERE 1=1 AND MBRContains(st_geomfromtext('POLYGON((-1.6916517400619 54.708536231884, -1.6916517400619 54.853463768116,-1.4403482599381 54.853463768116,-1.4403482599381 54.708536231884,-1.6916517400619 54.708536231884))'),Ent.location) AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '75865' AND Listings.PromotorID != '28722' GROUP BY Listings.PromotorID ORDER BY salesCountLast7Days DESC, FeatureSpecial DESC LIMIT 4 OFFSET 0
SELECT Listings.ListingID, Ent.Rating, EventStartDateTime,EventEndDateTime, Listings.seatingPlanID, Listings.ExtTicketsAttached, Ent.Votes, Listings.MinAge, Listings.EventCode,Listings.TicketsAttached, CityCode, ListingInstance.iEventDate AS iEventDate, ListingInstance.goingto, EntryPrice, ListingInstance.iListingInstance AS iListingInstance,ListingInstance.fbeid, ListingInstance.iListingInstance as ListingInstanceID,MIN( ListingInstance.iListingInstance ) AS MinListingInstanceID,ListingInstance.iListingID, ListingInstance.ticketStatus, ListingInstance.ticketsAdded, Ent.c_Type, Ent.Town, Ent.PostCode, Ent.postcode_lookup,Ent.majorCity,Ent.Name, Ent.safeName,Ent.Country, Ent.Address, Ent.EntID, Ent.Logo, Listings.EventName, Listings.EventDescShort, DayOfWeek(ListingInstance.iEventDate) AS iEventDay, Listings.Feature,FeatureDays, Ent.latitude, Ent.longitude, Listings.DoorsOpen, Listings.DoorsClose, Listings.LastEntry, Listings.EntryPrice, Listings.canonicalurl, Listings.canonicaldesc,Listings.PromotorID, Listings.DateAdded, Listings.DateEdited, Listings.imgName, Listings.imgVersion, Listings.cancelled, Listings.rescheduledDate, Listings.eventCurrency, Listings.izettleMerchantAccountId, Listings.qualityFlag_image, Ent.imgName as entImgName, Ent.imgVersion as entImgVersion,ListingInstance.shortUrl, eventStartDate, eventEndDate, Listings.waitingListListingEnabled, Listings.groupingID FROM Ent INNER JOIN ListingInstance ON Ent.EntID = ListingInstance.iEntID INNER JOIN Listings ON ListingInstance.iListingID = Listings.ListingID WHERE 1=1 AND MBRContains(st_geomfromtext('POLYGON((-1.6916517400619 54.708536231884, -1.6916517400619 54.853463768116,-1.4403482599381 54.853463768116,-1.4403482599381 54.708536231884,-1.6916517400619 54.708536231884))'),Ent.location) AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '78686' AND Listings.PromotorID != '28722' GROUP BY Listings.PromotorID ORDER BY salesCountLast7Days DESC, FeatureSpecial DESC LIMIT 4 OFFSET 0
SELECT Listings.ListingID, Ent.Rating, EventStartDateTime,EventEndDateTime, Listings.seatingPlanID, Listings.ExtTicketsAttached, Ent.Votes, Listings.MinAge, Listings.EventCode,Listings.TicketsAttached, CityCode, ListingInstance.iEventDate AS iEventDate, ListingInstance.goingto, EntryPrice, ListingInstance.iListingInstance AS iListingInstance,ListingInstance.fbeid, ListingInstance.iListingInstance as ListingInstanceID,MIN( ListingInstance.iListingInstance ) AS MinListingInstanceID,ListingInstance.iListingID, ListingInstance.ticketStatus, ListingInstance.ticketsAdded, Ent.c_Type, Ent.Town, Ent.PostCode, Ent.postcode_lookup,Ent.majorCity,Ent.Name, Ent.safeName,Ent.Country, Ent.Address, Ent.EntID, Ent.Logo, Listings.EventName, Listings.EventDescShort, DayOfWeek(ListingInstance.iEventDate) AS iEventDay, Listings.Feature,FeatureDays, Ent.latitude, Ent.longitude, Listings.DoorsOpen, Listings.DoorsClose, Listings.LastEntry, Listings.EntryPrice, Listings.canonicalurl, Listings.canonicaldesc,Listings.PromotorID, Listings.DateAdded, Listings.DateEdited, Listings.imgName, Listings.imgVersion, Listings.cancelled, Listings.rescheduledDate, Listings.eventCurrency, Listings.izettleMerchantAccountId, Listings.qualityFlag_image, Ent.imgName as entImgName, Ent.imgVersion as entImgVersion,ListingInstance.shortUrl, eventStartDate, eventEndDate, Listings.waitingListListingEnabled, Listings.groupingID FROM Ent INNER JOIN ListingInstance ON Ent.EntID = ListingInstance.iEntID INNER JOIN Listings ON ListingInstance.iListingID = Listings.ListingID WHERE 1=1 AND MBRContains(st_geomfromtext('POLYGON((-1.6916517400619 54.708536231884, -1.6916517400619 54.853463768116,-1.4403482599381 54.853463768116,-1.4403482599381 54.708536231884,-1.6916517400619 54.708536231884))'),Ent.location) AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '74371' AND Listings.PromotorID != '28722' GROUP BY Listings.PromotorID ORDER BY salesCountLast7Days DESC, FeatureSpecial DESC LIMIT 4 OFFSET 0
SELECT Listings.ListingID, Ent.Rating, EventStartDateTime,EventEndDateTime, Listings.seatingPlanID, Listings.ExtTicketsAttached, Ent.Votes, Listings.MinAge, Listings.EventCode,Listings.TicketsAttached, CityCode, ListingInstance.iEventDate AS iEventDate, ListingInstance.goingto, EntryPrice, ListingInstance.iListingInstance AS iListingInstance,ListingInstance.fbeid, ListingInstance.iListingInstance as ListingInstanceID,MIN( ListingInstance.iListingInstance ) AS MinListingInstanceID,ListingInstance.iListingID, ListingInstance.ticketStatus, ListingInstance.ticketsAdded, Ent.c_Type, Ent.Town, Ent.PostCode, Ent.postcode_lookup,Ent.majorCity,Ent.Name, Ent.safeName,Ent.Country, Ent.Address, Ent.EntID, Ent.Logo, Listings.EventName, Listings.EventDescShort, DayOfWeek(ListingInstance.iEventDate) AS iEventDay, Listings.Feature,FeatureDays, Ent.latitude, Ent.longitude, Listings.DoorsOpen, Listings.DoorsClose, Listings.LastEntry, Listings.EntryPrice, Listings.canonicalurl, Listings.canonicaldesc,Listings.PromotorID, Listings.DateAdded, Listings.DateEdited, Listings.imgName, Listings.imgVersion, Listings.cancelled, Listings.rescheduledDate, Listings.eventCurrency, Listings.izettleMerchantAccountId, Listings.qualityFlag_image, Ent.imgName as entImgName, Ent.imgVersion as entImgVersion,ListingInstance.shortUrl, eventStartDate, eventEndDate, Listings.waitingListListingEnabled, Listings.groupingID FROM Ent INNER JOIN ListingInstance ON Ent.EntID = ListingInstance.iEntID INNER JOIN Listings ON ListingInstance.iListingID = Listings.ListingID WHERE 1=1 AND MBRContains(st_geomfromtext('POLYGON((-1.6916517400619 54.708536231884, -1.6916517400619 54.853463768116,-1.4403482599381 54.853463768116,-1.4403482599381 54.708536231884,-1.6916517400619 54.708536231884))'),Ent.location) AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '78723' AND Listings.PromotorID != '28722' GROUP BY Listings.PromotorID ORDER BY salesCountLast7Days DESC, FeatureSpecial DESC LIMIT 4 OFFSET 0
SELECT Listings.ListingID, Ent.Rating, EventStartDateTime,EventEndDateTime, Listings.seatingPlanID, Listings.ExtTicketsAttached, Ent.Votes, Listings.MinAge, Listings.EventCode,Listings.TicketsAttached, CityCode, ListingInstance.iEventDate AS iEventDate, ListingInstance.goingto, EntryPrice, ListingInstance.iListingInstance AS iListingInstance,ListingInstance.fbeid, ListingInstance.iListingInstance as ListingInstanceID,MIN( ListingInstance.iListingInstance ) AS MinListingInstanceID,ListingInstance.iListingID, ListingInstance.ticketStatus, ListingInstance.ticketsAdded, Ent.c_Type, Ent.Town, Ent.PostCode, Ent.postcode_lookup,Ent.majorCity,Ent.Name, Ent.safeName,Ent.Country, Ent.Address, Ent.EntID, Ent.Logo, Listings.EventName, Listings.EventDescShort, DayOfWeek(ListingInstance.iEventDate) AS iEventDay, Listings.Feature,FeatureDays, Ent.latitude, Ent.longitude, Listings.DoorsOpen, Listings.DoorsClose, Listings.LastEntry, Listings.EntryPrice, Listings.canonicalurl, Listings.canonicaldesc,Listings.PromotorID, Listings.DateAdded, Listings.DateEdited, Listings.imgName, Listings.imgVersion, Listings.cancelled, Listings.rescheduledDate, Listings.eventCurrency, Listings.izettleMerchantAccountId, Listings.qualityFlag_image, Ent.imgName as entImgName, Ent.imgVersion as entImgVersion,ListingInstance.shortUrl, eventStartDate, eventEndDate, Listings.waitingListListingEnabled, Listings.groupingID FROM Ent INNER JOIN ListingInstance ON Ent.EntID = ListingInstance.iEntID INNER JOIN Listings ON ListingInstance.iListingID = Listings.ListingID WHERE 1=1 AND MBRContains(st_geomfromtext('POLYGON((-1.6916517400619 54.708536231884, -1.6916517400619 54.853463768116,-1.4403482599381 54.853463768116,-1.4403482599381 54.708536231884,-1.6916517400619 54.708536231884))'),Ent.location) AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '72115' AND Listings.PromotorID != '28722' GROUP BY Listings.PromotorID ORDER BY salesCountLast7Days DESC, FeatureSpecial DESC LIMIT 4 OFFSET 0
SELECT Listings.ListingID, Ent.Rating, EventStartDateTime,EventEndDateTime, Listings.seatingPlanID, Listings.ExtTicketsAttached, Ent.Votes, Listings.MinAge, Listings.EventCode,Listings.TicketsAttached, CityCode, ListingInstance.iEventDate AS iEventDate, ListingInstance.goingto, EntryPrice, ListingInstance.iListingInstance AS iListingInstance,ListingInstance.fbeid, ListingInstance.iListingInstance as ListingInstanceID,MIN( ListingInstance.iListingInstance ) AS MinListingInstanceID,ListingInstance.iListingID, ListingInstance.ticketStatus, ListingInstance.ticketsAdded, Ent.c_Type, Ent.Town, Ent.PostCode, Ent.postcode_lookup,Ent.majorCity,Ent.Name, Ent.safeName,Ent.Country, Ent.Address, Ent.EntID, Ent.Logo, Listings.EventName, Listings.EventDescShort, DayOfWeek(ListingInstance.iEventDate) AS iEventDay, Listings.Feature,FeatureDays, Ent.latitude, Ent.longitude, Listings.DoorsOpen, Listings.DoorsClose, Listings.LastEntry, Listings.EntryPrice, Listings.canonicalurl, Listings.canonicaldesc,Listings.PromotorID, Listings.DateAdded, Listings.DateEdited, Listings.imgName, Listings.imgVersion, Listings.cancelled, Listings.rescheduledDate, Listings.eventCurrency, Listings.izettleMerchantAccountId, Listings.qualityFlag_image, Ent.imgName as entImgName, Ent.imgVersion as entImgVersion,ListingInstance.shortUrl, eventStartDate, eventEndDate, Listings.waitingListListingEnabled, Listings.groupingID FROM Ent INNER JOIN ListingInstance ON Ent.EntID = ListingInstance.iEntID INNER JOIN Listings ON ListingInstance.iListingID = Listings.ListingID WHERE 1=1 AND MBRContains(st_geomfromtext('POLYGON((-1.6916517400619 54.708536231884, -1.6916517400619 54.853463768116,-1.4403482599381 54.853463768116,-1.4403482599381 54.708536231884,-1.6916517400619 54.708536231884))'),Ent.location) AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '69077' AND Listings.PromotorID != '28722' GROUP BY Listings.PromotorID ORDER BY salesCountLast7Days DESC, FeatureSpecial DESC LIMIT 4 OFFSET 0
SELECT Listings.ListingID, Ent.Rating, EventStartDateTime,EventEndDateTime, Listings.seatingPlanID, Listings.ExtTicketsAttached, Ent.Votes, Listings.MinAge, Listings.EventCode,Listings.TicketsAttached, CityCode, ListingInstance.iEventDate AS iEventDate, ListingInstance.goingto, EntryPrice, ListingInstance.iListingInstance AS iListingInstance,ListingInstance.fbeid, ListingInstance.iListingInstance as ListingInstanceID,MIN( ListingInstance.iListingInstance ) AS MinListingInstanceID,ListingInstance.iListingID, ListingInstance.ticketStatus, ListingInstance.ticketsAdded, Ent.c_Type, Ent.Town, Ent.PostCode, Ent.postcode_lookup,Ent.majorCity,Ent.Name, Ent.safeName,Ent.Country, Ent.Address, Ent.EntID, Ent.Logo, Listings.EventName, Listings.EventDescShort, DayOfWeek(ListingInstance.iEventDate) AS iEventDay, Listings.Feature,FeatureDays, Ent.latitude, Ent.longitude, Listings.DoorsOpen, Listings.DoorsClose, Listings.LastEntry, Listings.EntryPrice, Listings.canonicalurl, Listings.canonicaldesc,Listings.PromotorID, Listings.DateAdded, Listings.DateEdited, Listings.imgName, Listings.imgVersion, Listings.cancelled, Listings.rescheduledDate, Listings.eventCurrency, Listings.izettleMerchantAccountId, Listings.qualityFlag_image, Ent.imgName as entImgName, Ent.imgVersion as entImgVersion,ListingInstance.shortUrl, eventStartDate, eventEndDate, Listings.waitingListListingEnabled, Listings.groupingID FROM Ent INNER JOIN ListingInstance ON Ent.EntID = ListingInstance.iEntID INNER JOIN Listings ON ListingInstance.iListingID = Listings.ListingID WHERE 1=1 AND MBRContains(st_geomfromtext('POLYGON((-1.6916517400619 54.708536231884, -1.6916517400619 54.853463768116,-1.4403482599381 54.853463768116,-1.4403482599381 54.708536231884,-1.6916517400619 54.708536231884))'),Ent.location) AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '76022' AND Listings.PromotorID != '28722' GROUP BY Listings.PromotorID ORDER BY salesCountLast7Days DESC, FeatureSpecial DESC LIMIT 4 OFFSET 0
Warning: Cannot modify header information - headers already sent by (output started at /home/vhosts/skiddle.com/httpdocs/functions/events.class.php:1255) in /home/vhosts/skiddle.com/httpdocs/navigation/header-responsive2.php on line 5

Warning: Cannot modify header information - headers already sent by (output started at /home/vhosts/skiddle.com/httpdocs/functions/events.class.php:1255) in /home/vhosts/skiddle.com/httpdocs/navigation/includes/csp.php on line 67

Warning: Cannot modify header information - headers already sent by (output started at /home/vhosts/skiddle.com/httpdocs/functions/events.class.php:1255) in /home/vhosts/skiddle.com/httpdocs/navigation/includes/csp.php on line 87
Durham Tickets Guide | Buy Tickets to Durham Events | Skiddle

Durham Guide

Hot Durham tickets

Planning that gig or rave in advance? Check out our comprehensive selection of the best tickets on sale for nights out in and around the Durham area.
Chubby Brown - 'Britains King of Comedy'
×

Chubby Brown - 'Britains King of Comedy'

Rainton Arena, Houghton-le-Spring

17th March

6:00pm til 10:30pm (last entry 7:15pm)

Minimum Age: 18

For ticket prices, please click here (Additional fees may apply)

The legendary Chubby Brown may not be everyone’s cup of tea ... But, a lot of people like tea!!

So Fetch - 2000s Party (Durham)
×

So Fetch - 2000s Party (Durham)

Klute, Durham

11th February

10:30pm til 2:00am (last entry 1:00am)

Minimum Age: 18

For ticket prices, please click here (Additional fees may apply)

You Go Glen Coco! Join us for a night of 2000s magic and get ready to sing your hearts out! 2000s ou...

Lunch & Laughs, LIVE! Tour 2023
×

Lunch & Laughs, LIVE! Tour 2023

Radisson Blu Hotel, Durham

23rd April

11:15am til 3:30pm

No age restrictions

For ticket prices, please click here (Additional fees may apply)

Join us at a ladies lunch like no other... Back after a sell out tour in 2021, Lunch & Laughs, L...

Wonderland Festival 2023
×

Wonderland Festival 2023

Rainton Arena, Houghton-le-Spring

2nd December

12:00pm til 10:00pm (last entry 5:00pm)

Minimum Age: 18

For ticket prices, please click here (Additional fees may apply)

Wonderland is back ?? Bigger and better than ever! 5000 People Huge Line Up Massive Production...

Durham events »

Your event not listed? Promote your event online

More about Durham

Irrespective of whether you're a first time visitor to the city, a frequently returning guest or a lifelong inhabitant, our guides are essential reading for anyone looking to make the most of their time in Durham.

Hotels Near Durham

Hotels Near Durham

Take a look at our wide range of Durham hotels. You can even save up to 70% by booking through Skiddle.

Top image: "IMGP9125" by mattbuck4950 is licensed under Attribution-ShareAlike License

Bottom image: "Barnard Castle" by rockindave1 is licensed under Attribution License