Locales that havn't finished translating an import yet

incomplete_locales.rb

class Import
  def self.incomplete_locales
    Locale.where(id:
      self.phrases.all_globally_pending.joins(
        'JOIN projects_locales'\
        ' on phrases_projects.project_id = projects_locales.project_id'\
        ' and projects_locales.status_id != 0'
      ).pluck('projects_locales.locale_id')
    )
  end
end