Disk full (/var/tmp/#sql_4013_1); 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 ('3813','3820','4198','4221','4222','4223','4224','4225','4226','4229','4230','4232','4234','4235','4236','4240','4305','30901','27313','31732','31585','29503','29725','9743','10382','10383','32024','31745','11125','11126','30313')
GROUP BY povt.optionID
ORDER BY pot.sort_order, pot.name_ru