8,756
edits
User:Teamtoto/Sandbox: Difference between revisions
User:Teamtoto/Sandbox (view source)
Revision as of 03:13, 22 December 2020
, 03:13, 22 December 2020no edit summary
mNo edit summary |
mNo edit summary |
||
| Line 1: | Line 1: | ||
{{#cargo_query:tables=ItemsTable=IT, GeneralData=GD|join on=IT.JoinKey=GD.JoinKey|fields=CONCAT('{{((}}favilink page {{!}}', IT._pageName, '{{))}}')=Gun, Shots, GD.Tier=Tier, CONCAT(CONCAT(CASE | {{#cargo_query:tables=ItemsTable=IT, GeneralData=GD|join on=IT.JoinKey=GD.JoinKey|fields=CONCAT('{{((}}favilink page {{!}}', IT._pageName, '{{))}}')=Gun, Shots, GD.Tier=Tier, CONCAT(CONCAT(CASE | ||
WHEN FLOOR(Shots*1.3) > FLOOR(Shots + 1) THEN FLOOR(Shots * 1.3) | WHEN FLOOR(Shots*1.3) > FLOOR(Shots + 1) THEN FLOOR(Shots * 1.3) | ||
ELSE FLOOR(Shots + 1) | |||
END), '-', FLOOR(Shots* 1.6))=Shots (Cooled), CONCAT(CASE | END), '-', FLOOR(Shots* 1.6))=Shots (Cooled), CONCAT(CASE | ||
WHEN Shots%4 = 0 THEN FLOOR(Shots * 2) | WHEN Shots%4 = 0 THEN FLOOR(Shots * 2) | ||
ELSE 2 * FLOOR(Shots) + (8-(Shots*2)%8) | |||
END) = Volume, CONCAT(15 + GD.Tier,'%') = Water usage chance|where= Shots > 1 AND GD._pageNamespace = 0|format = table|orderby=GD.Tier ASC}} | END) = Volume, CONCAT(15 + GD.Tier,'%') = Water usage chance|where= Shots > 1 AND GD._pageNamespace = 0|format = table|orderby=GD.Tier ASC}} | ||