| 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` = '17642'
|
| 0.0003 |
SELECT `class_id`, `classes`.`name`
FROM `classes_activities`
JOIN `classes` ON `classes_activities`.`class_id` = `classes`.`id`
WHERE `activity_id` = '17642'
|
| 0.0003 |
SELECT *
FROM `languages`
WHERE `id` = '2'
|
| 0.0007 |
SELECT DISTINCT `vocabulary`.`id`, `vocabulary`.`text`
FROM `activities`
JOIN `vocabulary_translations` ON `activities`.`id` = `vocabulary_translations`.`activity_id`
JOIN `vocabulary` ON `vocabulary_translations`.`vocabulary_id` = `vocabulary`.`id`
WHERE `activities`.`id` = '17642'
ORDER BY `vocabulary_translations`.`id` ASC
|
| 0.0005 |
SELECT `text`, `id`, `vocabulary_id`
FROM `vocabulary_translations`
WHERE `activity_id` = '17642'
AND `language_id` = '2'
|