Stroomversnellers

Powered by Quality Time Group - duurzaam, sociaal, betrokken

Sponsorstanden

Posted on 14 feb 2018 Reacties uitgeschakeld voor Sponsorstanden

[tablemaster sql=”SELECT concat(‘€’, round(sum(dm_amount),2)) AS ‘Totaal opgehaald bedrag’ from wp_donate_mollie where dm_status = ‘paid’ and time between ‘2019-01-01 *’ and ‘2019-12-31 *'”]
[tablemaster sql=”SELECT count(dm_amount) AS ‘Aantal Donaties’ from wp_donate_mollie where dm_status = ‘paid’ and time between ‘2019-01-01 *’ and ‘2019-12-31 *'”]
[tablemaster sql=”SELECT concat(‘€’,ROUND(AVG(dm_amount), 2)) AS ‘Gemiddelde Donatie’ from wp_donate_mollie where dm_status = ‘paid’ and time between ‘2019-01-01 *’ and ‘2019-12-31 *'”]

[tablemaster rows=”20″ datatables=”true” sql=”SELECT dm_project AS Naam, concat(‘Totaalbedrag €’, round(sum(dm_amount),2)) AS Totaal from wp_donate_mollie where dm_status = ‘paid’ and time between ‘2019-01-01 *’ and ‘2019-12-31 *’ group by dm_project ORDER BY dm_project ASC”]