Грешка при извршењу упита: (Error writing file '/tmp/MYRAnm8i' (Errcode: 28 - No space left on device))
SELECT
					`institutions`.`id`,
					
					
					`institutions`.`type`,
					`institutions`.`name` AS `name_ru`,
					`institutions`.`name_en`,
					`institutions`.`country` AS `location`,
					
					X(`institutions`.`coordinates`) AS `lat`,
					Y(`institutions`.`coordinates`) AS `lng`,
					
					`countries`.`country_name_ru` AS `location_name`,
					
					
					`institutions`.`cost`,
					
					`institutions`.`city`,
					`institutions`.`zipcode`,
					`institutions`.`street`,
					`institutions`.`house`,
					`institutions`.`housing`,
					`institutions`.`building`,
					
					`institutions`.`phone_1`,
					`institutions`.`phone_2`,
					`institutions`.`phone_1`,
					
					`institutions`.`photo`,
					`institutions`.`photos`,
					`institutions`.`rating`,
					
					`cities`.`city_name_ru` AS `city_name`,
					
					`institutions`.`sector`,
					
					main.`name` AS 'head_name', 
					main.`id`   AS 'head_id',
					main.`type` AS 'head_type',
					
					COUNT(DISTINCT `institutions_reviews`.`id`) AS `reviews_count`,
					0 AS `messages_count`
					
				FROM `countries`, `cities`, `institutions`
					LEFT JOIN `institutions_reviews`
						ON `institutions_reviews`.`institution_id`=`institutions`.`id`
					LEFT JOIN `institutions_departments` AS dep ON dep.`department_id` = `institutions`.id
					LEFT JOIN `institutions` AS main ON main.`id` = dep.`institution_id`
				WHERE `institutions`.`type`='kindergarten'
					
					 AND `institutions`.`country`='16'
					AND `cities`.`city_id`=`institutions`.`city`
					AND `countries`.`country_id`=`institutions`.`country`
				GROUP BY `institutions`.`id`
				
				
				

				ORDER BY `institutions`.`id` ASC, `institutions`.`rating` DESC