SELECT i.inviteId, i.name, i.emailAddress, i.reasonForAcceptance, SUM( v.score ) AS voteScore, i.invitedByUserId, u.username AS invitedByUsername, u.name AS invitedByName
FROM Invites i, Users u
LEFT JOIN InviteVotes v ON v.inviteId = i.inviteId
WHERE u.userId = i.invitedByUserId
AND (
i.invitedTime <1154742569
OR (
SELECT SUM( score )
FROM InviteVotes
WHERE InviteVotes.inviteId = i.inviteId
) >=3
OR (
SELECT SUM( score )
FROM InviteVotes
WHERE InviteVotes.inviteId = i.inviteId
) <= -10
)
GROUP BY i.inviteId
ORDER BY i.inviteId
LIMIT 0 , 30