https://sqlrelease.com/join-order-enforced-local-join-hint-used-warning-sql-server
The join order has been enforced because a local join hint is used - Warning in SQL Server