Loris Pinna DevLoris

🍍

working

freelance designer & developer

DevLoris / dump.sql

Last active May 12, 2021 06:09

Prestashop dump products & categories urls

	## 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

DevLoris / 1f44c.png

Last active October 8, 2019 10:17

outch