SELECT *
FROM
  ( SELECT *
   FROM tableone
   ORDER BY post_id DESC) AS tableone
WHERE
    ( SELECT count(*)
     FROM tabletwo
     WHERE tableone.user_id = tabletwo.user_id
       AND tokens > 0) >=1
  AND
    ( SELECT count(*)
     FROM tablethree
     WHERE tablethree.voted_post_id = tableone.post_id
       AND user_id =1234) <1
  AND user_id !=1234
GROUP BY user_id