CREATE TABLE table_29747178_2 (series__number VARCHAR, directed_by VARCHAR)

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