Ambiguous query when not admin on signup administration.

I get the following statement when i am not logged in as the administrator account.
user warning: Column 'nid' in field list is ambiguous query: SELECT COUNT(nid) FROM signup s INNER JOIN node_access na ON na.nid = s.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 4 AND na.realm = 'content_access_author') OR (na.gid = 2 AND na.realm = 'content_access_rid') OR (na.gid = 4 AND na.realm = 'content_access_rid') OR (na.gid = 2 AND na.realm = 'term_access') OR (na.gid = 4 AND na.realm = 'term_access')))
This happens when I give a role full permissions and they visist the page admin/content/signup

I am running mysql5 don't know if this is a mysql syntactical error specific to this version or if this is across all versions of mysql.