t_id'. // gerald
'LEFT JOIN '.TICKET_TABLE.' open ON open.ticket_id=ticket.ticket_id AND open.status=\'open\' AND open.isanswered=0 ';
if(!$thisuser->isAdmin()) // gerald
$sql.='AND (open.staff_id=0 OR open.staff_id='.db_input($thisuser->getId()).' OR dept... .ticket_id=ticket.ticket_id AND answered.status=\'open\' AND answered.isanswered=1 '.
'LEFT JOIN '.... e.ticket_id=ticket.ticket_id AND overdue.status=\'open\' AND overdue.isoverdue=1 ';
if(!$thisuser->isAdm