- FROM `item` WHERE `item`.`uid` = 0 AND `network` IN ('%s', '%s')
- AND `item`.`allow_cid` = '' AND `item`.`allow_gid` = ''
- AND `item`.`deny_cid` = '' AND `item`.`deny_gid` = ''
- ORDER BY `item`.`received` DESC LIMIT %d, %d",
- dbesc(NETWORK_DFRN),
- dbesc(NETWORK_DIASPORA),
+ FROM `thread`
+ INNER JOIN `item` ON `item`.`id` = `thread`.`iid`
+ WHERE `thread`.`uid` = 0
+ ORDER BY `thread`.`created` DESC LIMIT %d, %d",