[SELECT COUNT(DISTINCT CASE WHEN (A1.team_id IN (0, 3) OR A1.staff_id IN (1)) AND A2.state = 'open' AND A1.staff_id IN (1) AND (A1.team_id IN (0, 3) OR A1.staff_id IN (1)) AND A2.state = 'open' AND A1.staff_id IN (1) AND A2.id IN (1) AND A2.state = 'open' AND A1.staff_id IN (1) AND A1.created IS NOT NULL AND A1.est_duedate IS NOT NULL AND A1.ticket_id = Z1.ticket_id AND A3.object_type = 'T' THEN A1.ticket_id END) AS q15, 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 A3.object_type = 'T' THEN A1.ticket_id END) AS q2, COUNT(DISTINCT CASE WHEN (A1.team_id IN (0, 3) OR A1.staff_id IN (1)) AND A2.state = 'open' AND (A1.team_id IN (0, 3) 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 A2.state = 'closed' AND A2.state = 'closed' AND A1.closed BETWEEN '2020-04-08 00:00:00' AND '2020-04-08 23:59:59' AND A3.object_type = 'T' THEN A1.ticket_id END) AS q9, 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 (A1.team_id IN (0, 3) OR A1.staff_id IN (1)) AND A2.state = 'open' AND (A1.team_id IN (0, 3) 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 A2.state = 'closed' AND A1.closed BETWEEN '2020-04-07 00:00:00' AND '2020-04-07 23:59:59' AND A3.object_type = 'T' THEN A1.ticket_id END) AS q10, 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 (A1.team_id IN (0, 3) 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 A2.state = 'closed' AND A2.state = 'closed' AND A1.closed BETWEEN '2020-04-06 00:00:00' AND '2020-04-12 23:59:59' AND A3.object_type = 'T' THEN A1.ticket_id END) AS q11, 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-04-01 00:00:00' AND '2020-04-30 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-04-01 00:00:00' AND '2020-06-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) 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 (3) OR B0.team_id IN (3) OR A6.object_type = 'C' AND B1.team_id IN (3))) OR (A2.state IN ('open', 'closed') AND (A1.dept_id IN (1, 3) OR B2.id IN (1, 3))) OR A6.object_type = 'C' AND B3.id IN (1, 3))] Unknown column 'Z1.ticket_id' in 'field list'
---- Backtrace ----
#0 C:\inetpub\wwwroot\helpdesk\include\mysqli.php(200): osTicket->logDBError('DB Error #1054', '[SELECT COUNT(D...')
#1 C:\inetpub\wwwroot\helpdesk\include\class.orm.php(3459): db_query('SELECT COUNT(DI...', true, true)
#2 C:\inetpub\wwwroot\helpdesk\include\class.orm.php(3506): MySqlExecutor->execute()
#3 C:\inetpub\wwwroot\helpdesk\include\class.orm.php(2093): MySqlExecutor->getArray()
#4 C:\inetpub\wwwroot\helpdesk\include\class.orm.php(2043): HashArrayIterator->{closure}()
#5 C:\inetpub\wwwroot\helpdesk\include\class.orm.php(2022): CallbackSimpleIterator->next()
#6 C:\inetpub\wwwroot\helpdesk\include\class.orm.php(2031): CallbackSimpleIterator->rewind()
#7 C:\inetpub\wwwroot\helpdesk\include\class.orm.php(1703): CallbackSimpleIterator->valid()
#8 C:\inetpub\wwwroot\helpdesk\include\class.orm.php(1713): CachedResultSet->fillTo(2147483647)
#9 C:\inetpub\wwwroot\helpdesk\include\class.orm.php(1336): CachedResultSet->asArray()
#10 C:\inetpub\wwwroot\helpdesk\include\class.orm.php(1359): QuerySet->all()
#11 C:\inetpub\wwwroot\helpdesk\include\class.search.php(973): QuerySet->one()
#12 C:\inetpub\wwwroot\helpdesk\include\class.search.php(905): SavedQueue::counts(Object(StaffSession), true)
#13 C:\inetpub\wwwroot\helpdesk\include\staff\templates\queue-tickets.tmpl.php(111): SavedQueue->getCount(Object(StaffSession))
#14 C:\inetpub\wwwroot\helpdesk\scp\tickets.php(539): require_once('C:\inetpub\wwwr...')
#15 C:\inetpub\wwwroot\helpdesk\scp\index.php(17): require('C:\inetpub\wwwr...')
#16 {main}
