Vorlage:ListTranslatedStrings4: Unterschied zwischen den Versionen

Inhalt gelöscht Inhalt hinzugefügt

Inline

@@ Zeile 3: / Zeile 3: @@
 |join on=t1.ref=t2._pageName,t1.original_ref=t3._pageName,t1.string=t4._pageName
 |fields=t1.string,
-CONCAT(t1.where_in_original_ref,' ',t3.original_ref),
 t1.string_translated,
-CONCAT(t1.where_in_ref,' ',t2.ref),
 t4.string_jp,
 string_jp_romaji,
-context
+context,
+t1.where_in_original_ref,
-|where=t1._pageName='{{PAGENAME}}' AND t1.listNumber=4
+t3.original_mediaTitle,
+t3.original_mediaEdition,
+t3.original_textCredit,
+t3.original_artCredit,
+t3.original_language,
+t3.original_type,
+t3.original_type_detail,
+t3.original_media,
+t3.original_link,
+t3.original_link_detail,
+DATE_FORMAT(t3.original_link_accessDate,'%e. %M %Y','de_DE'),
+t3.original_publisher,
+DATE_FORMAT(t3.original_releaseDate,'%e. %M %Y','de_DE'),
+t1.where_in_ref,
+t2.mediaTitle,
+t2.mediaEdition,
+t2.textCredit,
+t2.artCredit,
+t2.translationCredit,
+t2.language,
+t2.type,
+t2.type_detail,
+t2.media,
+t2.link,
+t2.link_detail,
+DATE_FORMAT(t2.link_accessDate,'%e. %M %Y','de_DE'),
+t2.publisher,
+DATE_FORMAT(t2.releaseDate,'%e. %M %Y','de_DE')
+|where=t1.listNumber=4 AND t1._pageName='{{PAGENAME}}'
 |format=template
 |template=TranslatedStringListEintrag

Version vom 14. Dezember 2025, 01:39 Uhr