Table schema:
CREATE TABLE table_29747178_2 (series__number VARCHAR, directed_by VARCHAR)

Question: What is the series # when the director is john showalter?
SQL: SELECT series__number FROM table_29747178_2 WHERE directed_by = "John Showalter"