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_23224961_2 (mittelfranken_süd VARCHAR, unterfranken_west VARCHAR, mittelfranken_nord VARCHAR)

### Question ###
When atsv erlangen is the mittelfranken nord and alemannia haibach is the unterfranken west what is the mittelfranken süd?

### Accurate SQL ###

SELECT mittelfranken_süd FROM table_23224961_2 WHERE unterfranken_west = "Alemannia Haibach" AND mittelfranken_nord = "ATSV Erlangen"