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

next 5 LOST Events view all
LOST Freshers Festival Manchester : Hidden : Wed 18th Sep at Hidden

LOST Freshers Festival Manchester : Hidden : Wed 18th Sep

  • Hidden Manchester
  • Wednesday 18th September
  • Professional party starters LOST bring their spectacular Freshers Festival to MANCHESTER! The madness awaits...
    Popular Event: 519 attending
    LOST Freshers Festival Bangor : Academi : Fri 20th Sep at Academi

    LOST Freshers Festival Bangor : Academi : Fri 20th Sep

    • Academi Bangor
    • Friday 20th September
    • Professional party starters LOST UK bring their spectacular Freshers Festival to BANGOR! The madness awaits...
      Popular Event: 313 attending
      LOST Freshers Festival Liverpool : Camp & Furnace : Fri 20th Sep at Camp And Furnace

      LOST Freshers Festival Liverpool : Camp & Furnace : Fri 20th Sep

      • Camp And Furnace Liverpool
      • Friday 20th September
      • Professional party starters LOST bring their spectacular Freshers Festival to LIVERPOOL! The madness awaits...
        Popular Event: 894 attending
        LOST Light Odyssey : Invisible Wind Factory : Tue 24th Sep at Invisible Wind Factory

        LOST Light Odyssey : Invisible Wind Factory : Tue 24th Sep

        • Invisible Wind Factory Liverpool
        • Tuesday 24th September
        • Join us as we take a trip into the light odyssey... this week it's all about the visuals!
          LOST Freshers Festival Leeds : Mint Warehouse : Thurs 26th Sep at Mint Warehouse

          LOST Freshers Festival Leeds : Mint Warehouse : Thurs 26th Sep

          • Mint Warehouse Leeds
          • Thursday 26th September
          • Professional party starters LOST UK bring their spectacular Freshers Festival to LEEDS! The madness awaits...
            Popular Event: 354 attending
            view all 10 events
            about LOST
            Having now thrown their uniquely themed parties in almost every venue the city has to offer, ravers nationwide are flocking to see what all the fuss about.

            •  

            LOST Artists view all artists

            • Danny Howard

              Next Playing At:
              LOST Freshers Festival Keele : Danny Howard : Tue 8th Oct (8th October)

              Danny Howard Danny Howard
            • Max Chapman

              Next Playing At:
              LOST Freshers Festival : Max Chapman : The Mill : Fri 27th Sep (27th September)

              Max Chapman Max Chapman
            • Dan Fresco

              Next Playing At:
              LOST Light Odyssey : Invisible Wind Factory : Tue 24th Sep (24th September)

              Dan Fresco Dan Fresco
            • Liam Ross

              Next Playing At:
              LOST Light Odyssey : Invisible Wind Factory : Tue 24th Sep (24th September)

              Liam Ross Liam Ross

            Discuss LOST