SELECT ov.option_value, ov.option_type, ov.variantID, v.option_value variant_value 
 FROM `ss_product_options_values` ov 
 LEFT JOIN `ss_products_opt_val_variants` v ON ov.variantID = v.variantID
 LEFT JOIN ss_products p ON ov.productID = p.productID AND p.categoryID IN (252) AND p.firmID IN (66,110,87,345,249,216,412,404,401)
 WHERE 1
 AND ov.optionID = '28' AND p.productID IN (3345,3346,3347,3384,3385,3387,3388,3389,3390,3391,3392,3393,3394,3395,6919,6920,6921,6922,6923,8074,8323,8324,8325,8326,8624,28214,28213,28215,28216,28217,28721,28722,29574,29575,31751,31752,32170,33297,33298,33299,33540,33541,33542,33543,33544) 
 AND 
 (
 (ov.option_type = 0 AND ov.option_value <> '') || 
 (ov.option_type = 1 AND v.option_value <> '')
 )
 -- AND ov.variantID IS NOT NULL
 GROUP BY ov.option_value, ov.option_type, ov.variantID, v.option_value