|
|
שורה 1: |
שורה 1: |
| {{#vardefine:whereclause| | | {{#vardefine:whereclause| |
| result!="?" AND department="כדורגל" and mifal="גביע המדינה" and (stage LIKE '%סיבוב%') AND year>1979
| | liga='0' AND department='כדורסל' and mifal<>'גביע המדינה' and mifal<>'משחק אימון' |
| }} | | }} |
| | | <table border="1" cellpadding="2" cellspacing="0" width="90%" align="center"> |
| {| border="1" cellpadding="2" cellspacing="0" align="middle"
| | <tr style="background:#FF0000;"><td>תאריך</td><td>מפעל</td><td>שלב</td><td>מארחת</td><td>אורחת</td> |
| |- style="background:#FF0000;"
| | <td>תוצאה</td><td>הערות</td></tr> |
| !מפעל
| | {{#cargo_query: |
| !מפגשים
| | tables=Games|fields=day,month,year,stage,host,oponent,homescore,awayscore,ona,department,mifal,shootout,comments,department |
| !נצחונות
| |
| !תיקו
| |
| !הפסדים
| |
| !הפרש
| |
| {{!}}-{{#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,day,month,year,'{{#replace:{{{יריבה}}}|.|#}}'=against | |
| |where={{#var:whereclause}} | | |where={{#var:whereclause}} |
| |format=template | | |format=template |
| |template=שורת מפגשים ראש בראש | | |template=שורת טבלת משחקים פשוטה |
| | |more results text=עוד |
| | |named args=yes |
| |order by=year,month,day | | |order by=year,month,day |
| |rows per page=100
| |
| |default=
| |
| }}
| |
| |}
| |
|
| |
| {{#cargo_query:
| |
| tables=Games
| |
| |fields=concat(Games.year,'-',Games.month,'-',Games.day)=תאריך,
| |
| concat('<div class=\'',Games.result,'cell\'>','[[',Games.ona,']]','</div>')=עונה,
| |
| concat('<div class=\'',Games.result,'cell\'>','[[',Games.mifal,']]','</div>')=מפעל,
| |
| concat('<div class=\'',Games.result,'cell\'>',Games.stage,'</div>')=שלב,
| |
| concat('<div class=\'',Games.result,'cell\'>','[[',Games.host,']]','</div>')=מארחת,
| |
| concat('<div class=\'',Games.result,'cell\'>','[[',Games.oponent,']]','</div>')=אורחת,
| |
| 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>'))=תוצאה,
| |
| |where={{#var:whereclause}}
| |
| |format=dynamic table
| |
| |order by=תאריך DESC
| |
| |default=
| |
| |rows per page=100
| |
| }} | | }} |
| | </table> |