# File engines/member/app/actions/member/content_search/scope/sites_search.rb, line 5
def sites_search_scope(model)
  DB::Site
    .select(sites_table[Arel.star])
    .joins(sites_to_settings)
    .joins(sites_to_email_templates)
    .where(
      content_in_period(model).exists
    ).where(
      site_in_time_zones
    ).where(
      email_templates_table[:path].eq(notification_template)
    ).order(sites_table[:id].asc)
end