[Cello]

I'm getting this error. Can anyone help?

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