Hi there

$result = pager_query(db_rewrite_sql("SELECT DISTINCT u.uid, u.name FROM {users} u LEFT JOIN {node} n ON n.uid = u.uid WHERE n.type = 'blog' AND n.status = 1 ORDER BY n.created DESC"), variable_get('default_nodes_main', 10));

seems to break on the pager. Look here http://staging.webschuur.com/blog/list for what I mean. DISTINCT correctly removes all users that have no blog entries. But either the pager, or the JOIN breaks the amount in the pager.

Anyone there who hasa n idea whats going on here?

Bèr