$db = Zend_Db_Table::getDefaultAdapter();
$sql ="select
s.*
from cms_sites as s
where
s.deleted = 0 and s.parent_id=451 and s.published=1 order by s.cms_site_id desc";
$tmp = $db->fetchAll($sql);
$sites = array();
foreach($tmp as $v) {
$item = array();
$item['site'] = $v;
$item['url'] = Telekom_Cms_Url_Default::getUrl(array(
'siteId' => $v['cms_site_id'],
'subsiteId' => 0,
'lang' => 'pl',
'name' => Telekom_Cms::disablePhpCode($v['name']),
'get' => null
));
$sql = "SELECT * FROM cms_files WHERE site_id=".$v['cms_site_id']." and deleted=0 and published=1 order by cms_file_id desc limit 5;";
$files = $db->fetchAll($sql);
$item['files'] = $files;
$sites[] = $item;
}
//_dp($sites,1);
?>






































