| 0.0009 |
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` = '147'
|
| 0.0004 |
SELECT `class_id`, `classes`.`name`
FROM `classes_activities`
JOIN `classes` ON `classes_activities`.`class_id` = `classes`.`id`
WHERE `activity_id` = '147'
|
| 0.0003 |
SELECT `text`
FROM `activity_fillin`
WHERE `activity_id` = '147'
|
| 0.0002 |
SELECT *
FROM `languages`
WHERE `id` = '2'
|
| 0.0002 |
SELECT *
FROM `languages`
WHERE `id` = '2'
|
| 0.0003 |
SELECT `letter`, `prompt`, `alphabet`, `prompt_redesign`
FROM `special_characters`
WHERE `language` = 'french'
|
| 0.0002 |
SELECT `text`
FROM `activity_fillin`
WHERE `activity_id` = '147'
|
| 0.0003 |
SELECT `letter`, `prompt`, `alphabet`, `prompt_redesign`
FROM `special_characters`
WHERE `language` = 'french'
|