<!--SELECT jazyky_prezentace.domena, jazyky_prezentace.id_jazyk IS NOT NULL AS prezentace FROM jazyky LEFT JOIN jazyky_prezentace ON jazyky.id = jazyky_prezentace.id_jazyk AND jazyky_prezentace.id_mesto = 68 WHERE jazyky.id = 'cz'//--><!--SELECT 1 FROM come_from WHERE nazev = 'pages-map' LIMIT 1//--><!--SELECT url.* FROM url WHERE (id_mesto = 68 OR id_mesto IS NULL) AND (url_cz = 'pages-map' OR url_cz = 'pages-map`') ORDER BY id_mesto DESC//--><!--SELECT TRIM(TRAILING '`' FROM url.url_cz) FROM stranka INNER JOIN url ON tabulka = 'stranka' AND stranka.id = url.tabulka_id WHERE (stranka.id_mesto = 68 OR stranka.id_mesto IS NULL) AND stranka.specialni = 'order'//--><!--SELECT * FROM stranka WHERE id = '18'//--><!--SELECT idf, preklad_cz FROM prague.preklady WHERE puvod = 'sablony'//--><!--SELECT TRIM(TRAILING '`' FROM mesto_cz), TRIM(TRAILING '`' FROM meste_cz) FROM nastaveni WHERE id = 68//--><!--SELECT * FROM url WHERE (id_mesto = 68 OR id_mesto IS NULL) AND (url_cz = 'pages-map' OR url_cz = 'pages-map`')//--><!--SELECT jazyky.*, jazyky_prezentace.domena FROM jazyky INNER JOIN jazyky_prezentace ON jazyky.id = jazyky_prezentace.id_jazyk WHERE jazyky_prezentace.id_mesto = 68 ORDER BY jazyky.poradi//--><!--SELECT COUNT(*) FROM pruvodce WHERE id_mesto = 68//--><!--SELECT COUNT(*) FROM teplota WHERE id_mesto = 68//--><!--
		SELECT
			REPLACE(REPLACE(stranka.nadpis_cz, '#mesto', nastaveni.mesto_cz), '#meste', nastaveni.meste_cz) AS nadpis_cz,
			REPLACE(REPLACE(stranka.popisek_cz, '#mesto', nastaveni.mesto_cz), '#meste', nastaveni.meste_cz) AS popisek_cz,
			url.url_cz,
			(url.url_cz IN ('pages-map', 'pages-map`') OR COUNT(url2.id) > 0) AS aktivni,
			LEFT(url.url_cz, 7) = 'http://' AS new_window
		FROM stranka
		LEFT JOIN stranka_skryt_servery ON stranka.id = stranka_skryt_servery.id_stranka AND stranka_skryt_servery.id_server = 71
		INNER JOIN nastaveni ON nastaveni.id = 68
		INNER JOIN url ON stranka.id = url.tabulka_id AND url.tabulka = 'stranka'
		LEFT JOIN stranka stranka2 ON stranka.id = stranka2.skupina
		LEFT JOIN url url2 ON url2.id_mesto = 68 AND url2.url_cz IN ('pages-map', 'pages-map`') AND (
			(stranka2.id = url2.tabulka_id AND url2.tabulka = 'stranka')
			OR (url2.tabulka = 'hotel' AND stranka.specialni = 'accommodation')
			OR (url2.tabulka = 'auto' AND stranka.specialni = 'car-rental')
		)
		WHERE (stranka.id_mesto = 68 OR stranka.id_mesto IS NULL) AND stranka_skryt_servery.id_stranka IS NULL AND stranka.pozice = 'nahore' GROUP BY stranka.id
		ORDER BY stranka.pozice, stranka.poradi
	//--><!--SELECT servery.nazev, CONCAT(servery.id, '-', servery.logo) AS logo, servery_jazyky.urchin FROM servery LEFT JOIN servery_jazyky ON servery.id = servery_jazyky.id_server AND servery_jazyky.id_jazyk = 'cz' WHERE servery.id = 71//--><!--SELECT mesto_cz, foto FROM nastaveni WHERE id = 68//--><!--
        SELECT 
        jazyky_prezentace.domena AS stat_domena, 
        nastaveni.rodic,
        mesto_cz AS stat_nazev  
        FROM 
            czech.jazyky_prezentace 
            INNER JOIN czech.nastaveni ON jazyky_prezentace.id_mesto = nastaveni.id 
            
        WHERE 
        jazyky_prezentace.id_jazyk IN ('cz', 'en') 
        AND nastaveni.stat = 'CH' 
        ORDER BY jazyky_prezentace.id_jazyk = 'en' 
        LIMIT 1//--><!--
        SELECT 
            domena AS evropa_domena,
            mesto_cz AS evropa_nazev 
        FROM 
            czech.jazyky_prezentace 
            LEFT JOIN czech.nastaveni ON czech.jazyky_prezentace.id_mesto = czech.nastaveni.id
        WHERE 
            id_jazyk IN ('cz', 'en') 
            AND id_mesto = 2 
        ORDER BY id_jazyk = 'en' 
        LIMIT 1//--><!--
        SELECT 
            domena AS svet_domena,
            mesto_cz AS svet_nazev
        FROM 
            czech.jazyky_prezentace 
            LEFT JOIN czech.nastaveni ON czech.jazyky_prezentace.id_mesto = czech.nastaveni.id
        WHERE 
            id_jazyk IN ('cz', 'en') 
            AND id_mesto = 73 
        ORDER BY id_jazyk = 'en' 
        LIMIT 1//--><!--SELECT urchin AS second_tracker FROM nastaveni_spolecne//--><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="cs" xml:lang="cs">
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <title>A - ZURICH.com - Pages Map</title>
    <meta name="keywords" content="" />
    <link rel="stylesheet" type="text/css" href="/images/booking.css?ed=1" media="screen,projection" />
    <!--[if IE]><link rel="stylesheet" href="/images/layout_ie.css" type="text/css" media="screen, projection" /><![endif]-->
    <link rel="stylesheet" href="/images/print.css" type="text/css" media="print" />
    <link rel="shortcut icon" type="image/x-icon" href="/images/a-prague.ico" />
    <script type="text/javascript" src="/images/js/jquery-1.2.3.min.js"></script>
    <script type="text/javascript" src="/images/scripts.js"></script>
      <script type="text/javascript">
      var firstTracker = {
        _link: function (href) { location.href = href; },
        _linkByPost: function (form) { },
        _trackPageview: function (href) { }
      };
      secondTracker = false;
      </script>
  </head>
  
  <body>
      <div id="mother">   
        
        
        <div id="header">
          
          <p id="tree-breadcrumb">
              <a href="http://www.athos-travel.com/cz">Svět</a> <img src="/images/bg/arrow.png" width="4" height="7" alt=""/>
                <a href="http://www.a-evropa.com">Evropa</a> <img src="/images/bg/arrow.png" width="4" height="7" alt=""/>
                  <a href="http://www.a-switzerland.com/cz">Švýcarsko</a> <img src="/images/bg/arrow.png" width="4" height="7" alt=""/>
            Curych
          </p>
          
          <p id="lang-menu">
            Jazyky:
<a href="http://www.a-zurich.com/pages-map"><img src="/data/booking/jazyk-en-gb.gif" width="16" height="11" alt="English" title="English" /> <!--<span>English</span> -->
</a>                                                                                                                                                 
<span class="aktualni"><img src="/data/booking/jazyk-cz-jazyk-cz.gif" width="16" height="11" alt="Čeština" title="Čeština" /> <!--<span>Čeština</span> -->
</span>                                                                                                                                                 
<a href="http://www.a-zurich.com/de/seitenmappen"><img src="/data/booking/jazyk-de-de.gif" width="16" height="11" alt="Deutsch" title="Deutsch" /> <!--<span>Deutsch</span> -->
</a>                                                                                                                                                 
<a href="http://www.a-zurich.com/it/pages-map"><img src="/data/booking/jazyk-it-it.gif" width="16" height="11" alt="Italiano" title="Italiano" /> <!--<span>Italiano</span> -->
</a>                                                                                                                                                 
<a href="http://www.a-zurich.com/fr/pages-map"><img src="/data/booking/jazyk-fr-fr.gif" width="16" height="11" alt="Français" title="Français" /> <!--<span>Français</span> -->
</a>                                                                                                                                                 
<a href="http://www.a-zurich.com/es/pages-map"><img src="/data/booking/jazyk-es-es.gif" width="16" height="11" alt="Español" title="Español" /> <!--<span>Español</span> -->
</a>                                                                                                                                                 
<a href="http://www.a-zurich.com/nl/pages-map"><img src="/data/booking/jazyk-nl-nl.gif" width="16" height="11" alt="Nederlands" title="Nederlands" /> <!--<span>Nederlands</span> -->
</a>                                                                                                                                                 
          </p>
          <div class="break"></div>
          
          
          <p id="skip-nav" class="out">
            <a href="#col-content" accesskey="2" title="Keyboard shortcut" class="noborder">Proceed to content</a>
            &nbsp;|&nbsp;
            <a href="#main-menu">Proceed to main menu</a>
          </p>
          
          <div id="motive">
            <div class="motive-prague" style="background-image: url(/data/booking/mesto-68-zurich.gif);">
              <div id="logo">
                <a href="."><img src="/data/booking/server-71-generated.png" alt="A - ZURICH.com" title="Hotely Curych" /></a>
                <img id="logo-provided" src="/images/provided-athos.png" width="90" height="58" alt="Provided by Athos Travel" />
              </div>
              <div id="claim">Online rezervace hotelů v Curychu</div>
            </div>
          </div>
          
          <div class="break"></div>
        </div>
        <hr class="hidden" />
        <div id="main-menu">
          
          <ul>
              <li><a href="vyhledavani-ubytovani" title=""><span>Ubytování</span></a></li>
              <li><a href="pocasi" title="Curych Počasí"><span>Počasí</span></a></li>
              <li><a href="mapa" title="Mapa Curych "><span>Mapa</span></a></li>
              <li><a href="pruvodce" title="Curych pruvodce"><span>Průvodce</span></a></li>
              <li><a href="zeme-mesta-svet" title="Ubytování ve státech a městech světa Evropy a světa"><span>Země a Města</span></a></li>
          </ul>
          
          <div class="break"></div>
        </div>
        <hr class="hidden" />
        <div id="clients-discount">&nbsp;</div>
        
        
        <div id="main">
            <div class="no-cols"><div id="col-content"><div class="in">
          

	<h1>Pages Map</h1>
<!--SELECT CONCAT('link_', stranka.specialni), url_cz FROM url INNER JOIN stranka ON stranka.id = url.tabulka_id AND url.tabulka = 'stranka' WHERE (stranka.id_mesto = 68 OR stranka.id_mesto IS NULL) AND stranka.specialni IN ('pruvodce', 'hotel-feedback', 'pricelist')//--><!--SELECT stranka.specialni, stranka.skupina, stranka.nadpis_cz, url.url_cz FROM stranka INNER JOIN url ON url.tabulka = 'stranka' AND stranka.id = url.tabulka_id WHERE (stranka.id_mesto = 68 OR stranka.id_mesto IS NULL) AND stranka.pozice != 'nikde' ORDER BY stranka.pozice, stranka.poradi//--><!--SELECT COUNT(*) FROM pruvodce WHERE id_mesto = 68 AND jazyk = 'cz'//--><!--SELECT pruvodce.menu AS nadpis_cz, IFNULL(url.url_cz, BINARY CONCAT('pruvodce?pozice=', pruvodce.menu_pozice)) AS url_cz FROM pruvodce LEFT JOIN url ON url.tabulka = 'pruvodce' AND pruvodce.id = url.tabulka_id WHERE pruvodce.id_mesto = 68 AND pruvodce.menu_pozice > 1 AND pruvodce.jazyk = 'en' ORDER BY pruvodce.menu_pozice//--><ul>
	<li><a href="vyhledavani-ubytovani">Ubytování</a>
	</li>
	<li><a href="pocasi">Počasí</a>
	</li>
	<li><a href="mapa">Mapa</a>
	</li>
	<li><a href="pruvodce">Průvodce</a>
		<ul>
			<li><a href="z-rich-theatres">Theatres</a></li>
			<li><a href="sightseeing-in-z-rich">Sightseeing</a></li>
			<li><a href="nightlife-in-z-rich">Nightlife</a></li>
			<li><a href="sports-in-z-rich">Sports</a></li>
		</ul>
	</li>
	<li><a href="zeme-mesta-svet">Země a Města</a>
	</li>
	<li><a href="about-us">About Us</a>
	</li>
	<li><a href="booking-terms">Booking Terms &amp; Conditions</a>
	</li>
	<li><a href="privacy-statement">Privacy Statement</a>
	</li>
	<li><a href="casto-kladene-otazky">Často kladené otázky</a>
	</li>
	<li><a href="pages-map">Pages Map</a>
	</li>
</ul>
<!--
		SELECT stranka.nadpis_cz, stranka.popisek_cz, url.url_cz
		FROM stranka
		LEFT JOIN stranka_skryt_servery ON stranka.id = stranka_skryt_servery.id_stranka AND stranka_skryt_servery.id_server = 71
		INNER JOIN url ON stranka.id = url.tabulka_id AND url.tabulka = 'stranka'
		WHERE (stranka.id_mesto = 68 OR stranka.id_mesto IS NULL) AND stranka_skryt_servery.id_stranka IS NULL AND stranka.pozice = 'dole'
		GROUP BY TRIM(TRAILING '`' FROM url.url_cz)
		ORDER BY stranka.poradi
	//--><!--SELECT links.nadpis_cz, links.odkaz_cz FROM prague.links INNER JOIN prague.links_kontinent ON links.id_kontinent = links_kontinent.id INNER JOIN prague.links_back ON links.id = links_back.id_link WHERE links.check_valid AND links_kontinent.specialni = 'paticka' AND links_back.domena = 'www.a-zurich.com' ORDER BY links.id//--><!--SELECT servery.navrcholu, servery_jazyky.urchin FROM servery LEFT JOIN servery_jazyky ON servery.id = servery_jazyky.id_server AND servery_jazyky.id_jazyk = 'cz' WHERE servery.id = 71//-->              
              <hr class="hidden" />
            </div>
            <div id="footer" class="home">
              
              <div class="spc">
                <p class="col-h-l">
                  <img src="/images/athos-travel.png" width="82" height="51" alt="logo" title="Athos Travel" class="l" />
                      <a href="about-us" title="">About Us</a>
&middot;                      <a href="booking-terms" title="">Booking Terms &amp; Conditions</a>
&middot;                      <a href="privacy-statement" title="">Privacy Statement</a>
&middot;                      <a href="casto-kladene-otazky" title="">Často kladené otázky</a>
&middot;                      <a href="pages-map" title="">Pages Map</a>
                    <br />  
                  <span>Adresa kanceláře:</span> Durychova č.101, 142 00 Praha 4<br />
<span>Otvírací doba kanceláře:</span> Po - Pá 8.00 - 20.00. So, Ne a Státní svátky 10.00 - 16.00<br />
<span>E-mail</span>: <a href="mailto:info@a-zurich.com">info@a-zurich.com</a>

                </p>
                
                <p class="links">
                    <a href="http://www.a-brussels.com/cz">Brusel hotely</a> &middot;
                    <a href="http://www.a-bern.com/cz">Bern hotely</a> &middot;
                    <a href="http://www.a-geneva.com/cz">Ženeva hotely</a> &middot;
                    <a href="http://www.a-lausanne.com/cz">Lausanne hotely</a> &middot;
                    <a href="http://www.a-cork.com/cz">Cork hotely</a> &middot;
                    <a href="http://www.a-dublin.com/cz">Dublin hotely</a> &middot;
                    <a href="http://www.a-london.eu/cz">Londýn hotely</a> &middot;
                  Powered by <a href="http://www.root.cz/">Linux</a>
                </p>
                
                <div class="break"></div>
              </div>
              
            </div>
          </div></div></div>
        
<script type="text/javascript" src="http://crypted.athos.cz/booking/xml/tracker.php?user_enter=http%3A%2F%2Fwww.a-zurich.com%2Fcz%2Fpages-map&amp;lang=cz"></script><script src="http://c1.navrcholu.cz/code?site=111027;t=t1x1" type="text/javascript"></script><noscript><div><img src="hit?site=111027;t=t1x1;ref=;jss=0" width="1" height="1" alt="" /></div></noscript>        
    </div>
  </body>
</html>