I was editing the email templates and now I continuously get emails with DB Error #1054

-----Original Message-----
From: ICT Support <ictsupport@cobh.org.au>
Sent: Monday, 20 April 2020 10:47 AM
To: ICT Support <ictsupport@cobh.org.au>
Subject: DB Error #1054

[SELECT COUNT(DISTINCT CASE WHEN A2.state = 'closed' AND A2.state = 'closed' AND A1.topic_id = 13 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q27, COUNT(DISTINCT CASE WHEN A2.state = 'closed' AND A2.state = 'closed' AND NOT A1.topic_id = 13 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q28, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND A2.state = 'open' AND A1.dept_id = 2 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q38, COUNT(DISTINCT CASE WHEN A1.ticket_id = Z1.ticket_id THEN A1.ticket_id END) AS q67, 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 NOT A1.closed IS NOT NULL AND A3.object_type = 'T' THEN A1.ticket_id END) AS q2, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND A2.state = 'open' AND A1.topic_id = 13 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q29, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND A2.state = 'open' AND A1.topic_id = 18 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q34, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND A2.state = 'open' AND NOT A1.topic_id = 13 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q30, 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 q43, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND A2.state = 'open' AND A1.topic_id = 19 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q44, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND A2.state = 'open' AND A1.topic_id = 12 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q33, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND A2.state = 'open' AND A1.team_id IN (3, 2) AND A3.object_type = 'T' THEN A1.ticket_id END) AS q31, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND A2.state = 'open' AND A1.topic_id = 21 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q3, COUNT(DISTINCT CASE WHEN A1.staff_id IN (4) AND A2.state = 'open' AND A3.object_type = 'T' THEN A1.ticket_id END) AS q5, COUNT(DISTINCT CASE WHEN A1.staff_id IN (4) AND A2.state = 'open' AND A1.staff_id IN (4) AND A2.state = 'open' AND A1.topic_id = 16 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q53, COUNT(DISTINCT CASE WHEN A1.staff_id IN (4) AND A2.state = 'open' AND A1.staff_id IN (4) AND A2.state = 'open' AND A1.topic_id = 13 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q54, COUNT(DISTINCT CASE WHEN A1.staff_id IN (4) AND A2.state = 'open' AND A1.staff_id IN (4) AND A2.state = 'open' AND A1.topic_id = 12 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q55, COUNT(DISTINCT CASE WHEN A1.staff_id IN (4) AND A2.state = 'open' AND A1.staff_id IN (4) AND A2.state = 'open' AND A1.topic_id = 18 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q56, COUNT(DISTINCT CASE WHEN A1.staff_id IN (4) AND A2.state = 'open' AND A1.staff_id IN (4) AND A2.state = 'open' AND A1.topic_id IN (20, 19) AND A3.object_type = 'T' THEN A1.ticket_id END) AS q57, COUNT(DISTINCT CASE WHEN A1.staff_id IN (4) AND A2.state = 'open' AND A1.staff_id IN (4) AND A2.state = 'open' AND A1.dept_id = 2 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q59, COUNT(DISTINCT CASE WHEN A1.staff_id IN (4) AND A2.state = 'open' AND A1.staff_id IN (4) AND A2.state = 'open' AND A1.topic_id = 21 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q60, COUNT(DISTINCT CASE WHEN A1.staff_id IN (4) AND A2.state = 'open' AND A1.staff_id IN (4) AND A2.state = 'open' AND A1.staff_id IN (4) AND A3.object_type = 'T' THEN A1.ticket_id END) AS q6, 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.topic_id = 12 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q61, COUNT(DISTINCT CASE WHEN A2.state = 'closed' AND A2.state = 'closed' AND A1.topic_id = 18 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q62, COUNT(DISTINCT CASE WHEN A2.state = 'closed' AND A2.state = 'closed' AND A1.closed BETWEEN '2020-04-20 00:00:00' AND '2020-04-20 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-04-19 00:00:00' AND '2020-04-19 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-04-20 00:00:00' AND '2020-04-26 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-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, COUNT(DISTINCT CASE WHEN NOT A1.team_id IN (3) AND A3.object_type = 'T' THEN A1.ticket_id END) AS q7, COUNT(DISTINCT CASE WHEN NOT A1.team_id IN (3) AND NOT A1.team_id IN (3) AND A2.id IN (1, 6, 7, 8, 3) AND A1.created BETWEEN '2020-04-20 00:00:00' AND '2020-04-20 23:59:59' AND A3.object_type = 'T' THEN A1.ticket_id END) AS q4, COUNT(DISTINCT CASE WHEN NOT A1.team_id IN (3) AND NOT A1.team_id IN (3) AND A1.closed BETWEEN '2020-04-20 00:00:00' AND '2020-04-20 23:59:59' AND A3.object_type = 'T' THEN A1.ticket_id END) AS q65, COUNT(DISTINCT CASE WHEN NOT A1.team_id IN (3) AND NOT A1.team_id IN (3) AND A1.topic_id IN (12, 21, 20, 19, 13, 16, 18) AND A3.object_type = 'T' THEN A1.ticket_id END) AS q64, COUNT(DISTINCT CASE WHEN NOT A1.team_id IN (3) AND NOT A1.team_id IN (3) AND A1.topic_id IN (12, 20, 19, 16, 18) AND A3.object_type = 'T' THEN A1.ticket_id END) AS q63, COUNT(DISTINCT CASE WHEN NOT A1.team_id IN (3) AND NOT A1.team_id IN (3) 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 q66 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_department B0 ON (A4.object_type = 'D' AND A4.object_id = B0.id) LEFT JOIN ost_department B1 ON (A7.object_type = 'D' AND A7.object_id = B1.id) WHERE ((A2.state = 'open' AND (A1.staff_id = 4 OR A5.staff_id = 4 OR A6.object_type = 'C' AND A8.staff_id = 4)) OR (A2.state IN ('open', 'closed') AND (A1.dept_id IN (1, 2) OR B0.id IN (1, 2))) OR A6.object_type = 'C' AND B1.id IN (1, 2))]

Unknown column 'Z1.ticket_id' in 'field list' 
---- Backtrace ---- 
#0 C:\inetpub\wwwroot\osTicket\include\mysqli.php(200): osTicket->logDBError('DB Error #1054', '[SELECT COUNT(D...') 
#1 C:\inetpub\wwwroot\osTicket\include\class.orm.php(3459): db_query('SELECT COUNT(DI...', true, true) 
#2 C:\inetpub\wwwroot\osTicket\include\class.orm.php(3506): MySqlExecutor->execute() 
#3 C:\inetpub\wwwroot\osTicket\include\class.orm.php(2093): MySqlExecutor->getArray() 
#4 C:\inetpub\wwwroot\osTicket\include\class.orm.php(2043): HashArrayIterator->{closure}() 
#5 C:\inetpub\wwwroot\osTicket\include\class.orm.php(2022): CallbackSimpleIterator->next() 
#6 C:\inetpub\wwwroot\osTicket\include\class.orm.php(2031): CallbackSimpleIterator->rewind() 
#7 C:\inetpub\wwwroot\osTicket\include\class.orm.php(1703): CallbackSimpleIterator->valid() 
#8 C:\inetpub\wwwroot\osTicket\include\class.orm.php(1713): CachedResultSet->fillTo(2147483647) 
#9 C:\inetpub\wwwroot\osTicket\include\class.orm.php(1336): CachedResultSet->asArray() 
#10 C:\inetpub\wwwroot\osTicket\include\class.orm.php(1359): QuerySet->all() 
#11 C:\inetpub\wwwroot\osTicket\include\class.search.php(973): QuerySet->one() 
#12 C:\inetpub\wwwroot\osTicket\include\ajax.search.php(397): SavedQueue::counts(Object(StaffSession), true, Array) 
#13 C:\inetpub\wwwroot\osTicket\include\class.dispatcher.php(145): SearchAjaxAPI->collectQueueCounts() 
#14 C:\inetpub\wwwroot\osTicket\include\class.dispatcher.php(38): UrlMatcher->dispatch('counts', Array) 
#15 C:\inetpub\wwwroot\osTicket\include\class.dispatcher.php(120): Dispatcher->resolve('counts', Array) 
#16 C:\inetpub\wwwroot\osTicket\include\class.dispatcher.php(38): UrlMatcher->dispatch('/queue/counts', NULL) 
#17 C:\inetpub\wwwroot\osTicket\scp\ajax.php(308): Dispatcher->resolve('/queue/counts') 
#18 {main}

helpdesk.cobh.org.au/osticket

Not sure what is creating the error.
thanks
Roger