[TYPO3] Advanced query not advanced enough - part 2

[Michael Cannon]

Pieter,

Try the following cleaned up SQL query. It works fine on my 15,5000  
members system.

-----
SELECT username
	, usergroup
	, first_name
	, last_name
FROM fe_users
WHERE
	1 = 1
	AND fe_users.disable = 0
	AND fe_users.deleted = 0
	AND FIND_IN_SET('1' , fe_users.usergroup)
ORDER BY zip
-----

Look up FIND_IN_SET at http://dev.mysql.com/doc/refman/4.1/en/string- 
functions.html.

Michael

-----
Michael Cannon
President of Cannonbose, LLC
Tel    : +1 (603) 294-4418         Fax : +1 (802) 609-2776





Michael

-----
Michael Cannon
President of Cannonbose, LLC
Tel    : +1 (603) 294-4418         Fax : +1 (802) 609-2776