Query Results for
SELECT * FROM `Item` LEFT JOIN `IndexEntry` USING (ItemID) WHERE `Type` = 'Contest' AND `IsHidden` = 0 AND `Item`.`IsDeleted` = 0 AND `Language` = 'English' AND SUBSTRING(URL,1,5) IN ('http:', 'https', 'link2', 'd.lin') ORDER BY `ModifiedDate` DESC, `Item`.`RecordCreated` DESC LIMIT 500 OFFSET 0
- Hyperchess . Commercial page, advertising beautiful but expensive 3-dimensional chess sets. (Link.).
- Denver Chess Club Chigorin Chess Tournament. I'm sponsoring my first local chess variants tournament. Author: Jeremy Gabriel Good.