Editing Move Limit
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 43: | Line 43: | ||
,IFNULL(IFNULL(CR.FormattedGameText, CR.GameText),'')=GameText | ,IFNULL(IFNULL(CR.FormattedGameText, CR.GameText),'')=GameText | ||
|where=C.ID LIKE 'LOTR-EN%' | |where=C.ID LIKE 'LOTR-EN%' | ||
AND C.ID | AND (C.ID LIKE '%S%' OR C.SetNum LIKE '9') | ||
AND | AND C.SetNum <> '0' | ||
AND CR.GameText LIKE '%move limit%' | AND CR.GameText LIKE '%move limit%' | ||
AND (CR.GameText LIKE '%limit +%' | AND (CR.GameText LIKE '%limit +%' | ||
OR CR.GameText LIKE '%is +%' | OR CR.GameText LIKE '%is +%' | ||
OR CR.GameText LIKE '%turn +%') | OR CR.GameText LIKE '%turn +%') | ||
|order by= | |order by=C.Side, C.Culture, CONVERT(C.SetNum, int) | ||
}} | }} | ||
Line 63: | Line 63: | ||
,IFNULL(IFNULL(CR.FormattedGameText, CR.GameText),'')=GameText | ,IFNULL(IFNULL(CR.FormattedGameText, CR.GameText),'')=GameText | ||
|where=C.ID LIKE 'LOTR-EN%' | |where=C.ID LIKE 'LOTR-EN%' | ||
AND C.ID | AND C.ID LIKE '%S%' | ||
AND | AND C.SetNum <> 0 | ||
AND CR.GameText LIKE '% move limit%' | AND CR.GameText LIKE '% move limit%' | ||
AND (CR.GameText LIKE '%limit -%' | AND (CR.GameText LIKE '%limit -%' | ||
OR CR.GameText LIKE '%is -%' | OR CR.GameText LIKE '%is -%' | ||
OR CR.GameText LIKE '%turn -%') | OR CR.GameText LIKE '%turn -%') | ||
|order by= | |order by=C.Side, C.Culture, CONVERT(C.SetNum, int) | ||
}} | }} | ||
Line 85: | Line 85: | ||
,IFNULL(IFNULL(CR.FormattedGameText, CR.GameText),'')=GameText | ,IFNULL(IFNULL(CR.FormattedGameText, CR.GameText),'')=GameText | ||
|where=C.ID LIKE 'LOTR-EN%' | |where=C.ID LIKE 'LOTR-EN%' | ||
AND C.ID | AND C.ID LIKE '%S%' | ||
AND | AND C.SetNum <> 0 | ||
AND CR.GameText LIKE '%make the % move again%' | AND CR.GameText LIKE '%make the % move again%' | ||
|order by= | |order by=C.Side, C.Culture, CONVERT(C.SetNum, int) | ||
}} | }} |