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

Question: Which 2nd Party has a Election of 1857?
SQL: SELECT "2nd_party" FROM north_essex_elections WHERE "election" = '1857'

Question: Which 2nd Party has a Election of 1857?
SQL: SELECT "2nd_party" FROM north_essex_elections WHERE "election" = '1857'

Question: Which 1st Party has a 1st Member of sir john tyssen tyrell, bt, and a 2nd Party of conservative, and a 2nd Member of john payne elwes?
SQL: SELECT "1st_party" FROM north_essex_elections WHERE "1st_member" = 'sir john tyssen tyrell, bt' AND "2nd_party" = 'conservative' AND "2nd_member" = 'john payne elwes'

Question: Which Election has a 2nd Member of reform act 1867 : constituency abolished?
SQL: SELECT "election" FROM north_essex_elections WHERE "2nd_member" = 'reform act 1867 : constituency abolished'

Question: which 1st Member has a Election of 1832
SQL: SELECT "1st_member" FROM north_essex_elections WHERE "election" = '1832'

Question: Which 2nd Member has a 1st Party of conservative and a Election of 1865?
SQL: SELECT "2nd_member" FROM north_essex_elections WHERE "1st_party" = 'conservative' AND "election" = '1865'