Ι.Μ.Θ. :: Ηχητικό ντοκουμέντο

website clocks

αναζήτηση

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

Αίνοι αναστάσιμοι του Αθ. Καραμάνη
Τίτλος:	Αίνοι αναστάσιμοι του Αθ. Καραμάνη
Δημιουργός:	ΑΘΑΝΑΣΙΟΣ
Τόπος:	ΑΓΙΟΣ ΓΡΗΓΟΡΙΟΣ ΠΑΛΑΜΑΣ
Κατηγορία ήχου:	ΒΑΡΥΣ
Ονομασία ήχου:	Αίνοι αναστάσιμοι

Ηχητικό Υλικό

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


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

- Statement

[TABLES] (1133) = DAM_Artifacts LEFT JOIN DAM_ArtifactsML ON DAM_Artifacts.ArtifactID=DAM_ArtifactsML.ArtifactID AND DAM_ArtifactsML.LanguageID=1 LEFT JOIN IMTH2_Sounds ON DAM_Artifacts.ArtifactID=IMTH2_Sounds.ArtifactID LEFT JOIN IMTH2_SoundsML ON IMTH2_Sounds.SoundsID=IMTH2_SoundsML.SoundsID AND IMTH2_SoundsML.LanguageID=1 LEFT JOIN IMTH2_LU_Persons AS IMTH2_Sounds_PersonID ON IMTH2_Sounds_PersonID.PersonID=IMTH2_Sounds.PersonID LEFT JOIN IMTH2_LU_PersonsML AS IMTH2_Sounds_ML_PersonID ON IMTH2_Sounds_PersonID.PersonID=IMTH2_Sounds_ML_PersonID.PersonID AND IMTH2_Sounds_ML_PersonID.LanguageID=1 LEFT JOIN IMTH2_LU_Places AS IMTH2_Sounds_PlaceID ON IMTH2_Sounds_PlaceID.PlaceID=IMTH2_Sounds.PlaceID LEFT JOIN IMTH2_LU_PlacesML AS IMTH2_Sounds_ML_PlaceID ON IMTH2_Sounds_PlaceID.PlaceID=IMTH2_Sounds_ML_PlaceID.PlaceID AND IMTH2_Sounds_ML_PlaceID.LanguageID=1 LEFT JOIN IMTH2_LU_PartOfSpeech AS IMTH2_Sounds_SpeechID ON IMTH2_Sounds_SpeechID.SpeechID=IMTH2_Sounds.SpeechID LEFT JOIN IMTH2_LU_PartOfSpeechML AS IMTH2_Sounds_ML_SpeechID ON IMTH2_Sounds_SpeechID.SpeechID=IMTH2_Sounds_ML_SpeechID.SpeechID AND IMTH2_Sounds_ML_SpeechID.LanguageID=1 [PRIMARY KEY] = DAM_Artifacts.ArtifactID [FIELDS] (515) = DAM_Artifacts.ArtifactID AS ArtifactID,IMTH2_SoundsML.SoundName AS IMTH2_SoundsML_SoundName,DAM_ArtifactsML.ArtifactName AS DAM_ArtifactsML_ArtifactName,IMTH2_Sounds.SoundsID,IMTH2_Sounds_ML_PersonID.FirstName AS IMTH2_Sounds_PersonID_FirstName,IMTH2_Sounds.PersonID AS IMTH2_Sounds_PersonID,IMTH2_Sounds_ML_PlaceID.PlaceName AS IMTH2_Sounds_PlaceID_PlaceName,IMTH2_Sounds.PlaceID AS IMTH2_Sounds_PlaceID,IMTH2_Sounds_ML_SpeechID.Speech AS IMTH2_Sounds_SpeechID_Speech,IMTH2_Sounds.SpeechID AS IMTH2_Sounds_SpeechID [FILTER] (66) = ( DAM_Artifacts.ArtifactID= 2443 AND DAM_Artifacts.TypeID =31 ) [SORT] (52) = DAM_Artifacts.ParentID, DAM_ArtifactsML.ArtifactName [GROUP BY] (0) = [COUNT OF COLUMNS SELECTED] = 5 [COUNT OF JOINS] = 10 [EXECUTE STATEMENT] (1796 ) = SELECT DAM_Artifacts.ArtifactID AS ArtifactID,IMTH2_SoundsML.SoundName AS IMTH2_SoundsML_SoundName,DAM_ArtifactsML.ArtifactName AS DAM_ArtifactsML_ArtifactName,IMTH2_Sounds.SoundsID,IMTH2_Sounds_ML_PersonID.FirstName AS IMTH2_Sounds_PersonID_FirstName,IMTH2_Sounds.PersonID AS IMTH2_Sounds_PersonID,IMTH2_Sounds_ML_PlaceID.PlaceName AS IMTH2_Sounds_PlaceID_PlaceName,IMTH2_Sounds.PlaceID AS IMTH2_Sounds_PlaceID,IMTH2_Sounds_ML_SpeechID.Speech AS IMTH2_Sounds_SpeechID_Speech,IMTH2_Sounds.SpeechID AS IMTH2_Sounds_SpeechID FROM DAM_Artifacts LEFT JOIN DAM_ArtifactsML ON DAM_Artifacts.ArtifactID=DAM_ArtifactsML.ArtifactID AND DAM_ArtifactsML.LanguageID=1 LEFT JOIN IMTH2_Sounds ON DAM_Artifacts.ArtifactID=IMTH2_Sounds.ArtifactID LEFT JOIN IMTH2_SoundsML ON IMTH2_Sounds.SoundsID=IMTH2_SoundsML.SoundsID AND IMTH2_SoundsML.LanguageID=1 LEFT JOIN IMTH2_LU_Persons AS IMTH2_Sounds_PersonID ON IMTH2_Sounds_PersonID.PersonID=IMTH2_Sounds.PersonID LEFT JOIN IMTH2_LU_PersonsML AS IMTH2_Sounds_ML_PersonID ON IMTH2_Sounds_PersonID.PersonID=IMTH2_Sounds_ML_PersonID.PersonID AND IMTH2_Sounds_ML_PersonID.LanguageID=1 LEFT JOIN IMTH2_LU_Places AS IMTH2_Sounds_PlaceID ON IMTH2_Sounds_PlaceID.PlaceID=IMTH2_Sounds.PlaceID LEFT JOIN IMTH2_LU_PlacesML AS IMTH2_Sounds_ML_PlaceID ON IMTH2_Sounds_PlaceID.PlaceID=IMTH2_Sounds_ML_PlaceID.PlaceID AND IMTH2_Sounds_ML_PlaceID.LanguageID=1 LEFT JOIN IMTH2_LU_PartOfSpeech AS IMTH2_Sounds_SpeechID ON IMTH2_Sounds_SpeechID.SpeechID=IMTH2_Sounds.SpeechID LEFT JOIN IMTH2_LU_PartOfSpeechML AS IMTH2_Sounds_ML_SpeechID ON IMTH2_Sounds_SpeechID.SpeechID=IMTH2_Sounds_ML_SpeechID.SpeechID AND IMTH2_Sounds_ML_SpeechID.LanguageID=1 WHERE ( DAM_Artifacts.ArtifactID= 2443 AND DAM_Artifacts.TypeID =31 ) ORDER BY DAM_Artifacts.ParentID, DAM_ArtifactsML.ArtifactName