ארגז חול: הבדלים בין גרסאות בדף

{{#vardefine:whereclause|department='כדורסל' AND ona='2023/24' AND homegame='1'}}

 

}}{{#cargo_query:

tables=Games

|fields=STR_TO_DATE(CONCAT(Games.year,'-',Games.month, '-', Games.day), '%Y-%m-%d')=תאריך,

concat('<div class=\'',Games.result,'cell\'>','[[',Games.stadium,']]','</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>'))=תוצאה,

|format=dynamic table

|order by={{#ifeq:{{{סדר}}}|הפרש| ABS(Games.homescore-Games.awayscore) DESC|תאריך DESC}}

|default=

|rows per page=100