'-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. Pasirinkite kelionę į norimą šalį $z_viet."; $page_footer=$page_h1; $short_desc=$page_description; $top_links_arr[0] = array($page_h1,'',''); $kategorijos[2]=array("$z_name","Туры в $z_gal","/keliones_pagal_sali/".$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 AND k.top_kelione=1 GROUP BY s.id ORDER BY name ASC "; $rezultatai_top=mysql_query($sql,$db1); $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,"",''); #} ?>