$db = Zend_Db_Table::getDefaultAdapter();
$sql = "SELECT s.* , (select lang_prefix from cms_lang_versions as l where l.cms_lang_version_id =s.lang_version_id) as lang_prefix FROM cms_sites as s where parent_id=546 and deleted=0 and published=1 order by cms_site_id desc limit 4";
$sites = $db->fetchAll($sql);
$photos = array();
foreach($sites as $v) {
$sql ="SELECT * FROM cms_files WHERE type=2 and site_id=".$v['cms_site_id']." order by cms_file_id desc ";
$res = $db->fetchAll($sql);
$photos[$v['cms_site_id']] = array(
'site' => $v,
'photos' => $res
);
}
//_dp($photos,1);
?>
NOWE ZDJĘCIA W GALERII
foreach($photos as $v):?>
foreach($v['photos'] as $k=>$vv):?>
if($k >0) break ?>