Jump to content

Edit History

Eolia

Eolia 

SELECT 
	p.id_product 'Product ID',
	p.reference 'Reference',
	pl.name 'Product Name',
	ps.price 'Price',
	ps.wholesale_price 'Wholesale Price',
	s.quantity 'Quantity'
FROM ps_product p
INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1)
LEFT JOIN ps_product_lang pl ON (p.id_product = pl.id_product)
INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product)
LEFT JOIN ps_category_lang cl ON (cp.id_category = cl.id_category and cl.id_lang=2)
INNER JOIN ps_stock_available s ON (p.id_product = s.id_product)
GROUP BY p.id_product
ORDER by p.reference

 

Eolia

Eolia 

SELECT 
	p.id_product 'Product ID',
	p.reference 'Reference',
	pl.name 'Product Name',
	ps.price 'Price',
	ps.wholesale_price 'Wholesale Price',
	s.quantity 'Quantity'
FROM ps_product p
LEFT JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1)
LEFT JOIN ps_product_lang pl ON (p.id_product = pl.id_product)
LEFT JOIN ps_category_product cp ON (p.id_product = cp.id_product)
LEFT JOIN ps_category_lang cl ON (cp.id_category = cl.id_category and cl.id_lang=2)
LEFT JOIN ps_stock_available s ON (p.id_product = s.id_product)
GROUP BY p.id_product
ORDER by p.reference

 

×
×
  • Create New...