SELECT Listings.ListingID, Ent.Rating, EventStartDateTime,EventEndDateTime, Listings.ExtTicketsAttached, Ent.Votes, Listings.MinAge, Listings.EventCode,Listings.TicketsAttached, CityCode, ListingInstance.iEventDate AS iEventDate, ListingInstance.goingto, EntryPrice, ListingInstance.iListingInstance,ListingInstance.fbeid, ListingInstance.iListingInstance as ListingInstanceID,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 FROM Ent INNER JOIN ListingInstance ON Ent.EntID = ListingInstance.iEntID INNER JOIN Listings ON ListingInstance.iListingID = Listings.ListingID WHERE 1=1 AND Latitude BETWEEN 53.517536231884 AND 53.662463768116 AND Longitude BETWEEN -2.5660834397355 and -2.3219165602645 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.ExtTicketsAttached, Ent.Votes, Listings.MinAge, Listings.EventCode,Listings.TicketsAttached, CityCode, ListingInstance.iEventDate AS iEventDate, ListingInstance.goingto, EntryPrice, ListingInstance.iListingInstance,ListingInstance.fbeid, ListingInstance.iListingInstance as ListingInstanceID,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 FROM Ent INNER JOIN ListingInstance ON Ent.EntID = ListingInstance.iEntID INNER JOIN Listings ON ListingInstance.iListingID = Listings.ListingID WHERE 1=1 AND Latitude BETWEEN 53.517536231884 AND 53.662463768116 AND Longitude BETWEEN -2.5660834397355 and -2.3219165602645 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '35106' 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.ExtTicketsAttached, Ent.Votes, Listings.MinAge, Listings.EventCode,Listings.TicketsAttached, CityCode, ListingInstance.iEventDate AS iEventDate, ListingInstance.goingto, EntryPrice, ListingInstance.iListingInstance,ListingInstance.fbeid, ListingInstance.iListingInstance as ListingInstanceID,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 FROM Ent INNER JOIN ListingInstance ON Ent.EntID = ListingInstance.iEntID INNER JOIN Listings ON ListingInstance.iListingID = Listings.ListingID WHERE 1=1 AND Latitude BETWEEN 53.517536231884 AND 53.662463768116 AND Longitude BETWEEN -2.5660834397355 and -2.3219165602645 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '34634' 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.ExtTicketsAttached, Ent.Votes, Listings.MinAge, Listings.EventCode,Listings.TicketsAttached, CityCode, ListingInstance.iEventDate AS iEventDate, ListingInstance.goingto, EntryPrice, ListingInstance.iListingInstance,ListingInstance.fbeid, ListingInstance.iListingInstance as ListingInstanceID,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 FROM Ent INNER JOIN ListingInstance ON Ent.EntID = ListingInstance.iEntID INNER JOIN Listings ON ListingInstance.iListingID = Listings.ListingID WHERE 1=1 AND Latitude BETWEEN 53.517536231884 AND 53.662463768116 AND Longitude BETWEEN -2.5660834397355 and -2.3219165602645 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '536' 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.ExtTicketsAttached, Ent.Votes, Listings.MinAge, Listings.EventCode,Listings.TicketsAttached, CityCode, ListingInstance.iEventDate AS iEventDate, ListingInstance.goingto, EntryPrice, ListingInstance.iListingInstance,ListingInstance.fbeid, ListingInstance.iListingInstance as ListingInstanceID,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 FROM Ent INNER JOIN ListingInstance ON Ent.EntID = ListingInstance.iEntID INNER JOIN Listings ON ListingInstance.iListingID = Listings.ListingID WHERE 1=1 AND Latitude BETWEEN 53.517536231884 AND 53.662463768116 AND Longitude BETWEEN -2.5660834397355 and -2.3219165602645 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '3971' 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.ExtTicketsAttached, Ent.Votes, Listings.MinAge, Listings.EventCode,Listings.TicketsAttached, CityCode, ListingInstance.iEventDate AS iEventDate, ListingInstance.goingto, EntryPrice, ListingInstance.iListingInstance,ListingInstance.fbeid, ListingInstance.iListingInstance as ListingInstanceID,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 FROM Ent INNER JOIN ListingInstance ON Ent.EntID = ListingInstance.iEntID INNER JOIN Listings ON ListingInstance.iListingID = Listings.ListingID WHERE 1=1 AND Latitude BETWEEN 53.517536231884 AND 53.662463768116 AND Longitude BETWEEN -2.5660834397355 and -2.3219165602645 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '11705' 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.ExtTicketsAttached, Ent.Votes, Listings.MinAge, Listings.EventCode,Listings.TicketsAttached, CityCode, ListingInstance.iEventDate AS iEventDate, ListingInstance.goingto, EntryPrice, ListingInstance.iListingInstance,ListingInstance.fbeid, ListingInstance.iListingInstance as ListingInstanceID,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 FROM Ent INNER JOIN ListingInstance ON Ent.EntID = ListingInstance.iEntID INNER JOIN Listings ON ListingInstance.iListingID = Listings.ListingID WHERE 1=1 AND Latitude BETWEEN 53.517536231884 AND 53.662463768116 AND Longitude BETWEEN -2.5660834397355 and -2.3219165602645 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '18076' 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.ExtTicketsAttached, Ent.Votes, Listings.MinAge, Listings.EventCode,Listings.TicketsAttached, CityCode, ListingInstance.iEventDate AS iEventDate, ListingInstance.goingto, EntryPrice, ListingInstance.iListingInstance,ListingInstance.fbeid, ListingInstance.iListingInstance as ListingInstanceID,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 FROM Ent INNER JOIN ListingInstance ON Ent.EntID = ListingInstance.iEntID INNER JOIN Listings ON ListingInstance.iListingID = Listings.ListingID WHERE 1=1 AND Latitude BETWEEN 53.517536231884 AND 53.662463768116 AND Longitude BETWEEN -2.5660834397355 and -2.3219165602645 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '30902' 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.ExtTicketsAttached, Ent.Votes, Listings.MinAge, Listings.EventCode,Listings.TicketsAttached, CityCode, ListingInstance.iEventDate AS iEventDate, ListingInstance.goingto, EntryPrice, ListingInstance.iListingInstance,ListingInstance.fbeid, ListingInstance.iListingInstance as ListingInstanceID,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 FROM Ent INNER JOIN ListingInstance ON Ent.EntID = ListingInstance.iEntID INNER JOIN Listings ON ListingInstance.iListingID = Listings.ListingID WHERE 1=1 AND Latitude BETWEEN 53.517536231884 AND 53.662463768116 AND Longitude BETWEEN -2.5660834397355 and -2.3219165602645 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '18535' 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.ExtTicketsAttached, Ent.Votes, Listings.MinAge, Listings.EventCode,Listings.TicketsAttached, CityCode, ListingInstance.iEventDate AS iEventDate, ListingInstance.goingto, EntryPrice, ListingInstance.iListingInstance,ListingInstance.fbeid, ListingInstance.iListingInstance as ListingInstanceID,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 FROM Ent INNER JOIN ListingInstance ON Ent.EntID = ListingInstance.iEntID INNER JOIN Listings ON ListingInstance.iListingID = Listings.ListingID WHERE 1=1 AND Latitude BETWEEN 53.517536231884 AND 53.662463768116 AND Longitude BETWEEN -2.5660834397355 and -2.3219165602645 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '11519' 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.ExtTicketsAttached, Ent.Votes, Listings.MinAge, Listings.EventCode,Listings.TicketsAttached, CityCode, ListingInstance.iEventDate AS iEventDate, ListingInstance.goingto, EntryPrice, ListingInstance.iListingInstance,ListingInstance.fbeid, ListingInstance.iListingInstance as ListingInstanceID,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 FROM Ent INNER JOIN ListingInstance ON Ent.EntID = ListingInstance.iEntID INNER JOIN Listings ON ListingInstance.iListingID = Listings.ListingID WHERE 1=1 AND Latitude BETWEEN 53.517536231884 AND 53.662463768116 AND Longitude BETWEEN -2.5660834397355 and -2.3219165602645 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '11251' 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.ExtTicketsAttached, Ent.Votes, Listings.MinAge, Listings.EventCode,Listings.TicketsAttached, CityCode, ListingInstance.iEventDate AS iEventDate, ListingInstance.goingto, EntryPrice, ListingInstance.iListingInstance,ListingInstance.fbeid, ListingInstance.iListingInstance as ListingInstanceID,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 FROM Ent INNER JOIN ListingInstance ON Ent.EntID = ListingInstance.iEntID INNER JOIN Listings ON ListingInstance.iListingID = Listings.ListingID WHERE 1=1 AND Latitude BETWEEN 53.517536231884 AND 53.662463768116 AND Longitude BETWEEN -2.5660834397355 and -2.3219165602645 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '30580' 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.ExtTicketsAttached, Ent.Votes, Listings.MinAge, Listings.EventCode,Listings.TicketsAttached, CityCode, ListingInstance.iEventDate AS iEventDate, ListingInstance.goingto, EntryPrice, ListingInstance.iListingInstance,ListingInstance.fbeid, ListingInstance.iListingInstance as ListingInstanceID,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 FROM Ent INNER JOIN ListingInstance ON Ent.EntID = ListingInstance.iEntID INNER JOIN Listings ON ListingInstance.iListingID = Listings.ListingID WHERE 1=1 AND Latitude BETWEEN 53.517536231884 AND 53.662463768116 AND Longitude BETWEEN -2.5660834397355 and -2.3219165602645 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '47704' 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.ExtTicketsAttached, Ent.Votes, Listings.MinAge, Listings.EventCode,Listings.TicketsAttached, CityCode, ListingInstance.iEventDate AS iEventDate, ListingInstance.goingto, EntryPrice, ListingInstance.iListingInstance,ListingInstance.fbeid, ListingInstance.iListingInstance as ListingInstanceID,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 FROM Ent INNER JOIN ListingInstance ON Ent.EntID = ListingInstance.iEntID INNER JOIN Listings ON ListingInstance.iListingID = Listings.ListingID WHERE 1=1 AND Latitude BETWEEN 53.517536231884 AND 53.662463768116 AND Longitude BETWEEN -2.5660834397355 and -2.3219165602645 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '34220' 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.ExtTicketsAttached, Ent.Votes, Listings.MinAge, Listings.EventCode,Listings.TicketsAttached, CityCode, ListingInstance.iEventDate AS iEventDate, ListingInstance.goingto, EntryPrice, ListingInstance.iListingInstance,ListingInstance.fbeid, ListingInstance.iListingInstance as ListingInstanceID,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 FROM Ent INNER JOIN ListingInstance ON Ent.EntID = ListingInstance.iEntID INNER JOIN Listings ON ListingInstance.iListingID = Listings.ListingID WHERE 1=1 AND Latitude BETWEEN 53.517536231884 AND 53.662463768116 AND Longitude BETWEEN -2.5660834397355 and -2.3219165602645 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '35014' 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.ExtTicketsAttached, Ent.Votes, Listings.MinAge, Listings.EventCode,Listings.TicketsAttached, CityCode, ListingInstance.iEventDate AS iEventDate, ListingInstance.goingto, EntryPrice, ListingInstance.iListingInstance,ListingInstance.fbeid, ListingInstance.iListingInstance as ListingInstanceID,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 FROM Ent INNER JOIN ListingInstance ON Ent.EntID = ListingInstance.iEntID INNER JOIN Listings ON ListingInstance.iListingID = Listings.ListingID WHERE 1=1 AND Latitude BETWEEN 53.517536231884 AND 53.662463768116 AND Longitude BETWEEN -2.5660834397355 and -2.3219165602645 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '1501' 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.ExtTicketsAttached, Ent.Votes, Listings.MinAge, Listings.EventCode,Listings.TicketsAttached, CityCode, ListingInstance.iEventDate AS iEventDate, ListingInstance.goingto, EntryPrice, ListingInstance.iListingInstance,ListingInstance.fbeid, ListingInstance.iListingInstance as ListingInstanceID,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 FROM Ent INNER JOIN ListingInstance ON Ent.EntID = ListingInstance.iEntID INNER JOIN Listings ON ListingInstance.iListingID = Listings.ListingID WHERE 1=1 AND Latitude BETWEEN 53.517536231884 AND 53.662463768116 AND Longitude BETWEEN -2.5660834397355 and -2.3219165602645 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '6668' 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.ExtTicketsAttached, Ent.Votes, Listings.MinAge, Listings.EventCode,Listings.TicketsAttached, CityCode, ListingInstance.iEventDate AS iEventDate, ListingInstance.goingto, EntryPrice, ListingInstance.iListingInstance,ListingInstance.fbeid, ListingInstance.iListingInstance as ListingInstanceID,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 FROM Ent INNER JOIN ListingInstance ON Ent.EntID = ListingInstance.iEntID INNER JOIN Listings ON ListingInstance.iListingID = Listings.ListingID WHERE 1=1 AND Latitude BETWEEN 53.517536231884 AND 53.662463768116 AND Longitude BETWEEN -2.5660834397355 and -2.3219165602645 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '15712' 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.ExtTicketsAttached, Ent.Votes, Listings.MinAge, Listings.EventCode,Listings.TicketsAttached, CityCode, ListingInstance.iEventDate AS iEventDate, ListingInstance.goingto, EntryPrice, ListingInstance.iListingInstance,ListingInstance.fbeid, ListingInstance.iListingInstance as ListingInstanceID,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 FROM Ent INNER JOIN ListingInstance ON Ent.EntID = ListingInstance.iEntID INNER JOIN Listings ON ListingInstance.iListingID = Listings.ListingID WHERE 1=1 AND Latitude BETWEEN 53.517536231884 AND 53.662463768116 AND Longitude BETWEEN -2.5660834397355 and -2.3219165602645 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '48712' 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.ExtTicketsAttached, Ent.Votes, Listings.MinAge, Listings.EventCode,Listings.TicketsAttached, CityCode, ListingInstance.iEventDate AS iEventDate, ListingInstance.goingto, EntryPrice, ListingInstance.iListingInstance,ListingInstance.fbeid, ListingInstance.iListingInstance as ListingInstanceID,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 FROM Ent INNER JOIN ListingInstance ON Ent.EntID = ListingInstance.iEntID INNER JOIN Listings ON ListingInstance.iListingID = Listings.ListingID WHERE 1=1 AND Latitude BETWEEN 53.517536231884 AND 53.662463768116 AND Longitude BETWEEN -2.5660834397355 and -2.3219165602645 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '19382' 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.ExtTicketsAttached, Ent.Votes, Listings.MinAge, Listings.EventCode,Listings.TicketsAttached, CityCode, ListingInstance.iEventDate AS iEventDate, ListingInstance.goingto, EntryPrice, ListingInstance.iListingInstance,ListingInstance.fbeid, ListingInstance.iListingInstance as ListingInstanceID,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 FROM Ent INNER JOIN ListingInstance ON Ent.EntID = ListingInstance.iEntID INNER JOIN Listings ON ListingInstance.iListingID = Listings.ListingID WHERE 1=1 AND Latitude BETWEEN 53.517536231884 AND 53.662463768116 AND Longitude BETWEEN -2.5660834397355 and -2.3219165602645 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '5684' 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.ExtTicketsAttached, Ent.Votes, Listings.MinAge, Listings.EventCode,Listings.TicketsAttached, CityCode, ListingInstance.iEventDate AS iEventDate, ListingInstance.goingto, EntryPrice, ListingInstance.iListingInstance,ListingInstance.fbeid, ListingInstance.iListingInstance as ListingInstanceID,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 FROM Ent INNER JOIN ListingInstance ON Ent.EntID = ListingInstance.iEntID INNER JOIN Listings ON ListingInstance.iListingID = Listings.ListingID WHERE 1=1 AND Latitude BETWEEN 53.517536231884 AND 53.662463768116 AND Longitude BETWEEN -2.5660834397355 and -2.3219165602645 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '63836' 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.ExtTicketsAttached, Ent.Votes, Listings.MinAge, Listings.EventCode,Listings.TicketsAttached, CityCode, ListingInstance.iEventDate AS iEventDate, ListingInstance.goingto, EntryPrice, ListingInstance.iListingInstance,ListingInstance.fbeid, ListingInstance.iListingInstance as ListingInstanceID,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 FROM Ent INNER JOIN ListingInstance ON Ent.EntID = ListingInstance.iEntID INNER JOIN Listings ON ListingInstance.iListingID = Listings.ListingID WHERE 1=1 AND Latitude BETWEEN 53.517536231884 AND 53.662463768116 AND Longitude BETWEEN -2.5660834397355 and -2.3219165602645 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '33694' 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.ExtTicketsAttached, Ent.Votes, Listings.MinAge, Listings.EventCode,Listings.TicketsAttached, CityCode, ListingInstance.iEventDate AS iEventDate, ListingInstance.goingto, EntryPrice, ListingInstance.iListingInstance,ListingInstance.fbeid, ListingInstance.iListingInstance as ListingInstanceID,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 FROM Ent INNER JOIN ListingInstance ON Ent.EntID = ListingInstance.iEntID INNER JOIN Listings ON ListingInstance.iListingID = Listings.ListingID WHERE 1=1 AND Latitude BETWEEN 53.517536231884 AND 53.662463768116 AND Longitude BETWEEN -2.5660834397355 and -2.3219165602645 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '46070' 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.ExtTicketsAttached, Ent.Votes, Listings.MinAge, Listings.EventCode,Listings.TicketsAttached, CityCode, ListingInstance.iEventDate AS iEventDate, ListingInstance.goingto, EntryPrice, ListingInstance.iListingInstance,ListingInstance.fbeid, ListingInstance.iListingInstance as ListingInstanceID,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 FROM Ent INNER JOIN ListingInstance ON Ent.EntID = ListingInstance.iEntID INNER JOIN Listings ON ListingInstance.iListingID = Listings.ListingID WHERE 1=1 AND Latitude BETWEEN 53.517536231884 AND 53.662463768116 AND Longitude BETWEEN -2.5660834397355 and -2.3219165602645 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '685' 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.ExtTicketsAttached, Ent.Votes, Listings.MinAge, Listings.EventCode,Listings.TicketsAttached, CityCode, ListingInstance.iEventDate AS iEventDate, ListingInstance.goingto, EntryPrice, ListingInstance.iListingInstance,ListingInstance.fbeid, ListingInstance.iListingInstance as ListingInstanceID,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 FROM Ent INNER JOIN ListingInstance ON Ent.EntID = ListingInstance.iEntID INNER JOIN Listings ON ListingInstance.iListingID = Listings.ListingID WHERE 1=1 AND Latitude BETWEEN 53.517536231884 AND 53.662463768116 AND Longitude BETWEEN -2.5660834397355 and -2.3219165602645 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '4237' 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.ExtTicketsAttached, Ent.Votes, Listings.MinAge, Listings.EventCode,Listings.TicketsAttached, CityCode, ListingInstance.iEventDate AS iEventDate, ListingInstance.goingto, EntryPrice, ListingInstance.iListingInstance,ListingInstance.fbeid, ListingInstance.iListingInstance as ListingInstanceID,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 FROM Ent INNER JOIN ListingInstance ON Ent.EntID = ListingInstance.iEntID INNER JOIN Listings ON ListingInstance.iListingID = Listings.ListingID WHERE 1=1 AND Latitude BETWEEN 53.517536231884 AND 53.662463768116 AND Longitude BETWEEN -2.5660834397355 and -2.3219165602645 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '9778' 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.ExtTicketsAttached, Ent.Votes, Listings.MinAge, Listings.EventCode,Listings.TicketsAttached, CityCode, ListingInstance.iEventDate AS iEventDate, ListingInstance.goingto, EntryPrice, ListingInstance.iListingInstance,ListingInstance.fbeid, ListingInstance.iListingInstance as ListingInstanceID,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 FROM Ent INNER JOIN ListingInstance ON Ent.EntID = ListingInstance.iEntID INNER JOIN Listings ON ListingInstance.iListingID = Listings.ListingID WHERE 1=1 AND Latitude BETWEEN 53.517536231884 AND 53.662463768116 AND Longitude BETWEEN -2.5660834397355 and -2.3219165602645 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '6709' 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.ExtTicketsAttached, Ent.Votes, Listings.MinAge, Listings.EventCode,Listings.TicketsAttached, CityCode, ListingInstance.iEventDate AS iEventDate, ListingInstance.goingto, EntryPrice, ListingInstance.iListingInstance,ListingInstance.fbeid, ListingInstance.iListingInstance as ListingInstanceID,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 FROM Ent INNER JOIN ListingInstance ON Ent.EntID = ListingInstance.iEntID INNER JOIN Listings ON ListingInstance.iListingID = Listings.ListingID WHERE 1=1 AND Latitude BETWEEN 53.517536231884 AND 53.662463768116 AND Longitude BETWEEN -2.5660834397355 and -2.3219165602645 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '1284' 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.ExtTicketsAttached, Ent.Votes, Listings.MinAge, Listings.EventCode,Listings.TicketsAttached, CityCode, ListingInstance.iEventDate AS iEventDate, ListingInstance.goingto, EntryPrice, ListingInstance.iListingInstance,ListingInstance.fbeid, ListingInstance.iListingInstance as ListingInstanceID,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 FROM Ent INNER JOIN ListingInstance ON Ent.EntID = ListingInstance.iEntID INNER JOIN Listings ON ListingInstance.iListingID = Listings.ListingID WHERE 1=1 AND Latitude BETWEEN 53.517536231884 AND 53.662463768116 AND Longitude BETWEEN -2.5660834397355 and -2.3219165602645 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '5872' 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.ExtTicketsAttached, Ent.Votes, Listings.MinAge, Listings.EventCode,Listings.TicketsAttached, CityCode, ListingInstance.iEventDate AS iEventDate, ListingInstance.goingto, EntryPrice, ListingInstance.iListingInstance,ListingInstance.fbeid, ListingInstance.iListingInstance as ListingInstanceID,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 FROM Ent INNER JOIN ListingInstance ON Ent.EntID = ListingInstance.iEntID INNER JOIN Listings ON ListingInstance.iListingID = Listings.ListingID WHERE 1=1 AND Latitude BETWEEN 53.517536231884 AND 53.662463768116 AND Longitude BETWEEN -2.5660834397355 and -2.3219165602645 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '6414' AND Listings.PromotorID != '28722' GROUP BY Listings.PromotorID ORDER BY salesCountLast7Days DESC, FeatureSpecial DESC LIMIT 4 OFFSET 0 Bolton Tickets Guide | Buy Tickets to Bolton Events | Skiddle
Coronavirus update: View cancelled events here

Bolton Guide

Hot Bolton 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 Bolton area.
The Mission Grand Masters of Darts 2021
×

The Mission Grand Masters of Darts 2021

This event has been Cancelled

University Of Bolton Stadium , Bolton

Friday 4th Jun

7:30pm til 11:00pm (last entry 7:00pm)

Minimum Age: 14

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

The North West’s biggest darts legends

Bolton events »

Your event not listed? Promote your event online

More about Bolton

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 Bolton.

Bolton Restaurants

Bolton Restaurants

Find somewhere to eat in Bolton. Book your table online to take advantage of numerous special offers.

Hotels Near Bolton

Hotels Near Bolton

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

Top image: "A Glimpse of Sun Ray Burst" by diggler141 is licensed under Attribution-NoDerivs License

Bottom image: "" by jez.atkinson is licensed under Attribution License