תבנית:שליפת נתוני משחקים: הבדלים בין גרסאות בדף

@@ שורה 11: / שורה 11: @@
 {{#cargo_query:
 tables=Games
-|fields=CONCAT(case liga when '1' then 'ליגה' else mifal end) AS mifal,COUNT(*) AS overall,SUM(case result when '1' then 1 else 0 end) AS wins,SUM(case result when 'x' then 1 else 0 end) as draws,SUM(case result when '0' then 1 else 0 end) AS losses,SUM(case host when 'הפועל ת"א' then homescore  else 0 end)+SUM(case oponent when 'הפועל ת"א' then awayscore else 0 end) AS scored,SUM(case host when 'הפועל ת"א' then awayscore  else 0 end)+SUM(case oponent when 'הפועל ת"א' then homescore else 0 end) AS against, department
+|fields=CONCAT(case liga when '1' then 'ליגה' else mifal end),COUNT(*),SUM(case result when '1' then 1 else 0 end),SUM(case result when 'x' then 1 else 0 end),SUM(case result when '0' then 1 else 0 end),SUM(case host when 'הפועל ת"א' then homescore  else 0 end)+SUM(case oponent when 'הפועל ת"א' then awayscore else 0 end),SUM(case host when 'הפועל ת"א' then awayscore  else 0 end)+SUM(case oponent when 'הפועל ת"א' then homescore else 0 end),department
 |where={{#var:whereclause}}
 |format=template

גרסה מ־21:10, 3 באוגוסט 2022