Query Results for
Type=Java
Categories=2d,UsualEquipment,Diff-Moving,Diff-Setups
SELECT * FROM `Item` LEFT JOIN `IndexEntry` USING (ItemID) WHERE `Type` = 'Java' AND FIND_IN_SET(:'2d',`Categories`) AND FIND_IN_SET(:'UsualEquipment',`Categories`) AND FIND_IN_SET(:'Diff-Moving',`Categories`) AND FIND_IN_SET(:'Diff-Setups',`Categories`) AND `IsHidden` = 0 AND `Item`.`IsDeleted` = 0 AND `Language` = 'English' ORDER BY `LinkText`, `Item`.`Summary` ASC LIMIT 500 OFFSET 0
- Chazz. Only kings and pawns. Pawns can move backwards. Author: Ed Friedlander.
- Citadel. Missing description Author: Ed Friedlander.
- Crown Prince Chess. Missing description Author: Ed Friedlander. Inventor: Matthew Chrzaszcz.
- Hero Chess. The king's pawn is replaced by a unit which mimics the move of any friendly unit on the board. Author: Ed Friedlander. Inventor: Tomas Forsman.
- Hero Chess II. Missing description Author: Ed Friedlander.
- Hero Chess III. Also called Superhero Chess. Author: Ed Friedlander. Inventor: Tomas Forsman.
- Legan's Chess. Normal set and board, different setup and pawn moves. Author: Ed Friedlander. Inventor: L. Legan.