laravel-tips/content/tips/you-can-avoid-many-n1-issues-by-using-lateral-joins-in-mysql.md

title	tweet_id	thread_slug	author_username	images	created_at	slug
You can avoid many n+1 issues by using lateral joins in MySQL	1530215268915417089	weekly-thread-2022-21	tobias_petry	https://pbs.twimg.com/media/FTmHagcX0AEBn_k.jpg	2022-05-27T15:52:04+00:00	you-can-avoid-many-n1-issues-by-using-lateral-joins-in-mysql

⚡️ Database Tip

Sometimes you want to get e.g. the last three orders for every customer. Normal joins can't do that. You have to execute n+1 queries in code, which is slow!

But with lateral joins, you can do one for-each loop join in SQL 🤯 https://sqlfordevs.com/for-each-loop-lateral-join