1
2
3
4
5
6
7
8
9
|
SELECT gl.id_group,gl.name,count( DISTINCT c.id_customer ) AS nb
FROM prstshp_group_lang gl
LEFT JOIN prstshp_customer c
inner JOIN prstshp_address a ON c.id_customer = a.id_customer AND a.postcode <> 'X'
ON c.id_default_group=gl.id_group and MONTH(c.date_add)=2 and YEAR(c.date_add)=2016
WHERE gl.id_lang=2
GROUP BY gl.id_group,gl.name
ORDER BY gl.name |
