אין תקציר עריכה |
אין תקציר עריכה |
||
| שורה 13: | שורה 13: | ||
AND Achievements.Achievement IN ('מקום 1', 'זכיה') | AND Achievements.Achievement IN ('מקום 1', 'זכיה') | ||
AND Competitions_Catalog.ConnectedCompID = '{{#var:מפעל לבדיקה}}' | AND Competitions_Catalog.ConnectedCompID = '{{#var:מפעל לבדיקה}}' | ||
|fields = {{#if: {{{ספירה|}}} | COUNT(*) | IF (Achievements.Season = '1966/68', IF (ConnectedCompID = 1, '1966/68', '1967/68'), Achievements.Season) }} | |fields = {{#if: {{{ספירה|}}} | COUNT(*) | IF (Achievements.Season = '1966/68', IF (Achievements.ConnectedCompID = 1, '1966/68', '1967/68'), Achievements.Season) }} | ||
|default = | |default = | ||
|no html | |no html | ||
}} | }} | ||
}} | }} | ||