I tried many variations (with populate and without filter, with filter and without populate, and both). Could not get the result I wanted. So I ended up just doing direct database queries instead. Can’t spend too long with an API that just won’t work. This was much cleaner:
const rows = await strapi.db.connection.context.raw(`
SELECT <query here>;
`);