SQL query failing as no priority column in ost_ticket__cdata

npchoubey

This query to display open tickets is failing as it tries to link priority in ost_ticket__cdata to priority_id in priority table

LEFT JOIN ost_ticket__cdata B2 ON (A1.ticket_id = B2.ticket_id) LEFT JOIN ost_ticket_priority B3 ON (B2.priority = B3.priority_id) LEFT JOIN

what is wrong with my setup?

ntozier

Is this a query you are trying to write yourself?

It looks like a lot of the query is missing.