SELECT u.id, u.username, u.email, ue.email
FROM users u
INNER JOIN user_emails ue ON u.id = ue.id
WHERE ue.primary = true
That worked
I was thrown off by the one email that was there; but I guess that’s a remnant of running
cd /var/discourse
./launcher enter app
rake admin:create
when I was troubleshooting my email troubles.