[Cello]

No help here at all. I swear. Where is the support?

SELECT albumpicture.*, album.*, user.username, user.usergroupid,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM albumpicture AS albumpicture
LEFT JOIN album AS album ON(album.albumid = albumpicture.albumid)
LEFT JOIN user AS user ON(user.userid = album.userid)
WHERE album.state = 'public'
ORDER BY rand(NOW()) DESC LIMIT 0, 5;

MySQL Error : Unknown column 'album.state' in 'where clause'
Error Number : 1054

I'm having that problem, can anyone help?