Template:Warrior table query

{{#uesc:{\{#invoke:Cargo\!{{#if:{{{debug|}}}|debug|query}} \!tables=Warriors,ElementIndex,WeaponIndex \!fields=Warriors._pageName=page, Warriors.name=name, icon, image, title, rarity, element, weapon, exskill, fixedskill, obtained, tags__full=tags \!where={{#tokenif:{{#lstsep: AND {{#listmap:list={{{page|}}}|insep=\\|outsep=\_OR\_|indextoken=####|pattern=Warriors._pageName = ?$page.####?|}} AND {{#listmap:list={{{name|}}}|insep=\\|outsep=\_OR\_|indextoken=####|pattern=Warriors.name = ?$name.####?|}} AND {{#listmap:list={{{icon|}}}|insep=\\|outsep=\_OR\_|indextoken=####|pattern=fore = ?$icon.####?|}} AND {{#listmap:list={{{image|}}}|insep=\\|outsep=\_OR\_|indextoken=####|pattern=fore = ?$image.####?|}} AND {{#listmap:list={{{title|}}}|insep=\\|outsep=\_OR\_|indextoken=####|pattern=aft = ?$title.####?|}} AND {{#listmap:list={{{rarity|}}}|insep=\\|outsep=\_OR\_|indextoken=####|pattern=rarity = ?#rarity.####?|}} AND {{#listmap:list={{{element|}}}|insep=\\|outsep=\_OR\_|indextoken=####|pattern=element = ?$element.####?|}} AND {{#listmap:list={{{weapon|}}}|insep=\\|outsep=\_OR\_|indextoken=####|pattern=weapon = ?$weapon.####?|}} AND {{#listmap:list={{{exskill|}}}|insep=\\|outsep=\_OR\_|indextoken=####|pattern=exskill = ?$exskill.####?|}} AND {{#listmap:list={{{fixedskill|}}}|insep=\\|outsep=\_OR\_|indextoken=####|pattern=fixedskill = ?$fixedskill.####?|}} AND {{#listmap:list={{{obtained|}}}|insep=\\\\|outsep=\_OR\_|indextoken=####|pattern=obtained = ?$obtained.####?|}} AND {{#listmap:list={{#if:{{{tags|}}}|~|}}{{#lstsep:{{#lstsep:{{{tags|}}}|\\|\!\!OR~}}|+|\!\!AND~}}|insep=\!\!|outsep=\_|token=@@@@|indextoken=####|pattern= {{#explode:@@@@|~|0}} ?%Warriors.tags.holds.####? |}}   |AND |)\_AND\_( }}|%%%%|(%%%%)}} \!{{#listmap:list={{{page|}}}|insep=\\|outsep=\n\!|indextoken=####|token=@@@@|pattern=$page.####=@@@@|}} \!{{#listmap:list={{{name|}}}|insep=\\|outsep=\n\!|indextoken=####|token=@@@@|pattern=$name.####=@@@@|}} \!{{#listmap:list={{{icon|}}}|insep=\\|outsep=\n\!|indextoken=####|token=@@@@|pattern=#icon.####=@@@@|}} \!{{#listmap:list={{{image|}}}|insep=\\|outsep=\n\!|indextoken=####|token=@@@@|pattern=#image.####=@@@@|}} \!{{#listmap:list={{{title|}}}|insep=\\|outsep=\n\!|indextoken=####|token=@@@@|pattern=$title.####=@@@@|}} \!{{#listmap:list={{{rarity|}}}|insep=\\|outsep=\n\!|indextoken=####|token=@@@@|pattern=#rarity.####=@@@@|}} \!{{#listmap:list={{{element|}}}|insep=\\|outsep=\n\!|indextoken=####|token=@@@@|pattern=$element.####=@@@@|}} \!{{#listmap:list={{{weapon|}}}|insep=\\|outsep=\n\!|indextoken=####|token=@@@@|pattern=$weapon.####=@@@@|}} \!{{#listmap:list={{{exskill|}}}|insep=\\|outsep=\n\!|indextoken=####|token=@@@@|pattern=$exskill.####=@@@@|}} \!{{#listmap:list={{{fixedskill|}}}|insep=\\|outsep=\n\!|indextoken=####|token=@@@@|pattern=$fixedskill.####=@@@@|}} \!{{#listmap:list={{{obtained|}}}|insep=\\|outsep=\n\!|indextoken=####|token=@@@@|pattern=$obtained.####=@@@@|}} \!{{#listmap:list={{#lstsep:{{{tags|}}}|+|\!\!}}|insep=\\|outsep=\n\!|indextoken=####|token=@@@@|pattern=%Warriors.tags.holds.####=@@@@|}} \!join=Warriors.element = ElementIndex.name,Warriors.weapon = WeaponIndex.name \!groupBy=Warriors._pageName \!having= \!orderBy=rarity ASC, ElementIndex.position ASC, WeaponIndex.position ASC, Warriors.name ASC \!template=Warrior table query row \!intro={\{Warrior table query header}\} \!outro={\{!}\}\}\n \!default= \!limit=5000 \!offset= }\} }}