Difference between revisions of "Template:EventsForThisPage"

From Culture.si
(Reverted edits by Ziva (talk) to last revision by Jurij)
Tag: Rollback
Line 30: Line 30:
 
   | #limit = 150
 
   | #limit = 150
 
   | #groupby = 1,2,3,4,5,6,7,8,9
 
   | #groupby = 1,2,3,4,5,6,7,8,9
   | #where = ({{{fld}}}={{#cast:ref|{{{1|{{{page|{{PAGENAME}}}}}}}}|db}} or {{{fld}}} in (select page_title from redirect join page on rd_from=page_id where rd_title={{#cast:ref|{{{1|{{{page|{{PAGENAME}}}}}}}}|db}})) and (Event.Country!='Slovenia') and to_char(coalesce(Event.End,Event.Start),'YYYYMMDD') = '{{#timel:Ymd|{{CURRENTDATE}}}}'
+
   | #where = ({{{fld}}}={{#cast:ref|{{{1|{{{page|{{PAGENAME}}}}}}}}|db}} or {{{fld}}} in (select page_title from redirect join page on rd_from=page_id where rd_title={{#cast:ref|{{{1|{{{page|{{PAGENAME}}}}}}}}|db}})) and (Event.Country!='Slovenia') and to_char(coalesce(Event.End,Event.Start),'YYYYMMDD') >= '{{#timel:Ymd|{{CURRENTDATE}}}}'
 
   | #orderby = Event.Start ASC
 
   | #orderby = Event.Start ASC
 
}}
 
}}

Revision as of 18:53, 26 February 2021