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 = '392' OR v.s_id = '392' OR v.t_id = '392' OR v.r_id = '392' OR v.f_id = '392' OR v.e_id = '392')
/*GROUP BY t.id*/
ORDER BY t.id DESC