Table: roman_legions
Columns: legion_no_and_title
main_legionary_base
emblem
date_founded_founder
date_disband
castra_legionaria_legion_bases_main_base_start_date_31bc_if_unspecified
notes

Question: When did svishtov , bulgaria disband?
SQL: SELECT "date_disband" FROM roman_legions WHERE "main_legionary_base" = 'Svishtov , Bulgaria'

Question: when notes are prima italica:raised for aborted caucasus war, when was that founded?
SQL: SELECT "date_founded_founder" FROM roman_legions WHERE "notes" = 'prima Italica:raised for aborted Caucasus war'

Question: What are the notes for svishtov , bulgaria?
SQL: SELECT "notes" FROM roman_legions WHERE "main_legionary_base" = 'Svishtov , Bulgaria'