TMPLNode::showSimpleList SELECT t.* , uia.accessvector FROM (submenu t inner join (SELECT u.id AS accessuser_id, i.id AS accessitem_id, bit_or(a.accessvector) AS accessvector FROM xusers u, xaccess a, xitem i WHERE ((a.relation_id = u.id AND u.id=-1) OR (a.relation_id IN ( SELECT getrelationsgroups.getrelationsgroups FROM getrelationsgroups(-1)))) AND i.id = a.item_id GROUP BY u.id, i.id) uia on t.id=uia.accessitem_id and uia.accessuser_id=-1) WHERE hidemenu='0' and t.level <= 3 AND t.parents[array_upper(t.parents,1)] = ANY(ARRAY[contents]) AND tablename <> 'casestories' AND accessvector & 1 = 1 ORDER BY t.sortorder [nativecode=ERROR: column "contents" does not exist]