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
Rebirth Beirut
Khaled Terikli Aboualhoul
The Return
The Return
Until Nov 24 2026
Galerie Janine Rubeiz
Renoz
Al-Fawwara
Al-Fawwara
Until Dec 30 2026
Art on 56th
Mansour El Habre
Bare Life
Bare Life
Until Dec 5 2026
KAF Art Gallery
May Nabhan
Presence
Presence
Until Dec 3 2026
Galerie Tanit
Zad Moultaka
Toupie
Toupie
Until Dec 3 2026
Saleh Barakat Gallery
Johanne Issa
Sweet Dust
Sweet Dust
Until Dec 4 2026
AUB Art Galleries and Collections
Ala Younis
Huge Likeness
Huge Likeness
Until Jan 8 2027
Sursock Museum
Collective Exhibition
Becoming Icon
Becoming Icon
Until Jun 20 2027