What is the location when the opposition is mid canterbury?
create table table_26847237_3 (location varchar, opposition varchar, PRIMARY KEY (location))
select location from table_26847237_3 where opposition = "mid canterbury"