I just thought maybe higher permissions were needed with the work around I found.
I modified ‘SET SQL_BIG_SELECTS=1’ workaround to be at the session level
SET SESSION SQL_BIG_SELECTS=1.
That solved the SQL failure.
I should have worked a little more before asking for help.