The Tuesday Club group

SELECT artists.* , MIN(iEventDate) as firstEventDate, EventName as firstEventName, ListingInstance.iListingInstance as firstEventILID FROM artists INNER JOIN artistListing ON artists.artistID = artistListing.artistID INNER JOIN Listings ON Listings.ListingID = artistListing.ListingID INNER JOIN ListingInstance ON ListingInstance.iListingID = Listings.ListingID INNER JOIN ListingPromotionBrand ON ListingPromotionBrand.listingID = Listings.ListingID WHERE 1=1 AND Listings.active=1 and iEventDate >= CURDATE() AND promotionBrandID = 8871 AND artists.active=1 GROUP BY artists.artistID ORDER BY ISNULL(artistRank) ASC, artistRank ASC LIMIT 6 OFFSET 0

next 5 The Tuesday Club Events view all
Redlight B2B DJ Zinc, Notion, Sherelle, Emerald, Conducta & More at Foundry

Redlight B2B DJ Zinc, Notion, Sherelle, Emerald, Conducta & More

  • Foundry Sheffield
  • Tuesday 24th September
  • TTC returns for the first event of the Autumn 19 season with a massive B2B set from Redlight and DJ Zinc!
    Popular Event: 664 attending
    TTC x Skiddle Spotlight: Emerald, Tino, Andy H & Gracie T at Sheffield Students' Union Concourse

    TTC x Skiddle Spotlight: Emerald, Tino, Andy H & Gracie T

      96 attending
      TTC Season Ticket 2019/20 at Foundry

      TTC Season Ticket 2019/20

      • Foundry Sheffield
      • Tuesday 24th - Tuesday 8th October
      • One ticket to guarantee your space at every TTC event in the 2019/2020 season!
        TTC Season Ticket 2019/20 at Foundry

        TTC Season Ticket 2019/20

        • Foundry Sheffield
        • Tuesday 24th - Tuesday 8th October
        • One ticket to guarantee your space at every TTC event in the 2019/2020 season!
          TTC Season Ticket 2019/20 at Foundry

          TTC Season Ticket 2019/20

          • Foundry Sheffield
          • Tuesday 24th - Tuesday 8th October
          • One ticket to guarantee your space at every TTC event in the 2019/2020 season!
            view all 30 events
            about The Tuesday Club
            The very best in Underground clubbing since 1998. Every Tuesday 11pm-3am. Foundry, Studio and Fusion, Sheffield Students' Union.

            •  

            The Tuesday Club News view all news

            The Tuesday Club Artists view all artists

            • Hybrid Minds

              Next Playing At:
              Hybrid Minds (8th October)

              Hybrid Minds Hybrid Minds
            • Mungos Hi Fi

              Next Playing At:
              Mungos HiFi & Parly B (5th November)

              Mungos Hi Fi Mungos Hi Fi
            • Dimension

              Next Playing At:
              Dimension (22nd October)

              Dimension Dimension
            • Redlight

              Next Playing At:
              Redlight B2B DJ Zinc, Notion, Sherelle, Emerald, Conducta & More (24th September)

              Redlight Redlight
            • Denis Sulta

              Next Playing At:
              TTC x TNK: Denis Sulta, Sally C, Stevie Cox (1st October)

              Denis Sulta Denis Sulta
            • Foreign Beggars

              Next Playing At:
              Foreign Beggars (The Final Tour) + Skinnyman, Franz Von, Andy H (8th November)

              Foreign Beggars Foreign Beggars

            Discuss The Tuesday Club