Difference between revisions of "Template:ChainCoAbilityTableEntry"
Jump to navigation
Jump to search
>Eave |
>Eave m (filter playable adventurers only) |
||
| (3 intermediate revisions by the same user not shown) | |||
| Line 5: | Line 5: | ||
|join on=Adventurers.ExAbility2Data5=ChainCoAbilities.Id | |join on=Adventurers.ExAbility2Data5=ChainCoAbilities.Id | ||
|fields=CONCAT('{{Tooltip|[[File:', Adventurers.Id, ' 0', VariationId,' r0', Rarity ,'.png|24px|link=', Adventurers._pageName, ']] [[', Adventurers._pageName, ']]|', ChainCoAbilities.Details, '}}') | |fields=CONCAT('{{Tooltip|[[File:', Adventurers.Id, ' 0', VariationId,' r0', Rarity ,'.png|24px|link=', Adventurers._pageName, ']] [[', Adventurers._pageName, ']]|', ChainCoAbilities.Details, '}}') | ||
| − | |where=ChainCoAbilities.GenericName="{{{Name|}}}" | + | |where=ChainCoAbilities.GenericName="{{{Name|}}}" AND Adventurers.IsPlayable |
|group by=Adventurers._pageName | |group by=Adventurers._pageName | ||
| − | |order by=ChainCoAbilities. | + | |order by=ChainCoAbilities.Id DESC,Adventurers._pageName |
|format=ul|default=}} | |format=ul|default=}} | ||
|- | |- | ||
</includeonly><noinclude>[[Category:Templates]]</noinclude> | </includeonly><noinclude>[[Category:Templates]]</noinclude> | ||