Below is the list of tables from the database along with their columns and datatype. Need to generate an accurate SQL query for the question.
Only use the columns present in the respective table. Only use the columns which are required to generate the SQL query. Only use table joins if required and not otherwise.

### Tables ###
TABLE: CREATE TABLE table_name_75 ( production_code VARCHAR, written_by VARCHAR, season__number VARCHAR, series__number VARCHAR )

### Question ###
What is the production code of the episode written by Gary Sturgis that is bigger than season number 23 and smaller than series number 126?

### Accurate SQL ###

SELECT production_code FROM table_name_75 WHERE season__number > 23 AND series__number < 126 AND written_by = "gary sturgis"