SELECT
p.id AS 'ID do projeto',
p.name AS 'Projeto',
p.percent_done AS '% de conclusão',
s.name AS 'Status do projeto',
ti.name AS 'Tipo de projeto',
p.date AS 'Data de criação',
p.date_mod AS 'Última atualização',
p.plan_start_date AS 'Início (planejado)',
p.real_start_date AS 'Início (real)',
p.plan_end_date AS 'Encerramento (planejado)',
p.real_end_date AS 'Encerramento (real)',
p.content AS 'Descrição',
ta.id AS 'ID da tarefa',
ta.name AS 'Tarefa'
FROM
glpi.glpi_projects p LEFT JOIN
glpi.glpi_projectstates s ON p.projectstates_id = s.id LEFT JOIN
glpi.glpi_projecttypes ti ON p.projecttypes_id = ti.id LEFT JOIN
glpi.glpi_projecttasks ta ON p.id = ta.projects_id LEFT JOIN
glpi.glpi_projecttasks_tickets tt ON ta.id = tt.projecttasks_id LEFT JOIN
glpi.glpi_tickets t ON t.id = tt.tickets_id
WHERE
p.is_deleted = 0
GROUP BY
ta.id;