SELECT COALESCE (b.customwpurl, '') AS customwpurl, COALESCE (b.Name, '') AS GalleryName, a.ID, a.GalleryID, a.Source, Coalesce(a.ExhibitionDescription,'') as ExhibitionDescription, Coalesce(a.NameDescription,'') as NameDescription, Coalesce(a.ArtistName,'') as ArtistName, Coalesce(a.PhotoAlbumUrl,'') as PhotoAlbumUrl, Coalesce(a.PhotoCover,'') as PhotoCover, COALESCE (a.FromDate,'') as FromDate, COALESCE (a.ToDate,'') as ToDate, CASE WHEN (GETDATE() between a.FromDate and a.ToDate) THEN 1 WHEN (COALESCE (a.FromDate,'') > GETDATE()) THEN 2 WHEN (COALESCE (a.FromDate,'') < GETDATE()) THEN 3 END AS ExhibitionDates , 'http://opportunities.com.lb/GalleryMagazine2018/upload/' + CONVERT(varchar(100), GalleryID) + '/' + a.PhotoCover AS DisplayExibitionPhotoCover from Galleries_Listing_Exhibitions as a, dbo.Galleries_Listing as b where b.ID = a.GalleryID and Coalesce(a.ListInVirtualGallery,0) =1 and Coalesce(a.PhotoAlbumUrl,'') <> '' and Coalesce(a.PhotoCover,'')<>'' and (GETDATE() between a.FromDate and a.ToDate) order by a.FromDate desc
Bringing together thirteen contemporary artists whose diverse practices reflect on themes of identity, belonging, landscape, memory, and human connection. While each artist approaches these subjects through a distinct visual language, the exhibition reveals common threads that unite individual perspectives within a broader collective experience.