SELECT DISTINCT `p`.`id`, `pt`.`nombre`, `pt`.`descripcion`, `pt`.`descripcion` FROM `producto` AS `p`
INNER JOIN `linea` AS `l` ON p.linea_id = l.id
INNER JOIN `producto_translation` AS `pt` ON p.id = pt.producto_id
INNER JOIN `language` AS `lang` ON pt.language_id = lang.id WHERE (p.id=65 AND p.activo=1 AND lcase(l.min)='aire' AND lang.prefijo='it')