Minimieren Sie SQL online – kostenloser SQL-Kompressor

-- Aktive Kunden mit aktuellen Bestellungen AUSWÄHLEN c.id, c.email, o.total, o.created_at VON Kunden AS c INNER JOIN-Bestellungen AS o ON o.customer_id = c.id WO c.active = TRUE UND o.status = 'abgeschlossen' ORDER BY o.created_at DESC LIMIT 50;

SELECT c.id, c.email, o.total, o.created_at FROM customer AS c INNER JOINorders AS o ON o.customer_id = c.id WHERE c.active = TRUE AND o.status = 'completed' ORDER BY o.created_at DESC LIMIT 50;