SELECT escaparates.id, escaparates.name, escaparates.alias, escaparates.description, escaparates.intro_desc, escaparates.image_url, escaparates.image_path, escaparates.image_caption, escaparates.img_count, escaparates.tiene_tour360, escaparates.concepto_precio, escaparates.price, escaparates.subcategoria_alias, escaparates.categoria_alias, regiones.name as localidad , CAST((6371 * ACOS( SIN(RADIANS(escaparates.latitude)) * SIN(RADIANS(40.0703925)) + COS(RADIANS(escaparates.longitude - -2.1374162)) * COS(RADIANS(escaparates.latitude)) * COS(RADIANS(40.0703925)) ) ) AS INT) AS distance FROM escaparates JOIN regiones ON regiones.id = escaparates.region_id WHERE escaparates.published = 1 AND (escaparates.destacado_buscador IS NULL OR escaparates.destacado_buscador = 0) AND (escaparates.destacado_buscador_nacional IS NULL OR escaparates.destacado_buscador_nacional = 0) AND escaparates.cat_id = 80 AND (escaparates.latitude BETWEEN 38.721410091122 AND 41.419374908878) AND (escaparates.longitude BETWEEN -3.8999758590191 AND -0.37485654098089) HAVING distance < 150 ORDER BY distance ASC, relevancia DESC

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