/** * @param \Sofa\Eloquence\Builder $query * @param array $publications * @return mixed */ public function scopePublishedOn($query, $publications) { return $query->whereIn('id_170', function ($query) use($publications) { $query->select('hotel_id_175')->from('007_175_hotels_publications')->whereIn('publication_id_175', $publications); }); }