{13} Votes

UndefinedColumn: column "resource" does not exist
LINE 11:   join (select resource, sum(vote) as votes from votes group...
                        ^
HINT:  Perhaps you meant to reference the column "votes.resource_id".

SELECT COUNT(*) FROM (
SELECT p.value AS __color__,
   id AS ticket, summary, component, version, milestone, t.type AS type, 
   owner, status,
   votes,
   changetime AS _changetime,
   description AS _description,
   reporter AS _reporter
  FROM ticket t
  LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority'
  join (select resource, sum(vote) as votes from votes group by resource) as v
     ON (v.resource = 'ticket/'||t.id)
  WHERE status <> 'closed'
  ORDER BY votes DESC, p.value, time

) AS tab