Ι.Μ.Θ. :: Παρεκκλήσια Νοσοκομείων

website clocks

αναζήτηση

Λατρευτική Εβδομάδα στην Θεσσαλονίκη (20 -27 Απριλίου 2024)

Ίσως κάποιες εκδόσεις απο internet browsers αντιμετωπίσουν προβλήματα στην αναπαραγωγή των αρχείων. Για να δείτε τη τρισδιάστατη απεικόνιση θα χρειαστείτε το quick time player, λογισμικό της εταιρείας apple που διανέμεται δωρεάν.

Ιεροί Ναοί

Άγιος Παντελεήμων Ιπποκρατείου Νοσοκομείου
Αρχιμ. Νικόλαος Παπαγεωργίου : τηλ. επικοινωνίας 6972056408

...επιστροφή


	Το παρόν έργο υλοποιήθηκε στα πλαίσια του Επιχειρησιακού Προγράμματος Κοινωνία της Πληροφορίας, Μέτρο 1.3 "Τεκμηρίωση, Αξιοποίηση και Ανάδειξη του Ελληνικού Πολιτισμού" powered by altaB2x

- Statement

[TABLES] (692) = DAM_Artifacts LEFT JOIN DAM_ArtifactsML ON DAM_Artifacts.ArtifactID=DAM_ArtifactsML.ArtifactID AND DAM_ArtifactsML.LanguageID=1 LEFT JOIN IMTH_Parishes ON DAM_Artifacts.ArtifactID=IMTH_Parishes.ArtifactID LEFT JOIN IMTH_ParishesML ON IMTH_Parishes.ParishID=IMTH_ParishesML.ParishID AND IMTH_ParishesML.LanguageID=1 LEFT JOIN IMTH_ParishesCategories AS IMTH_Parishes_ParishCategoryID ON IMTH_Parishes_ParishCategoryID.ParishCategoryID=IMTH_Parishes.ParishCategoryID LEFT JOIN IMTH_ParishesCategoriesML AS IMTH_Parishes_ML_ParishCategoryID ON IMTH_Parishes_ParishCategoryID.ParishCategoryID=IMTH_Parishes_ML_ParishCategoryID.ParishCategoryID AND IMTH_Parishes_ML_ParishCategoryID.LanguageID=1 [PRIMARY KEY] = DAM_Artifacts.ArtifactID [FIELDS] (550) = DAM_Artifacts.ArtifactID AS ArtifactID,IMTH_ParishesML.MainChurch AS IMTH_ParishesML_MainChurch,DAM_ArtifactsML.ArtifactName AS DAM_ArtifactsML_ArtifactName,IMTH_ParishesML.ParishDetail AS IMTH_ParishesML_ParishDetail,IMTH_ParishesML.Address AS IMTH_ParishesML_Address,IMTH_Parishes.Phone AS IMTH_Parishes_Phone,IMTH_ParishesML.City AS IMTH_ParishesML_City,IMTH_Parishes.ParishID,IMTH_Parishes_ML_ParishCategoryID.ParishCategoryName AS IMTH_Parishes_ParishCategoryID_ParishCategoryName,IMTH_Parishes.ParishCategoryID AS IMTH_Parishes_ParishCategoryID [FILTER] (119) = ( DAM_Artifacts.ArtifactID= 3345 ) AND ( ( DAM_Artifacts.TypeID = '25' AND DAM_Artifacts.PortalExport = N'1' ) ) [SORT] (52) = DAM_Artifacts.ParentID, DAM_ArtifactsML.ArtifactName [GROUP BY] (0) = [COUNT OF COLUMNS SELECTED] = 7 [COUNT OF JOINS] = 6 [EXECUTE STATEMENT] (1443 ) = SELECT DAM_Artifacts.ArtifactID AS ArtifactID,IMTH_ParishesML.MainChurch AS IMTH_ParishesML_MainChurch,DAM_ArtifactsML.ArtifactName AS DAM_ArtifactsML_ArtifactName,IMTH_ParishesML.ParishDetail AS IMTH_ParishesML_ParishDetail,IMTH_ParishesML.Address AS IMTH_ParishesML_Address,IMTH_Parishes.Phone AS IMTH_Parishes_Phone,IMTH_ParishesML.City AS IMTH_ParishesML_City,IMTH_Parishes.ParishID,IMTH_Parishes_ML_ParishCategoryID.ParishCategoryName AS IMTH_Parishes_ParishCategoryID_ParishCategoryName,IMTH_Parishes.ParishCategoryID AS IMTH_Parishes_ParishCategoryID FROM DAM_Artifacts LEFT JOIN DAM_ArtifactsML ON DAM_Artifacts.ArtifactID=DAM_ArtifactsML.ArtifactID AND DAM_ArtifactsML.LanguageID=1 LEFT JOIN IMTH_Parishes ON DAM_Artifacts.ArtifactID=IMTH_Parishes.ArtifactID LEFT JOIN IMTH_ParishesML ON IMTH_Parishes.ParishID=IMTH_ParishesML.ParishID AND IMTH_ParishesML.LanguageID=1 LEFT JOIN IMTH_ParishesCategories AS IMTH_Parishes_ParishCategoryID ON IMTH_Parishes_ParishCategoryID.ParishCategoryID=IMTH_Parishes.ParishCategoryID LEFT JOIN IMTH_ParishesCategoriesML AS IMTH_Parishes_ML_ParishCategoryID ON IMTH_Parishes_ParishCategoryID.ParishCategoryID=IMTH_Parishes_ML_ParishCategoryID.ParishCategoryID AND IMTH_Parishes_ML_ParishCategoryID.LanguageID=1 WHERE ( DAM_Artifacts.ArtifactID= 3345 ) AND ( ( DAM_Artifacts.TypeID = '25' AND DAM_Artifacts.PortalExport = N'1' ) ) ORDER BY DAM_Artifacts.ParentID, DAM_ArtifactsML.ArtifactName