m1.value AS plugin_statistics_sudan_title,
WORDCOUNT(m1.value) AS plugin_statistics_sudan_titleCount,
m2.value AS plugin_statistics_sudan_titlearabic,
WORDCOUNT(m2.value) AS plugin_statistics_sudan_titlearabicCount,
m3.value AS plugin_statistics_sudan_description,
WORDCOUNT(m3.value) AS plugin_statistics_sudan_descriptionCount,
m4.value AS plugin_statistics_sudan_descriptionarabic,
WORDCOUNT(m4.value) AS plugin_statistics_sudan_descriptionarabicCount,
s.Titel AS plugin_statistics_sudan_workflowTitle,
p.Titel AS plugin_statistics_sudan_processTitle,
CONCAT(u.Nachname, ', ', u.Vorname) AS plugin_statistics_sudan_userName
metadata m2 ON m1.processid = m2.processid
metadata m3 ON m1.processid = m3.processid
metadata m4 ON m1.processid = m4.processid
schritte s ON m1.processid = s.ProzesseID
prozesse p ON s.ProzesseID = p.ProzesseID
benutzer u ON s.BearbeitungsBenutzerID = u.BenutzerID
AND m2.name = 'TitleDocMainArabic'
AND m3.name = 'ContentDescription'
AND m4.name = 'ContentDescriptionArabic'
AND s.typMetadaten = TRUE
AND s.titel like '%ranslat%'
AND s.Bearbeitungsstatus = 3
AND s.BearbeitungsEnde BETWEEN '2019-01-01' AND '2020-12-31';