We have been getting the following two errors on repeat, we had over 22 of them come in, within 1 minute.

[SELECT COUNT(*) FROM (SELECT A1.ticket_id FROM Support_ticket A1 JOIN Support_ticket_status A2 ON (A1.status_id = A2.id) WHERE A1.staff_id IN (20) AND A2.state = 'open' AND A1.staff_id IN (20) AND A2.state = 'open' AND ) __]

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 ') __' at line 1 
---- Backtrace ---- 
#0 (root)/include/mysqli.php(199): osTicket->logDBError('DB Error #1064', '[SELECT COUNT(...') 
#1 (root)/include/class.orm.php(3455): db_query('SELECT COUNT()...', true, true) 
#2 (root)/include/class.orm.php(3511): MySqlExecutor->execute() 
#3 (root)/include/class.orm.php(2941): MySqlExecutor->getRow() 
#4 (root)/include/class.orm.php(1372): MySqlCompiler->compileCount(Object(QuerySet)) 
#5 (root)/include/class.search.php(857): QuerySet->count() 
#6 (root)/include/class.search.php(928): SavedQueue->getTotal() 
#7 (root)/include/class.search.php(865): SavedQueue::counts(Object(StaffSession), true) 
#8 (root)/include/staff/templates/queue-tickets.tmpl.php(96): SavedQueue->getCount(Object(StaffSession)) 
#9 (root)/scp/tickets.php(526): require_once('/home/infrasupp...') 
#10 (root)/scp/index.php(17): require('/home/infrasupp...') 
#11 {main}

[SELECT COUNT(DISTINCT CASE WHEN A2.state = 'open' AND A2.state = 'open' AND A1.isanswered = '0' THEN A1.ticket_id END) AS q45, COUNT(DISTINCT CASE WHEN A1.staff_id IN (20) AND A2.state = 'open' AND A1.staff_id IN (20) AND A2.state = 'open' AND A2.state = 'open' AND A1.staff_id IN (20) THEN A1.ticket_id END) AS q43, COUNT(DISTINCT CASE WHEN A1.staff_id IN (20) AND A2.state = 'open' AND A1.staff_id IN (20) AND A2.state = 'open' AND THEN A1.ticket_id END) AS q54, 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.team_id = 0 AND A1.staff_id = 0 THEN A1.ticket_id END) AS q2, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND A2.state = 'open' AND A2.id IN (13, 8) THEN A1.ticket_id END) AS q33, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND A2.state = 'open' AND A2.id IN (14) THEN A1.ticket_id END) AS q32, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND A2.state = 'open' AND A2.id IN (6) THEN A1.ticket_id END) AS q34, 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.staff_id IN (20) AND A2.state = 'open' THEN A1.ticket_id END) AS q5, 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 '2019-05-20 00:00:00' AND '2019-05-20 23:59:59' THEN A1.ticket_id END) AS q9, COUNT(DISTINCT CASE WHEN A2.state = 'closed' AND A2.state = 'closed' AND A1.closed BETWEEN '2019-05-19 00:00:00' AND '2019-05-19 23:59:59' THEN A1.ticket_id END) AS q10, COUNT(DISTINCT CASE WHEN A2.state = 'closed' AND A2.state = 'closed' AND A1.closed BETWEEN '2019-05-20 00:00:00' AND '2019-05-26 23:59:59' THEN A1.ticket_id END) AS q11, COUNT(DISTINCT CASE WHEN A2.state = 'closed' AND A2.state = 'closed' AND A1.closed BETWEEN '2019-05-01 00:00:00' AND '2019-05-31 23:59:59' THEN A1.ticket_id END) AS q12, COUNT(DISTINCT CASE WHEN A2.state = 'closed' AND A2.state = 'closed' AND A1.closed BETWEEN '2019-04-01 00:00:00' AND '2019-06-30 23:59:59' THEN A1.ticket_id END) AS q13, COUNT(DISTINCT CASE WHEN A2.state = 'closed' AND A2.state = 'closed' AND A1.closed BETWEEN '2019-01-01 00:00:00' AND '2019-12-31 23:59:59' THEN A1.ticket_id END) AS q14 FROM Support_ticket A1 JOIN Support_ticket_status A2 ON (A1.status_id = A2.id) LEFT JOIN Support_thread A3 ON (A3.object_type = 'T' AND A1.ticket_id = A3.object_id) LEFT JOIN Support_thread_referral A4 ON (A3.id = A4.thread_id) LEFT JOIN Support_staff A5 ON (A4.object_type = 'S' AND A4.object_id = A5.staff_id) LEFT JOIN Support_department A6 ON (A4.object_type = 'D' AND A4.object_id = A6.id) WHERE (A2.state = 'open' AND (A1.staff_id = 20 OR A5.staff_id = 20)) OR A1.dept_id IN (7, 12) OR A6.id IN (7, 12)]

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 q54, COUNT(DISTINCT CASE WHEN A2.state = 'open' ' at line 1 
---- Backtrace ---- 
#0 (root)/include/mysqli.php(199): osTicket->logDBError('DB Error #1064', '[SELECT COUNT(D...') 
#1 (root)/include/class.orm.php(3455): db_query('SELECT COUNT(DI...', true, true) 
#2 (root)/include/class.orm.php(3502): MySqlExecutor->execute() 
#3 (root)/include/class.orm.php(2085): MySqlExecutor->getArray() 
#4 (root)/include/class.orm.php(2035): HashArrayIterator->{closure}() 
#5 (root)/include/class.orm.php(2014): CallbackSimpleIterator->next() 
#6 (root)/include/class.orm.php(2023): CallbackSimpleIterator->rewind() 
#7 (root)/include/class.orm.php(1695): CallbackSimpleIterator->valid() 
#8 (root)/include/class.orm.php(1705): CachedResultSet->fillTo(9223372036854775807) 
#9 (root)/include/class.orm.php(1328): CachedResultSet->asArray() 
#10 (root)/include/class.orm.php(1351): QuerySet->all() 
#11 (root)/include/class.search.php(925): QuerySet->one() 
#12 (root)/scp/autocron.php(51): SavedQueue::counts(Object(StaffSession), false) 
#13 {main}