Bristol In:Motion 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 = 9363 AND artists.active=1 GROUP BY artists.artistID ORDER BY ISNULL(artistRank) ASC, artistRank ASC LIMIT 6 OFFSET 0

next 5 Bristol In:Motion Events view all
RUN ALL DAY - WK1 - Andy C, Turno + more at Motion

RUN ALL DAY - WK1 - Andy C, Turno + more

  • Motion Bristol
  • Saturday 7th September
  • RUNALLDAY returns to Motion’s outdoor spaces over two weekends this September!
    RUN ALL DAY - Weekend 2 at Motion

    RUN ALL DAY - Weekend 2

    • Motion Bristol
    • Saturday 14th September
    • RUNALLDAY returns to Motion’s outdoor spaces over two weekends this September!
      IN:MOTION 2019: Drumcode Day & Night at Motion

      IN:MOTION 2019: Drumcode Day & Night

      • Motion Bristol
      • Saturday 28th September
      • Drumcode returns to Bristol for their biggest ever party in the South West.
        170 attending
        In:Motion 2019 / MK Presents Area 10 at The Marble Factory

        In:Motion 2019 / MK Presents Area 10

        • The Marble Factory Bristol
        • Friday 4th October
        • MK Presents Area 10
          The Blast - Sub Focus, Camo & Krooked, Hazard + more at Motion

          The Blast - Sub Focus, Camo & Krooked, Hazard + more

          • Motion Bristol
          • Saturday 5th October
          • The Blast return to Motion after an unforgettable summer for this year’s stellar in:Motion launch weekend!
            view all 13 events
            about Bristol In:Motion

            October 2015 - January 2016

            •  

            Bristol In:Motion News view all news

            Bristol In:Motion Artists view all artists

            • MK

              Next Playing At:
              In:Motion 2019 / MK Presents Area 10 (4th October)

              MK MK
            • Andy C

              Next Playing At:
              RUN ALL DAY - WK1 - Andy C, Turno + more (7th September)

              Andy C Andy C
            • Sub Focus

              Next Playing At:
              The Blast - Sub Focus, Camo & Krooked, Hazard + more (5th October)

              Sub Focus Sub Focus
            • Shy FX

              Next Playing At:
              The Blast Halloween - ShyFX, Problem Central, Rusko + more (2nd November)

              Shy FX Shy FX
            • Four Tet

              Next Playing At:
              In:Motion 2019 / 25 years of Bugged Out! with Four Tet (25th October)

              Four Tet Four Tet
            • Green Velvet

              Next Playing At:
              In:Motion 2019 / Annie Mac Presents (1st November)

              Green Velvet Green Velvet

            Discuss Bristol In:Motion