Who has the most vistor messages on their profile?

[pgowder]

What would be the query to determine that?

Thanks!

[Lats]

Try this...

SELECT 
    user.username, 
    count( visitormessage.vmid ) AS vmcount
FROM 
    visitormessage
LEFT JOIN 
    user ON visitormessage.userid = user.userid
GROUP BY 
    user.username
ORDER BY 
    vmcount DESC 
LIMIT 
    20

[pgowder]

Thanks!

Try running this via vB Control Panel - no results.

[Lats]

Try the alternative - phpmyadmin

[Dilly]

Won't make a difference.

Did you add your table prefix in?

[Nick]

Won't make a difference.

Did you add your table prefix in?

Surprisingly, it actually would make a difference. http://www.vbulletin.com/forum/showthread.php?t=289226

[Dilly]

In that case, it's a bug.

[David Grove]

Reported.

[Lats]

The query works just fine in the ACP, without the vertical spacing. I just post it like that for clarity.

[David Grove]

Yes, vBulletin does some manipulation of the query string before execution, but the newlines cause their manipulation to fail in some cases.