-
- $values[] = $itemspage;
-
- /// @todo Use "unsearchable" here as well (instead of "hidewall")
- $r = DBA::p("SELECT `item`.`uri`, `author`.`url` AS `author-link`, `thread`.`commented` 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`
- WHERE `thread`.`visible` AND NOT `thread`.`deleted` AND NOT `thread`.`moderated`
- AND NOT `thread`.`private` AND `thread`.`wall` AND `thread`.`origin`
- $sql_accounttype
- $sql_boundaries
- ORDER BY `thread`.`commented` DESC
- LIMIT ?", $values);