Example query from older version, from /scp/tickets.php for "quick stats - submenus"/*quick stats...*/$sql='SELECT count(unclassified.ticket_id) as unclassified, count(ittix.ticket_id) as ittix, count(incident.ticket_id) as incident '. ',count(problem.ticket_id) as problem, count(request.ticket_id) as request, count(assigned.ticket_id) as assigned '. ' FROM '.TICKET_TABLE.' ticket '. 'LEFT JOIN '.TICKET_TABLE.' unclassified ON unclassified.ticket_id=ticket.ticket_id AND unclassified.status=\'Open\' AND unclassified.itil_id=1 '. 'LEFT JOIN '.TICKET_TABLE.' ittix ON ittix.ticket_id=ticket.ticket_id AND ittix.status=\'Open\' AND ittix.itil_id=1 AND ticket.dept_id=3 '. 'LEFT JOIN '.TICKET_TABLE.' incident ON incident.ticket_id=ticket.ticket_id AND incident.status=\'Open\' AND incident.itil_id=2 '. 'LEFT JOIN '.TICKET_TABLE.' problem ON problem.ticket_id=ticket.ticket_id AND problem.status=\'Open\' AND problem.itil_id=3 '. 'LEFT JOIN '.TICKET_TABLE.' request ON request.ticket_id=ticket.ticket_id AND request.status=\'Open\' AND request.itil_id=4 '. 'LEFT JOIN '.TICKET_TABLE.' assigned ON assigned.ticket_id=ticket.ticket_id AND assigned.staff_id='.db_input($thisuser->getId());