Template:Cell performance for charge: Difference between revisions

Jump to navigation Jump to search
m
no edit summary
mNo edit summary
mNo edit summary
Line 3: Line 3:
   |tables=ArtifactData=AD,PhysicalProperties=PP
   |tables=ArtifactData=AD,PhysicalProperties=PP
   |join on=AD.JoinKey=PP.JoinKey
   |join on=AD.JoinKey=PP.JoinKey
   |fields=AD._pageName,CONCAT(CASE WHEN AD.MaxCharge IS NOT NULL THEN AD.MaxCharge ELSE AD.ChargePerDram * PP.MaxVolume END)=MaxCharge,FLOOR((CASE WHEN AD.MaxCharge IS NOT NULL THEN AD.MaxCharge ELSE AD.ChargePerDram * PP.MaxVolume END) / {{#var:charge_consumed}})=Uses
   |fields=AD._pageName,CONCAT(CASE WHEN AD.MaxCharge IS NOT NULL THEN AD.MaxCharge ELSE AD.ChargePerDram * PP.Volume END)=MaxCharge,FLOOR((CASE WHEN AD.MaxCharge IS NOT NULL THEN AD.MaxCharge ELSE AD.ChargePerDram * PP.Volume END) / {{#var:charge_consumed}})=Uses
   |where=AD.MaxCharge IS NOT NULL OR (AD.ChargePerDram IS NOT NULL AND PP.MaxVolume IS NOT NULL)
   |where=AD.MaxCharge IS NOT NULL OR (AD.ChargePerDram IS NOT NULL AND PP.Volume IS NOT NULL)
   |order by=Uses ASC
   |order by=Uses ASC
   |format=template
   |format=template

Navigation menu