The problem was we could not select fields that we had created to appear in columns on a list that we wanted to make in Community Builder.

The SQL required the fields to be published and in the profile so we edited “AND f.profile = 1” from the query in the code (around line 185 when editing in Joomlaxplorer) that gets the fields I got this info from here