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