====== Dons ======

===== Dons année passée =====
  * jce <lesanges@free.fr>

++++Cliquer pour voir le code|
<code sql>
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
</code>
++++

{{tag>sql}}