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

מתוך ויקיפועל
קפיצה לניווט קפיצה לחיפוש
(עוד ניסיון טיפול באפוסטרוף)
מאין תקציר עריכה
שורה 12: שורה 12:
}}{{#cargo_query:
}}{{#cargo_query:
tables=Games
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:fromyear}}=fromyear,{{#var:today}}=today,{{#var:tomonth}}=tomonth,{{#var:toyear}}=toyear,'{{#replace:{{{יריבה}}}|.|#}}'=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,"{{#replace:{{{יריבה}}}|.|#}}"=against
|where={{#var:whereclause}}
|where={{#var:whereclause}}
|format=template
|format=template

גרסה מ־12:29, 20 בינואר 2023


Error 1054: Unknown column '"{{{יריבה}}}"' in 'field list'

Function: CargoSQLQuery::run Query: SELECT `cargo__Games`.`_pageID` AS `cargo_backlink_page_id_Games`,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` AS `department`,'{{{מיום}}}' AS `fromday`,'{{{מחודש}}}' AS `frommonth`,'{{{משנה}}}' AS `fromyear`,'{{{ליום}}}' AS `today`,'{{{לחודש}}}' AS `tomonth`,'{{{לשנה}}}' AS `toyear`,`"{{{יריבה}}}"` AS `against` FROM `cargo__Games` WHERE liga IS NOT NULL AND liga='{{{ליגה}}}' AND department='{{{מחלקה}}}' AND result='{{{תוצאה}}}' AND homegame='{{{ביתיות}}}' AND (`cargo__Games`.`host`="" OR `cargo__Games`.`oponent`="") AND (year>'{{{משנה}}}' OR (year='{{{משנה}}}' AND month>'{{{מחודש}}}') OR (year='{{{משנה}}}' AND month='{{{מחודש}}}' AND day>='{{{מיום}}}')) AND (year<'{{{לשנה}}}' OR (year='{{{לשנה}}}' AND month<'{{{לחודש}}}') OR (year='{{{לשנה}}}' AND month='{{{לחודש}}}' AND day<='{{{ליום}}}')) AND mifal="{{{מפעל}}}" GROUP BY mifal ORDER BY `year`,`month`,`day` LIMIT 100