- $r = q("SELECT `item`.`uri`, `thread`.`iid` AS `item_id`, $sql_order AS `order_date`
- FROM `thread` $sql_post_table
- STRAIGHT_JOIN `contact` ON `contact`.`id` = `thread`.`contact-id`
- AND (NOT `contact`.`blocked` OR `contact`.`pending`)
- STRAIGHT_JOIN `item` ON `item`.`id` = `thread`.`iid`
- AND (`item`.`gravity` != %d
- OR `contact`.`uid` = `item`.`uid` AND `contact`.`self`
- OR `contact`.`rel` IN (%d, %d) AND NOT `contact`.`readonly`)
- LEFT JOIN `user-item` ON `user-item`.`iid` = `item`.`id` AND `user-item`.`uid` = %d
- WHERE `thread`.`uid` = %d AND `thread`.`visible` AND NOT `thread`.`deleted`
- AND NOT `thread`.`moderated`
- AND (`user-item`.`hidden` IS NULL OR NOT `user-item`.`hidden`)
- $sql_extra2 $sql_extra3 $sql_range $sql_extra $sql_nets
- ORDER BY `order_date` DESC $pager_sql",
- intval(GRAVITY_PARENT),
- intval(Contact::SHARING),
- intval(Contact::FRIEND),
- intval(local_user()),
- intval(local_user())
- );
+ $params = ['order' => [$order_mode => true], 'limit' => [$pager->getStart(), $pager->getItemsPerPage()]];
+ $table = 'network-thread-view';