Query Results for

Last Game Courier move entered 6 minutes ago.

Last Game Courier open invitation made 17 hours ago.

Last Game Courier game finished 6 hours ago.

Last kibbitz comment entered 1 DAY ago.

Last Chess Variant problem added 2957 DAYS ago.

Last comment or rating entered 2 hours ago.

Last game review entered 3 DAYS ago.

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

Week ending March 23, 2024

The showpiece script. A script for displaying individual piece images with some modifications. By Fergus Duniho.

Next: between 30 and 60 days or more old for a minimum of 0 items.