The Greystones Sheffield
The Greystones events and tickets
Skiddle is an official primary ticket outlet for The Greystones in Sheffield. Find 1 upcoming events below. Tickets can be purchased directly from Skiddle:
SELECT Listings.ListingID, Ent.Rating, EventStartDateTime,EventEndDateTime, Listings.seatingPlanID, Listings.ExtTicketsAttached, Ent.Votes, Listings.MinAge, Listings.EventCode,Listings.TicketsAttached, CityCode, ListingInstance.iEventDate AS iEventDate, ListingInstance.goingto, EntryPrice, ListingInstance.iListingInstance AS iListingInstance,ListingInstance.fbeid, ListingInstance.iListingInstance as ListingInstanceID,MIN( ListingInstance.iListingInstance ) AS MinListingInstanceID,ListingInstance.iListingID, ListingInstance.ticketStatus, ListingInstance.ticketsAdded, Ent.c_Type, Ent.Town, Ent.PostCode, Ent.postcode_lookup,Ent.majorCity,Ent.Name, Ent.safeName,Ent.Country, Ent.Address, Ent.EntID, Ent.Logo, Listings.EventName, Listings.EventDescShort, DayOfWeek(ListingInstance.iEventDate) AS iEventDay, Listings.Feature,FeatureDays, Ent.latitude, Ent.longitude, Listings.DoorsOpen, Listings.DoorsClose, Listings.LastEntry, Listings.EntryPrice, Listings.canonicalurl, Listings.canonicaldesc,Listings.PromotorID, Listings.DateAdded, Listings.DateEdited, Listings.imgName, Listings.imgVersion, Listings.cancelled, Listings.rescheduledDate, Listings.eventCurrency, Listings.izettleMerchantAccountId, Listings.qualityFlag_image, Ent.imgName as entImgName, Ent.imgVersion as entImgVersion,ListingInstance.shortUrl, eventStartDate, eventEndDate, Listings.waitingListListingEnabled, Listings.groupingID , Listings.EventDesc FROM Ent INNER JOIN ListingInstance ON Ent.EntID = ListingInstance.iEntID INNER JOIN Listings ON ListingInstance.iListingID = Listings.ListingID WHERE 1=1 AND Listings.EventStartDate >= CURDATE() AND Listings.ACTIVE=1 AND Listings.EventVisibility ='public' AND Ent.EntID = '19938' AND Listings.PromotorID != '28722' GROUP BY Listings.ListingID ORDER BY ListingInstance.iEventDate, IF(Listings.Feature=1 AND DATE_SUB(EventStartDate, interval FeatureDays DAY) < NOW(),1,0) DESC, Listings.TicketsAttached DESC, Listings.ExtTicketsAttached DESC, EventName ASC LIMIT 10 OFFSET 0

- The Greystones Sheffield
- Tuesday 14th February
- Sharon Shannon is back in Sheffield
Do you own/manage The Greystones? Use our free Event Promotion Centre to claim/edit this venue.
Do you promote an event at The Greystones that's not listed? Use our free Event Promotion Centre to add/edit your events
Hotels and AirBnbs near The Greystones
Need a place to stay? Compare every available hotel deal and Airbnb near The Greystones, so book today to secure the best price!
Reviews of The Greystones in Sheffield
The Greystones venue information
Venue contact details and info
Name: The Greystones
Phone: 0114 2665599
Capacity: 120
Opening hours: Monday – Thursday 3pm-11pm Friday and Saturday 12pm-12am Sunday 12pm-11pm
Address: Greystones Road, Sheffield, S11 7BW
Venue short url: https://www.skiddle.com/venues/19938/
Type of venue: Live