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_242785_3 (main_legion_base VARCHAR, notes VARCHAR)

### Question ###
What was the main legion base for the Romans when the notes were "primigenia goddess of fate. xx in batavi revolt"?

### Accurate SQL ###

SELECT main_legion_base FROM table_242785_3 WHERE notes = "Primigenia goddess of Fate. XX in Batavi revolt"