| 0.0006 |
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` = '1'
|
| 0.0003 |
SELECT `class_id`, `classes`.`name`
FROM `classes_activities`
JOIN `classes` ON `classes_activities`.`class_id` = `classes`.`id`
WHERE `activity_id` = '1'
|
| 0.0004 |
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` = '1'
|
| 0.0016 |
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` = '1'
AND `infinitive_translations`.`language_id` = '2'
GROUP BY `infinitive_translations`.`text`
ORDER BY `infinitive_translations`.`text` ASC
|
| 0.0002 |
SELECT *
FROM `languages`
WHERE `id` = '2'
|
| 0.0002 |
SELECT *
FROM `activity_tenses`
WHERE `activity_id` = '1'
|
| 0.0401 |
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` = '1'
AND `activity_tenses`.`activity_id` = '1'
GROUP BY `tenses`.`id`, `pronouns`.`id`, `conjugations`.`translation_id`, `conjugation`
ORDER BY `pronouns`.`order` ASC
|
| 0.2555 |
SELECT `infinitive_translations`.`infinitive_id` as `infinitive_id`, `infinitives`.`text` as `infinitive`, if(isnull(infinitive_alternates.text), infinitives.text, infinitive_alternates.text) as infinitive, `conjugations`.`conjugation` as `conjugation`, `conjugations`.`id` as `conjugation_id`, `conjugations`.`language_id` as `language_id`, `conjugations`.`tense_id` as `tense_id`, `tenses`.`text` as `tense_text`, `infinitive_translations`.`text` as `translation`, `infinitive_translations`.`id` as `translation_id`, `infinitive_translations`.`verified` as `verified`, `conjugations`.`id` as `conjugation_id`, `pronouns`.`imperative` as `imperative`, `pronouns`.`text` as `pronoun`, `conjugations`.`pronoun_id` as `pronoun_id`, `conjugations`.`translation_id` as `translation_id`, `tense_imperative_pronouns`.`pronoun_id` `imperative_pronoun`, `tenses`.`imperative` `is_imperative`
FROM `conjugations`
JOIN `activity_tenses` ON `conjugations`.`tense_id` = `activity_tenses`.`tense_id`
JOIN `tenses` ON `conjugations`.`tense_id` = `tenses`.`id`
JOIN `activity_translations` ON `conjugations`.`translation_id` = `activity_translations`.`translation_id`
JOIN `pronouns` ON `pronouns`.`id` = `conjugations`.`pronoun_id`
LEFT JOIN `tense_imperative_pronouns` ON `tenses`.`id` = `tense_imperative_pronouns`.`tense_id` and `pronouns`.`id` = `tense_imperative_pronouns`.`pronoun_id`
JOIN `infinitive_translations` ON `infinitive_translations`.`id` = `conjugations`.`translation_id`
JOIN `infinitives` ON `infinitives`.`id` = `infinitive_translations`.`infinitive_id`
JOIN `activities` ON `activities`.`id` = `activity_translations`.`activity_id`
LEFT JOIN `infinitive_alternates` ON `infinitive_alternates`.`translation_id` = `infinitive_translations`.`id` and `infinitive_alternates`.`teacher_id` = 0
WHERE `activity_tenses`.`activity_id` = '1'
AND `activity_translations`.`activity_id` = '1'
AND (ifnull(tenses.imperative, 0) =0 OR `tense_imperative_pronouns`.`pronoun_id` is not null)
GROUP BY `tenses`.`id`, `pronouns`.`id`, `conjugations`.`translation_id`, `conjugation`
ORDER BY `infinitive_translations`.`text`, `tenses`.`id` asc, `pronouns`.`order_chart`
|