Difference between revisions of "Template:EventsForThisPage"
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