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 (61,261,311,262,263,467,264,330) AND p.firmID IN (325,435,216,468,249,187,140,101,365,345,39,252,110,401,425,476,78,270,333,215,380,281,14,106,344,285,317,33,412,418,203,330,414,224,451,66,483,307,456,492,470,321,411,417)
 WHERE 1
 AND ov.optionID = '28' AND p.productID IN (13878,13877,24610,2612,389,390,8949,9045,9044,8742,5174,6000,6052,13480,6057,6058,6524,7650,7651,18170,18169,10626,10744,11015,11181,11852,11853,11854,12027,13483,13640,13801,13804,13876,14790,16046,16047,34283,34284,18058,18059,19764,18428,19772,19576,19756,19932,21454,22936,22937,23453,23483,23484,23585,23674,23722,26348,26350,26347,26346,26524,26637,26936,27857,29361,31110,31449,31450,31607,31803,31804,32115,32116,32119,32941,33743,33959,34035,34041,34094,34782,34319,34320,34656,35496,35590,35629,35763,36196,173,174,9043,9042,6226,27395,27396,27397,97,98,100,101,102,172,6054,6055,6947,12390,12391,12392,13798,13799,13800,13924,13925,13926,13927,13928,14204,14205,14828,14829,14830,14831,14832,14833,14834,14835,14836,14837,14838,17871,18050,18051,18052,18053,26874,26875,26876,21291,21292,22570,23479,23480,23481,26873,26248,26249,26500,26501,26502,26503,26504,26505,26506,26507,26508,26924,26925,32498,32499,32500,32501,32502,33174,33175,33176,33177,33178,33179,33180,33181,34587,34588,34589,36019,36384,6706,6707,10770,14207,18049,33511,10764,6859,6857,6860,9532,9533,9534,10735,10736,10737,10738,10739,10740,10741,10742,10743,10745,10746,10747,10748,10749,10750,10751,10752,10753,10754,10755,10756,10757,10758,10759,10760,10761,10762,10763,10775,10765,10766,10767,10768,10769,10771,10772,10773,10774,10776,10777,10778,10779,10781,10782,11088,12599,12600,13120,21144,21145,24908,26962,26963,26964,26965,29147,27841,27842,28792,28793,28794,29146,29148,29953,29954,29955,29965,29966,29967,29968,29969,29970,29971,29972,29973,29974,29975,29976,29977,29978,29979,30001,31294,34135,34136,34137,34138,34139,34140,34141,34142,34143,34144,34145,35294,35666,36197,36198,13482,175,5175,34317,34318,11182,16437,18054,18056,18057,19917,19577,19578,19918,20621,20622,21142,21143,21857,21859,21940,22994,23478,23482,23641,24614,24907,26246,26247,26495,26496,26497,26498,26499,27677,27705,28307,28308,28309,28736,28737,28839,28933,28934,29337,29338,29339,29340,29428,29429,29531,29532,30143,30144,30883,30884,30885,30896,30908,30936,30937,31148,31292,31293,31512,31513,31529,31892,32107,32108,32109,32292,32293,32494,32495,32496,32497,32580,32818,32889,32890,32891,32892,33462,33578,34134,34316,34657,34658,34698,34889,35499,35500,35498,35501,35502,35503,35504,35505,35628,35846,35847,35873,35874,35875,35876,35877,35878,36017,36385,36386,36387) 
 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