<?php
$o = '';
$o .= '<ul>';
$result = $modx->db->query('SELECT * FROM `modx_site_content` WHERE parent = 29 AND published = 1 AND deleted = 0 ORDER BY pagetitle ASC LIMIT 0, 30 ');
$rs = $modx->db->makeArray( $result );
foreach( $rs as $val ) {
$o .= '<li><a href="[~'.$val['id'].'~]" title="'.$val['pagetitle'].'">'.$val['pagetitle'].'</a></li>';
}
$o .= '</ul>';
return $o;
?>