|
|
(27 גרסאות ביניים של 2 משתמשים אינן מוצגות) |
שורה 1: |
שורה 1: |
| [[קטגוריה:מסד נתונים (כדורגל)]]
| | {{#vardefine:whereclause|department='כדורסל' AND ona='2023/24' AND homegame='1'}} |
| |
| | |
| {{#cargo_store:_table = Games | | }}{{#cargo_query: |
| |stage=מחזור 1
| | tables=Games |
| |host=הפועל חדרה
| | |fields=STR_TO_DATE(CONCAT(Games.year,'-',Games.month, '-', Games.day), '%Y-%m-%d')=תאריך, |
| |oponent=הפועל ת"א
| | concat('<div class=\'',Games.result,'cell\'>','[[',Games.stadium,']]','</div>')=אצטדיון, |
| |homegame=0
| | concat('<div class=\'',Games.result,'cell\'>','[[',Games.mifal,']]','</div>')=מפעל, |
| |result=x
| | concat('<div class=\'',Games.result,'cell\'>',Games.stage,'</div>')=שלב, |
| |mifal=ליגה לאומית
| | concat('<div class=\'',Games.result,'cell\'>','[[',Games.host,']]','</div>')=מארחת, |
| |liga=1
| | concat('<div class=\'',Games.result,'cell\'>','[[',Games.oponent,']]','</div>')=אורחת, |
| |hour=
| | IF(Games.liga = '1',concat('<div class=\'',Games.result,'cell\'>','[[עונת ',Games.ona,' (',Games.department,') ',Games.stage,'|',Games.awayscore,':',Games.homescore,']]','</div>'),concat('<div class=\'',Games.result,'cell\'>','[[עונת ',Games.ona,' (',Games.department,') ',Games.mifal,' ',Games.stage,'|',Games.awayscore,':',Games.homescore,']]','</div>'))=תוצאה, |
| |stadium=אצטדיון הפועל (חדרה)
| | |where={{#var:whereclause}} |
| |department=כדורגל | | |format=dynamic table |
| |comments=
| | |order by={{#ifeq:{{{סדר}}}|הפרש| ABS(Games.homescore-Games.awayscore) DESC|תאריך DESC}} |
| |ona=1975/76
| | |default= |
| |shidur=
| | |rows per page=100 |
| |homescore=0
| | }} |
| |awayscore=0
| |
| |shootout=
| |
| |day=25
| |
| |month=10
| |
| |year=1975
| |
| |}}
| |
| {{#cargo_store:_table = Games
| |
| |stage=מחזור 2
| |
| |host=הפועל ת"א
| |
| |oponent=מכבי נתניה
| |
| |homegame=1
| |
| |result=0
| |
| |mifal=ליגה לאומית
| |
| |liga=1
| |
| |hour=
| |
| |stadium=אצטדיון בלומפילד
| |
| |department=כדורגל
| |
| |comments=
| |
| |ona=1975/76
| |
| |shidur=
| |
| |homescore=0
| |
| |awayscore=1
| |
| |shootout=
| |
| |day=1
| |
| |month=11
| |
| |year=1975
| |
| |}}
| |
| {{#cargo_store:_table = Games | |
| |stage=סיבוב ד' | |
| |host=הפועל ר"ג
| |
| |oponent=הפועל ת"א
| |
| |mifal=גביע המדינה
| |
| |hour=
| |
| |stadium=המכתש
| |
| |department=כדורגל
| |
| |comments=משה מורדוכוביץ (1)
| |
| |ona=1975/76
| |
| |homescore=2
| |
| |awayscore=1
| |
| |shootout=
| |
| |day=4
| |
| |month=11
| |
| |year=1975
| |
| |result=0
| |
| |homegame=0
| |
| |liga=0
| |
| |}}
| |
| {{#cargo_store:_table = Games
| |
| |stage=מחזור 3
| |
| |host=הפועל ת"א
| |
| |oponent=בית"ר ת"א
| |
| |homegame=1
| |
| |result=0
| |
| |mifal=ליגה לאומית
| |
| |liga=1
| |
| |hour=
| |
| |stadium=אצטדיון בלומפילד
| |
| |department=כדורגל
| |
| |comments=
| |
| |ona=1975/76
| |
| |shidur=
| |
| |homescore=0
| |
| |awayscore=1
| |
| |shootout=
| |
| |day=8
| |
| |month=11
| |
| |year=1975
| |
| |}}
| |
| {{#cargo_store:_table = Games
| |
| |stage=מחזור 4
| |
| |host=בני יהודה
| |
| |oponent=הפועל ת"א
| |
| |homegame=0
| |
| |result=0
| |
| |mifal=ליגה לאומית
| |
| |liga=1
| |
| |hour=
| |
| |stadium=מגרש הפועל (טירת הכרמל)
| |
| |department=כדורגל
| |
| |comments=יעקב רחמינוביץ
| |
| |ona=1975/76
| |
| |shidur=
| |
| |homescore=2
| |
| |awayscore=1
| |
| |shootout=
| |
| |day=15
| |
| |month=11
| |
| |year=1975
| |
| |}}
| |
| {{#cargo_store:_table = Games
| |
| |stage=מחזור 5
| |
| |host=הפועל ת"א
| |
| |oponent=הכח ר"ג
| |
| |homegame=1
| |
| |result=x
| |
| |mifal=ליגה לאומית
| |
| |liga=1
| |
| |hour=
| |
| |stadium=אצטדיון בלומפילד
| |
| |department=כדורגל
| |
| |comments=דני ספוקויני
| |
| |ona=1975/76
| |
| |shidur=
| |
| |homescore=1
| |
| |awayscore=1
| |
| |shootout=
| |
| |day=22
| |
| |month=11
| |
| |year=1975
| |
| |}}
| |
| {{#cargo_store:_table = Games
| |
| |stage=מחזור 6
| |
| |host=הפועל פ"ת
| |
| |oponent=הפועל ת"א
| |
| |homegame=0
| |
| |result=1
| |
| |mifal=ליגה לאומית
| |
| |liga=1
| |
| |hour=
| |
| |stadium=האורווה
| |
| |department=כדורגל
| |
| |comments=[[משה מורדכוביץ]] (18), [[חיים פרנקו]] (38)
| |
| |ona=1975/76
| |
| |shidur=
| |
| |homescore=0
| |
| |awayscore=2
| |
| |shootout=
| |
| |day=29
| |
| |month=11
| |
| |year=1975
| |
| |}}
| |
| {{#cargo_store:_table = Games
| |
| |stage=מחזור 7
| |
| |host=הכח ר"ג
| |
| |oponent=הפועל ת"א
| |
| |homegame=0
| |
| |result=0
| |
| |mifal=ליגה לאומית
| |
| |liga=1
| |
| |hour=
| |
| |stadium=המכתש
| |
| |department=כדורגל
| |
| |comments=
| |
| |ona=1975/76
| |
| |shidur=
| |
| |homescore=1
| |
| |awayscore=0
| |
| |shootout=
| |
| |day=2
| |
| |month=12
| |
| |year=1975
| |
| |}}
| |
| {{#cargo_store:_table = Games
| |
| |stage=מחזור 8
| |
| |host=הפועל ת"א
| |
| |oponent=מכבי חיפה
| |
| |homegame=1
| |
| |result=1
| |
| |mifal=ליגה לאומית
| |
| |liga=1
| |
| |hour=
| |
| |stadium=אצטדיון בלומפילד
| |
| |department=כדורגל
| |
| |comments=[[מנחם מור]] (50), [[דני ספוקויני]] (82)
| |
| |ona=1975/76
| |
| |shidur=
| |
| |homescore=2
| |
| |awayscore=1
| |
| |shootout=
| |
| |day=6
| |
| |month=12
| |
| |year=1975
| |
| |}}
| |
| {{#cargo_store:_table = Games
| |
| |stage=מחזור 9
| |
| |host=שמשון ת"א
| |
| |oponent=הפועל ת"א
| |
| |homegame=0
| |
| |result=0
| |
| |mifal=ליגה לאומית
| |
| |liga=1
| |
| |hour=
| |
| |stadium=הקופסא
| |
| |department=כדורגל
| |
| |comments=אמיר ליברמן
| |
| |ona=1975/76
| |
| |shidur=
| |
| |homescore=4
| |
| |awayscore=1
| |
| |shootout=
| |
| |day=16
| |
| |month=12
| |
| |year=1975
| |
| |}}
| |
| {{#cargo_store:_table = Games
| |
| |stage=מחזור 10
| |
| |host=הפועל ת"א
| |
| |oponent=הפועל ב"ש
| |
| |homegame=1
| |
| |result=1
| |
| |mifal=ליגה לאומית
| |
| |liga=1
| |
| |hour=
| |
| |stadium=מגרש קטמון
| |
| |department=כדורגל
| |
| |comments=מישקה לפרדון
| |
| |ona=1975/76
| |
| |shidur=
| |
| |homescore=1
| |
| |awayscore=0
| |
| |shootout=
| |
| |day=20
| |
| |month=12
| |
| |year=1975
| |
| |}}
| |
| {{#cargo_store:_table = Games
| |
| |stage=מחזור 11
| |
| |host=הפועל ת"א
| |
| |oponent=הפועל פ"ת
| |
| |homegame=1
| |
| |result=0
| |
| |mifal=ליגה לאומית
| |
| |liga=1
| |
| |hour=
| |
| |stadium=אצטדיון עירוני אשקלון
| |
| |department=כדורגל
| |
| |comments=[[אמיר ליברמן]] (50)
| |
| |ona=1975/76
| |
| |shidur=
| |
| |homescore=1
| |
| |awayscore=2
| |
| |shootout=
| |
| |day=23
| |
| |month=12
| |
| |year=1975
| |
| |}}
| |
| {{#cargo_store:_table = Games
| |
| |stage=מחזור 12
| |
| |host=בית"ר י-ם
| |
| |oponent=הפועל ת"א
| |
| |homegame=0
| |
| |result=x
| |
| |mifal=ליגה לאומית
| |
| |liga=1
| |
| |hour=
| |
| |stadium=מגרש ימק"א
| |
| |department=כדורגל
| |
| |comments=
| |
| |ona=1975/76
| |
| |shidur=
| |
| |homescore=0
| |
| |awayscore=0
| |
| |shootout=
| |
| |day=27
| |
| |month=12
| |
| |year=1975
| |
| |}}
| |
| {{#cargo_store:_table = Games
| |
| |stage=מחזור 13
| |
| |host=הפועל ת"א
| |
| |oponent=מכבי רמת עמידר
| |
| |homegame=1
| |
| |result=1
| |
| |mifal=ליגה לאומית
| |
| |liga=1
| |
| |hour=
| |
| |stadium=אצטדיון בלומפילד
| |
| |department=כדורגל
| |
| |comments=ריפעת טורק
| |
| |ona=1975/76
| |
| |shidur=
| |
| |homescore=1
| |
| |awayscore=0
| |
| |shootout=
| |
| |day=3
| |
| |month=1
| |
| |year=1976
| |
| |}}
| |
| {{#cargo_store:_table = Games
| |
| |stage=מחזור 14
| |
| |host=מכבי יפו
| |
| |oponent=הפועל ת"א
| |
| |homegame=0
| |
| |result=x
| |
| |mifal=ליגה לאומית
| |
| |liga=1
| |
| |hour=
| |
| |stadium=מגרש הפועל (יהוד)
| |
| |department=כדורגל
| |
| |comments=
| |
| |ona=1975/76
| |
| |shidur=
| |
| |homescore=0
| |
| |awayscore=0
| |
| |shootout=
| |
| |day=10
| |
| |month=1
| |
| |year=1976
| |
| |}}
| |
| {{#cargo_store:_table = Games
| |
| |stage=מחזור 15
| |
| |host=הפועל ת"א
| |
| |oponent=הפועל כפ"ס
| |
| |homegame=1
| |
| |result=0
| |
| |mifal=ליגה לאומית
| |
| |liga=1
| |
| |hour=
| |
| |stadium=אצטדיון בלומפילד
| |
| |department=כדורגל
| |
| |comments=
| |
| |ona=1975/76
| |
| |shidur=
| |
| |homescore=0
| |
| |awayscore=4
| |
| |shootout=
| |
| |day=17
| |
| |month=1
| |
| |year=1976
| |
| |}}
| |
| {{#cargo_store:_table = Games
| |
| |stage=מחזור 16
| |
| |host=הפועל חיפה
| |
| |oponent=הפועל ת"א
| |
| |homegame=0
| |
| |result=1
| |
| |mifal=ליגה לאומית
| |
| |liga=1
| |
| |hour=
| |
| |stadium=מגרש הפועל (קרית חיים)
| |
| |department=כדורגל
| |
| |comments=ריפעת טורק
| |
| |ona=1975/76
| |
| |shidur=
| |
| |homescore=0
| |
| |awayscore=1
| |
| |shootout=
| |
| |day=24
| |
| |month=1
| |
| |year=1976
| |
| |}}
| |
| {{#cargo_store:_table = Games
| |
| |stage=מחזור 17
| |
| |host=הפועל ת"א | |
| |oponent=מכבי פ"ת
| |
| |homegame=1
| |
| |result=1
| |
| |mifal=ליגה לאומית
| |
| |liga=1
| |
| |hour=
| |
| |stadium=אצטדיון בלומפילד
| |
| |department=כדורגל
| |
| |comments=יעקב רחמינוביץ, אמיר ליברמן
| |
| |ona=1975/76
| |
| |shidur=
| |
| |homescore=2
| |
| |awayscore=0
| |
| |shootout=
| |
| |day=31
| |
| |month=1
| |
| |year=1976
| |
| |}}
| |
| {{#cargo_store:_table = Games
| |
| |stage=מחזור 18
| |
| |host=מכבי ת"א
| |
| |oponent=הפועל ת"א
| |
| |homegame=0
| |
| |result=x
| |
| |mifal=ליגה לאומית
| |
| |liga=1
| |
| |hour=
| |
| |stadium=אצטדיון בלומפילד
| |
| |department=כדורגל
| |
| |comments=
| |
| |ona=1975/76
| |
| |shidur=
| |
| |homescore=0
| |
| |awayscore=0
| |
| |shootout=
| |
| |day=7
| |
| |month=2
| |
| |year=1976
| |
| |}}
| |
| {{#cargo_store:_table = Games
| |
| |stage=מחזור 19
| |
| |host=הפועל ת"א
| |
| |oponent=הפועל י-ם
| |
| |homegame=1
| |
| |result=1
| |
| |mifal=ליגה לאומית
| |
| |liga=1
| |
| |hour=
| |
| |stadium=אצטדיון בלומפילד
| |
| |department=כדורגל
| |
| |comments=ריפעת טורק, אמיר ליברמן, דוד מיר
| |
| |ona=1975/76
| |
| |shidur=
| |
| |homescore=3
| |
| |awayscore=2
| |
| |shootout=
| |
| |day=14
| |
| |month=2
| |
| |year=1976
| |
| |}}
| |
| {{#cargo_store:_table = Games
| |
| |stage=מחזור 20
| |
| |host=הפועל ת"א
| |
| |oponent=הפועל חדרה
| |
| |homegame=1
| |
| |result=1
| |
| |mifal=ליגה לאומית
| |
| |liga=1
| |
| |hour=
| |
| |stadium=אצטדיון בלומפילד
| |
| |department=כדורגל
| |
| |comments=דוד מיר
| |
| |ona=1975/76
| |
| |shidur=
| |
| |homescore=1
| |
| |awayscore=0
| |
| |shootout=
| |
| |day=21
| |
| |month=2
| |
| |year=1976
| |
| |}}
| |
| {{#cargo_store:_table = Games
| |
| |stage=מחזור 21
| |
| |host=מכבי נתניה
| |
| |oponent=הפועל ת"א
| |
| |homegame=0
| |
| |result=0
| |
| |mifal=ליגה לאומית
| |
| |liga=1
| |
| |hour=
| |
| |stadium=הקופסא
| |
| |department=כדורגל
| |
| |comments=
| |
| |ona=1975/76
| |
| |shidur=
| |
| |homescore=1
| |
| |awayscore=0
| |
| |shootout=
| |
| |day=28
| |
| |month=2
| |
| |year=1976
| |
| |}}
| |
| {{#cargo_store:_table = Games
| |
| |stage=מחזור 22
| |
| |host=בית"ר ת"א | |
| |oponent=הפועל ת"א
| |
| |homegame=0
| |
| |result=1
| |
| |mifal=ליגה לאומית
| |
| |liga=1
| |
| |hour=
| |
| |stadium=אצטדיון בלומפילד
| |
| |department=כדורגל
| |
| |comments=ריפעת טורק, חיים פרנקו
| |
| |ona=1975/76
| |
| |shidur=
| |
| |homescore=0
| |
| |awayscore=2
| |
| |shootout=
| |
| |day=6
| |
| |month=3
| |
| |year=1976
| |
| |}}
| |
| {{#cargo_store:_table = Games
| |
| |stage=מחזור 23
| |
| |host=הפועל ת"א
| |
| |oponent=בני יהודה
| |
| |homegame=1
| |
| |result=x
| |
| |mifal=ליגה לאומית
| |
| |liga=1
| |
| |hour=
| |
| |stadium=אצטדיון בלומפילד
| |
| |department=כדורגל
| |
| |comments=
| |
| |ona=1975/76
| |
| |shidur=
| |
| |homescore=0
| |
| |awayscore=0
| |
| |shootout=
| |
| |day=13 | |
| |month=3
| |
| |year=1976
| |
| |}}
| |
| {{#cargo_store:_table = Games | |
| |stage=מחזור 24
| |
| |host=הפועל ב"ש
| |
| |oponent=הפועל ת"א
| |
| |homegame=0
| |
| |result=x
| |
| |mifal=ליגה לאומית
| |
| |liga=1
| |
| |hour=
| |
| |stadium=אצטדיון וסרמיל
| |
| |department=כדורגל
| |
| |comments=
| |
| |ona=1975/76
| |
| |shidur=
| |
| |homescore=0
| |
| |awayscore=0
| |
| |shootout=
| |
| |day=20
| |
| |month=3
| |
| |year=1976
| |
| |}}
| |
| {{#cargo_store:_table = Games
| |
| |stage=מחזור 25
| |
| |host=הפועל ת"א
| |
| |oponent=שמשון ת"א
| |
| |homegame=1
| |
| |result=x
| |
| |mifal=ליגה לאומית
| |
| |liga=1
| |
| |hour=
| |
| |stadium=אצטדיון בלומפילד
| |
| |department=כדורגל
| |
| |comments=
| |
| |ona=1975/76 | |
| |shidur= | |
| |homescore=0
| |
| |awayscore=0
| |
| |shootout=
| |
| |day=17
| |
| |month=4
| |
| |year=1976
| |
| |}}
| |
| {{#cargo_store:_table = Games | |
| |stage=מחזור 26
| |
| |host=מכבי חיפה
| |
| |oponent=הפועל ת"א
| |
| |homegame=0
| |
| |result=0
| |
| |mifal=ליגה לאומית
| |
| |liga=1
| |
| |hour=
| |
| |stadium=קרית אליעזר
| |
| |department=כדורגל
| |
| |comments=
| |
| |ona=1975/76
| |
| |shidur=
| |
| |homescore=1
| |
| |awayscore=0
| |
| |shootout=
| |
| |day=21
| |
| |month=4
| |
| |year=1976
| |
| |}}
| |
| {{#cargo_store:_table = Games | |
| |stage=מחזור 27
| |
| |host=הפועל ת"א
| |
| |oponent=בית"ר י-ם
| |
| |homegame=1
| |
| |result=x
| |
| |mifal=ליגה לאומית
| |
| |liga=1
| |
| |hour=
| |
| |stadium=אצטדיון בלומפילד
| |
| |department=כדורגל
| |
| |comments=ריפעת טורק
| |
| |ona=1975/76
| |
| |shidur=
| |
| |homescore=1
| |
| |awayscore=1
| |
| |shootout=
| |
| |day=24
| |
| |month=4
| |
| |year=1976
| |
| |}}
| |
| {{#cargo_store:_table = Games | |
| |stage=מחזור 28
| |
| |host=מכבי רמת עמידר
| |
| |oponent=הפועל ת"א
| |
| |homegame=0
| |
| |result=x
| |
| |mifal=ליגה לאומית
| |
| |liga=1
| |
| |hour=
| |
| |stadium=מגרש מכבי רמת עמידר
| |
| |department=כדורגל
| |
| |comments=
| |
| |ona=1975/76
| |
| |shidur=
| |
| |homescore=0
| |
| |awayscore=0
| |
| |shootout=
| |
| |day=1
| |
| |month=5
| |
| |year=1976
| |
| |}}
| |
| {{#cargo_store:_table = Games
| |
| |stage=מחזור 29
| |
| |host=הפועל ת"א
| |
| |oponent=מכבי יפו
| |
| |homegame=1
| |
| |result=1
| |
| |mifal=ליגה לאומית
| |
| |liga=1
| |
| |hour=
| |
| |stadium=אצטדיון בלומפילד
| |
| |department=כדורגל
| |
| |comments=משה מורדוכוביץ
| |
| |ona=1975/76
| |
| |shidur=
| |
| |homescore=1
| |
| |awayscore=0
| |
| |shootout=
| |
| |day=8
| |
| |month=5
| |
| |year=1976
| |
| |}}
| |
| {{#cargo_store:_table = Games
| |
| |stage=מחזור 30
| |
| |host=הפועל כפ"ס
| |
| |oponent=הפועל ת"א
| |
| |homegame=0
| |
| |result=0
| |
| |mifal=ליגה לאומית | |
| |liga=1 | |
| |hour=
| |
| |stadium=מגרש הפועל (כפ"ס)
| |
| |department=כדורגל
| |
| |comments=
| |
| |ona=1975/76
| |
| |shidur=
| |
| |homescore=1
| |
| |awayscore=0
| |
| |shootout=
| |
| |day=15
| |
| |month=5
| |
| |year=1976
| |
| |}}
| |
| {{#cargo_store:_table = Games
| |
| |stage=מחזור 31
| |
| |host=הפועל ת"א
| |
| |oponent=הפועל חיפה
| |
| |homegame=1
| |
| |result=x
| |
| |mifal=ליגה לאומית
| |
| |liga=1
| |
| |hour=
| |
| |stadium=אצטדיון בלומפילד
| |
| |department=כדורגל
| |
| |comments=יחזקאל חזום
| |
| |ona=1975/76
| |
| |shidur=
| |
| |homescore=1
| |
| |awayscore=1
| |
| |shootout=
| |
| |day=22
| |
| |month=5
| |
| |year=1976
| |
| |}}
| |
| {{#cargo_store:_table = Games
| |
| |stage=מחזור 32
| |
| |host=מכבי פ"ת
| |
| |oponent=הפועל ת"א
| |
| |homegame=0
| |
| |result=0
| |
| |mifal=ליגה לאומית
| |
| |liga=1
| |
| |hour=
| |
| |stadium=האורווה
| |
| |department=כדורגל
| |
| |comments=יהושע פייגנבוים
| |
| |ona=1975/76
| |
| |shidur=
| |
| |homescore=2
| |
| |awayscore=1
| |
| |shootout=
| |
| |day=29
| |
| |month=5
| |
| |year=1976
| |
| |}} | |
| {{#cargo_store:_table = Games
| |
| |stage=מחזור 33
| |
| |host=הפועל ת"א
| |
| |oponent=מכבי ת"א
| |
| |homegame=1
| |
| |result=1
| |
| |mifal=ליגה לאומית
| |
| |liga=1
| |
| |hour=
| |
| |stadium=אצטדיון בלומפילד
| |
| |department=כדורגל
| |
| |comments=יחזקאל חזום, יהושע פייגנבוים | |
| |ona=1975/76 | |
| |shidur=
| |
| |homescore=2
| |
| |awayscore=1
| |
| |shootout=
| |
| |day=5
| |
| |month=6
| |
| |year=1976
| |
| |}}
| |
| {{#cargo_store:_table = Games
| |
| |stage=מחזור 34
| |
| |host=הפועל י-ם
| |
| |oponent=הפועל ת"א
| |
| |homegame=0
| |
| |result=1
| |
| |mifal=ליגה לאומית
| |
| |liga=1
| |
| |hour=
| |
| |stadium=מגרש קטמון
| |
| |department=כדורגל
| |
| |comments=יהושע פייגנבוים, יעקב רחמינוביץ', יחזקאל חזום
| |
| |ona=1975/76
| |
| |shidur=
| |
| |homescore=1
| |
| |awayscore=3
| |
| |shootout=
| |
| |day=12
| |
| |month=6
| |
| |year=1976
| |
| |}}
| |