Prestashop dump products & categories urls

dump.sql

## LIST CATEGORIES
SELECT CONCAT( `id_category`, '-',`link_rewrite`)
FROM  `ps3s_category_lang` WHERE id_lang = 1;

## LIST PRODUCTS
SELECT
	CONCAT( (SELECT (
			SELECT `link_rewrite` 
			FROM  `ps3s_category_lang` 
			WHERE id_lang = 1 
			AND id_category = pr.id_category_default
		) 
		FROM ps3s_product AS pr 
		WHERE id_product = ps.id_product 
		LIMIT 1
	), '/',ps.`id_product`, '-', ps.`link_rewrite`, '.html')
	
FROM  `ps3s_product_lang` AS ps ;

## LIST CMS

SELECT CONCAT( 'content/', `id_cms`, '-',`link_rewrite`)
FROM  `ps3s_cms_lang` WHERE id_lang = 1;