Disk full (/var/tmp/#sql_cb9_5); waiting for someone to free some space...
SELECT pot.*, povt.*, v.option_value_ru as variantName
FROM SC_product_options_values as povt
LEFT JOIN SC_products_opt_val_variants as v ON v.variantID=povt.variantID
LEFT JOIN SC_product_options as pot ON pot.optionID=povt.optionID
WHERE povt.productID IN ('29572','29574','29568','29567','29336','29319','29539','29324','29326','29537','29540','29322','29538','29698','29543','29545','29325','29338','29327','29329','29546','29544','29341','29337','29349','29328','29340','29339','29347','29346','29350')
GROUP BY povt.optionID
ORDER BY pot.sort_order, pot.name_ru