Select all active articles in a Shopware 5.x database which have unsupported special characters in the ordernumber.

select_unsupported_ordernumbers.sql

/*
  Select all active articles in a Shopware 5.x database
  which have unsupported special characters in the ordernumber.
  (Supported special characters are: . - _)
*/

SELECT
    sad.ordernumber,
    sa.name AS 'ArticleName',
    sa.active,
    sas.name AS 'SupplierName'    
FROM
    s_articles sa
LEFT JOIN
    s_articles_details sad
ON
    sa.id = sad.articleID
LEFT JOIN
    s_articles_supplier sas
ON
    sa.supplierID = sas.id
WHERE
    sa.active = 1
AND
    sad.ordernumber REGEXP '[^a-zA-Z0-9\-\_\.]';