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

Query Results for


 Last Game Courier move entered 28 minutes ago.
 Last Game Courier open invitation made 2 DAYS ago.
 Last Game Courier game finished 1 DAY ago.
Last kibbitz comment entered 25 DAYS ago.
Last Chess Variant problem added 2929 DAYS ago.
Last comment or rating entered 1 hour ago.
Last game review entered 6 hours ago.

SELECT * FROM `Item` LEFT JOIN `IndexEntry` USING (ItemID) WHERE FIND_IN_SET(:'ShogiBased',`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