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 -- | Bèr Kessels | webschuur.com | website development | | Turnhoutsebaan 34/3 | 2140 Antwerpen | België | | IM: ber@jabber.org.uk | MSN: berkessels@gmx.net | | pers: bler.webschuur.com | prof: www.webschuur.com | Regards, Bèr -- [ Bèr Kessels | Drupal services www.webschuur.com ]