SELECT 
0 language_id,
c.category_id categories_id,
c.category_parent_id parent_id,
0 sort_order,
0 as TCGroupID,
c.category_name categories_name from <@PREFIX>hikashop_category c
where c.category_type='product' and 
category_name <> 'product category'
 
