protected static function selectChilds($nSitemapId, $szAdditionalSQL, $orderCondition, $nStart, $nCount)
{
$nSitemapId = intval($nSitemapId);
$nCount = intval($nCount);
$nStart = intval($nStart);
$nStart = $nStart < 0 ? 0 : $nStart;
$sql = 'SELECT SQL_CALC_FOUND_ROWS * FROM `%s` WHERE `parent`="%d" %s ORDER by %s';
if (!empty($nCount)) {
$sql .= ' LIMIT %d,%d';
} else {
}
$orderCondition = empty($orderCondition) ? '`order` asc' : $orderCondition;
if (!defined('CMS')) {
$szAdditionalSQL .= 'and `visible`=1 ';
}
$sql = sprintf($sql, SITEMAP_TABLE, $nSitemapId, $szAdditionalSQL, $orderCondition, $nStart, $nCount);
$aItem = DB::query($sql);
//
if (!empty($nCount)) {
$aFound = DB::get('SELECT FOUND_ROWS() as `totalcount`');
self::$nTotalCount = $aFound['totalcount'];
}
return $aItem;
}
