Tom Ellis wrote on medium.com this interesting article about how to use Straight Joins in Laravel 4 and 5
I came across an issue where I needed to do a STRAIGHT_JOIN to force a query plan in Mysql, but as I was using Laravel I didn’t want to have to re-write what I’d already done as raw queries. Turns out its not too hard to get it working