Vorlage:ListTranslatedStrings: Unterschied zwischen den Versionen
Aus Der Bratpfannenberg
Weitere Optionen
Inhalt gelöscht Inhalt hinzugefügt
Matt (Diskussion | Beiträge) Die Seite wurde neu angelegt: „<includeonly> {{#cargo_query:tables=TranslatedStringsInReferences=t1,MediaReferences=t2,OriginalMediaReferences=t3 |join on=t1.ref=t2._pageName,t1.original_ref=t3._pageName |fields=t1.string, CONCAT(t1.where_in_original_ref,' ',t3.original_ref), t1.string_translated, CONCAT(t1.where_in_ref,' ',t2.ref) |where=t1._pageName='{{PAGENAME}}' AND t1.listNumber=1 |format=template |template=TranslatedStringListEintrag |delimiter=}} </includeonly>“ |
Matt (Diskussion | Beiträge) Keine Bearbeitungszusammenfassung |
||
| (6 dazwischenliegende Versionen desselben Benutzers werden nicht angezeigt) | |||
| Zeile 1: | Zeile 1: | ||
<includeonly> |
<includeonly> |
||
{{#cargo_query:tables=TranslatedStringsInReferences=t1,MediaReferences=t2,OriginalMediaReferences=t3 |
{{#cargo_query:tables=TranslatedStringsInReferences=t1,MediaReferences=t2,OriginalMediaReferences=t3,TranslatedStrings=t4 |
||
|join on=t1.ref=t2._pageName,t1.original_ref=t3._pageName |
|join on=t1.ref=t2._pageName,t1.original_ref=t3._pageName,t1.string=t4._pageName |
||
|fields=t1.string, |
|fields=t1.string, |
||
| ⚫ | |||
t1.string_translated, |
t1.string_translated, |
||
t4.string_jp, |
|||
| ⚫ | |||
string_jp_romaji, |
|||
context, |
|||
| ⚫ | |||
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'), |
|||
| ⚫ | |||
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._pageName='{{PAGENAME}}' AND t1.listNumber=1 |
|where=t1._pageName='{{PAGENAME}}' AND t1.listNumber=1 |
||
|group by=t1.string,t1.string_translated |
|||
|format=template |
|format=template |
||
|template=TranslatedStringListEintrag |
|template=TranslatedStringListEintrag |
||