All pastes #564461 Raw Edit

Noel

public sql v1 · immutable
#564461 ·published 2007-06-13 16:31 UTC
rendered paste body
SELECT Distinct i.userid, i.invoice_id, i.invoice_date, p.duration, m.nameFROM mi_invoices as iLEFT JOIN mi_packages as p on p.package_id=i.package_idLEFT JOIN mi_members as m on m.userid=i.useridWHERE (i.package_id=1) || (i.package_id=2)ORDER BY i.userid, i.invoice_id DESC