SELECT
<@LANGUAGE_ID@> language_id,
category_id categories_id,
category_parent_id parent_id,
concat('img_categories/', category_image) categories_image,
ordering sort_order,
0 as TCGroupID,
`name_nl-NL` categories_name from <@PREFIX>jshopping_categories  