Template:Saints of the day/sandbox: Difference between revisions

Template:Saints of the day/sandbox (view source)

105 bytes added , 3 November 2025

13,382

edits

@@ Line 19: / Line 19: @@
 ==2nd==
 {{#cargo_compound_query:
-tables=Saints;where=Saints.FeastDay LIKE "%{{{Date}}}%";fields=Saints.SaintName
+tables=Saints
-|tables=Feasts;where=Feasts.FeastDate LIKE "%{{{Date}}}%";fields=Feasts.FeastName
+|where=Saints.FeastDay HOLDS "{{{Date}}}"
+|fields=CONCAT('[[',Saints.SaintName,'|',REPLACE(Saints.SaintName,'Saint ',''),']]')=Name
+|tables=Feasts
+|where=Feasts.FeastDate HOLDS "{{{Date}}}"
+|fields=CONCAT('[[',Feasts.FeastName,']]')=Name
+|order by=Name
 |format=ul
 |default=(none today)
 }}