Check out Symmetric Chess, our featured variant for March, 2024.

Query Results for


 Last Game Courier move entered 2 hours ago.
 Last Game Courier open invitation made 5 DAYS ago.
 Last Game Courier game finished 2 hours ago.
Last kibbitz comment entered 34 DAYS ago.
Last Chess Variant problem added 2938 DAYS ago.
Last comment or rating entered 2 hours ago.
Last game review entered 4 DAYS ago.

SELECT * FROM `Item` LEFT JOIN `IndexEntry` USING (ItemID) WHERE `Type` = 'Game' AND FIND_IN_SET(:'Large',`Categories`) AND `IsHidden` = 0 AND `Item`.`IsDeleted` = 0 AND FROM_DAYS(TO_DAYS(NOW()) - 120) <= `ModifiedDate` AND FROM_DAYS(TO_DAYS(NOW()) - 90) >= `ModifiedDate` AND `Language` = 'English' ORDER BY `ModifiedDate` DESC, `Item`.`RecordCreated` DESC LIMIT 500 OFFSET 0