Disk full (/var/tmp/#sql_cb9_2); 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 ('18942','14423','14639','9856','15661','15230','18941','15269','15231','18940','18939','25110','10047','14741','15662') GROUP BY povt.optionID ORDER BY pot.sort_order, pot.name_ru