CrystalEngine Database Error

Query:Select * from site_accommodation_tbl where active =1 and site_accommodation_tbl.guests = and site_accommodation_tbl.id!=467 order by rand() limit 3
Error:SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'and site_accommodation_tbl.id!=467 order by rand() limit 3' at line 3