Hello,
I have this problem that always comes up:

[SELECT COUNT(DISTINCT CASE WHEN A1.sourceREGEXP '\"?Email(\"|,|$)' AND A1.ticket_id= Z1.ticket_idTHEN A1.ticket_idEND) ASq15, COUNT(DISTINCT CASE WHEN A1.sourceREGEXP '\"?Email(\"|,|$)' AND A1.ticket_id= Z1.ticket_idTHEN A1.ticket_idEND) ASq16, COUNT(DISTINCT CASE WHEN A2.state= 'open' AND A2.state= 'open' AND A2.state= 'open' THEN A1.ticket_idEND) ASq17, COUNT(DISTINCT CASE WHEN A2.state= 'open' THEN A1.ticket_idEND) ASq1, COUNT(DISTINCT CASE WHEN A2.state= 'open' AND A2.state= 'open' AND A1.isanswered= '0' THEN A1.ticket_idEND) ASq2, COUNT(DISTINCT CASE WHEN (A1.team_idIN (1) OR A1.staff_idIN (1)) AND A2.state= 'open' AND (A1.team_idIN (1) OR A1.staff_idIN (1)) AND A2.state= 'open' AND A1.staff_idIN (1) THEN A1.ticket_idEND) ASq6, COUNT(DISTINCT CASE WHEN A2.state= 'closed' AND A2.state= 'closed' AND A1.closedBETWEEN '2019-09-14 00:00:00' AND '2019-09-14 23:59:59' THEN A1.ticket_idEND) ASq9, COUNT(DISTINCT CASE WHEN A2.state= 'open' AND A2.state= 'open' AND A1.isanswered= '1' THEN A1.ticket_idEND) ASq3, COUNT(DISTINCT CASE WHEN (A1.team_idIN (1) OR A1.staff_idIN (1)) AND A2.state= 'open' AND (A1.team_idIN (1) OR A1.staff_idIN (1)) AND A2.state= 'open' AND NOT A1.staff_idIN (1) THEN A1.ticket_idEND) ASq7, COUNT(DISTINCT CASE WHEN A2.state= 'closed' AND A2.state= 'closed' AND A1.closedBETWEEN '2019-09-13 00:00:00' AND '2019-09-13 23:59:59' THEN A1.ticket_idEND) ASq10, COUNT(DISTINCT CASE WHEN A2.state= 'open' AND A2.state= 'open' AND A1.isoverdue= '1' THEN A1.ticket_idEND) ASq4, COUNT(DISTINCT CASE WHEN (A1.team_idIN (1) OR A1.staff_idIN (1)) AND A2.state= 'open' THEN A1.ticket_idEND) ASq5, COUNT(DISTINCT CASE WHEN A2.state= 'closed' AND A2.state= 'closed' AND A1.closedBETWEEN '2019-09-09 00:00:00' AND '2019-09-15 23:59:59' THEN A1.ticket_idEND) ASq11, COUNT(DISTINCT CASE WHEN A2.state= 'closed' THEN A1.ticket_idEND) ASq8, COUNT(DISTINCT CASE WHEN A2.state= 'closed' AND A2.state= 'closed' AND A1.closedBETWEEN '2019-09-01 00:00:00' AND '2019-09-30 23:59:59' THEN A1.ticket_idEND) ASq12, COUNT(DISTINCT CASE WHEN A2.state= 'closed' AND A2.state= 'closed' AND A1.closedBETWEEN '2019-07-01 00:00:00' AND '2019-09-30 23:59:59' THEN A1.ticket_idEND) ASq13, COUNT(DISTINCT CASE WHEN A2.state= 'closed' AND A2.state= 'closed' AND A1.closedBETWEEN '2019-01-01 00:00:00' AND '2019-12-31 23:59:59' THEN A1.ticket_idEND) ASq14FROMostql_ticketA1 JOINostql_ticket_statusA2 ON (A1.status_id= A2.id) LEFT JOINostql_threadA3 ON (A3.object_type= 'T' AND A1.ticket_id= A3.object_id) LEFT JOINostql_thread_referralA4 ON (A3.id= A4.thread_id) LEFT JOINostql_staffA5 ON (A4.object_type= 'S' AND A4.object_id= A5.staff_id) LEFT JOINostql_teamA6 ON (A4.object_type= 'E' AND A4.object_id= A6.team_id) LEFT JOINostql_departmentA7 ON (A4.object_type= 'D' AND A4.object_id= A7.id) WHERE (A2.state= 'open' AND (A1.staff_id= 1 OR A5.staff_id= 1 OR A1.team_idIN (1) OR A6.team_idIN (1))) OR (A2.stateIN ('open', 'closed') AND (A1.dept_idIN (1, 3, 4) OR A7.id` IN (1, 3, 4)))]

Unknown column 'Z1.ticket_id' in 'field list' 
 
---- Trace ---- 
#0 (racine)/include/mysqli.php(199): osTicket->logDBError('DB Error #1054', '[SELECT COUNT(D...') 
#1 (racine)/include/class.orm.php(3455): db_query('SELECT COUNT(DI...', true, true) 
#2 (racine)/include/class.orm.php(3502): MySqlExecutor->execute() 
#3 (racine)/include/class.orm.php(2085): MySqlExecutor->getArray() 
#4 (racine)/include/class.orm.php(2035): HashArrayIterator->{closure}() 
#5 (racine)/include/class.orm.php(2014): CallbackSimpleIterator->next() 
#6 (racine)/include/class.orm.php(2023): CallbackSimpleIterator->rewind() 
#7 (racine)/include/class.orm.php(1695): CallbackSimpleIterator->valid() 
#8 (racine)/include/class.orm.php(1705): CachedResultSet->fillTo(9223372036854775807) 
#9 (racine)/include/class.orm.php(1328): CachedResultSet->asArray() 
#10 (racine)/include/class.orm.php(1351): QuerySet->all() 
#11 (racine)/include/class.search.php(925): QuerySet->one() 
#12 (racine)/scp/autocron.php(51): SavedQueue::counts(Object(StaffSession), false) `

How can I fix this problem?

Thank's for your support,