Skip to content

Instantly share code, notes, and snippets.

@colinmurphy
Created March 14, 2019 08:32
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
Star You must be signed in to star a gist
Save colinmurphy/e40b4537f24ffe861cba365883139f48 to your computer and use it in GitHub Desktop.
Shopware - Get Name and Ordernumber for Products that allow backorders
SELECT d.ordernumber,a.name
FROM s_articles_details as d
INNER JOIN s_articles as a ON (
d.articleID = a.id
)
WHERE d.laststock != 1;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment