-
- $r = qu("SELECT %s
- FROM `thread`
- INNER JOIN `item` ON `item`.`id` = `thread`.`iid` %s
- WHERE `thread`.`uid` = 0
- ORDER BY `thread`.`created` DESC LIMIT %d, %d",
- item_fieldlists(), item_joins(),
- intval($start), intval($itemspage)
+ $r = dba::p("SELECT ".item_fieldlists()." FROM `thread`
+ INNER JOIN `item` ON `item`.`id` = `thread`.`iid` ".item_joins().
+ "WHERE `thread`.`uid` = 0 AND `verb` = ?
+ ORDER BY `thread`.`created` DESC LIMIT ".intval($start).", ".intval($itemspage),
+ ACTIVITY_POST