SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa
    LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
    LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
    LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
    WHERE pa.product_id = ''
    AND agd.language_id = '1'
    GROUP BY ag.attribute_group_id
    ORDER BY ag.sort_order, agd.name