Disk full (/var/tmp/#sql_cb9_3); 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 ('29553','29555','29551','29549','29535','29522','29521','29334','29316','29541','29536','29500','29321','29323','29320','29560','29542','29518','29570','29565','29557','29563','29561','29559','29558','29564','29562','29573','29566','29575','29571')
GROUP BY povt.optionID
ORDER BY pot.sort_order, pot.name_ru