SELECT
<@LANGUAGE_ID@> language_id,
t.term_id categories_id,
'' categories_image,
tx.parent parent_id,
0 sort_order,
0 as TCGroupID,
t.name categories_name 

from  <@PREFIX>terms t 
join <@PREFIX>term_taxonomy tx on tx.term_id = t.term_id
where tx.taxonomy ='product_cat'  