Check out Grant Acedrex, our featured variant for April, 2024.

Query Results for


 Last Game Courier move entered 1 minute ago.
 Last Game Courier open invitation made 3 DAYS ago.
 Last Game Courier game finished 7 minutes ago.
Last kibbitz comment entered 11 DAYS ago.
Last Chess Variant problem added 2966 DAYS ago.
Last comment or rating entered 2 hours ago.
Last game review entered 2 DAYS ago.

SELECT * FROM `Item` LEFT JOIN `IndexEntry` USING (ItemID) WHERE `Type` = 'Java' AND `IsHidden` = 0 AND `Item`.`IsDeleted` = 0 AND `Language` != 'English' ORDER BY `ModifiedDate` DESC, `Item`.`RecordCreated` DESC LIMIT 500 OFFSET 0