Disk full (/var/tmp/#sql_5344_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 ('18103','27365','18195','18196','18197','18253','23930','18387','18388','23928','18410','18514','18525','18559','18654','18703','18704','18705','18706','18707','18765','18886','18888','18889','20359','29209','29229','29241','29242','29243','28532','26940','25662','29141','28660','28579','28541','25546','25547','28022')
GROUP BY povt.optionID
ORDER BY pot.sort_order, pot.name_ru