Template:BTD6 change list by name: Difference between revisions

mNo edit summary
mNo edit summary
Line 3: Line 3:
GROUP_CONCAT(CONCAT(IF(quote != "", CONCAT("\n<table class='quote' border='0' cellspacing='0' cellpadding='0'><tr><td class='quote-side' style='text-align:right'>&ldquo;</td><td class='quote-center'><i>", quote, "</i><br><span style='font-size:0.9em;padding-left:10px'>&mdash; Update notes</span></td><td class='quote-side' style='text-align:left'>&rdquo;</tr></table>\n"), ""), IF(changes != "", CONCAT("\n", changes), "")) ORDER BY priority DESC, changes SEPARATOR "")) = a
GROUP_CONCAT(CONCAT(IF(quote != "", CONCAT("\n<table class='quote' border='0' cellspacing='0' cellpadding='0'><tr><td class='quote-side' style='text-align:right'>&ldquo;</td><td class='quote-center'><i>", quote, "</i><br><span style='font-size:0.9em;padding-left:10px'>&mdash; Update notes</span></td><td class='quote-side' style='text-align:left'>&rdquo;</tr></table>\n"), ""), IF(changes != "", CONCAT("\n", changes), "")) ORDER BY priority DESC, changes SEPARATOR "")) = a


|where=(names HOLDS "{{{1|}}}"{{#if:{{{2|}}}| OR names HOLDS "{{{2|}}}"}}){{#if:{{{until|}}}| AND version <= {{{until}}}}}{{#if:{{{since|}}}| AND version >= {{{since}}}}}
|where=(names HOLDS "{{{1|}}}"{{#if:{{{2|}}}| OR names HOLDS "{{{2|}}}"}}){{#if:{{{before|}}}| AND version < {{{before}}}}}{{#if:{{{since|}}}| AND version >= {{{since}}}}}
|order by=(version+0)
|order by=(version+0)
|group by=_pageName, version, version_note
|group by=_pageName, version, version_note