{122} Active Tickets ohne Verantwortlichen - gruppiert nach Meilenstein

OperationalError: ambiguous column name: description

SELECT COUNT(*) FROM (

SELECT __color__, __group__, __style__,  ticket, summary, component, type,
  priority, severity, __milestone__, status, 
  _ord, __prio__, __severity__

FROM (
SELECT p.value AS __color__,
       t.milestone AS __group__,
       '' as __style__,
       t.id AS ticket, summary AS summary,             -- ## Break line here
       t.type as type,
       component,priority, severity, milestone as __milestone__, status, owner,
       p.value as __prio__,
       s.value as __severity__,
       CASE WHEN EstimatedHours.value = '' OR EstimatedHours.value IS NULL THEN 0
         ELSE CAST( EstimatedHours.value AS DECIMAL ) END as Estimated_work,
       CASE WHEN totalhours.value = '' OR totalhours.value IS NULL THEN 0
         ELSE CAST( totalhours.value AS DECIMAL ) END as Total_work,
       time AS created, changetime AS modified,         -- ## Dates are formatted
       description AS _description_,                    -- ## Uses a full row
       changetime AS _changetime,
       reporter AS _reporter, 
       0 as _ord -- als Sortiermerkmal der beiden Selects im union (Daten vor Summe)

  FROM ticket as t
  LEFT JOIN enum as p ON p.name=t.priority AND p.type='priority'
  LEFT JOIN enum as s ON s.name=t.severity AND s.type='severity'

LEFT JOIN ticket_custom as EstimatedHours ON EstimatedHours.name='estimatedhours'
      AND EstimatedHours.Ticket = t.Id
LEFT JOIN ticket_custom as totalhours ON totalhours.name='totalhours'
      AND totalhours.Ticket = t.Id

  WHERE t.status <> 'closed'

)  as tbl

ORDER BY __milestone__, _ord ASC, __prio__, __severity__, ticket


) AS tab