$query = "SELECT DISTINCT b.handler_id as id, u.username FROM $t_bug_table b RIGHT JOIN {$_TABLES['users']} u ON b.handler_id = u.uid WHERE handler_id != 0 ORDER BY u.username";