SELECT p.productID, `name_ru` AS name, Price, list_price, customers_rating, zapros_cena, badge_url, slug, list_new, g.group_name FROM SC_products p, SC_related_products r LEFT JOIN SC_related_groups g ON r.related_group=g.id_1c WHERE r.product='82abcd6c-d851-11e9-80d8-000c29177c1d' AND connection_type='Бумага' AND r.related_product=p.id_1c AND enabled=1 ORDER BY on_top DESC