Hauts-de-France Convention Bureau - Tourism business and corporate event - organizing congress, seminar organization, trade shows
Make easier your business events in the Hauts-de-France
SELECT TOP 1 lanpop_Titre, pop_Id, lanpop_DescriptionCourte, pop_Visuel, lanpop_DescriptionLongue, lanpop_Lien,lanpop_act_Id, lanact_UrlRewritting, lanrub_Name, pop_pag_Id FROM Popup INNER JOIN LanguePopup ON lanpop_pop_Id = pop_Id AND lanpop_lan_Id = 2 LEFT OUTER JOIN Actualite ON act_Id = lanpop_act_Id LEFT OUTER JOIN LangueActualite ON lanact_act_Id = act_Id AND lanact_lan_Id = 2 LEFT OUTER JOIN Rubrique ON rub_Id = act_rub_Id LEFT OUTER JOIN LangueRubrique ON lanrub_rub_Id = rub_Id AND lanrub_lan_Id = 2 WHERE pop_DateSuppression IS NULL AND pop_DateDebut <= GetDate() AND (pop_DateFin >= GetDate() OR pop_DateFin IS NULL) ORDER BY pop_Id DESC

subscribe to our newsletter

I want to subscribe and receive the newsletter of the Hauts-de-France Convention Bureau


* Required fields

Solendunt am que pa sum reperios magnis eatem abo ?

Question suivante