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

Query Results for


 Last Game Courier move entered 10 minutes ago.
 Last Game Courier open invitation made 19 hours ago.
 Last Game Courier game finished 13 hours ago.
Last kibbitz comment entered 36 DAYS ago.
Last Chess Variant problem added 2939 DAYS ago.
Last comment or rating entered 2 hours ago.
Last game review entered 5 DAYS ago.

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