| 0.0013 |
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` = '108'
|
| 0.0006 |
SELECT `class_id`, `classes`.`name`
FROM `classes_activities`
JOIN `classes` ON `classes_activities`.`class_id` = `classes`.`id`
WHERE `activity_id` = '108'
|
| 0.0048 |
SELECT `tenses`.`id`, `tenses`.`text`, `tenses`.`etre`, `tenses`.`imperative`
FROM `activities`
JOIN `activity_tenses` ON `activity_tenses`.`activity_id` = `activities`.`id`
JOIN `tenses` ON `tenses`.`id` = `activity_tenses`.`tense_id`
WHERE `activities`.`id` = '108'
|
| 0.0018 |
SELECT `activity_translations`.`id` as `translation_id`, `infinitives`.`id`, `infinitive_translations`.`id` as `translation_id`, if(isnull(infinitive_alternates.text), infinitives.text, infinitive_alternates.text) as original, `infinitive_alternates`.`text` `alternate`, `infinitive_translations`.`text`, `infinitive_translations`.`language_id`, `infinitive_translations`.`latin` as `latin`
FROM `activity_translations`
JOIN `infinitive_translations` ON `infinitive_translations`.`id` = `activity_translations`.`translation_id`
LEFT JOIN `infinitive_alternates` ON `infinitive_alternates`.`translation_id` = `infinitive_translations`.`id` and `infinitive_alternates`.`teacher_id` = 0
LEFT JOIN `infinitives` ON `infinitive_translations`.`infinitive_id` = `infinitives`.`id`
WHERE `activity_translations`.`activity_id` = '108'
AND `infinitive_translations`.`language_id` = '7'
GROUP BY `infinitive_translations`.`text`
ORDER BY `infinitive_translations`.`text` ASC
|
| 0.0066 |
SELECT *
FROM `languages`
WHERE `id` = '7'
|
| 0.0010 |
SELECT *
FROM `activity_tenses`
WHERE `activity_id` = '108'
|
| 0.0353 |
SELECT TRIM(conjugation) as text, `conjugations`.`id` as `conjugation_id`, `conjugations`.`pronoun_id`, `conjugations`.`translation_id`, `conjugations`.`tense_id`, `conjugations`.`infinitive_id`, `pronouns`.`text` as `pronoun`, `order_chart`, `pronouns`.`order`, `tenses`.`etre`
FROM `conjugations`
JOIN `activity_translations` ON `conjugations`.`translation_id` = `activity_translations`.`translation_id`
JOIN `pronouns` ON `pronouns`.`id` = `conjugations`.`pronoun_id`
JOIN `tenses` ON `tenses`.`id` = `conjugations`.`tense_id`
JOIN `activity_tenses` ON `conjugations`.`tense_id` = `activity_tenses`.`tense_id`
JOIN `activities` ON `activities`.`id` = `activity_translations`.`activity_id`
WHERE `activity_translations`.`activity_id` = '108'
AND `activity_tenses`.`activity_id` = '108'
GROUP BY `tenses`.`id`, `pronouns`.`id`, `conjugations`.`translation_id`, `conjugation`
ORDER BY `pronouns`.`order` ASC
|