כדורעף:ליגת העל: הבדלים בין גרסאות בדף
מתוך מכביפדיה
אין תקציר עריכה
אין תקציר עריכה
שורה 1: שורה 1:
{{#cargo_query:
{{#cargo_query:
tables=Volleyball_Games
tables=Volleyball_Games
|fields=_pageName, TotalSetsMaccabi, CEIL(FirstSetPointsMaccabi>FirstSetPointsOpponent) + CEIL(SecondSetPointsMaccabi>SecondSetPointsOpponent) + CEIL(ThirdSetPointsMaccabi>ThirdSetPointsOpponent) + IFNULL(FourthSetPointsMaccabi>FourthSetPointsOpponent, 0) + IFNULL(FifthSetPointsMaccabi>FifthSetPointsOpponent, 0)
|fields=_pageName, TotalSetsMaccabi=MaccabiSetsWritten, IFNULL(FirstSetPointsMaccabi>FirstSetPointsOpponent, 0) + IFNULL(SecondSetPointsMaccabi>SecondSetPointsOpponent, 0) + IFNULL(ThirdSetPointsMaccabi>ThirdSetPointsOpponent, 0) + IFNULL(FourthSetPointsMaccabi>FourthSetPointsOpponent, 0) + IFNULL(FifthSetPointsMaccabi>FifthSetPointsOpponent, 0)=MaccabiSetsCalculated
|where=1=1
|where=1=1
AND TotalSetsMaccabi != IFNULL(FirstSetPointsMaccabi>FirstSetPointsOpponent, 0) + IFNULL(SecondSetPointsMaccabi>SecondSetPointsOpponent, 0) + IFNULL(ThirdSetPointsMaccabi>ThirdSetPointsOpponent, 0) + IFNULL(FourthSetPointsMaccabi>FourthSetPointsOpponent, 0) + IFNULL(FifthSetPointsMaccabi>FifthSetPointsOpponent, 0)
|format=dynamic table
|format=dynamic table
|rows per page=100
|order by=Volleyball_Games.Date desc
}}
}}

גרסה מ־01:01, 7 באפריל 2024

שגיאה: פונקציית ה־SQL בשם "IFNULL()" אינה מותרת.