SELECT
cscart_product_feature_variants.variant_id,
cscart_product_feature_variants.position,
cscart_product_feature_variants.color,
cscart_product_feature_variant_descriptions.variant
FROM
cscart_product_feature_variants
LEFT JOIN cscart_product_feature_variant_descriptions ON cscart_product_feature_variants.variant_id = cscart_product_feature_variant_descriptions.variant_id
AND cscart_product_feature_variant_descriptions.lang_code = 'tr'
WHERE
cscart_product_feature_variants.variant_id IN (1215, 1214, 1223, 0, 1224, 1225)
ORDER BY
cscart_product_feature_variants.position ASC,
cscart_product_feature_variant_descriptions.variant ASC