Table: north_staffs_mp_elections
Columns: election
1st_member
1st_party
2nd_member
2nd_party

Question: Which 1st Party has an election in 1847?
SQL: SELECT "1st_party" FROM north_staffs_mp_elections WHERE "election" = '1847'

Question: Which 1st Party has an election in 1865?
SQL: SELECT "1st_party" FROM north_staffs_mp_elections WHERE "election" = '1865'

Question: Which 1st Party has a 2nd Member of constituency abolished?
SQL: SELECT "1st_party" FROM north_staffs_mp_elections WHERE "2nd_member" = 'constituency abolished'

Question: Which 1st Member has an election in 1880 and a liberal 1st Party?
SQL: SELECT "1st_member" FROM north_staffs_mp_elections WHERE "1st_party" = 'liberal' AND "election" = '1880'

Question: Which 1st Member has an election in 1859 and a conservative 2nd Party?
SQL: SELECT "1st_member" FROM north_staffs_mp_elections WHERE "2nd_party" = 'conservative' AND "election" = '1859'