More joins replaced by view calls

[friendica.git] / mod / poco.php

diff --git a/mod/poco.php b/mod/poco.php
index f04ec42790f1a08b37fdd80dc2122ce07a331cdb..edbe73dceaffe825ceb1bc345f425764e71d8c8d 100644 (file)
--- a/mod/poco.php
+++ b/mod/poco.php
@@ -81,10 +81,7 @@ function poco_init(App $a) {
        }
 
        if (!$system_mode && !$global) {
-               $user = DBA::fetchFirst("SELECT `user`.`uid`, `user`.`nickname` FROM `user`
-                       INNER JOIN `profile` ON `user`.`uid` = `profile`.`uid`
-                       WHERE `user`.`nickname` = ? AND NOT `profile`.`hide-friends`",
-                       $nickname);
+               $user = DBA::selectFirst('owner-view', ['uid', 'nickname'], ['nickname' => $nickname, 'hide-friends' => false]);
                if (!DBA::isResult($user)) {
                        throw new \Friendica\Network\HTTPException\NotFoundException();
                }