All users not showing

[UK10]

Since recently not all user are showing on the user galleries page (index.php?cat=1).
I worked out that the error is to do with the following query.

Code Select Expand

SELECT user_id as user_id,user_name as user_name,COUNT(DISTINCT a.aid) as alb_count,COUNT(DISTINCT pid) as pic_count,MAX(pid) as thumb_pid, MAX(galleryicon) as gallery_pid FROM cpg135_albums AS a INNER JOIN `dpspot_fotoupg`.cpg135_users as u on u.user_id = a.category - 10000 INNER JOIN cpg135_pictures AS p ON p.aid = a.aid WHERE ((isnull(approved) or approved='YES') AND category > 10000)  GROUP BY category ORDER BY category LIMIT 0, 9

Also I tried changing the LIMIT 0,9 to LIMIT 0,500 in phpMyAdmin and then it does show the results that I am looking for.

Link is http://www.dutchplanespotters.nl/_dev/cpg143/index.php

Can anyone help to fix this problem?

[Nibbler]

http://forum.coppermine-gallery.net/index.php?topic=35151