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 56.124536231884 AND 56.269463768116 AND Longitude BETWEEN -3.3272510732428 and -3.0667489267572 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 56.124536231884 AND 56.269463768116 AND Longitude BETWEEN -3.3272510732428 and -3.0667489267572 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '52116' 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 56.124536231884 AND 56.269463768116 AND Longitude BETWEEN -3.3272510732428 and -3.0667489267572 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '2762' 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 56.124536231884 AND 56.269463768116 AND Longitude BETWEEN -3.3272510732428 and -3.0667489267572 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '42466' 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 56.124536231884 AND 56.269463768116 AND Longitude BETWEEN -3.3272510732428 and -3.0667489267572 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '79401' 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 56.124536231884 AND 56.269463768116 AND Longitude BETWEEN -3.3272510732428 and -3.0667489267572 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '78140' 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 56.124536231884 AND 56.269463768116 AND Longitude BETWEEN -3.3272510732428 and -3.0667489267572 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '73789' 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 56.124536231884 AND 56.269463768116 AND Longitude BETWEEN -3.3272510732428 and -3.0667489267572 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '78931' 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 56.124536231884 AND 56.269463768116 AND Longitude BETWEEN -3.3272510732428 and -3.0667489267572 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '79187' 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 56.124536231884 AND 56.269463768116 AND Longitude BETWEEN -3.3272510732428 and -3.0667489267572 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '73817' 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 56.124536231884 AND 56.269463768116 AND Longitude BETWEEN -3.3272510732428 and -3.0667489267572 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '78713' 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 56.124536231884 AND 56.269463768116 AND Longitude BETWEEN -3.3272510732428 and -3.0667489267572 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND (Ent.imageUploaded=1 OR Listings.imageUploaded=1) AND Ent.EntID = '78834' AND Listings.PromotorID != '28722' GROUP BY Listings.PromotorID ORDER BY salesCountLast7Days DESC, FeatureSpecial DESC LIMIT 4 OFFSET 0 Glenrothes Tickets Guide | Buy Tickets to Glenrothes Events | Skiddle
Coronavirus update: View cancelled events here

Glenrothes Guide

Hot Glenrothes 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 Glenrothes area.
W3L Wrestling Showdown - Glenrothes
×

W3L Wrestling Showdown - Glenrothes

Rothes Halls, Glenrothes

Friday 3rd Sep

6:30pm til 9:00pm (last entry 7:00pm)

No age restrictions

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

The World Wide Wrestling League returns with live action featuring top wrestling stars from around t...

Glenrothes events »

Your event not listed? Promote your event online

More about Glenrothes

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

Glenrothes Restaurants

Glenrothes Restaurants

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

Hotels Near Glenrothes

Hotels Near Glenrothes

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

Top image: "Hangingmyre Harvest." by B4bees is licensed under Attribution License

Bottom image: "DSC_5566.JPG" by bazhall81 is licensed under Attribution-NoDerivs License