Export PrestaShop products with seo URLs (including category)

ps.sql

# Export PrestaShop products with seo URLs (including category)
# id_lang = xxx, id_shop = yyy (default 1 if not multistore)

SELECT p.id_product, pl.name, CONCAT("https://example.com/", cl.link_rewrite, "/", p.id_product, "-", pl.link_rewrite, ".html") AS url, p.date_add, p.date_upd
FROM ps_product p
INNER JOIN ps_product_lang pl ON (p.id_product = pl.id_product AND pl.id_lang = 1 AND pl.id_shop = 1)
INNER JOIN ps_category_lang  cl ON (p.id_category_default = cl.id_category AND cl.id_lang = 1 AND cl.id_shop = 1)  
WHERE p.active = 1
ORDER BY `p`.`id_product` DESC