Template:Change list by name: Difference between revisions
mNo edit summary |
mNo edit summary |
||
| (8 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
<includeonly>{{#cargo_query:tables={{{table|???}}}=changes, {{{updates table|btdbm_updates}}}=update | <includeonly>{{#cargo_query:tables={{{table|???}}}=changes, {{{updates table|btdbm_updates}}}=update | ||
|fields=CONCAT("<h{{{header level|3}}}>[[", changes._pageName, "|Version ", changes.version, "]] ", IF(changes.version_note != "", CONCAT("(", changes.version_note, ")"), ""), "</h{{{header level|3}}}>\n", | |fields=CONCAT("{{#ifeq:{{{header level|3}}}|2|==|<h{{{header level|3}}}>}}[[", changes._pageName, "|Version ", changes.version, "]] ", IF(changes.version_note != "", CONCAT("(", changes.version_note, ")"), ""), "{{#ifeq:{{{header level|3}}}|2|==|</h{{{header level|3}}}>}}\n", | ||
GROUP_CONCAT(changes.changes ORDER BY changes.priority DESC, changes.changes SEPARATOR "\n")) = a | GROUP_CONCAT(changes.changes ORDER BY changes.priority DESC, changes.changes SEPARATOR "\n")) = a | ||
|where=(changes.names HOLDS "{{{1|}}}"{{#if:{{{2|}}}| OR changes.names HOLDS "{{{2|}}}"}}){{#if:{{{before|}}}| AND update.version_code < {{#invoke:pad version|main|{{{before}}}}}}}{{#if:{{{since|}}}| AND update.version_code >= {{#invoke:pad version|main|{{{since}}}}}}} | |where=(changes.names HOLDS "{{{1|}}}"{{#if:{{{2|}}}| OR changes.names HOLDS "{{{2|}}}"}}{{#if:{{{3|}}}| OR changes.names HOLDS "{{{3|}}}"}})<!-- | ||
|order by=update.version_code | -->{{#if:{{{before|}}}|AND update.version_code < (0+{{#invoke:pad version|main|{{{before}}}}})}}<!-- | ||
-->{{#if:{{{since|}}}|AND update.version_code >= (0+{{#invoke:pad version|main|{{{since}}}}})}} | |||
|order by=update.version_code, changes.version | |||
|group by=changes._pageName, changes.version, changes.version_note, update.version_code | |group by=changes._pageName, changes.version, changes.version_note, update.version_code | ||
|join on=changes._pageName = update._pageName | |join on=changes._pageName = update._pageName | ||
| Line 10: | Line 12: | ||
|format=list | |format=list | ||
|delimiter=\n | |delimiter=\n | ||
|default= | |default=[[Category:Pages with empty Cargo queries in templates]] | ||
}}</includeonly><noinclude>{{/doc}}</noinclude> | }}</includeonly><noinclude>{{/doc}}</noinclude> | ||