SELECT products.product_id, descr1.product as product, companies.company as company_name, MIN(IF(prices.percentage_discount = 0, prices.price, prices.price - (prices.price * prices.percentage_discount)/100)) as price, products.product_type, products.parent_product_id, products.master_product_id, products.company_id, products.rf_stop_update_price, products.rf_stop_update_amount, products.rf_stop_update_status, IF(images_links.detailed_id IS NULL OR images_links.detailed_id=0, 0, 1) as images FROM ?:products as products LEFT JOIN ?:images_links AS images_links ON products.product_id = images_links.object_id AND images_links.type="M" AND images_links.object_type="product" LEFT JOIN ?:product_options_inventory as inventory ON inventory.product_id = products.product_id LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'ru' LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id AND (?:categories.usergroup_ids = '' OR FIND_IN_SET(0, ?:categories.usergroup_ids) OR FIND_IN_SET(1, ?:categories.usergroup_ids)) AND ?:categories.status IN ('A', 'H') WHERE 1 AND (companies.status = 'A' OR products.company_id = 0) AND products.amount > 0 AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) AND products.approved = 'Y' AND products.master_product_status IN ('A') AND products.master_product_id = 489697 AND IF(images_links.detailed_id IS NULL OR images_links.detailed_id=0, 1, 0)=0 AND products.product_type != 'D' GROUP BY products.product_id ORDER BY images desc,price asc, products.product_id ASC