SELECT products.*, categories.name_rus AS cat_name, categories.path5k AS cat_path, categories.p_id AS p_id, categories.subtitle,
                      groups.name AS group_name, brands.name AS brand_name, brands.check_rozn, brands.check_opt, brands.blackfriday, brands.firmofweek, brands.action_type, brands.action_start, brands.action_end, brands.brand_kurs_rub, brands.brand_kurs_rur,(TO_DAYS(NOW())-TO_DAYS(products.date2)) AS days, brands.proshiv FROM `products` IGNORE INDEX (cat_id), `categories`, `groups`, `brands` WHERE products.actual = 1 AND products.price4 > 1 AND products.price2 > 0 AND brands.check_rozn = 1 AND products.cat_id = categories.id AND products.group_id = groups.id AND products.group_id IN (29,37,38,39,40,42,43,44,46,47) AND products.brand_id = brands.id AND (products.id in (SELECT product_id FROM prod_res WHERE prod_res.product_id = products.id AND prod_res.attr_id=154 AND prod_res.value REGEXP BINARY "670") AND products.cat_id IN (479,496,497,499,501,503,504) AND pricebyn>0 AND products.brand_id = 1179) ORDER BY RAND() LIMIT 10