SELECT escaparates.id, escaparates.name, escaparates.alias, escaparates.description, escaparates.intro_desc, escaparates.image_url, escaparates.image_path, escaparates.image_caption, escaparates.concepto_precio, escaparates.price, escaparates.subcategoria_alias, escaparates.categoria_alias, regiones.name as localidad, (6371 * ACOS(SIN(RADIANS(escaparates.latitude)) * SIN(RADIANS(41.193379000000000)) + COS(RADIANS(escaparates.longitude - 1.606467999999950)) * COS(RADIANS(escaparates.latitude)) * COS(RADIANS(41.193379000000000)))) AS distance FROM escaparates INNER JOIN regiones ON regiones.id = escaparates.region_id WHERE escaparates.published = 1 AND escaparates.cat_id = 80 AND (escaparates.latitude BETWEEN 39.844396591122 AND 42.542361408878) AND (escaparates.longitude BETWEEN -0.18596739318787 AND 3.3989033931878) HAVING distance < 150 ORDER BY distance ASC LIMIT 0, 6

Error writing file '/tmp/MYe422Zt' (Errcode: 28 "No space left on device")