SELECT 
  brand_logo 
FROM 
  cscart_product_feature_variant_descriptions vd 
  INNER JOIN cscart_product_features_values pfv ON (pfv.variant_id = vd.variant_id) 
WHERE 
  pfv.feature_id = 171 
  AND pfv.product_id = 66532 
  AND vd.lang_code = 'en' 
  AND vd.brand_logo IS NOT NULL 
  AND vd.brand_logo <> '' 
LIMIT 
  2

Query time 0.00032