original_string: public function getUnreviewedSelectQuery(LocaleEntity $locale)
      {
          $cn = $this->app->make(EntityManager::class)->getConnection();
          $queryLocaleID = $cn->quote($locale->getID());
  
          return $cn->executeQuery(
              $this->getBaseSelectString($locale, false, false) .
              " inner join
                  (
                      select distinct
                          translatable
                      from
                          CommunityTranslationTranslations
                      where
                          locale = $queryLocaleID
                          and
                          (
                              (approved is null)
                              or
                              (current = 1 and approved = 0)
                          )
                  ) as tNR on CommunityTranslationTranslatables.id = tNR.translatable
              order by
                  CommunityTranslationTranslatables.text
              "
          );
      }
code: public function getUnreviewedSelectQuery(LocaleEntity $locale)
      {
          $cn = $this->app->make(EntityManager::class)->getConnection();
          $queryLocaleID = $cn->quote($locale->getID());
  
          return $cn->executeQuery(
              $this->getBaseSelectString($locale, false, false) .
              " inner join
                  (
                      select distinct
                          translatable
                      from
                          CommunityTranslationTranslations
                      where
                          locale = $queryLocaleID
                          and
                          (
                              (approved is null)
                              or
                              (current = 1 and approved = 0)
                          )
                  ) as tNR on CommunityTranslationTranslatables.id = tNR.translatable
              order by
                  CommunityTranslationTranslatables.text
              "
          );
      }
code_tokens: public function getUnreviewedSelectQuery ( LocaleEntity $ locale ) { $ cn = $ this -> app -> make ( EntityManager :: class ) -> getConnection ( ) ; $ queryLocaleID = $ cn -> quote ( $ locale -> getID ( ) ) ; return $ cn -> executeQuery ( $ this -> getBaseSelectString ( $ locale , false , false ) . " inner join
                  (
                      select distinct
                          translatable
                      from
                          CommunityTranslationTranslations
                      where
                          locale = $queryLocaleID
                          and
                          (
                              (approved is null)
                              or
                              (current = 1 and approved = 0)
                          )
                  ) as tNR on CommunityTranslationTranslatables.id = tNR.translatable
              order by
                  CommunityTranslationTranslatables.text
              " ) ; }
docstring: Get the recordset of all the translations of a locale that needs to be reviewed.
  
  @param LocaleEntity $locale
  
  @return PDOStatement
docstring_tokens: Get the recordset of all the translations of a locale that needs to be reviewed .