/ учебный год
Сен Окт Ноя Дек Янв Фев Мар Апр Май Июн Июл Авг
35
(default) 7 queries took 0 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Year`.`id`, (CONCAT(`Year`.`year_from`, "/", `Year`.`year_to`)) AS `Year__year_name` FROM `mgl_ischool`.`years` AS `Year` WHERE 1 = 1 ORDER BY `Year`.`year_from` desc110
2SELECT `Year`.`id`, `Year`.`year_from`, `Year`.`year_to`, (CONCAT(`Year`.`year_from`, "/", `Year`.`year_to`)) AS `Year__year_name` FROM `mgl_ischool`.`years` AS `Year` WHERE `year_from` = 2024 ORDER BY `Year`.`year_from` desc LIMIT 1000
3SELECT `Learnerstatus`.`id`, `Learnerstatus`.`status`, `Learnerstatus`.`learner_id`, `Learnerstatus`.`klass_id`, `Learnerstatus`.`date`, `Learnerstatus`.`comment`, `Learner`.`id`, `Learner`.`f`, `Learner`.`i`, `Learner`.`o`, `Learner`.`birthdate`, `Learner`.`about`, `Learner`.`balls`, `Learner`.`user_id`, `Learner`.`pol`, `Learner`.`fio_parents`, `Learner`.`parents_work`, `Learner`.`home`, `Learner`.`delo`, `Learner`.`par_id`, `Learner`.`dont_prolong`, `Learner`.`prolong_notes`, `Learner`.`prolong_note_last`, `Learner`.`has_reqs_prev_year`, `Learner`.`has_na_prev_year`, (CONCAT(f, " ", LEFT(i, 1) , ".", LEFT(o, 1), ".")) AS `Learner__fio_short`, (CONCAT(f, " ", i , " ", o, "")) AS `Learner__fio`, (CONCAT(f, " ", i)) AS `Learner__fi`, `Klass`.`id`, `Klass`.`professor_id`, `Klass`.`year_id`, `Klass`.`command_id`, `Klass`.`name`, `Klass`.`comment`, `Klass`.`color`, `Klass`.`klass_name_digital`, `Klass`.`zveno`, `Klass`.`hide_balls_to_pars_and_learners`, `Klass`.`hide_ratings_to_pars_and_learners` FROM `mgl_ischool`.`learnerstatuses` AS `Learnerstatus` LEFT JOIN `mgl_ischool`.`learners` AS `Learner` ON (`Learnerstatus`.`learner_id` = `Learner`.`id`) LEFT JOIN `mgl_ischool`.`klasses` AS `Klass` ON (`Learnerstatus`.`klass_id` = `Klass`.`id`) WHERE `Learnerstatus`.`learner_id` IS NULL AND `Learnerstatus`.`date` >= '-01-1' AND `Learnerstatus`.`date` <= '-08-31' ORDER BY `Learnerstatus`.`date` DESC LIMIT 1000
4SELECT `LearnersSubgroup`.`id`, `LearnersSubgroup`.`subgroup_id` FROM `mgl_ischool`.`learners_subgroups` AS `LearnersSubgroup` WHERE `LearnersSubgroup`.`learner_id` IS NULL000
5SELECT `Year`.`id`, `Year`.`year_from`, `Year`.`year_to`, (CONCAT(`Year`.`year_from`, "/", `Year`.`year_to`)) AS `Year__year_name` FROM `mgl_ischool`.`years` AS `Year` WHERE 1 = 1 ORDER BY `Year`.`year_from` desc110
6SELECT `Klass`.`id`, `Klass`.`professor_id`, `Klass`.`year_id`, `Klass`.`command_id`, `Klass`.`name`, `Klass`.`comment`, `Klass`.`color`, `Klass`.`klass_name_digital`, `Klass`.`zveno`, `Klass`.`hide_balls_to_pars_and_learners`, `Klass`.`hide_ratings_to_pars_and_learners` FROM `mgl_ischool`.`klasses` AS `Klass` WHERE `Klass`.`year_id` = (15) ORDER BY `klass_name_digital` ASC11110
7SELECT `Period`.`id`, `Period`.`name`, `Period`.`date_from`, `Period`.`date_to`, `Period`.`year_id`, `Period`.`is_holiday`, `Period`.`closed`, `Period`.`weight`, `Period`.`is_year`, `Period`.`sname`, `Period`.`is_exam`, `Period`.`date_to_grid`, (`Period`.`date_from`) AS `Period__date_from_timestamp`, (`Period`.`date_to`) AS `Period__date_to_timestamp`, (`Period`.`date_to_grid`) AS `Period__date_to_grid_timestamp` FROM `mgl_ischool`.`periods` AS `Period` WHERE `Period`.`year_id` = (15) ORDER BY `Period`.`weight` ASC, `Period`.`date_from` ASC, `Period`.`name` ASC18180