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

@@ שורה 20: / שורה 20: @@
 {{#cargo_query:
 tables=Games
-|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,{{#var:fromday}}=fromday,{{#var:frommonth}}=frommonth,{{#var:froyear}}=fromyear,{{#var:today}}=today,{{#var:tomonth}}=tomonth,{{#var:toyear}}=toyear,{{#var:oponent}}=against
+|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,{{#var:fromday}}=fromday,{{#var:frommonth}}=frommonth,{{#var:fromyear}}=fromyear,{{#var:today}}=today,{{#var:tomonth}}=tomonth,{{#var:toyear}}=toyear,{{#var:oponent}}=against
 |where={{#var:whereclause}}
 |format=template

גרסה מ־21:50, 4 באוגוסט 2022