question: What is the series # when the director is john showalter?
answer: SELECT series__number FROM table_29747178_2 WHERE directed_by = "John Showalter"
context: CREATE TABLE table_29747178_2 (series__number VARCHAR, directed_by VARCHAR)