Editing List of International Cards
From LOTR-TCG Wiki
The edit can be undone. Please check the comparison below to verify that this is what you want to do, and then publish the changes below to finish undoing the edit.
Latest revision | Your text | ||
Line 622: | Line 622: | ||
|join on=C.ID = CR.BaseCardID | |join on=C.ID = CR.BaseCardID | ||
|fields=CR.ImageFilename | |fields=CR.ImageFilename | ||
|where= CR.Subset IN ('F', 'O', 'A', 'S') AND CR.LanguageCode IN ('EN', 'TG', 'DE', 'FR', 'IT', 'ES', 'PL', 'PT', 'ZH', 'EL', 'HU', 'NL', 'SV') | |where= CR.Subset IN ('F', 'O', 'A', 'S', 'M') AND CR.LanguageCode IN ('EN', 'TG', 'DE', 'FR', 'IT', 'ES', 'PL', 'PT', 'ZH', 'EL', 'HU', 'NL', 'SV') | ||
|named args= yes | |named args= yes | ||
|default=''No Cards Found | |default=''No Cards Found | ||
Line 633: | Line 633: | ||
|join on=C.ID = CR.BaseCardID | |join on=C.ID = CR.BaseCardID | ||
|fields=COUNT(*) | |fields=COUNT(*) | ||
|where= CR.Subset IN ('F', 'O', 'A', 'S') AND CR.LanguageCode IN ('EN', 'TG', 'DE', 'FR', 'IT', 'ES', 'PL', 'PT', 'ZH', 'EL', 'HU', 'NL', 'SV') | |where= CR.Subset IN ('F', 'O', 'A', 'S', 'M') AND CR.LanguageCode IN ('EN', 'TG', 'DE', 'FR', 'IT', 'ES', 'PL', 'PT', 'ZH', 'EL', 'HU', 'NL', 'SV') | ||
|named args= yes | |named args= yes | ||
|default=''No Cards Found | |default=''No Cards Found | ||
Line 643: | Line 643: | ||
|join on=C.ID = CR.BaseCardID | |join on=C.ID = CR.BaseCardID | ||
|fields=CR.ImageFilename | |fields=CR.ImageFilename | ||
|where= CR.Subset IN ('F', 'O', 'A', 'S') AND CR.LanguageCode IN ('EN', 'TG', 'DE', 'FR', 'IT', 'ES', 'PL', 'PT', 'ZH', 'EL', 'HU', 'NL', 'SV') | |where= CR.Subset IN ('F', 'O', 'A', 'S', 'M') AND CR.LanguageCode IN ('EN', 'TG', 'DE', 'FR', 'IT', 'ES', 'PL', 'PT', 'ZH', 'EL', 'HU', 'NL', 'SV') | ||
|named args= yes | |named args= yes | ||
|default=''No Cards Found | |default=''No Cards Found | ||
Line 654: | Line 654: | ||
|join on=C.ID = CR.BaseCardID | |join on=C.ID = CR.BaseCardID | ||
|fields=COUNT(*) | |fields=COUNT(*) | ||
|where= CR.Subset IN ('F', 'O', 'A', 'S') AND CR.LanguageCode IN ('EN', 'TG', 'DE', 'FR', 'IT', 'ES', 'PL', 'PT', 'ZH', 'EL', 'HU', 'NL', 'SV') | |where= CR.Subset IN ('F', 'O', 'A', 'S', 'M') AND CR.LanguageCode IN ('EN', 'TG', 'DE', 'FR', 'IT', 'ES', 'PL', 'PT', 'ZH', 'EL', 'HU', 'NL', 'SV') | ||
|named args= yes | |named args= yes | ||
|default=''No Cards Found | |default=''No Cards Found |