lol.php

<?php

    public function getSitePositionAds($site_id, $position_id, $container_width)
    {
        $ads = Ad::leftJoin('sites', 'sites.id', '=', \DB::raw($site_id))
            ->leftJoin('positions', 'positions.id', '=', \DB::raw($position_id))
            ->leftJoin('ad_position', function ($join) use ($position_id) {
                $join->on('ad_position.ad_id', '=', 'ads.id')
                    ->on('ad_position.position_id', '=', 'positions.id');
            })
            ->leftJoin('ad_site', function ($join) use ($site_id) {
                $join->on('ad_site.ad_id', '=', 'ads.id')
                    ->on('ad_site.site_id', '=', 'sites.id');
            })
            ->where('ad_site.is_excluded', false)
            ->where('ads.max_position_width', '<=', $container_width)
            ->where(function ($query) {
                $query->where('ads.limit_displays', '>', 0)
                    ->orWhereNull('ads.limit_displays');
            })
            ->where(function ($query) {
                $query->where('ad_position.limit_displays', '>', 0)
                    ->orWhereNull('ad_position.limit_displays');
            })
            ->where(function ($query) {
                $query->where('ad_site.limit_displays', '>', 0)
                    ->orWhereNull('ad_site.limit_displays');
            })
            ->get();

        return $ads->toJson();
    }