SELECT acc_transactions_users.id_user AS 'Reçu', users.id AS 'idPers', users.nom AS 'Nom', printf('%.2f', SUM(acc_transactions_lines.credit)/100.) AS 'Montant', users.adresse AS 'Adresse', users.code_postal AS 'Code postal', users.ville AS 'Ville' FROM acc_transactions_users INNER JOIN users ON acc_transactions_users.id_user = users.id INNER JOIN acc_transactions ON acc_transactions_users.id_transaction = acc_transactions.id INNER JOIN acc_transactions_lines ON acc_transactions_lines.id_transaction = acc_transactions.id WHERE strftime('%Y', acc_transactions.date) = strftime('%Y', DATE('now', '-1 year')) GROUP BY users.id ORDER BY users.nom COLLATE NOCASE