SELECT cp.`id_feature`, cl.`name`, cv.`value` FROM `ps_feature_product` cp LEFT JOIN `ps_feature_lang` cl ON (cp.`id_feature` = cl.`id_feature` AND cl.`id_lang` = 2) LEFT JOIN ps_feature_value_lang cv ON (cv.id_feature_value = cp.id_feature_value AND cv.id_lang = 2) WHERE cp.`id_product` = 3117 ORDER BY cl.`name`