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 ('4272','12164','16036','15904','30698','16671','15920','15915','15903','27965','15923','29876','15912','15914','15913','17363','15911','30406','12130','15909','15910','15591','12108','15916','16037','15924','31702','28598','15925','12102','12129') GROUP BY povt.optionID ORDER BY pot.sort_order, pot.name_ru