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

Undo revision 17029 by Tom (talk)
No edit summary
Tag: Reverted
(Undo revision 17029 by Tom (talk))
Tag: Undo
Line 1: Line 1:
{{#cargo_compound_query:
;'''Saints'''
  tables=Saints
{{#cargo_query:
  |fields=CONCAT('[[',SaintName,'|',REPLACE(SaintName,'Saint ',''),']]')=Name,_pageName=Page,FeastDay
tables=Saints
  |where=FeastDay HOLDS "{{{Date}}}"
|fields=Saints.SaintName
  |tables=Feasts
|where=Saints.FeastDay LIKE "%{{{Date}}}%"
  |fields=CONCAT('[[',FeastName,']]')=Name,_pageName=Page,FeastDate
|format=ul
  |where=FeastDate HOLDS "{{{Date}}}"
|default=(none today)
  |order by=Name
}}
  |format=ul
 
  |default=(none today)
;'''Feasts & Solemnities'''
{{#cargo_query:
tables=Feasts
|fields=Feasts.FeastName
|where=Feasts.FeastDate LIKE "%{{{Date}}}%"
|format=ul
|default=(none today)
}}
}}