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; }