Template:Role

Wrapper for cargo_query for each role:

GROUP_CONCAT(DISTINCT IF(REGEXP_LIKE(CAST(REVERSE(s.Multiplier) AS BINARY), '%digit:{5,}')

      ,CONCAT(", ",CONCAT_WS("_"
              ,IF(s.ActionType IN("Prayer","Song","Aura"),s.ActionType,NULL)
              ,IF(s.ActionType="Valor Chant","VC"
               ,IF(s.ActionType="Another Sense","AS"
                ,IF(s.ActionType="EX Special Move","EX"
                 ,IF(s.ActionType="Battle Start","BS"
                  ,IF(s.Description LIKE "%replaces the basic attack%","BA"
                   ,IF(s.ActionType LIKE "%End of turn%" ,"EoT"
                    ,IF(s.ActionType LIKE "%Start of turn%" ,"SoT"
                     ,IF(s.ActionType="Preemptive","Pre"
                      ,IF(s.ActionType="Delayed","Del"
                       ,IF(s.ActionType="Counter",CONCAT_WS("_",
                        IF(s.Description LIKE "%magically%attacked%","Counter_M",NULL)
                        ,IF(s.Description LIKE "%physically%attacked%","Counter_P",NULL))
                        ,IF(s.ActionType in("Auto","Charged","Aura"),"Sidekick"
              ,NULL)))))))))))
              ,"Over10k"
              ,IF(REGEXP_LIKE(CAST(s.Description AS CHAR CHARACTER SET utf8mb4)
                  ,'attack on (all enemies|(a )?single enemy)','i')
               ,CONCAT_WS("_","A",CONCAT(TRUNCATE(REVERSE(REGEXP_SUBSTR(CAST(REVERSE(Multiplier) AS BINARY), '%[0-9]{4,}')),-3)/1000,"K"))
               ,NULL)

)),NULL) SEPARATOR "")

ActionType
Another Sense
Aura
Auto
Battle End
Battle Start
Battle Start Activation
Battle Start Stacking
Charged
Counter
Delayed
Elements
End of Turn
End of Turn Activation
End of Turn Attack
End of Turn Stacking
EX Special Move
Follow Up
Mystic Arte
Prayer
Praying
Preemptive
Resonant Raid
Rush Attack
Singing
Song
Start of Turn
Start of Turn Activation
Start of Turn Stacking
Stellar Burst Activation Bonus
Stellar Burst Gauge Fill Bonus
Turn Start Stacking
Valor Chant
Zone Ability

GROUP_CONCAT(DISTINCT IF(,", ","") SEPARATOR "")