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.800536231884 AND 53.945463768116 AND Longitude BETWEEN -1.8359080547478 and -1.5900919452522 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.800536231884 AND 53.945463768116 AND Longitude BETWEEN -1.8359080547478 and -1.5900919452522 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '11316' 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.800536231884 AND 53.945463768116 AND Longitude BETWEEN -1.8359080547478 and -1.5900919452522 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '12176' 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.800536231884 AND 53.945463768116 AND Longitude BETWEEN -1.8359080547478 and -1.5900919452522 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '27682' 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.800536231884 AND 53.945463768116 AND Longitude BETWEEN -1.8359080547478 and -1.5900919452522 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '11906' 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.800536231884 AND 53.945463768116 AND Longitude BETWEEN -1.8359080547478 and -1.5900919452522 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '34620' 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.800536231884 AND 53.945463768116 AND Longitude BETWEEN -1.8359080547478 and -1.5900919452522 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '373' 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.800536231884 AND 53.945463768116 AND Longitude BETWEEN -1.8359080547478 and -1.5900919452522 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '1283' 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.800536231884 AND 53.945463768116 AND Longitude BETWEEN -1.8359080547478 and -1.5900919452522 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '1649' 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.800536231884 AND 53.945463768116 AND Longitude BETWEEN -1.8359080547478 and -1.5900919452522 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '1482' 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.800536231884 AND 53.945463768116 AND Longitude BETWEEN -1.8359080547478 and -1.5900919452522 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '36250' 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.800536231884 AND 53.945463768116 AND Longitude BETWEEN -1.8359080547478 and -1.5900919452522 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '36720' 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.800536231884 AND 53.945463768116 AND Longitude BETWEEN -1.8359080547478 and -1.5900919452522 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '28926' 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.800536231884 AND 53.945463768116 AND Longitude BETWEEN -1.8359080547478 and -1.5900919452522 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '5914' 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.800536231884 AND 53.945463768116 AND Longitude BETWEEN -1.8359080547478 and -1.5900919452522 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '10227' 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.800536231884 AND 53.945463768116 AND Longitude BETWEEN -1.8359080547478 and -1.5900919452522 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '11901' 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.800536231884 AND 53.945463768116 AND Longitude BETWEEN -1.8359080547478 and -1.5900919452522 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '21964' 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.800536231884 AND 53.945463768116 AND Longitude BETWEEN -1.8359080547478 and -1.5900919452522 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '231' 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.800536231884 AND 53.945463768116 AND Longitude BETWEEN -1.8359080547478 and -1.5900919452522 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '33260' 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.800536231884 AND 53.945463768116 AND Longitude BETWEEN -1.8359080547478 and -1.5900919452522 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '55137' 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.800536231884 AND 53.945463768116 AND Longitude BETWEEN -1.8359080547478 and -1.5900919452522 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '65283' 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.800536231884 AND 53.945463768116 AND Longitude BETWEEN -1.8359080547478 and -1.5900919452522 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '532' 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.800536231884 AND 53.945463768116 AND Longitude BETWEEN -1.8359080547478 and -1.5900919452522 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '31354' 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.800536231884 AND 53.945463768116 AND Longitude BETWEEN -1.8359080547478 and -1.5900919452522 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '48552' 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.800536231884 AND 53.945463768116 AND Longitude BETWEEN -1.8359080547478 and -1.5900919452522 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '55152' 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.800536231884 AND 53.945463768116 AND Longitude BETWEEN -1.8359080547478 and -1.5900919452522 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '7312' 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.800536231884 AND 53.945463768116 AND Longitude BETWEEN -1.8359080547478 and -1.5900919452522 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '58484' 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.800536231884 AND 53.945463768116 AND Longitude BETWEEN -1.8359080547478 and -1.5900919452522 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '24372' 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.800536231884 AND 53.945463768116 AND Longitude BETWEEN -1.8359080547478 and -1.5900919452522 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '6145' 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.800536231884 AND 53.945463768116 AND Longitude BETWEEN -1.8359080547478 and -1.5900919452522 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '5606' 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.800536231884 AND 53.945463768116 AND Longitude BETWEEN -1.8359080547478 and -1.5900919452522 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '13293' AND Listings.PromotorID != '28722' GROUP BY Listings.PromotorID ORDER BY salesCountLast7Days DESC, FeatureSpecial DESC LIMIT 4 OFFSET 0 Guiseley Tickets Guide | Buy Tickets to Guiseley Events | Skiddle
Coronavirus update: View cancelled events here

Guiseley Guide

Hot Guiseley 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 Guiseley area.
John Lennon Tribute UK
×

John Lennon Tribute UK

Yeadon Town Hall, Leeds

Saturday 25th Sep

7:30pm til 11:00pm

Minimum Age: 18

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

John Lennon Tribute UK playing the best of his solo work and his classic Beatles songs.

Guiseley events »

Your event not listed? Promote your event online

More about Guiseley

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

Guiseley Restaurants

Guiseley Restaurants

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

Hotels Near Guiseley

Hotels Near Guiseley

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