v_overview (view)

Data license: Intern · Data source: PayPal CSV + PDF-Belege

11,369 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source, type, date (date)

Next page

CREATE VIEW v_overview AS
SELECT 
    t.date, t.amount, t.counterparty, t.description, t.source, t.type,
    GROUP_CONCAT(DISTINCT r.filename) as receipts,
    GROUP_CONCAT(DISTINCT b.description) as bookings
FROM transactions t
LEFT JOIN links l ON l.transaction_id = t.id
LEFT JOIN receipts r ON r.id = l.receipt_id
LEFT JOIN bookings b ON b.id = l.booking_id
GROUP BY t.id
ORDER BY t.date DESC;