SELECT 
2 language_id,
b.product_id products_id,
b.category_id categories_id,
c.category_thumb_image categories_image,
0 parent_id,
0 sort_order,
c.category_name categories_name 
from <@PREFIX>vm_product_category_xref  b join <@PREFIX>vm_category c on 
(b.category_id = c.category_id) 