SELECT Residence, Gender, Occupation, Player_ID, Player_name FROM player WHERE Rank != "1st" OR "Votes" <= 4914 AND "Player_ID" <= 7 OR Sponsor_name = "Kildonan—St. Paul" AND Gender = "F" AND Residence = "Winnipeg" AND Player_name != "Pat Martin" OR Occupation = "Self Employed / Consultant" INTERSECT SELECT Residence, Gender, Occupation, Player_ID, Player_name FROM player WHERE Rank = "1st" OR Occupation != "Small Businessman" AND Gender != "M" AND Player_name != "Mohamed Alli" OR "Player_ID" <= 7 OR "Votes" < 4947 AND Sponsor_name = "Elmwood—Transcona" AND Residence = "Winnipeg" <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 : Residence | Gender | Occupation | Player_ID | Player_name row 1 : Birtle | M | Retired | 4 | Ron Strynadka row 2 : Brandon | M | Locomotive Engineer | 1 | Jean Luc Bouché row 3 : Selkirk | F | Retired | 10 | Patricia Cordner row 4 : Winnipeg | F | Ministerial Assistant | 2 | Fiona Shiells row 5 : Winnipeg | F | Student | 14 | Rachel Heinrichs row 6 : Winnipeg | M | Distribution Centre Associate | 7 | Mohamed Alli row 7 : Winnipeg | M | Self Employed / Consultant | 6 | Ross Eadie