אין תקציר עריכה |
אין תקציר עריכה |
||
| שורה 2: | שורה 2: | ||
-->{{#תנאי: {{{עונות|}}} | {{#arraydefine:עונות לבדיקה| {{{עונות|}}} }} }}<!-- | -->{{#תנאי: {{{עונות|}}} | {{#arraydefine:עונות לבדיקה| {{{עונות|}}} }} }}<!-- | ||
-->{{#arraydefine: special_seasons| 1966/67, 1967/68|,}}<!-- | -->{{#arraydefine: special_seasons| 1966/67, 1967/68|,}}<!-- | ||
-->{{#if: {{#arraysearch: עונות לבדיקה| 1966/68}}| {{#arrayunion: all_seasons| special_seasons| עונות לבדיקה}}| {{#arrayunion: all_seasons| עונות לבדיקה}} }}<!-- | -->{{#if: {{#arraysearch: עונות לבדיקה| 1966/68}}| {{#arrayunion: all_seasons| special_seasons| עונות לבדיקה}}| {{#arrayunion: all_seasons| עונות לבדיקה}} }}<!-- | ||
-->{{#cargo_query: | -->{{#cargo_query: | ||
tables = Achievements, | tables = Achievements, Competitions | ||
|join on = Achievements. | |join on = Achievements.Competition = Competitions.OriginalName | ||
|group | |group | ||
|where = 1=1 | |where = 1=1 | ||
AND Achievements.Season IN ( {{#arrayprint:all_seasons|, |@@@@| '@@@@' }} ) | AND Achievements.Season IN ( {{#arrayprint:all_seasons|, |@@@@| '@@@@' }} ) | ||
AND Achievements.Achievement IN ('מקום 1', 'זכיה') | AND Achievements.Achievement IN ('מקום 1', 'זכיה') | ||
AND | AND Competitions.OriginalName= '{{{מפעל|}}}' | ||
|fields = Achievements.Season | |fields = Achievements.Season | ||
|default = | |default = | ||
|no html | |no html | ||
}} | }} | ||
גרסה מ־00:20, 2 בספטמבר 2022
Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')\x0AAND `MPMW_cargo__Achievements`.`Achievement` IN ('\xD7\x9E\xD7\xA7\xD7\x95\' at line 2
Function: CargoSQLQuery::run Query: SELECT `MPMW_cargo__Competitions`.`_pageID` AS `cargo_backlink_page_id_Competitions`,`MPMW_cargo__Achievements`.`_pageID` AS `cargo_backlink_page_id_Achievements`,`MPMW_cargo__Achievements`.`Season` AS `Season` FROM `MPMW_cargo__Achievements` LEFT OUTER JOIN `MPMW_cargo__Competitions` ON ((`MPMW_cargo__Achievements`.`Competition`=`MPMW_cargo__Competitions`.`OriginalName`)) WHERE 1=1 AND `MPMW_cargo__Achievements`.`Season` IN ( ) AND `MPMW_cargo__Achievements`.`Achievement` IN ('מקום 1', 'זכיה') AND `MPMW_cargo__Competitions`.`OriginalName`= ORDER BY `MPMW_cargo__Competitions`.`_pageID`,`MPMW_cargo__Achievements`.`_pageID`,`MPMW_cargo__Achievements`.`Season` LIMIT 100