select distinct p.productID, p.name , p.product_code, 
@markaEn := (select inopt.option_value from product_options_values as inopt where inopt.productID = p.productID and inopt.optionID = 25),
@modelEn := (select inopt.option_value from product_options_values as inopt where inopt.productID = p.productID and inopt.optionID = 26),
@markaRu := (select inopt.option_value from product_options_values as inopt where inopt.productID = p.productID and inopt.optionID = 2),
@modelRu := (select inopt.option_value from product_options_values as inopt where inopt.productID = p.productID and inopt.optionID = 24)
from products as p left outer join product_options_values as o on p.productID = o.productID;