SELECT
FROM_UNIXTIME(mantis_bugnote_table.last_modified,'%d/%m/%Y') as 'fecha',
FROM_UNIXTIME(mantis_bugnote_table.last_modified,'%m/%Y') as 'mes',
mantis_project_table.name as proyecto,
mantis_category_table.name as categoria,
mantis_bugnote_table.bug_id as incidente,
mantis_bug_table.summary as sumario, 
mantis_bugnote_text_table.note as descripcion,
round((mantis_bugnote_table.time_tracking)/60,2) as tiempo,
mantis_user_table.username as usuario
FROM
mantis_bugnote_table
Inner Join mantis_bugnote_text_table ON mantis_bugnote_table.id = mantis_bugnote_text_table.id
Inner Join mantis_user_table ON mantis_bugnote_table.reporter_id = mantis_user_table.id
Inner Join mantis_bug_table ON mantis_bugnote_table.bug_id = mantis_bug_table.id
Inner Join mantis_project_table ON mantis_bug_table.project_id = mantis_project_table.id
Inner Join mantis_category_table ON mantis_bug_table.category_id = mantis_category_table.id
WHERE
mantis_bugnote_table.time_tracking > 0