Odd It works great on my site, yet when I try to do it on another I get some SQL Error.
Code:
Database error in vBulletin 3.0.7:
Invalid SQL:
SELECT user.userid,username
FROM user
LEFT JOIN subscriptionlog as subscriptionlog ON (subscriptionlog.userid = user.userid)
WHERE subscriptionlog.status = '1' ORDER BY regdate DESC LIMIT 10
mysql error: Table 'theflyfi_forums.user' doesn't exist
mysql error number: 1146
Date: Monday 02nd of May 2005 05:09:17 PM
Script: http://www.theflyfishingforum.com/
Referer:
Username:
IP Address: