Difference between revisions of "Template:ChainCoAbilityTableEntry"
Jump to navigation
Jump to search
>Eave m |
>Eave m (filter playable adventurers only) |
||
| 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.Id DESC,Adventurers._pageName | |order by=ChainCoAbilities.Id DESC,Adventurers._pageName | ||