- $r = dba::p("SELECT `item`.`uri`, `item`.`author-link` FROM `thread`
- INNER JOIN `user` ON `user`.`uid` = `thread`.`uid` AND NOT `user`.`hidewall`
- INNER JOIN `item` ON `item`.`id` = `thread`.`iid`
+ if (!is_null($accounttype)) {
+ $sql_accounttype = " AND `user`.`account-type` = ?";
+ $values = [$accounttype, $start, $itemspage];
+ } else {
+ $sql_accounttype = "";
+ $values = [$start, $itemspage];
+ }
+
+ /// @todo Use "unsearchable" here as well (instead of "hidewall")
+ $r = DBA::p("SELECT `item`.`uri`, `author`.`url` AS `author-link` FROM `thread`
+ STRAIGHT_JOIN `user` ON `user`.`uid` = `thread`.`uid` AND NOT `user`.`hidewall`
+ STRAIGHT_JOIN `item` ON `item`.`id` = `thread`.`iid`
+ STRAIGHT_JOIN `contact` AS `author` ON `author`.`id`=`item`.`author-id`