Skip to content

Instantly share code, notes, and snippets.

@PrestaEdit

PrestaEdit/gist:2661515384ff767ab753

Created January 15, 2016 15:32
Show Gist options
  • Save PrestaEdit/2661515384ff767ab753 to your computer and use it in GitHub Desktop.
Save PrestaEdit/2661515384ff767ab753 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
SELECT DISTINCT
p.id_product AS 'id_produit',
p.reference AS 'reference',
p.supplier_reference AS 'reference fournisseur',
pl.name AS 'designation' ,
p.id_category_default AS 'categorie par defaut',
m.name AS 'marque',
p.price AS 'prix_ht',
pl.description_short AS 'resume',
pl.description AS 'Description',
p.quantity AS 'quantite',
p.active AS 'Actif (0.1)'
FROM ps_product p
LEFT JOIN ps_category_product cp ON (p.id_product = cp.id_product)
LEFT JOIN ps_product_lang pl ON (p.id_product=pl.id_product)
LEFT JOIN ps_manufacturer m ON (p.id_manufacturer = m.id_manufacturer)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment