SELECT pd.price, cgd.name, pd.customer_group_id FROM `oc_product_discount` pd LEFT JOIN `oc_customer_group_description` cgd ON (pd.customer_group_id = cgd.customer_group_id AND cgd.language_id = '1') WHERE product_id = '17007' ORDER BY pd.customer_group_id