Институты с военной кафедрой в Тамбове. Список вузов с военной кафедрой // ACADEMICA.RU

array:6 ["city" => 435 "ege_type" => null "main" => 0 "params" => array:12 [ "dopitems" => null "directions" => array:1 [ "direction_studies_id" => 8 ] "coursesitems" => null "coursesobjects" => null "egeitems" => null "foreignlanguages" => null "foreigntypes" => null "foreignwho" => null "compitems" => null "vuzarmies" => array:1 [ "army_id" => 2 ] "vuzforms" => array:1 [ "form_id" => 2 ] "vuzstatuses" => array:1 [ "status_id" => "" ] ] "type" => null "count" => 0]

"select `s`.* from `seo` as `s` inner join `seo_city` as `sc` on `s`.`id` = `sc`.`seo_id` inner join `direction_studies_seo` as `ds` on `s`.`id` = `ds`.`seo_id` left join `professions_seo` as `missing_professions` on `s`.`id` = `missing_professions`.`seo_id` left join `foreign_language_seo` as `missing_foreignlanguages` on `s`.`id` = `missing_foreignlanguages`.`seo_id` left join `foreign_type_seo` as `missing_foreigntypes` on `s`.`id` = `missing_foreigntypes`.`seo_id` left join `foreign_who_seo` as `missing_foreignwho` on `s`.`id` = `missing_foreignwho`.`seo_id` left join `ege_item_seo` as `missing_egeitems` on `s`.`id` = `missing_egeitems`.`seo_id` left join `comp_item_seo` as `missing_compitems` on `s`.`id` = `missing_compitems`.`seo_id` left join `dop_item_seo` as `missing_dopitems` on `s`.`id` = `missing_dopitems`.`seo_id` left join `courses_item_seo` as `missing_coursesitems` on `s`.`id` = `missing_coursesitems`.`seo_id` left join `courses_object_seo` as `missing_coursesobjects` on `s`.`id` = `missing_coursesobjects`.`seo_id` left join `vuz_army_seo` as `missing_vuzarmies` on `s`.`id` = `missing_vuzarmies`.`seo_id` left join `vuz_form_seo` as `missing_vuzforms` on `s`.`id` = `missing_vuzforms`.`seo_id` left join `vuz_status_seo` as `missing_vuzstatuses` on `s`.`id` = `missing_vuzstatuses`.`seo_id` where `sc`.`city_id` = ? and `s`.`main` = ? and `ds`.`direction_studies_id` = ? and `missing_professions`.`seo_id` is null and `missing_foreignlanguages`.`seo_id` is null and `missing_foreigntypes`.`seo_id` is null and `missing_foreignwho`.`seo_id` is null and `missing_egeitems`.`seo_id` is null and `missing_compitems`.`seo_id` is null and `missing_dopitems`.`seo_id` is null and `missing_coursesitems`.`seo_id` is null and `missing_coursesobjects`.`seo_id` is null and `missing_vuzarmies`.`seo_id` is null and `missing_vuzforms`.`seo_id` is null and `missing_vuzstatuses`.`seo_id` is null"

"select `s`.* from `seo` as `s` left join `seo_city` as `sc` on `s`.`id` = `sc`.`seo_id` inner join `direction_studies_seo` as `ds` on `s`.`id` = `ds`.`seo_id` left join `professions_seo` as `missing_professions` on `s`.`id` = `missing_professions`.`seo_id` left join `foreign_language_seo` as `missing_foreignlanguages` on `s`.`id` = `missing_foreignlanguages`.`seo_id` left join `foreign_type_seo` as `missing_foreigntypes` on `s`.`id` = `missing_foreigntypes`.`seo_id` left join `foreign_who_seo` as `missing_foreignwho` on `s`.`id` = `missing_foreignwho`.`seo_id` left join `ege_item_seo` as `missing_egeitems` on `s`.`id` = `missing_egeitems`.`seo_id` left join `comp_item_seo` as `missing_compitems` on `s`.`id` = `missing_compitems`.`seo_id` left join `dop_item_seo` as `missing_dopitems` on `s`.`id` = `missing_dopitems`.`seo_id` left join `courses_item_seo` as `missing_coursesitems` on `s`.`id` = `missing_coursesitems`.`seo_id` left join `courses_object_seo` as `missing_coursesobjects` on `s`.`id` = `missing_coursesobjects`.`seo_id` left join `vuz_army_seo` as `missing_vuzarmies` on `s`.`id` = `missing_vuzarmies`.`seo_id` left join `vuz_form_seo` as `missing_vuzforms` on `s`.`id` = `missing_vuzforms`.`seo_id` left join `vuz_status_seo` as `missing_vuzstatuses` on `s`.`id` = `missing_vuzstatuses`.`seo_id` where `sc`.`seo_id` is null and `s`.`main` = ? and `ds`.`direction_studies_id` = ? and `missing_professions`.`seo_id` is null and `missing_foreignlanguages`.`seo_id` is null and `missing_foreigntypes`.`seo_id` is null and `missing_foreignwho`.`seo_id` is null and `missing_egeitems`.`seo_id` is null and `missing_compitems`.`seo_id` is null and `missing_dopitems`.`seo_id` is null and `missing_coursesitems`.`seo_id` is null and `missing_coursesobjects`.`seo_id` is null and `missing_vuzarmies`.`seo_id` is null and `missing_vuzforms`.`seo_id` is null and `missing_vuzstatuses`.`seo_id` is null"

"select `s`.* from `seo` as `s` left join `seo_city` as `sc` on `s`.`id` = `sc`.`seo_id` inner join `direction_studies_seo` as `ds` on `s`.`id` = `ds`.`seo_id` where `sc`.`seo_id` is null and `s`.`main` = ? and `ds`.`direction_studies_id` = ?"

Институты с военной кафедрой в Тамбове