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_11164 ( "Difficulty Value" text, "1d10 Resolution (+5)" real, "3d6 or 1d20 Resolution (+10)" real, "+1d6-1d6 or +1d10-1d10 (+0)" real, "+1d12 (6)" real )

### Question ###
What is the highest +1d12 (6) with a 3d6 or 1d20 Resolution (+10) larger than 10,with a +1d6-1d6 or +1d10-1d10 (+0) of 4, with 1d10 Resolution (+5) larger than 9?

### Accurate SQL ###

SELECT MAX("+1d12 (6)") FROM table_11164 WHERE "3d6 or 1d20 Resolution (+10)" > '10' AND "+1d6-1d6 or +1d10-1d10 (+0)" = '4' AND "1d10 Resolution (+5)" > '9'