Query Results for
SELECT * FROM `Item` LEFT JOIN `IndexEntry` USING (ItemID) WHERE `Type` = 'Java' AND `IsHidden` = 0 AND `Item`.`IsDeleted` = 0 AND `YearInvented` >= '2004' AND `YearInvented` <= '2006' AND `Language` = 'English' ORDER BY `LinkText`, `Item`.`Summary` ASC LIMIT 500 OFFSET 0
- Crown Prince Chess. Missing description Author: Ed Friedlander. Inventor: Matthew Chrzaszcz.
- OverKnight Chess. Pawns are replaced by Knights, which promote. Author: Ed Friedlander.
- Royal Magician Chess. Missing description Author: Ed Friedlander. Inventor: Gary K. Gifford.
- Royal Pawn. Missing description Author: Ed Friedlander. Inventor: Jeremy Gabriel Good.
- Sanctuary Chess. Archbishop and Swiss Guard replace Queen and King; no checkmate. Author: Ed Friedlander.
- Trophy Hunt Chess. Squirrels and Elephants instead of Kings, Queens and Bishops. Author: Ed Friedlander.