requete :SELECT sum(extra) as extra, sum(vente) as vente, sum(if (method, prix, 0)+if (emethod, extra, 0)+if (vmethod, vente, 0)) s1,
sum(if (method, 0, prix)+if (emethod, 0, extra) +if (vmethod, 0, vente)) s2, sum(remise) remiseT, sum(if (prix > 0, 1, 0)) as cnt, YEAR(date) Y, 0 m
FROM rdv WHERE prix + vente > 0 AND status = 1 AND YEAR(date) > 2013 GROUP BY YEAR(date) order by date desc
erreur:1146=>Table 'scoobydomicharly.rdv' doesn't exist
requete :SELECT YEAR(created_at) as Y, count(1) as cnt
FROM client WHERE 1 GROUP BY YEAR(created_at) order by created_at desc
erreur:1146=>Table 'scoobydomicharly.client' doesn't exist
Stats
2026202520242023202220212020201920182017201620152014
| date |
cheque |
espece |
extra |
vente |
remise |
rdv |
total |
moyenne |
| Année |
Code postal |
Nb rdv |
pourcent |
| Année |
Provenance |
Nb rdv |
pourcent |
| Races |
Total |
Max |
Min |
Moyenne |