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 `LinkText` LIKE 'P%' ORDER BY `AvgRating` DESC, `Item`.`Summary` DESC LIMIT 500 OFFSET 0
- Pocket pieces thematic tourney. Chess problem composition tournament. Closing date April 30, 2002.
- Proposed World Open Variant PBEM Tourney. Tournament proposal open for public comment before creation.