question: what is the latest year where glos & wilts is warminster?
answer: SELECT MAX(year) FROM table_12043148_2 WHERE glos_ & _wilts = "Warminster"
context: CREATE TABLE table_12043148_2 (year INTEGER, glos_ VARCHAR, _wilts VARCHAR)