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,
	users,
	acc_transactions
	INNER JOIN acc_transactions_lines
	ON acc_transactions_lines.id_transaction = acc_transactions.id
WHERE (
	strftime('%Y', acc_transactions.date) =  strftime('%Y',  DATE('now', 'start of year', '-1 year'))
	AND
		acc_transactions_lines.credit > 0
	AND
		acc_transactions_users.id_transaction = acc_transactions.id
	AND
		acc_transactions_users.id_user = users.id
	)
GROUP BY acc_transactions_users.id_user
ORDER BY users.nom COLLATE NOCASE