Ι.Μ.Θ. :: Μνημειακή Zωγραφική

website clocks

αναζήτηση

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

Αγιος Ανδρέας ο Στρατηλάτης στην Στοά Ιερού Ναού Αγίων Αποστόλων
Τίτλος:	Αγιος Ανδρέας ο Στρατηλάτης στην Στοά Ιερού Ναού Αγίων Αποστόλων
Επιγραφές:	ΑΓΙΟΣ (ΑΝ)ΔΡΕΑ(Σ) Ο ΣΤΡΑΤΗΛ(Α)Τ(ΗΣ)
Περιγραφή:	Αγιος Ανδρέας ο Στρατηλάτης στην Στοά Ιερού Ναού Αγίων Αποστόλων
Τόπος:	ΑΓΙΟΙ ΑΠΟΣΤΟΛΟΙ
Θέση:	ΣΤΟΑ
Υλη:	ΤΟΙΧΟΓΡΑΦΙΑ

Φωτογραφικό Υλικό

Αρχεία

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


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

- Statement

[TABLES] (1488) = DAM_Artifacts LEFT JOIN DAM_ArtifactsML ON DAM_Artifacts.ArtifactID=DAM_ArtifactsML.ArtifactID AND DAM_ArtifactsML.LanguageID=1 LEFT JOIN IMTH2_MonumentalPainting ON DAM_Artifacts.ArtifactID=IMTH2_MonumentalPainting.ArtifactID LEFT JOIN IMTH2_MonumentalPaintingML ON IMTH2_MonumentalPainting.MonumentalID=IMTH2_MonumentalPaintingML.MonumentalID AND IMTH2_MonumentalPaintingML.LanguageID=1 LEFT JOIN IMTH2_LU_Places AS IMTH2_MonumentalPainting_PlaceID ON IMTH2_MonumentalPainting_PlaceID.PlaceID=IMTH2_MonumentalPainting.PlaceID LEFT JOIN IMTH2_LU_PlacesML AS IMTH2_MonumentalPainting_ML_PlaceID ON IMTH2_MonumentalPainting_PlaceID.PlaceID=IMTH2_MonumentalPainting_ML_PlaceID.PlaceID AND IMTH2_MonumentalPainting_ML_PlaceID.LanguageID=1 LEFT JOIN IMTH2_LU_Places AS IMTH2_MonumentalPainting_LocationID ON IMTH2_MonumentalPainting_LocationID.PlaceID=IMTH2_MonumentalPainting.LocationID LEFT JOIN IMTH2_LU_PlacesML AS IMTH2_MonumentalPainting_ML_LocationID ON IMTH2_MonumentalPainting_LocationID.PlaceID=IMTH2_MonumentalPainting_ML_LocationID.PlaceID AND IMTH2_MonumentalPainting_ML_LocationID.LanguageID=1 LEFT JOIN IMTH2_LU_Materials AS IMTH2_MonumentalPainting_MaterialID ON IMTH2_MonumentalPainting_MaterialID.MaterialID=IMTH2_MonumentalPainting.MaterialID LEFT JOIN IMTH2_LU_MaterialsML AS IMTH2_MonumentalPainting_ML_MaterialID ON IMTH2_MonumentalPainting_MaterialID.MaterialID=IMTH2_MonumentalPainting_ML_MaterialID.MaterialID AND IMTH2_MonumentalPainting_ML_MaterialID.LanguageID=1 [PRIMARY KEY] = DAM_Artifacts.ArtifactID [FIELDS] (723) = DAM_Artifacts.ArtifactID AS ArtifactID,IMTH2_MonumentalPaintingML.Description AS IMTH2_MonumentalPaintingML_Description,DAM_ArtifactsML.ArtifactName AS DAM_ArtifactsML_ArtifactName,IMTH2_MonumentalPainting.MonumentalID,IMTH2_MonumentalPainting_ML_PlaceID.PlaceName AS IMTH2_MonumentalPainting_PlaceID_PlaceName,IMTH2_MonumentalPainting.PlaceID AS IMTH2_MonumentalPainting_PlaceID,IMTH2_MonumentalPainting_ML_LocationID.PlaceName AS IMTH2_MonumentalPainting_LocationID_PlaceName,IMTH2_MonumentalPainting.LocationID AS IMTH2_MonumentalPainting_LocationID,IMTH2_MonumentalPainting_ML_MaterialID.Material AS IMTH2_MonumentalPainting_MaterialID_Material,IMTH2_MonumentalPainting.MaterialID AS IMTH2_MonumentalPainting_MaterialID [FILTER] (66) = ( DAM_Artifacts.ArtifactID= 2769 AND DAM_Artifacts.TypeID =32 ) [SORT] (52) = DAM_Artifacts.ParentID, DAM_ArtifactsML.ArtifactName [GROUP BY] (0) = [COUNT OF COLUMNS SELECTED] = 6 [COUNT OF JOINS] = 10 [EXECUTE STATEMENT] (2359 ) = SELECT DAM_Artifacts.ArtifactID AS ArtifactID,IMTH2_MonumentalPaintingML.Description AS IMTH2_MonumentalPaintingML_Description,DAM_ArtifactsML.ArtifactName AS DAM_ArtifactsML_ArtifactName,IMTH2_MonumentalPainting.MonumentalID,IMTH2_MonumentalPainting_ML_PlaceID.PlaceName AS IMTH2_MonumentalPainting_PlaceID_PlaceName,IMTH2_MonumentalPainting.PlaceID AS IMTH2_MonumentalPainting_PlaceID,IMTH2_MonumentalPainting_ML_LocationID.PlaceName AS IMTH2_MonumentalPainting_LocationID_PlaceName,IMTH2_MonumentalPainting.LocationID AS IMTH2_MonumentalPainting_LocationID,IMTH2_MonumentalPainting_ML_MaterialID.Material AS IMTH2_MonumentalPainting_MaterialID_Material,IMTH2_MonumentalPainting.MaterialID AS IMTH2_MonumentalPainting_MaterialID FROM DAM_Artifacts LEFT JOIN DAM_ArtifactsML ON DAM_Artifacts.ArtifactID=DAM_ArtifactsML.ArtifactID AND DAM_ArtifactsML.LanguageID=1 LEFT JOIN IMTH2_MonumentalPainting ON DAM_Artifacts.ArtifactID=IMTH2_MonumentalPainting.ArtifactID LEFT JOIN IMTH2_MonumentalPaintingML ON IMTH2_MonumentalPainting.MonumentalID=IMTH2_MonumentalPaintingML.MonumentalID AND IMTH2_MonumentalPaintingML.LanguageID=1 LEFT JOIN IMTH2_LU_Places AS IMTH2_MonumentalPainting_PlaceID ON IMTH2_MonumentalPainting_PlaceID.PlaceID=IMTH2_MonumentalPainting.PlaceID LEFT JOIN IMTH2_LU_PlacesML AS IMTH2_MonumentalPainting_ML_PlaceID ON IMTH2_MonumentalPainting_PlaceID.PlaceID=IMTH2_MonumentalPainting_ML_PlaceID.PlaceID AND IMTH2_MonumentalPainting_ML_PlaceID.LanguageID=1 LEFT JOIN IMTH2_LU_Places AS IMTH2_MonumentalPainting_LocationID ON IMTH2_MonumentalPainting_LocationID.PlaceID=IMTH2_MonumentalPainting.LocationID LEFT JOIN IMTH2_LU_PlacesML AS IMTH2_MonumentalPainting_ML_LocationID ON IMTH2_MonumentalPainting_LocationID.PlaceID=IMTH2_MonumentalPainting_ML_LocationID.PlaceID AND IMTH2_MonumentalPainting_ML_LocationID.LanguageID=1 LEFT JOIN IMTH2_LU_Materials AS IMTH2_MonumentalPainting_MaterialID ON IMTH2_MonumentalPainting_MaterialID.MaterialID=IMTH2_MonumentalPainting.MaterialID LEFT JOIN IMTH2_LU_MaterialsML AS IMTH2_MonumentalPainting_ML_MaterialID ON IMTH2_MonumentalPainting_MaterialID.MaterialID=IMTH2_MonumentalPainting_ML_MaterialID.MaterialID AND IMTH2_MonumentalPainting_ML_MaterialID.LanguageID=1 WHERE ( DAM_Artifacts.ArtifactID= 2769 AND DAM_Artifacts.TypeID =32 ) ORDER BY DAM_Artifacts.ParentID, DAM_ArtifactsML.ArtifactName