Optimalizujte dopyt SELECT p.id ako project_id, p.name ako project_name, i.id ako issue_id, i.subject ako issue_subject, i.status_name ako last_status, h.status ako current_status, h.date_update FROM project ako p LEFT JOIN issue ako i ON p.id=i.project_id LEFT JOIN issue_history ako h ON h.id_issue=i.id WHERE h.code IN (1,4,6)