- $items = q("SELECT `item`.*, `sign`.`signed_text`,`sign`.`signature`,`sign`.`signer`
- FROM `item` LEFT JOIN `sign` ON `sign`.`iid` = `item`.`id` WHERE `parent` = %d AND visible AND NOT moderated ORDER BY `id` ASC",
- intval($parent_id)
- );
+ $condition = ['parent' => $parent_id, 'visible' => true, 'moderated' => false];
+ $params = ['order' => ['id']];
+ $ret = Item::select([], $condition, $params);