Query failed: Disk full (/tmp/#sql_240_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") SELECT HO.id, HO.haendler_id, hotel_name AS bu_hotel_name, hotel_name AS hotel_name, subheadline AS subheadline, url_name, HO.plz, HO.ort, HO.land, HO.gbreite, HO.glaenge, HO.telefon, HO.telefax, HO.homepage, 
			(SELECT bild FROM hotel_bilder WHERE HO.id = hotel_id AND kategorie = 0 ORDER BY sort LIMIT 0,1) as origbild, 
			MA.email, LA.flagge 
			FROM hotels AS HO JOIN marketing_adressbook AS MA LEFT JOIN laender AS LA ON (HO.land LIKE LA.name)
			WHERE HO.haendler_id = MA.id AND HO.visible='1'  AND HO.plz LIKE '54568' ORDER BY ranking_points DESC, land, ort  LIMIT 0, 16