8,290
edits
Missile weapon combat: Difference between revisions
Jump to navigation
Jump to search
m
Missile weapon combat (view source)
Revision as of 18:56, 30 September 2021
, 18:56, 30 September 2021query optimization
m (note about Ruin of House Isner) |
m (query optimization) |
||
| Line 99: | Line 99: | ||
CONCAT('{{((}}PV{{))}}',CONCAT(IT.MaxPV))=Max PV, | CONCAT('{{((}}PV{{))}}',CONCAT(IT.MaxPV))=Max PV, | ||
CONCAT(CASE WHEN IT.Damage IS NOT NULL THEN CONCAT('{{((}}Heart{{))}}{{((}}dice tooltip{{!}}',CONCAT(IT.Damage),'{{))}}') ELSE 'ammo-based' END)=Damage | CONCAT(CASE WHEN IT.Damage IS NOT NULL THEN CONCAT('{{((}}Heart{{))}}{{((}}dice tooltip{{!}}',CONCAT(IT.Damage),'{{))}}') ELSE 'ammo-based' END)=Damage | ||
| where=IT.Skill='Pistol' AND MWD. | | where=IT.Skill='Pistol' AND MWD._pageNamespace = 0 | ||
| order by=IT.MaxPV DESC,IT.Damage DESC | | order by=IT.MaxPV DESC,IT.Damage DESC | ||
| format=table | | format=table | ||
| Line 112: | Line 112: | ||
CONCAT('{{((}}PV{{))}}',CONCAT(IT.MaxPV))=Max PV, | CONCAT('{{((}}PV{{))}}',CONCAT(IT.MaxPV))=Max PV, | ||
CONCAT(CASE WHEN IT.Damage IS NOT NULL THEN CONCAT('{{((}}Heart{{))}}{{((}}dice tooltip{{!}}',CONCAT(IT.Damage),'{{))}}') ELSE 'ammo-based' END)=Damage | CONCAT(CASE WHEN IT.Damage IS NOT NULL THEN CONCAT('{{((}}Heart{{))}}{{((}}dice tooltip{{!}}',CONCAT(IT.Damage),'{{))}}') ELSE 'ammo-based' END)=Damage | ||
| where=IT.Skill='Bow and Rifle' AND MWD.AmmoName = 'arrow' AND MWD. | | where=IT.Skill='Bow and Rifle' AND MWD.AmmoName = 'arrow' AND MWD._pageNamespace = 0 | ||
| order by=IT.MaxPV DESC,IT.Damage DESC | | order by=IT.MaxPV DESC,IT.Damage DESC | ||
| format=table | | format=table | ||
| Line 128: | Line 128: | ||
CONCAT('{{((}}PV{{))}}',CONCAT(IT.MaxPV))=Max PV, | CONCAT('{{((}}PV{{))}}',CONCAT(IT.MaxPV))=Max PV, | ||
CONCAT(CASE WHEN IT.Damage IS NOT NULL THEN CONCAT('{{((}}Heart{{))}}{{((}}dice tooltip{{!}}',CONCAT(IT.Damage),'{{))}}') ELSE 'ammo-based' END)=Damage | CONCAT(CASE WHEN IT.Damage IS NOT NULL THEN CONCAT('{{((}}Heart{{))}}{{((}}dice tooltip{{!}}',CONCAT(IT.Damage),'{{))}}') ELSE 'ammo-based' END)=Damage | ||
| where=IT.Skill='Bow and Rifle' AND MWD.AmmoName <> 'arrow' AND MWD. | | where=IT.Skill='Bow and Rifle' AND MWD.AmmoName <> 'arrow' AND MWD._pageNamespace = 0 | ||
| order by=IT.MaxPV DESC,IT.Damage DESC | | order by=IT.MaxPV DESC,IT.Damage DESC | ||
| format=table | | format=table | ||
| Line 144: | Line 144: | ||
CONCAT('{{((}}PV{{))}}',CONCAT(IT.MaxPV))=Max PV, | CONCAT('{{((}}PV{{))}}',CONCAT(IT.MaxPV))=Max PV, | ||
CONCAT(CASE WHEN IT.Damage IS NOT NULL THEN CONCAT('{{((}}Heart{{))}}{{((}}dice tooltip{{!}}',CONCAT(IT.Damage),'{{))}}') ELSE 'ammo-based' END)=Damage | CONCAT(CASE WHEN IT.Damage IS NOT NULL THEN CONCAT('{{((}}Heart{{))}}{{((}}dice tooltip{{!}}',CONCAT(IT.Damage),'{{))}}') ELSE 'ammo-based' END)=Damage | ||
| where=IT.Skill='Heavy Weapon' AND MWD. | | where=IT.Skill='Heavy Weapon' AND MWD._pageNamespace = 0 | ||
| order by=IT.MaxPV DESC,IT.Damage DESC | | order by=IT.MaxPV DESC,IT.Damage DESC | ||
| format=table | | format=table | ||