0.0005 |
SELECT `activities`.*, `teachers`.`school_id`, `teachers`.`user_id` `teacher_user_id`, `teachers`.`receive_email` `receive_email`, `activities`.`language_id`, `users`.`email` `teacher_email`, `languages`.`text` as `language_text`, `activity_types`.`description` as `type`, `verb_activity_settings`.`settings` as `settings`, `verb_activity_settings`.`pronouns` as `selected_pronouns`, `activity_types`.`description` as `type`, `users`.`last_name` `creator` FROM `activities` LEFT JOIN `activity_types` ON `type_id`=`activity_types`.`id` LEFT JOIN `teachers` ON `activities`.`teacher_id` = `teachers`.`id` LEFT JOIN `users` ON `teachers`.`user_id` = `users`.`id` JOIN `languages` ON `activities`.`language_id` = `languages`.`id` LEFT JOIN `verb_activity_settings` ON `verb_activity_settings`.`activity_id` = `activities`.`id` WHERE `activities`.`id` = '17843'
|