|
|
שורה 1: |
שורה 1: |
| [[קובץ:IMG 20230824 104120.jpg|400px]] | | [[קובץ:IMG 20230824 104120.jpg|400px]] |
|
| |
| {{#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
| |
| |where=liga IS NOT NULL and stage='מחזור 1' AND department='כדורגל' AND year>1947 AND result<>'?' GROUP BY liga}}
| |
| |format=template
| |
| |template=שורת מפגשים ראש בראש
| |
| |default=
| |
| }}
| |
|
| |
|
| |
|
| {{#vardefine:whereclause|liga IS NOT NULL and stage='מחזור 1' AND department='כדורגל' AND year>1947 AND result<>'?'}} | | {{#vardefine:whereclause|liga IS NOT NULL and stage='מחזור 1' AND department='כדורגל' AND year>1947 AND result<>'?'}} |