0.0250 |
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` = '99' AND `activity_translations`.`activity_id` = '99' 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`
|