Dynamic Scope on Related Model and Then Sorting by Distance Using Spatial Functions and Row Numbering Techniques.

Retrieving Campaigns for a Specific User Based on Pivot Table: A More Efficient Approach

Converting Raw SQL Query to Laravel Eloquent: A Practical Guide