SELECT
*
FROM
cscart_wk_support_groups
LEFT JOIN cscart_wk_support_groups_descriptions ON cscart_wk_support_groups_descriptions.id = cscart_wk_support_groups.id
WHERE
1
AND cscart_wk_support_groups_descriptions.lang_code = 'en'
AND cscart_wk_support_groups.status = 'A'
ORDER BY
cscart_wk_support_groups.id asc