Cause of and means to avoid "flat BNL join" in mariadb 10.11...

Correlated queries without the LATERAL keyword...