'-1' AND s.id<>0
AND k.id=ka.kelione AND (ka.dat='0000-00-00' OR ka.dat>'$siandien')
AND s.zemyno_regionas=zr.id AND zr.zemynas=z.id
AND z.code='$zemynas'
GROUP BY s.id
ORDER BY name ASC ";
$rezultatai=mysql_query($sql,$db1);
$sql="SELECT z.name as z_name, z.galininkas as z_gal, z.vietininkas as z_viet
FROM zemynai z
WHERE z.code='$zemynas' ";
$rezultatai1=mysql_query($sql,$db1);
$first=mysql_fetch_array($rezultatai1);
$z_name=win2utf($first['z_name']);
$z_gal=win2utf($first['z_gal']);
$z_viet=win2utf($first['z_viet']);
$page_h1="Туры в $z_gal";
$page_title="Туры в $z_gal | AZA tours";
$page_keywords="$z_name, туры в $z_gal, туры, тур, $z_viet";
$page_description="Туры в $z_gal. Выберите страну $z_viet.";
$page_footer=$page_h1;
$short_desc=$page_description;
$top_links_arr[0] = array($page_h1,'','');
$kategorijos[2]=array("$z_name","Туры в $z_gal","/tury_po_stranam/".$zemynas);
if (($salis_id==62)||($salis_id=155)) $salis_id=0;
} else {
$siandien=date("Y-m-d");
$sql="SELECT s.*, COUNT(DISTINCT k.id) as kelioniu_sk
FROM salys s, keliones k, kainos ka
WHERE ((s.id=k.salis1)OR(s.id=k.salis2)OR(s.id=k.salis3)) AND s.id<>'-1' AND s.id<>0
AND ka.kelione=k.id AND (ka.dat>'$siandien' OR ka.dat='0000-00-00')
AND k.tipas=1
GROUP BY s.id
ORDER BY name ASC ";
$rezultatai=mysql_query($sql,$db1);
$page_h1="Туры по странам";
$page_title="Туры по странам | Выберите страну";
$page_keywords="туры, по странам, страна, страны, выберите";
$page_description="Туры по странам. Выберите из списка.";
$page_footer=$page_h1;
$short_desc=$page_description;
$top_links_arr[0] = array($page_h1,"",'');
}
?>
