Skip to content

Instantly share code, notes, and snippets.

@Hotfirenet

Hotfirenet/listReferenceWithAvailableNowMessage.sql

Last active April 12, 2017 12:10
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Hotfirenet/e7099d312471a2f4576d9f52fcfe8fb5 to your computer and use it in GitHub Desktop.
Save Hotfirenet/e7099d312471a2f4576d9f52fcfe8fb5 to your computer and use it in GitHub Desktop.
Download ZIP
Liste les références actives d'un catalogue prestashop qui ont un message disponible maintenance
Raw
listReferenceWithAvailableNowMessage.sql
SELECT reference FROM ps_product P
INNER JOIN ps_product_lang PL ON PL.id_product = P.id_product
WHERE P.active = 1 AND (PL.available_now IS NOT NULL AND PL.available_now <> '')
GROUP BY reference
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment