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.related_product='8f8acaaf-dac5-11e5-9ff7-e4115bd5b719' AND reverse_connection_type='СовместимыеУстройства' AND r.product=p.id_1c AND enabled=1 ORDER BY on_top DESC