Table schema:
CREATE TABLE table_name_97 (club VARCHAR, player VARCHAR)

Question: What club wast he player hristo stoitchkov from?
SQL: SELECT club FROM table_name_97 WHERE player = "hristo stoitchkov"