Query  	SELECT
						st.*,

						st.name_l1 as name,
						st.name_l1 as name_rus,
						st.name_l2 as name_eng,
						st.name_l3 as name_ukr,
						st.address_l1 as address,
						st.about_economic_l1 as about_economic,
						st.about_standard_l1 as about_standard,
						st.about_premium_l1 as about_premium,
						st.working_hours_l1 as working_hours,

						UNIX_TIMESTAMP(st.update_date) as update_date,
						cc.name_eng as country_name,
						c.name_eng as city_name,
						stt.name_l1 as tariff_name,
						stt.code as tariff_code,
						stt_new.name_l1 as tariff_name_new,
						stt_new.code as tariff_code_new,

						u.preferred_language_id
					FROM
						seaman_trainers st 		LEFT JOIN countries cc ON cc.id = st.country_id
					LEFT JOIN cities c ON c.id = st.city_id
					LEFT JOIN seaman_trainers_tariffs stt ON stt.id = st.tariff_id
					LEFT JOIN seaman_trainers_tariffs stt_new ON stt_new.id = st.tariff_id_new
                
					LEFT JOIN users u ON u.id=st.user_id
                	WHERE 1 	AND st.approved='1'	AND st.chpu='butc_astrah' 	ORDER BY -stt.weight DESC, st.name_l1 ASC:Disk full (/tmp/#sql_5dc_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")