Query Results for
SELECT * FROM `Item` LEFT JOIN `IndexEntry` USING (ItemID) WHERE FIND_IN_SET(:'XiangqiBased',`Categories`) AND FIND_IN_SET(:'Oriental',`Categories`) AND `IsHidden` = 0 AND `Item`.`IsDeleted` = 0 AND `YearInvented` >= '2006' AND `YearInvented` <= '2008' AND `Language` = 'English' AND `LinkText` LIKE 'M%' ORDER BY `LinkText`, `Item`.`Summary` ASC LIMIT 500 OFFSET 0
- Magic River. Xiang Qi pieces crossing the Magic River turn into their Western counterparts, and vice versa! (17x9, Cells: 77) By John Smith.
- MiniXiang. Missing description Author: Larry L. Smith. Inventor: Charles Gilman.
Redirect Your Search