thing.sql

    SELECT
      (
        SELECT 
          COUNT(*)
        FROM entry_votes
        LEFT OUTER JOIN users as guessed_user ON lower(guessed_user.username) = lower(entry_votes.guess)
        LEFT OUTER JOIN compo_entries ON compo_entries.id = entry_votes.entry_id
        WHERE 
          entry_votes.user_id = users.id AND
          guessed_user.id = compo_entries.user_id AND
          compo_entries.compo_id = $1
      ) as "count",

      ARRAY(
        SELECT 
          guessed_user.username
        FROM entry_votes
        LEFT OUTER JOIN users as guessed_user ON lower(guessed_user.username) = lower(entry_votes.guess)
        LEFT OUTER JOIN compo_entries ON compo_entries.id = entry_votes.entry_id
        WHERE 
          entry_votes.user_id = users.id AND
          guessed_user.id = compo_entries.user_id AND
          compo_entries.compo_id = $1
      ) as usernames,

      users.username 
    FROM u