SELECT t.id, t.pic, t.pnomer, ROUND(t.price*a.coef, 2) as price, t.name_en, t.short_en, t.used, t.unpacked, t.price as price_new, t.price_org, t.status_id, DATE_FORMAT(t.nav_date, '%d-%m-%Y'), t.nav_order, t.nav_date, t.delivery_days, DATE_FORMAT(t.delivery_date, '%d-%m-%Y'), t.disc_qty FROM products t JOIN atts a ON (a.id = ?) ,products_groups u WHERE t.status = '1' AND t.cz_en = '0' AND (t.id IN (SELECT b.product_id FROM productsgroups_active a, products_groups b WHERE a.id = b.group_id)) AND t.id = u.product_id AND t.discounted = '0' AND u.group_id IN (SELECT v.id FROM productsgroups_v2 v WHERE v.b_id = '165' OR v.s_id = '165' OR v.t_id = '165' OR v.r_id = '165' OR v.f_id = '165' OR v.e_id = '165') /*GROUP BY t.id*/ ORDER BY t.id DESC