8,756
edits
mNo edit summary |
mNo edit summary |
||
Line 1: | Line 1: | ||
{{#cargo_query:tables=ItemsTable=IT, GeneralData=GD|join on=IT.JoinKey=GD.JoinKey|fields=IT._pageName=Gun, Shots, GD.Tier=Tier, CONCAT(FLOOR(Shots*1.3), '-', FLOOR(Shots* 1.6))=Shots (Cooled), (2 * FLOOR(Shots)) = Volume, CONCAT(15 + GD.Tier,'%') = Water usage chance|where= Shots > 1 AND Shots%4 = 0|format = table}} | {{#cargo_query:tables=ItemsTable=IT, GeneralData=GD|join on=IT.JoinKey=GD.JoinKey|fields=IT._pageName=Gun, Shots, GD.Tier=Tier, CONCAT(FLOOR(Shots*1.3), '-', FLOOR(Shots* 1.6))=Shots (Cooled), (2 * FLOOR(Shots)) = Volume, CONCAT(15 + GD.Tier,'%') = Water usage chance|where= Shots > 1 AND Shots%4 = 0 AND GD._pageNamespace = 0|format = table}} | ||
{{#cargo_query:table=ItemsTable|fields=_pageName=Gun, Shots, CONCAT(FLOOR(Shots*1.3), '-', FLOOR(Shots* 1.6))=Shots (Cooled)|where= Shots > 1 AND Shots%4 <> 0|format = table}} | {{#cargo_query:table=ItemsTable=IT, GeneralData=GD|join on=IT.JoinKey=GD.JoinKey|fields=IT._pageName=Gun, Shots, CONCAT(FLOOR(Shots*1.3), '-', FLOOR(Shots* 1.6))=Shots (Cooled), (2 * FLOOR(Shots) + (8-(Shots*2)%8)) = Volume, CONCAT(15 + GD.Tier,'%') = Water usage chance|where= Shots > 1 AND Shots%4 <> 0 AND GD._pageNamespace = 0|format = table}} |