getUser($request))) { throw new AuthorizationFailedException(); } list($offset, $limit) = $this->getOffsetAndLimit(); $total = \Theme::countBySQL('1'); $themes = \Theme::findBySQL("1 ORDER BY name ASC LIMIT {$offset}, {$limit}"); return $this->getPaginatedContentResponse($themes, $total); } }