8,290
edits
Thrown weapon combat: Difference between revisions
m
additional sorting
(update queries to show thrown daggers) |
m (additional sorting) |
||
| Line 92: | Line 92: | ||
CONCAT('{{((}}Heart{{))}}{{((}}dice tooltip{{!}}',CONCAT(IT.Damage),'{{))}}')=Damage | CONCAT('{{((}}Heart{{))}}{{((}}dice tooltip{{!}}',CONCAT(IT.Damage),'{{))}}')=Damage | ||
| where = PP.Throwable='1' AND GD.Categories='Short Blades' | | where = PP.Throwable='1' AND GD.Categories='Short Blades' | ||
| order by = IT.MaxPV DESC, IT.Damage DESC | | order by = IT.MaxPV DESC, IT.Damage DESC, GD.PlainName ASC | ||
| format = table | | format = table | ||
}} | }} | ||
| Line 107: | Line 107: | ||
CONCAT('{{((}}Heart{{))}}{{((}}dice tooltip{{!}}',CONCAT(IT.Damage),'{{))}}')=Damage | CONCAT('{{((}}Heart{{))}}{{((}}dice tooltip{{!}}',CONCAT(IT.Damage),'{{))}}')=Damage | ||
| where = PP.Throwable='1' AND GD.Categories<>'Short Blades' AND GD.Categories<>'Tonics' AND GD.Categories<>'Grenades' | | where = PP.Throwable='1' AND GD.Categories<>'Short Blades' AND GD.Categories<>'Tonics' AND GD.Categories<>'Grenades' | ||
| order by = IT.MaxPV DESC, IT.Damage DESC | | order by = IT.MaxPV DESC, IT.Damage DESC, GD.PlainName ASC | ||
| format = table | | format = table | ||
}} | }} | ||
| Line 122: | Line 122: | ||
CONCAT('{{((}}Heart{{))}}{{((}}dice tooltip{{!}}',CONCAT(IT.Damage),'{{))}}')=Damage | CONCAT('{{((}}Heart{{))}}{{((}}dice tooltip{{!}}',CONCAT(IT.Damage),'{{))}}')=Damage | ||
| where = PP.Throwable='1' AND GD.Categories='Tonics' | | where = PP.Throwable='1' AND GD.Categories='Tonics' | ||
| order by = IT.MaxPV DESC, IT.Damage DESC | | order by = IT.MaxPV DESC, IT.Damage DESC, GD.PlainName ASC | ||
| format = table | | format = table | ||
}} | }} | ||
| Line 137: | Line 137: | ||
CONCAT('{{((}}Heart{{))}}{{((}}dice tooltip{{!}}',CONCAT(IT.Damage),'{{))}}')=Damage | CONCAT('{{((}}Heart{{))}}{{((}}dice tooltip{{!}}',CONCAT(IT.Damage),'{{))}}')=Damage | ||
| where = PP.Throwable='1' AND GD.Categories='Grenades' | | where = PP.Throwable='1' AND GD.Categories='Grenades' | ||
| order by = IT.MaxPV DESC, IT.Damage DESC | | order by = IT.MaxPV DESC, IT.Damage DESC, GD.PlainName ASC | ||
| format = table | | format = table | ||
}} | }} | ||