I'm puzzled as to why this query is not working. There is a column named 'access' in the mos_content table (int(11) unsigned). I get the mysql error above when executing.
SELECT c.*, g.name AS groupname, cc.name, u.name AS editor, f.content_id AS frontpage, s.title AS section_name, v.name AS...