SELECT i.number, i.created_at, ii.description, (ii.quantity*ii.price) AS Total FROM invoice_items ii
INNER JOIN invoices i ON (i.id=ii.invoice_id)
WHERE i.client_id=57 AND i.created_at >= '2015-09-01'
ORDER BY i.created_at ASC;