Table: legion_info
Columns: legion_no_and_title
main_legion_base
emblem
date_founded_founder
date_disband
castra_legionaria_legion_bases_main_base_start_date_31_bc_if_unspecified
notes

Question: What was the main legion base for the Romans when the notes were "primigenia goddess of fate. xx in batavi revolt"?
SQL: SELECT "main_legion_base" FROM legion_info WHERE "notes" = 'Primigenia goddess of Fate. XX in Batavi revolt'

Question: What are the notes during 57 bc caesar?
SQL: SELECT "notes" FROM legion_info WHERE "date_founded_founder" = '57 BC Caesar'

Question: What are the notes when castra legionaria (legion bases)  is 39-c.300 moguntiacum * (gs)?
SQL: SELECT "notes" FROM legion_info WHERE "castra_legionaria_legion_bases_main_base_start_date_31_bc_if_unspecified" = '39-c.300 Moguntiacum * (GS)'

Question: What is the date founded/founder when the emblem was Hercules?
SQL: SELECT "date_founded_founder" FROM legion_info WHERE "emblem" = 'Hercules'

Question: What is the main legion base that disbanded 70 xx?
SQL: SELECT "main_legion_base" FROM legion_info WHERE "date_disband" = '70 XX'