sqlerror 1140

[amitsina]

im getting SQL error 1140 in the following code. The error goes away when I remove the WHERE statement but not otherwise. Can anyone please help me with the right syntax. Im a complete beginner here.
SELECT min(allusersinfo.alluserslevel) AS fdsfdsf, allusersinfo.allusersid
FROM allusersinfo
WHERE {$NXTFilter_Recordset1}
GROUP BY allusersinfo.allusersid
ORDER BY {$NXTSort_Recordset1}

DETAILS: I am using Dreamweaver Developer. I built this in Query Builder and the {$NXTFilter_Recordset1} comes from a dynamic list in Dreamweaver.

Any help is greatly appreciated.

[brotherhood of LAN]

A list of MySQL error codes are here for future reference:
[dev.mysql.com...]

Error: 1140
SQLSTATE: 42000 ER_MIX_OF_GROUP_FUNC_AND_FIELDS
Message: Mixing of GROUP columns MIN,MAX,COUNT,... with no GROUP columns is illegal if there is no GROUP BY clause

Perhaps you can provide a snippet of data from your table as well as what the variables would hold?