error - rating scale
SELECT t1.id, t2.translation, ABS(9.4 - t1.rating) AS nearest FROM data_review_scale AS t1 LEFT JOIN data_translations AS t2 ON t2.id_item=t1.id AND t2.langcode='es' AND t2.id_table=4 ORDER BY nearest ASC LIMIT 1