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
Home Appliances Repair & Handyman Services in Abu Dhabi Dubai at Just Care Services

Home Appliances Repair & Handyman Services in Abu Dhabi Dubai

  • Just Care Services Dubai
  • Thursday 14th - Thursday 28th November
  • Home Appliances Repair & Handyman Services in Abu Dhabi Dubai-UAE
    Camelphat at Motion

    Camelphat

    • Motion Bristol
    • Friday 15th November
    • Camelphat return to Bristol for one of our most anticipated nights of the year
      Popular Event: 234 attending
      Home Appliances Repair & Handyman Services in Abu Dhabi Dubai at Just Care Services

      Home Appliances Repair & Handyman Services in Abu Dhabi Dubai

      • Just Care Services Dubai
      • Thursday 14th - Thursday 28th November
      • Home Appliances Repair & Handyman Services in Abu Dhabi Dubai-UAE
        Home Appliances Repair & Handyman Services in Abu Dhabi Dubai at Just Care Services

        Home Appliances Repair & Handyman Services in Abu Dhabi Dubai

        • Just Care Services Dubai
        • Thursday 14th - Thursday 28th November
        • Home Appliances Repair & Handyman Services in Abu Dhabi Dubai-UAE
          Home Appliances Repair & Handyman Services in Abu Dhabi Dubai at Just Care Services

          Home Appliances Repair & Handyman Services in Abu Dhabi Dubai

          • Just Care Services Dubai
          • Thursday 14th - Thursday 28th November
          • Home Appliances Repair & Handyman Services in Abu Dhabi Dubai-UAE
            view all 30 events
            about Bristol In:Motion

            October 2015 - January 2016

            •  

            Bristol In:Motion News view all news

            Bristol In:Motion Artists view all artists

            • Camelphat

              Next Playing At:
              Camelphat (15th November)

              Camelphat Camelphat
            • Solardo

              Next Playing At:
              Solardo presents Higher (6th December)

              Solardo Solardo
            • Skream

              Next Playing At:
              Alan Fitzpatrick presents We Are The Brave (7th December)

              Skream Skream
            • Hybrid Minds

              Next Playing At:
              Boiler Room Bristol (13th December)

              Hybrid Minds Hybrid Minds
            • Alan Fitzpatrick

              Next Playing At:
              Alan Fitzpatrick presents We Are The Brave (7th December)

              Alan Fitzpatrick Alan Fitzpatrick
            • My Nu Leng

              Next Playing At:
              The Blast NYE with My Nu Leng (31st December)

              My Nu Leng My Nu Leng

            Discuss Bristol In:Motion