User:Teamtoto/Sandbox: Difference between revisions
Jump to navigation
Jump to search
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) | {{#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) | |||
END), '-', FLOOR(Shots* 1.6))=Shots (Cooled), CONCAT(CASE | |||
WHEN Shots%4 = 0 THEN FLOOR(Shots * 2) | |||
WHEN Shots%4 <> 0 THEN 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}} |
Revision as of 03:04, 22 December 2020
Error: No field named "Shots" found for any of the specified database tables.