I don't think he wants a RIGHT JOIN there.
I think just an INNER JOIN.
If you look at his while loop on the votingsite records, the only thing he does with it is get and ID to be used in the inside while loop. So he doesn't really care about any values from the votingsite table.
An optimist sees the glass as half full.
A pessimist sees the glass as half empty.
A realist drinks it no matter how much there is.