Query Results for

Type=Photo
Categories=chess,Singleplayer

SELECT * FROM `Item` LEFT JOIN `IndexEntry` USING (ItemID) WHERE `Type` = 'Photo' AND FIND_IN_SET(:'chess',`Categories`) AND FIND_IN_SET(:'Singleplayer',`Categories`) AND `IsHidden` = 0 AND `Item`.`IsDeleted` = 0 AND `Language` = 'English' ORDER BY `LinkText`, `Item`.`Summary` ASC LIMIT 500 OFFSET 0

H

1. Horse Chess-Nut. Horse statue with two chess problems painted on it. Author: David Howe.

---

Redirect Your Search

By Initial Letter

0-9

By Category

By Type

Search For

What's New Primary Links

Advanced Search

Search Criteria

Link text starts with letter: Any  0-9  A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  Q  R  S  T  U  V  W  X  Y  Z




Type:

Any  Contest  Craft  DTP  Fiction  Game  Graphics  Interview  Java  Jocly  Misc  NewsItem  Organization  PBM  Person  Photo  Piece  Piececlopedia  Poll  Problem  Program  Publication  Reference  SampleGame  Shop  Website  Video  Zillions  ZSG  Review  Link  Script

Category:

chess 1d 2d 3d 4d Large Small Multiplayer Oriental Historical Dice Cards Wargame Shape Hexagonal Round IncompleteInfo Other UnequalArmies Commercial Crossover Singleplayer XiangqiBased ShogiBased UsualEquipment Diff-Moving Diff-MovingOpponent Diff-MultiMove Diff-BoardRules Diff-Winning Diff-Setups Diff-Capturing Diff-Other Diff-Modest

Search LinkText = LIKE REGEXP Search URL = LIKE REGEXP Author ID: Inventor ID: Language: EnglishAny LanguageNon-EnglishSpanishFrenchGermanItalianDutchRussianChineseJapanese Invented on or after the year:  Invented on or before the year:  Board Rows:  Board Columns:  Board Levels:  Board Realms:  Board Cells:  Only Primary Links: Only Recognized Items: Only External Links: Only Internal Links: Only Member Submitted: Only HTML Pages: What's New? Last updated between days ago and days ago




Display Criteria

Order search results by: Link Text Type Date Modified Sort in descending order:  Display Author:  Display Inventor:  Display Images  Display Text Notes: