SELECT 
d.language_id,
c.categories_id,
parent_id,
c.categories_image,
sort_order,
0 as TCGroupID,
d.categories_name from <@PREFIX>categories c join <@PREFIX>categories_description d on
(c.categories_id = d.categories_id) where d.language_id = <@LANGUAGE_ID@>
