Error: Unable to perform query: (SELECT DISTINCT e.name, c.role_id, path, primary_contributor, othernames FROM CONTRIBUTORS c, ROLE r, ENTITY e LEFT JOIN scottis2_cms.smic_members m ON m.entity_id = e.entity_id WHERE e.entity_id = r.entity_id AND r.role_id = c.role_id AND cardbox_id = ) UNION (SELECT DISTINCT e.name, c.role_id, path, primary_contributor, othernames FROM CONTRIBUTORS c, ROLE r, ENTITY e LEFT JOIN scottis2_cms.smic_members m ON m.entity_id = e.entity_id WHERE e.entity_id = r.entity_id AND r.role_id = c.role_id AND works_id = 0) ORDER BY primary_contributor DESC, othernames :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 ') UNION (SELECT DISTINCT e.name, c.role_id, path, primary_contri