An Error Was Encountered

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''whatson'' at line 12

SELECT n.id nodeId, if(n.controller = 'buy', 'shop', n.controller), c.id pageId, coalesce(method.name, 'page') as method FROM (`node` n) JOIN `content_live` c ON c.nodeid = n.id and (c.typeid = 111 or c.typeid = 119) and c.rank = 1 and c.parentid is null LEFT JOIN `category` method ON method.id = c.custom9 LEFT JOIN `category` complex ON complex.id = c.cat0id WHERE if(c.typeid = '111',complex.rank = '1','1') and n.display = '1' AND if(n.controller = 'shop', 'buy', n.controller) 'whatson'