SELECT
csscart_ec_bd_features.feature_id,
csscart_ec_bd_feature_descriptions.feature,
csscart_ec_bd_features.status,
csscart_ec_bd_features.timestamp,
csscart_ec_bd_features.feature_style,
csscart_ec_bd_features.filter_type,
csscart_ec_bd_features.categories_path,
csscart_ec_bd_features.display_on_vendor,
csscart_ec_bd_feature_values.value,
csscart_ec_bd_feature_values.variant_id,
csscart_ec_bd_feature_values.value_int
FROM
csscart_ec_bd_features
LEFT JOIN csscart_ec_bd_feature_values ON csscart_ec_bd_feature_values.feature_id = csscart_ec_bd_features.feature_id
AND csscart_ec_bd_feature_values.company_id = 2
AND csscart_ec_bd_feature_values.lang_code = 'en'
LEFT JOIN csscart_ec_bd_feature_descriptions ON csscart_ec_bd_feature_descriptions.feature_id = csscart_ec_bd_features.feature_id
AND csscart_ec_bd_feature_descriptions.lang_code = 'en'
WHERE
1
AND csscart_ec_bd_features.status = 'A'
ORDER BY
csscart_ec_bd_features.position asc