SELECT  products.product_id, descr1.product as product, companies.company as company_name, 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_features_values as var_val_15911 ON var_val_15911.product_id = products.product_id AND var_val_15911.lang_code = 'ru' AND var_val_15911.feature_id = 15911 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 (var_val_15911.variant_id IN (148799)) AND ?:categories.category_id IN (2915) AND (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.parent_product_id = 0 AND products.master_product_status IN ('A') AND products.master_product_id = 0 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,products.timestamp desc, products.product_id ASC  LIMIT 0, 20