Zum durchforsten in der Datenbank sollten die SQL Anweisung weiterhelfen
Auflistung aller Gutscheine in den Bestellungen
SELECT
*
FROM s_order_details details
INNER JOIN s_order auftrag ON details.orderID = auftrag.id
INNER JOIN s_emarketing_vouchers voucher ON details.articleordernumber = voucher.ordercode
LEFT JOIN s_emarketing_voucher_codes code ON code.id=details.articleID
Auflistung der Bestelldaten nach Artikelnummer
SELECT
o.ordernumber as Besellnummer,
od.articleordernumber as Artikel,
od.quantity as Menge,
DATE_FORMAT(o.ordertime, "%d.%m.%Y %H:%i:%s") as Bestelldatum,
IF(u.salutation="ms", "Frau", "Herr") as Anrede,
u.firstname as Vorname,
u.lastname as Nachname,
u.email as Email
FROM s_order_details as od
LEFT JOIN s_order as o ON o.id=od.orderID
LEFT JOIN s_user as u ON u.id=o.userID
WHERE od.articleordernumber IN ("SW10013", "SW10015", "SW10016")
ORDER BY o.ordertime
