SELECT DISTINCT ecl.exercise_id          as exerciseId,
       ecl.ordering             as exerciseOrderNumber,
       ex.description_1         as description1,
       ex.description_2         as description2,
       ex.audio_files           as audioFiles,
       ex.max_score             as maxScore,
       ex.is_verbal             as isVerbal,
       ex.is_speaking           as isSpeaking,
       ex.cloud_icon            as cloudIcon,
       ex.is_writing            as isWriting,
       ex.add_editor_text_field as editorTextField,
       ler.is_finished as ler_isFinisedm,
       ler.no_mistakes as ler_noMistakes,
       ler.count_mistakes as ler_countMistakes,
       ler.score as ler_score,
       ler.max_score as ler_maxScore,
       ler.user_unswers as ler_userAnswers,
       ler.editor_text_field as ler_editorTextField,
       ler.teacher_corrections as ler_teacherCorrections,
       ler.finished_date as ler_finisgedDate,
       ler.remaining_attempts as ler_remainingAttempts
FROM `exercises_to_course_lessons` as ecl
         LEFT JOIN `exercises` as ex
                   ON ex.id = ecl.exercise_id
         LEFT JOIN `courses` as c
                   ON c.id = ecl.course_id
         LEFT JOIN `lessons` as l
                   ON l.id = ecl.lesson_id
        LEFT JOIN `lesson_exercises_results` as ler
            ON ler.course_id = ecl.course_id AND ler.lesson_id = ecl.lesson_id AND ler.exercise_id = ecl.exercise_id

WHERE ecl.course_id = 3
  AND ecl.lesson_id = 33
  AND ler.user_id = 1
  AND l.publish = 1
  AND c.publish = 1
  AND ex.published = 1
ORDER BY ecl.ordering;

SELECT ecl.exercise_id          as exerciseId,
       ecl.ordering             as exerciseOrderNumber,
       ex.description_1         as description1,
       ex.description_2         as description2,
       ex.audio_files           as audioFiles,
       ex.max_score             as maxScore,
       ex.is_verbal             as isVerbal,
       ex.is_speaking           as isSpeaking,
       ex.cloud_icon            as cloudIcon,
       ex.is_writing            as isWriting,
       ex.add_editor_text_field as editorTextField
FROM `exercises_to_course_lessons` as ecl
         LEFT JOIN `exercises` as ex
                   ON ex.id = ecl.exercise_id
         LEFT JOIN `courses` as c
                   ON c.id = ecl.course_id
         LEFT JOIN `lessons` as l
                   ON l.id = ecl.lesson_id
WHERE ecl.course_id = 3
  AND ecl.lesson_id = 33
  AND l.publish = 1
  AND c.publish = 1
  AND ex.published = 1
ORDER BY ecl.ordering;