https://bytefoundries.com/2025/07/14/underlying-principles-of-mysql-join-queries/