✨ Rewrite INNER JOIN where only the LEFT table is referenced in WHERE/HAVING/SELECT clauses as SEMI JOIN

[joocer]

trafficstars

This is generally being used as a containment test for the LEFT table, rewriting as a SEMI JOIN will be faster.