SELECT * FROM `#__splms_lesson_status` AS s INNER JOIN `#__splms_lessons`AS l ON l.splms_lesson_id = s.lesson_id WHERE `course_id`=11260 AND `status`='completed' AND s.archive_date IS NULL AND `s`.`user_id`=0 AND `s`.`language`='es-LAS' GROUP BY `s`.`user_id`,`s`.`course_id`,`s`.`lesson_id` ORDER BY `l`.`ordering`ASC