Failed to execute the SQL query

select c.title, c.icon, i.title from  gre__channels  c inner join  gre__item  i on i.cid = c.id where c.id =  and i.id=04 and not(i.unread & 8) 

Error 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 i.id=04 and not(i.unread & 8)' at line 1