FROM album AS album
LEFT JOIN picture AS picture ON (album.coverpictureid = picture.pictureid AND picture.thumbnail_filesize > 0)
WHERE album.userid = 1261
AND album.state IN ('public', 'private', 'profile')
AND (album.visible > 0 OR album.moderation > 0)
ORDER BY album.lastpicturedate DESC
LIMIT 2;
MySQL Error : Unknown column 'album.userid' in 'where clause'
Error Number : 1054
Request Date : Tuesday, July 22nd 2008 @ 04:25:22 PM
Error Date : Tuesday, July 22nd 2008 @ 04:25:22 PM
Script : u=1261
Referrer :
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.0.51a-community