DB Error #1054
[SELECT COUNT(DISTINCT CASE WHEN A1.ticket_id
= Z1.ticket_id
THEN A1.ticket_id
END) AS q15
, COUNT(DISTINCT CASE WHEN (A1.team_id
IN (1, 2) OR A1.staff_id
IN (1)) AND A2.state
= 'open' AND (A1.team_id
IN (1, 2) OR A1.staff_id
IN (1)) AND A2.state
= 'open' AND (A1.team_id
IN (1, 2) OR A1.staff_id
IN (1)) AND A2.state
= 'open' AND A1.isanswered
= '1' AND A3.object_type
= 'T' THEN A1.ticket_id
END) AS q17
, COUNT(DISTINCT CASE WHEN A2.state
= 'open' AND A2.state
= 'open' AND A1.topic_id
= 20 AND A3.object_type
= 'T' THEN A1.ticket_id
END) AS q32
, COUNT(DISTINCT CASE WHEN A2.state
= 'open' AND A3.object_type
= 'T' THEN A1.ticket_id
END) AS q1
, COUNT(DISTINCT CASE WHEN A2.state
= 'open' AND A2.state
= 'open' AND A1.isanswered
= '0' AND A1.team_id
= 0 AND A1.staff_id
= 0 AND NOT A2.id
IN (9, 11, 10) AND A3.object_type
= 'T' THEN A1.ticket_id
END) AS q2
, COUNT(DISTINCT CASE WHEN A2.state
= 'open' AND A2.state
= 'open' AND A2.id
IN (7) AND A3.object_type
= 'T' THEN A1.ticket_id
END) AS q16
, COUNT(DISTINCT CASE WHEN A2.state
= 'open' AND A2.state
= 'open' AND A1.isanswered
= '1' AND A3.object_type
= 'T' THEN A1.ticket_id
END) AS q3
, COUNT(DISTINCT CASE WHEN A2.state
= 'open' AND A2.state
= 'open' AND A1.isoverdue
= '1' AND A3.object_type
= 'T' THEN A1.ticket_id
END) AS q4
, COUNT(DISTINCT CASE WHEN B6.name
= 'Lexington' AND A2.state
= 'open' AND A3.object_type
= 'T' THEN A1.ticket_id
END) AS q19
, COUNT(DISTINCT CASE WHEN B6.name
= 'Lexington' AND A2.state
= 'open' AND B6.name
= 'Lexington' AND A2.state
= 'open' AND A2.id
IN (7) AND A3.object_type
= 'T' THEN A1.ticket_id
END) AS q21
, COUNT(DISTINCT CASE WHEN A2.id
IN (9, 11, 10) AND A3.object_type
= 'T' THEN A1.ticket_id
END) AS q26
, COUNT(DISTINCT CASE WHEN A2.id
IN (9, 11, 10) AND A2.id
IN (9, 11, 10) AND A2.id
IN (9, 11, 10) AND A2.state
= 'open' AND A1.team_id
= 0 AND A1.staff_id
= 0 AND A3.object_type
= 'T' THEN A1.ticket_id
END) AS q30
, COUNT(DISTINCT CASE WHEN A2.id
IN (9, 11, 10) AND A2.id
IN (9, 11, 10) AND A2.id
IN (10) AND A3.object_type
= 'T' THEN A1.ticket_id
END) AS q31
, COUNT(DISTINCT CASE WHEN A2.id
IN (9, 11, 10) AND A2.id
IN (9, 11, 10) AND A2.id
IN (11) AND A3.object_type
= 'T' THEN A1.ticket_id
END) AS q28
, COUNT(DISTINCT CASE WHEN (A1.team_id
IN (1, 2) OR A1.staff_id
IN (1)) AND A2.state
= 'open' AND A3.object_type
= 'T' THEN A1.ticket_id
END) AS q5
, COUNT(DISTINCT CASE WHEN (A1.team_id
IN (1, 2) OR A1.staff_id
IN (1)) AND A2.state
= 'open' AND (A1.team_id
IN (1, 2) OR A1.staff_id
IN (1)) AND A2.state
= 'open' AND A1.staff_id
IN (1) AND A3.object_type
= 'T' THEN A1.ticket_id
END) AS q6
, COUNT(DISTINCT CASE WHEN (A1.team_id
IN (1, 2) OR A1.staff_id
IN (1)) AND A2.state
= 'open' AND (A1.team_id
IN (1, 2) OR A1.staff_id
IN (1)) AND A2.state
= 'open' AND NOT A1.staff_id
IN (1) AND A3.object_type
= 'T' THEN A1.ticket_id
END) AS q7
, COUNT(DISTINCT CASE WHEN A2.state
= 'closed' AND A3.object_type
= 'T' THEN A1.ticket_id
END) AS q8
, COUNT(DISTINCT CASE WHEN A2.state
= 'closed' AND A2.state
= 'closed' AND A1.closed
BETWEEN '2020-07-01 00:00:00' AND '2020-07-01 23:59:59' AND A3.object_type
= 'T' THEN A1.ticket_id
END) AS q9
, COUNT(DISTINCT CASE WHEN A2.state
= 'closed' AND A2.state
= 'closed' AND A1.closed
BETWEEN '2020-06-30 00:00:00' AND '2020-06-30 23:59:59' AND A3.object_type
= 'T' THEN A1.ticket_id
END) AS q10
, COUNT(DISTINCT CASE WHEN A2.state
= 'closed' AND A2.state
= 'closed' AND A1.closed
BETWEEN '2020-06-29 00:00:00' AND '2020-07-05 23:59:59' AND A3.object_type
= 'T' THEN A1.ticket_id
END) AS q11
, COUNT(DISTINCT CASE WHEN A2.state
= 'closed' AND A2.state
= 'closed' AND A1.closed
BETWEEN '2020-07-01 00:00:00' AND '2020-07-31 23:59:59' AND A3.object_type
= 'T' THEN A1.ticket_id
END) AS q12
, COUNT(DISTINCT CASE WHEN A2.state
= 'closed' AND A2.state
= 'closed' AND A1.closed
BETWEEN '2020-07-01 00:00:00' AND '2020-09-30 23:59:59' AND A3.object_type
= 'T' THEN A1.ticket_id
END) AS q13
, COUNT(DISTINCT CASE WHEN A2.state
= 'closed' AND A2.state
= 'closed' AND A1.closed
BETWEEN '2020-01-01 00:00:00' AND '2020-12-31 23:59:59' AND A3.object_type
= 'T' THEN A1.ticket_id
END) AS q14
FROM ost_ticket
A1 JOIN ost_ticket_status
A2 ON (A1.status_id
= A2.id
) LEFT JOIN ost_thread
A3 ON (A3.object_type
= 'T' AND A1.ticket_id
= A3.object_id
) LEFT JOIN ost_thread_referral
A4 ON (A3.id
= A4.thread_id
) LEFT JOIN ost_staff
A5 ON (A4.object_type
= 'S' AND A4.object_id
= A5.staff_id
) LEFT JOIN ost_thread
A6 ON (A1.ticket_id
= A6.object_id
AND A6.object_type
= 'C') LEFT JOIN ost_thread_referral
A7 ON (A6.id
= A7.thread_id
) LEFT JOIN ost_staff
A8 ON (A7.object_type
= 'S' AND A7.object_id
= A8.staff_id
) LEFT JOIN ost_team
B0 ON (A4.object_type
= 'E' AND A4.object_id
= B0.team_id
) LEFT JOIN ost_team
B1 ON (A7.object_type
= 'E' AND A7.object_id
= B1.team_id
) LEFT JOIN ost_department
B2 ON (A4.object_type
= 'D' AND A4.object_id
= B2.id
) LEFT JOIN ost_department
B3 ON (A7.object_type
= 'D' AND A7.object_id
= B3.id
) JOIN ost_user
B4 ON (A1.user_id
= B4.id
) LEFT JOIN ost_organization
B5 ON (B4.org_id
= B5.id
) LEFT JOIN ost_organization__cdata
B6 ON (B5.id
= B6.org_id
) WHERE ((A2.state
= 'open' AND (A1.staff_id
= 1 OR A5.staff_id
= 1 OR A6.object_type
= 'C' AND A8.staff_id
= 1 OR A1.team_id
IN (1, 2) OR B0.team_id
IN (1, 2) OR A6.object_type
= 'C' AND B1.team_id
IN (1, 2))) OR (A2.state
IN ('open', 'closed') AND (A1.dept_id
IN (1, 4, 5) OR B2.id
IN (1, 4, 5))) OR A6.object_type
= 'C' AND B3.id
IN (1, 4, 5))] Unknown column 'Z1.ticket_id' in 'field list'