Most votes (sub-queries maybe?)
Well I need help with this one...
I want to select the members ID with the most votes.
`ID` mediumint(8)`MEM_ID` is the members ID who is voting
`MEM_ID ` mediumint(8)
`galaxy ` tinyint(3)
`planet` enum('1', '2' ... '20')
`vote_for` is who the above member is voting for
I want to select the members IDs (vote_for) with the most votes in a specific galaxy and planet - galaxy and planet are supplied by me.
If you need anymore information just ask.