SELECT 
%s language_id,
category_id categories_id,
a.category_parent_id parent_id,
category_full_image categories_image,
list_order sort_order,
0 as TCGroupID,
category_name categories_name from 
<@PREFIX>vm_category b left join <@PREFIX>vm_category_xref a on a.category_child_id = b.category_id