Export link products

[antonio04]

I need to export the links to my products via sql.

I use this query:

 

SELECT `name` , `link_rewrite` , `id_product`
FROM  `ps_product_lang` ;

This only exports the rewrite link of the article.
I would like to export also the rewrite of the category, can someone help me?

Grazie

[musicmaster]

in the shop table you will also find a field     id_category_default

You can use that to link to the ps_category_lang table

[antonio04]

Ok