$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 menu_id=70 and deleted=0 and published=1 order by cms_site_id";
$sites = $db->fetchAll($sql);
$photos = array();
foreach($sites as $v) {
$sql ="SELECT * FROM cms_files WHERE deleted=0 and type=2 and site_id=".$v['cms_site_id']." order by random() ";
$res = $db->fetchAll($sql);
$photos[$v['cms_site_id']] = array(
'site' => $v,
'photos' => $res
);
}
//_dp($photos,1);
?>