| SELECT `FrenchLesson`.`id`, `FrenchLesson`.`version`, `FrenchLesson`.`module`, `FrenchLesson`.`group`, `FrenchLesson`.`type`, `FrenchLesson`.`state`, `FrenchLesson`.`rank`, `FrenchLesson`.`chapter`, `FrenchLesson`.`title`, `FrenchLesson`.`author_name`, `FrenchLesson`.`dialect`, `FrenchLesson`.`description`, `FrenchLesson`.`content`, `FrenchLesson`.`preview`, `FrenchLesson`.`content_html`, `FrenchLesson`.`content_html_fr`, `FrenchLesson`.`text_shimaore`, `FrenchLesson`.`text_shimwali`, `FrenchLesson`.`text_shindzuani`, `FrenchLesson`.`text_shingazidja`, `FrenchLesson`.`thumbnail`, `FrenchLesson`.`media_source`, `FrenchLesson`.`audio_source`, `FrenchLesson`.`audio_source_shimaore`, `FrenchLesson`.`audio_source_shimwali`, `FrenchLesson`.`audio_source_shindzuani`, `FrenchLesson`.`audio_source_shingazidja`, `FrenchLesson`.`video_source`, `FrenchLesson`.`purchase_link`, `FrenchLesson`.`publishing_house`, `FrenchLesson`.`authorization`, `FrenchLesson`.`is_shingazidja`, `FrenchLesson`.`is_shindzuani`, `FrenchLesson`.`is_shimaore`, `FrenchLesson`.`is_shimwali`, `FrenchLesson`.`is_standard`, `FrenchLesson`.`use_all_audios`, `FrenchLesson`.`use_all_videos`, `FrenchLesson`.`verified`, `FrenchLesson`.`active`, `FrenchLesson`.`is_conversation`, `FrenchLesson`.`licensed`, `FrenchLesson`.`closed`, `FrenchLesson`.`exercises_to_validate`, `FrenchLesson`.`exercises_to_memorize`, `FrenchLesson`.`required_exercises`, `FrenchLesson`.`creator_id`, `FrenchLesson`.`editor_id`, `FrenchLesson`.`date_created`, `FrenchLesson`.`date_updated`, `FrenchLesson`.`date_published`, `FrenchLesson`.`date_day_article`, `User`.`id`, `User`.`email`, `User`.`security_email`, `User`.`payment_email`, `User`.`payment_id`, `User`.`biography`, `User`.`curriculum_vitae`, `User`.`thumbnail`, `User`.`sex`, `User`.`first_name`, `User`.`last_name`, `User`.`display_name`, `User`.`date_of_birth`, `User`.`address`, `User`.`phone`, `User`.`phone2`, `User`.`city`, `User`.`country`, `User`.`dialect`, `User`.`learning_dialect`, `User`.`shikomori_level`, `User`.`website`, `User`.`visio_url`, `User`.`password`, `User`.`password_question`, `User`.`password_response`, `User`.`digest_a1`, `User`.`rating`, `User`.`count_dictionary_contribution`, `User`.`count_ressource_contribution`, `User`.`count_of_words_to_revise`, `User`.`time_to_revise`, `User`.`revision_duration`, `User`.`license_registration_in_process`, `User`.`subscribe`, `User`.`certified`, `User`.`has_teacher`, `User`.`has_license_game`, `User`.`available`, `User`.`share_exercice`, `User`.`dictionary_signatory`, `User`.`requested_contribution`, `User`.`session_number`, `User`.`session_id`, `User`.`school_id`, `User`.`referral_code`, `User`.`referred`, `User`.`api_key`, `User`.`client_name`, `User`.`created`, `User`.`modified`, `User`.`connected`, `User`.`online`, `User`.`timezone`, `User`.`role`, `User`.`free_week_for_teacher`, `User`.`active_newsletter_notification`, `User`.`active_comment_notification`, `User`.`active`, `User`.`temp_user_data`, `User`.`access_token`, `User`.`access_token2`, `User`.`access_token3`, `User`.`access_token4`, `User`.`firebase_device_token_dictionary`, `User`.`firebase_device_token_luha`, `User`.`certificate_level`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__full_name`, (CONCAT(`User`.`first_name`, " ", UPPER(LEFT(`User`.`last_name`, 1)), ".")) AS `User__short_name`, (IF(
`User`.`last_name` != "" AND `User`.`last_name` IS NOT NULL,
CONCAT(
`User`.`first_name`, " ",
IF(LOCATE(" ", `User`.`last_name`) = 0,
CONCAT(UPPER(LEFT(`User`.`last_name`, 1)), "."),
CONCAT(
UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", 1), 1)), ". ",
UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", -1), 1)), "."
)
)
),
`User`.`first_name`
)) AS `User__short_full_name` FROM `noniseshorelc`.`french_lessons` AS `FrenchLesson` LEFT JOIN `noniseshorelc`.`users` AS `User` ON (`FrenchLesson`.`editor_id` = `User`.`id`) WHERE ((`FrenchLesson`.`type` = 'publicite') AND (`FrenchLesson`.`module` = 'Formation')) ORDER BY `rank` ASC | 0 | 0 | 2 | maybe slow |
