SELECT *, pov.image as pov_image, pov.product_option_value_id as povd, (SELECT image FROM balon_product_price WHERE product_id = '77' AND product_option_value_id = povd BY product_price_id DESC LIMIT 1) as pp_image FROM balon_product_option_value pov LEFT JOIN balon_option_value ov ON (pov.option_value_id = ov.option_value_id) LEFT JOIN balon_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id) WHERE pov.product_id = '77' AND pov.status = 1 AND pov.product_option_id = '8833' AND ovd.language_id = '1' ORDER BY pov.price_default DESC