I'm currently using 1.12.3, but I've been upgrading the system for a long time, about 6 years or so.
I've searched a few fixes and tried without result for this error I keep getting on my email with no resolve.
Can someone give me a hand?
Thx

[SELECT COUNT(DISTINCT CASE WHEN THEN A1.ticket_id END) AS q15, COUNT(DISTINCT CASE WHEN A2.state = 'open' THEN A1.ticket_id END) AS q1, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND A2.state = 'open' AND A1.isanswered = '0' THEN A1.ticket_id END) AS q2, COUNT(DISTINCT CASE WHEN (A1.team_id IN (1, 2, 3, 5, 6, 7, 8, 9) OR A1.staff_id IN (13)) AND A2.state = 'open' AND (A1.team_id IN (1, 2, 3, 5, 6, 7, 8, 9) OR A1.staff_id IN (13)) AND A2.state = 'open' AND A1.staff_id IN (13) THEN A1.ticket_id END) AS q6, COUNT(DISTINCT CASE WHEN A2.state = 'closed' AND A2.state = 'closed' AND A1.closed BETWEEN '2020-01-15 01:00:00' AND '2020-01-16 00:59:59' THEN A1.ticket_id END) AS q9, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND A2.state = 'open' AND A1.isanswered = '1' THEN A1.ticket_id END) AS q3, COUNT(DISTINCT CASE WHEN (A1.team_id IN (1, 2, 3, 5, 6, 7, 8, 9) OR A1.staff_id IN (13)) AND A2.state = 'open' AND (A1.team_id IN (1, 2, 3, 5, 6, 7, 8, 9) OR A1.staff_id IN (13)) AND A2.state = 'open' AND NOT A1.staff_id IN (13) THEN A1.ticket_id END) AS q7, COUNT(DISTINCT CASE WHEN A2.state = 'closed' AND A2.state = 'closed' AND A1.closed BETWEEN '2020-01-14 01:00:00' AND '2020-01-15 00:59:59' THEN A1.ticket_id END) AS q10, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND A2.state = 'open' AND A1.isoverdue = '1' THEN A1.ticket_id END) AS q4, COUNT(DISTINCT CASE WHEN (A1.team_id IN (1, 2, 3, 5, 6, 7, 8, 9) OR A1.staff_id IN (13)) AND A2.state = 'open' THEN A1.ticket_id END) AS q5, COUNT(DISTINCT CASE WHEN A2.state = 'closed' AND A2.state = 'closed' AND A1.closed BETWEEN '2020-01-13 01:00:00' AND '2020-01-20 00:59:59' THEN A1.ticket_id END) AS q11, COUNT(DISTINCT CASE WHEN A2.state = 'closed' THEN A1.ticket_id END) AS q8, COUNT(DISTINCT CASE WHEN A2.state = 'closed' AND A2.state = 'closed' AND A1.closed BETWEEN '2020-01-01 01:00:00' AND '2020-02-01 00:59:59' THEN A1.ticket_id END) AS q12, COUNT(DISTINCT CASE WHEN A2.state = 'closed' AND A2.state = 'closed' AND A1.closed BETWEEN '2020-01-01 01:00:00' AND '2020-04-01 01:59:59' 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 01:00:00' AND '2021-01-01 00:59:59' 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_team A6 ON (A4.object_type = 'E' AND A4.object_id = A6.team_id) LEFT JOIN ost_department A7 ON (A4.object_type = 'D' AND A4.object_id = A7.id) WHERE (A2.state = 'open' AND (A1.staff_id = 13 OR A5.staff_id = 13 OR A1.team_id IN (1, 2, 3, 5, 6, 7, 8, 9) OR A6.team_id IN (1, 2, 3, 5, 6, 7, 8, 9))) OR (A2.state IN ('open', 'closed') AND (A1.dept_id IN (14, 7, 8, 6, 5, 9, 10, 11, 13) OR A7.id IN (14, 7, 8, 6, 5, 9, 10, 11, 13)))]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'THEN A1.ticket_id END) AS q15, COUNT(DISTINCT CASE WHEN A2.state = 'open' ' at line 1 
 
---- Backtrace ---- 
#0 (raiz)/include/mysqli.php(199): osTicket->logDBError('DB Error #1064', '[SELECT COUNT(D...') 
#1 (raiz)/include/class.orm.php(3455): db_query('SELECT COUNT(DI...', true, true) 
#2 (raiz)/include/class.orm.php(3502): MySqlExecutor->execute() 
#3 (raiz)/include/class.orm.php(2085): MySqlExecutor->getArray() 
#4 (raiz)/include/class.orm.php(2035): HashArrayIterator->{closure}() 
#5 (raiz)/include/class.orm.php(2014): CallbackSimpleIterator->next() 
#6 (raiz)/include/class.orm.php(2023): CallbackSimpleIterator->rewind() 
#7 (raiz)/include/class.orm.php(1695): CallbackSimpleIterator->valid() 
#8 (raiz)/include/class.orm.php(1705): CachedResultSet->fillTo(9223372036854775807) 
#9 (raiz)/include/class.orm.php(1328): CachedResultSet->asArray() 
#10 (raiz)/include/class.orm.php(1351): QuerySet->all() 
#11 (raiz)/include/class.search.php(925): QuerySet->one() 
#12 (raiz)/include/ajax.search.php(397): SavedQueue::counts(Object(StaffSession), true, Array) 
#13 (raiz)/include/class.dispatcher.php(145): SearchAjaxAPI->collectQueueCounts() 
#14 (raiz)/include/class.dispatcher.php(38): UrlMatcher->dispatch('counts', Array) 
#15 (raiz)/include/class.dispatcher.php(120): Dispatcher->resolve('counts', Array) 
#16 (raiz)/include/class.dispatcher.php(38): UrlMatcher->dispatch('/queue/counts', NULL) 
#17 (raiz)/scp/ajax.php(289): Dispatcher->resolve('/queue/counts') 
#18 {main}