Query Results for
SELECT * FROM `Item` LEFT JOIN `IndexEntry` USING (ItemID) WHERE FIND_IN_SET(:'Oriental',`Categories`) AND `IsHidden` = 0 AND `Item`.`IsDeleted` = 0 AND `YearInvented` >= '2002' AND `YearInvented` <= '2004' AND `Language` = 'English' AND `LinkText` LIKE 'H%' ORDER BY `LinkText`, `Item`.`Summary` ASC LIMIT 500 OFFSET 0
- Humpmitregi. Larger Shogi variant with more powerful diagonal pieces. (10x9, Cells: 90) By Charles Gilman.
Redirect Your Search