SELECT
<@LANGUAGE_ID@> language_id,
p.product_id products_id,
p.category_id categories_id,
concat('img_categories/',c.category_image) categories_image,
c.category_parent_id parent_id,
c.ordering sort_order,
c.`name_nl-NL`  categories_name 
from <@PREFIX>jshopping_products_to_categories p join <@PREFIX>jshopping_categories c on 
(p.category_id = c.category_id) 

 
