AW: [dbs] Abfrage nach Anzahl

[News]

Hallo,

hier noch mal die komplette Abfrage

SELECT sms_user.*, sms_user.username as title, sms_user.ip_date as
title3, COUNT(sms_stats.id) AS stat_anzahl FROM sms_user,sms_stats WHERE
1=1 AND sms_user.id=sms_stats.id_user AND stat_anzahl > '4' GROUP BY
sms_user.id ORDER BY
sms_user.company,sms_user.lastname,sms_user.firstname Unknown column
'stat_anzahl' in 'where clause' /dbs