Template:Change list by name: Difference between revisions

mNo edit summary
mNo edit summary
Line 3: Line 3:
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|}}}"}}) {{#if:{{{before|}}}|AND update.version_code < {{#invoke:pad version|main|{{{before}}}}}}} {{#if:{{{since|}}}|AND update.version_code >= {{#invoke:pad version|main|{{{since}}}}}}}
|order by=update.version_code, changes.version
|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