ok, add the joins back in and see it break. wtf
these are the droids you're looking for. this query returns the correct ordering for the front page. sort by supporters, then actualizers