SELECT Gender, Residence, Player_name, Occupation, Player_ID, Votes, Rank FROM player WHERE Rank != "3rd" OR Gender != "M" AND Residence = "Brandon" AND "Player_ID" > 11 OR Sponsor_name != "Provencher" OR "Votes" >= 4947 AND Occupation != "Small Businessman" AND Player_name = "Niki Ashton" INTERSECT SELECT Gender, Residence, Player_name, Occupation, Player_ID, Votes, Rank FROM player WHERE "Player_ID" != 14 OR Gender != "F" OR "Votes" != 5490 OR Occupation = "Retired" OR Rank = "2nd" OR Player_name != "Matt Schaubroeck" OR Residence != "Winnipeg" OR Sponsor_name != "Brandon—Souris" <table_name> : player col : Player_ID | Sponsor_name | Player_name | Gender | Residence | Occupation | Votes | Rank row 1 : 1 | BrandonâSouris | Jean Luc BouchÃ© | M | Brandon | Locomotive Engineer | 6055 | 2nd row 2 : 2 | CharleswoodâSt. JamesâAssiniboia | Fiona Shiells | F | Winnipeg | Ministerial Assistant | 7190 | 3rd row 3 : 3 | Churchill | Niki Ashton | F | Thompson | Researcher | 8734 | 1st row 4 : 4 | DauphinâSwan RiverâMarquette | Ron Strynadka | M | Birtle | Retired | 4914 | 2nd row 5 : 5 | ElmwoodâTranscona | Jim Maloway | M | Winnipeg | Small Businessman | 14355 | 1st row 6 : 6 | KildonanâSt. Paul | Ross Eadie | M | Winnipeg | Self Employed / Consultant | 12093 | 2nd row 7 : 7 | PortageâLisgar | Mohamed Alli | M | Winnipeg | Distribution Centre Associate | 2353 | 4th row 8 : 8 | Provencher | Ross C. Martin | M | Oakbank | Design Coordinator | 4947 | 2nd row 9 : 9 | Saint Boniface | Matt Schaubroeck | M | Winnipeg | Student | 5502 | 3rd row 10 : 10 | SelkirkâInterlake | Patricia Cordner | F | Selkirk | Retired | 9506 | 2nd row 11 : 11 | Winnipeg Centre | Pat Martin | M | Winnipeg | Parliamentarian | 12285 | 1st row 12 : 12 | Winnipeg North | Judy Wasylycia-Leis | F | Winnipeg | Parliamentarian | 14097 | 1st row 13 : 13 | Winnipeg South | Sean Robert | M | Winnipeg | Product Consultant - MLCC | 4673 | 3rd row 14 : 14 | Winnipeg South Centre | Rachel Heinrichs | F | Winnipeg | Student | 5490 | 3rd <table_name> : player col : Player_ID | Sponsor_name | Player_name | Gender | Residence | Occupation | Votes | Rank row 1 : 1 | BrandonâSouris | Jean Luc BouchÃ© | M | Brandon | Locomotive Engineer | 6055 | 2nd row 2 : 2 | CharleswoodâSt. JamesâAssiniboia | Fiona Shiells | F | Winnipeg | Ministerial Assistant | 7190 | 3rd row 3 : 3 | Churchill | Niki Ashton | F | Thompson | Researcher | 8734 | 1st row 4 : 4 | DauphinâSwan RiverâMarquette | Ron Strynadka | M | Birtle | Retired | 4914 | 2nd row 5 : 5 | ElmwoodâTranscona | Jim Maloway | M | Winnipeg | Small Businessman | 14355 | 1st row 6 : 6 | KildonanâSt. Paul | Ross Eadie | M | Winnipeg | Self Employed / Consultant | 12093 | 2nd row 7 : 7 | PortageâLisgar | Mohamed Alli | M | Winnipeg | Distribution Centre Associate | 2353 | 4th row 8 : 8 | Provencher | Ross C. Martin | M | Oakbank | Design Coordinator | 4947 | 2nd row 9 : 9 | Saint Boniface | Matt Schaubroeck | M | Winnipeg | Student | 5502 | 3rd row 10 : 10 | SelkirkâInterlake | Patricia Cordner | F | Selkirk | Retired | 9506 | 2nd row 11 : 11 | Winnipeg Centre | Pat Martin | M | Winnipeg | Parliamentarian | 12285 | 1st row 12 : 12 | Winnipeg North | Judy Wasylycia-Leis | F | Winnipeg | Parliamentarian | 14097 | 1st row 13 : 13 | Winnipeg South | Sean Robert | M | Winnipeg | Product Consultant - MLCC | 4673 | 3rd row 14 : 14 | Winnipeg South Centre | Rachel Heinrichs | F | Winnipeg | Student | 5490 | 3rd
col : Gender | Residence | Player_name | Occupation | Player_ID | Votes | Rank row 1 : F | Selkirk | Patricia Cordner | Retired | 10 | 9506 | 2nd row 2 : F | Thompson | Niki Ashton | Researcher | 3 | 8734 | 1st row 3 : F | Winnipeg | Fiona Shiells | Ministerial Assistant | 2 | 7190 | 3rd row 4 : F | Winnipeg | Judy Wasylycia-Leis | Parliamentarian | 12 | 14097 | 1st row 5 : F | Winnipeg | Rachel Heinrichs | Student | 14 | 5490 | 3rd row 6 : M | Birtle | Ron Strynadka | Retired | 4 | 4914 | 2nd row 7 : M | Brandon | Jean Luc Bouché | Locomotive Engineer | 1 | 6055 | 2nd row 8 : M | Oakbank | Ross C. Martin | Design Coordinator | 8 | 4947 | 2nd row 9 : M | Winnipeg | Jim Maloway | Small Businessman | 5 | 14355 | 1st row 10 : M | Winnipeg | Matt Schaubroeck | Student | 9 | 5502 | 3rd row 11 : M | Winnipeg | Mohamed Alli | Distribution Centre Associate | 7 | 2353 | 4th row 12 : M | Winnipeg | Pat Martin | Parliamentarian | 11 | 12285 | 1st row 13 : M | Winnipeg | Ross Eadie | Self Employed / Consultant | 6 | 12093 | 2nd row 14 : M | Winnipeg | Sean Robert | Product Consultant - MLCC | 13 | 4673 | 3rd