{90} report_title_90

ProgrammingError: (1146, "Table 'trac.budgeting' doesn't exist")

SELECT COUNT(*) FROM (
SELECT t.id, t.summary, t.milestone AS __group__, '../milestone/' || t.milestone AS __grouplink__, 
    t.owner, t.reporter, t.status, t.type, t.priority, t.component,
    count(b.ticket) AS Anz, sum(b.cost) AS Aufwand, sum(b.estimation) AS Schaetzung,
    floor(avg(b.status)) || '%' AS "Status", 
    (CASE t.status 
      WHEN 'closed' THEN 'color: #777; background: #ddd; border-color: #ccc;'
      ELSE 
        (CASE sum(b.cost) > sum(b.estimation) WHEN true THEN 'font-weight: bold; background: orange;' END)
    END) AS __style__
    from ticket t
    left join budgeting b ON b.ticket = t.id
    where t.milestone like 
    (CASE %s
              WHEN '' THEN '%' 
              ELSE %s END) and
    (t.component like (CASE %s
              WHEN '' THEN '%' 
              ELSE %s END) or t.component is null) and 
    (t.owner like (CASE %s
              WHEN '' THEN %s 
              ELSE %s END) or t.owner is null or 
     b.username like (CASE %s
              WHEN '' THEN %s 
              ELSE %s END) )
    group by t.id, t.type, t.priority, t.summary, t.owner, t.reporter, t.component, t.status, t.milestone
    having count(b.ticket) > 0
    order by t.milestone desc, t.status, t.id desc
) AS tab