SELECT `medical_msk`.*,
`category`.`category` AS `category_name`,
`type`.`type` AS `type_name`
FROM `medical_msk`
LEFT JOIN `category` ON `category`.`id`=`medical_msk`.`category`
LEFT JOIN `type` ON `type`.`id`=`medical_msk`.`type`;


SELECT `medical_spb`.*,
`area_spb`.`area` AS `area_name`,
`category`.`category` AS `category_name`,
`type`.`type` AS `type_name`
FROM `medical_spb`
LEFT JOIN `area_spb` ON `area_spb`.`id`=`medical_spb`.`area`
LEFT JOIN `category` ON `category`.`id`=`medical_spb`.`category`
LEFT JOIN `type` ON `type`.`id`=`medical_spb`.`type`;


SELECT `medical_reg`.*,
`region`.`region` AS `region_name`,
`city`.`city` AS `city_name`,
`category`.`category` AS `category_name`,
`type`.`type` AS `type_name`
FROM `medical_reg`
LEFT JOIN `region` ON `region`.`id`=`medical_reg`.`region`
LEFT JOIN `city` ON `city`.`id`=`medical_reg`.`city`
LEFT JOIN `category` ON `category`.`id`=`medical_reg`.`category`
LEFT JOIN `type` ON `type`.`id`=`medical_reg`.`type`;


SELECT `medical_oth`.*,
`country`.`country` AS `country_name`,
`city_oth`.`city` AS `city_name`,
`category`.`category` AS `category_name`,
`type`.`type` AS `type_name`
FROM `medical_oth`
LEFT JOIN `country` ON `country`.`id`=`medical_oth`.`country`
LEFT JOIN `city_oth` ON `city_oth`.`id`=`medical_oth`.`city`
LEFT JOIN `category` ON `category`.`id`=`medical_oth`.`category`
LEFT JOIN `type` ON `type`.`id`=`medical_oth`.`type`;