[drupal-support] sql guru pager question

Bèr Kessels berdrupal at tiscali.be
Thu Mar 17 23:15:02 UTC 2005


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 at jabber.org.uk | MSN: berkessels at gmx.net |
| pers: bler.webschuur.com | prof: www.webschuur.com |
Regards,
 Bèr
-- 
 [ Bèr Kessels | Drupal services www.webschuur.com ]



More information about the drupal-support mailing list