<!--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 = 386 WHERE jazyky.id = 'es'//--><!--SELECT 1 FROM come_from WHERE nazev = 'guia' LIMIT 1//--><!--SELECT url.* FROM url WHERE (id_mesto = 386 OR id_mesto IS NULL) AND (url_es = 'guia' OR url_es = 'guia`') ORDER BY id_mesto DESC//--><!--SELECT TRIM(TRAILING '`' FROM url.url_es) FROM stranka INNER JOIN url ON tabulka = 'stranka' AND stranka.id = url.tabulka_id WHERE (stranka.id_mesto = 386 OR stranka.id_mesto IS NULL) AND stranka.specialni = 'order'//--><!--SELECT * FROM stranka WHERE id = '12'//--><!--SELECT url.url_es FROM pruvodce INNER JOIN url ON pruvodce.id = url.tabulka_id AND url.tabulka = 'pruvodce' WHERE pruvodce.id_mesto = 386 AND pruvodce.jazyk = 'es' AND pruvodce.menu_pozice = ''//--><!--SELECT idf, preklad_es FROM prague.preklady WHERE puvod = 'sablony'//--><!--SELECT TRIM(TRAILING '`' FROM mesto_es), TRIM(TRAILING '`' FROM meste_es) FROM nastaveni WHERE id = 386//--><!--SELECT * FROM url WHERE (id_mesto = 386 OR id_mesto IS NULL) AND (url_es = 'guia' OR url_es = 'guia`')//--><!--SELECT jazyky.*, jazyky_prezentace.domena FROM jazyky INNER JOIN jazyky_prezentace ON jazyky.id = jazyky_prezentace.id_jazyk WHERE jazyky_prezentace.id_mesto = 386 ORDER BY jazyky.poradi//--><!--SELECT COUNT(*) FROM pruvodce WHERE id_mesto = 386//--><!--SELECT COUNT(*) FROM teplota WHERE id_mesto = 386//--><!--
		SELECT
			REPLACE(REPLACE(stranka.nadpis_es, '#mesto', nastaveni.mesto_es), '#meste', nastaveni.meste_es) AS nadpis_es,
			REPLACE(REPLACE(stranka.popisek_es, '#mesto', nastaveni.mesto_es), '#meste', nastaveni.meste_es) AS popisek_es,
			url.url_es,
			(url.url_es IN ('guia', 'guia`') OR COUNT(url2.id) > 0) AS aktivni,
			LEFT(url.url_es, 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 = 391
		INNER JOIN nastaveni ON nastaveni.id = 386
		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 = 386 AND url2.url_es IN ('guia', 'guia`') 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 = 386 OR stranka.id_mesto IS NULL) AND stranka_skryt_servery.id_stranka IS NULL AND stranka.pozice = 'nahore' AND stranka.specialni != 'weather' 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 = 'es' WHERE servery.id = 391//--><!--SELECT mesto_es, foto FROM nastaveni WHERE id = 386//--><!--
        SELECT 
        jazyky_prezentace.domena AS stat_domena, 
        nastaveni.rodic,
        mesto_es AS stat_nazev  
        FROM 
            czech.jazyky_prezentace 
            INNER JOIN czech.nastaveni ON jazyky_prezentace.id_mesto = nastaveni.id 
            
        WHERE 
        jazyky_prezentace.id_jazyk IN ('es', 'en') 
        AND nastaveni.stat = 'DE' 
        ORDER BY jazyky_prezentace.id_jazyk = 'en' 
        LIMIT 1//--><!--
        SELECT 
            domena AS evropa_domena,
            mesto_es AS evropa_nazev 
        FROM 
            czech.jazyky_prezentace 
            LEFT JOIN czech.nastaveni ON czech.jazyky_prezentace.id_mesto = czech.nastaveni.id
        WHERE 
            id_jazyk IN ('es', 'en') 
            AND id_mesto = 2 
        ORDER BY id_jazyk = 'en' 
        LIMIT 1//--><!--
        SELECT 
            domena AS svet_domena,
            mesto_es AS svet_nazev
        FROM 
            czech.jazyky_prezentace 
            LEFT JOIN czech.nastaveni ON czech.jazyky_prezentace.id_mesto = czech.nastaveni.id
        WHERE 
            id_jazyk IN ('es', '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="es" xml:lang="es">
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <title>A - GERMANY.com - Badenweiler Guia</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/es">Mundo</a> <img src="/images/bg/arrow.png" width="4" height="7" alt=""/>
                <a href="http://www.a-europe.com/es">Europa</a> <img src="/images/bg/arrow.png" width="4" height="7" alt=""/>
                  <a href="http://www.a-germany.com/es">Alemania </a> <img src="/images/bg/arrow.png" width="4" height="7" alt=""/>
            Badenweiler
          </p>
          
          <p id="lang-menu">
            Idiomas:
<a href="http://www.badenweiler.a-germany.com/guide"><img src="/data/booking/jazyk-en-gb.gif" width="16" height="11" alt="English" title="English" /> <!--<span>English</span> -->
</a>                                                                                                                                                 
<a href="http://www.badenweiler.a-germany.com/cz/pruvodce"><img src="/data/booking/jazyk-cz-jazyk-cz.gif" width="16" height="11" alt="Čeština" title="Čeština" /> <!--<span>Čeština</span> -->
</a>                                                                                                                                                 
<a href="http://www.badenweiler.a-germany.com/de/wissenswertes"><img src="/data/booking/jazyk-de-de.gif" width="16" height="11" alt="Deutsch" title="Deutsch" /> <!--<span>Deutsch</span> -->
</a>                                                                                                                                                 
<a href="http://www.badenweiler.a-germany.com/it/guida"><img src="/data/booking/jazyk-it-it.gif" width="16" height="11" alt="Italiano" title="Italiano" /> <!--<span>Italiano</span> -->
</a>                                                                                                                                                 
<a href="http://www.badenweiler.a-germany.com/fr/guide"><img src="/data/booking/jazyk-fr-fr.gif" width="16" height="11" alt="Français" title="Français" /> <!--<span>Français</span> -->
</a>                                                                                                                                                 
<span class="aktualni"><img src="/data/booking/jazyk-es-es.gif" width="16" height="11" alt="Español" title="Español" /> <!--<span>Español</span> -->
</span>                                                                                                                                                 
<a href="http://www.badenweiler.a-germany.com/nl/gids"><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">Progresar al contenido</a>
            &nbsp;|&nbsp;
            <a href="#main-menu">Progresar a la oferta principal</a>
          </p>
          
          <div id="motive">
            <div class="motive-prague">
              <div id="logo">
                <a href="."><img src="/data/booking/server-391-generated.png" alt="A - GERMANY.com" title="Badenweiler hoteles" /></a>
                <img id="logo-provided" src="/images/provided-athos.png" width="90" height="58" alt="Provided by Athos Travel" />
              </div>
              <div id="claim">Reservación de hotel on-line en Badenweiler</div>
            </div>
          </div>
          
          <div class="break"></div>
        </div>
        <hr class="hidden" />
        <div id="main-menu">
          
          <ul>
              <li><a href="alojamiento" title=""><span>Buscar Alojamiento</span></a></li>
              <li><a href="mapa" title="Badenweiler Mapa"><span>Mapa</span></a></li>
              <li class="active"><a href="guia" title="Badenweiler Guia"><span>Guia</span></a></li>
              <li><a href="países-ciudades-mundo" title="Paises y Ciudades "><span>Paises y Ciudades </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>Badenweiler Guia</h1>
<!--SELECT * FROM pruvodce WHERE jazyk = 'es' AND pruvodce.id_mesto = 386 AND pruvodce.menu_pozice = 1//--><!--SELECT * FROM pruvodce WHERE jazyk = 'en' AND pruvodce.id_mesto = 386 AND pruvodce.menu_pozice = 1//--><!--SELECT CONCAT('link_', stranka.specialni), url_es FROM url INNER JOIN stranka ON stranka.id = url.tabulka_id AND url.tabulka = 'stranka' WHERE (stranka.id_mesto = 386 OR stranka.id_mesto IS NULL) AND stranka.specialni IN ('pruvodce')//--><!--
	SELECT IF(pruvodce.menu_pozice = 1, 'guia', IFNULL(url.url_es, CONCAT('guia?pozice=', pruvodce.menu_pozice))) AS url, pruvodce.menu, (pruvodce.id_mesto = 386 AND pruvodce.menu_pozice = 1) AS aktivni
	FROM pruvodce
	LEFT JOIN url ON url.tabulka = 'pruvodce' AND pruvodce.id = url.tabulka_id
	WHERE pruvodce.id_mesto = 386 AND pruvodce.jazyk = 'en'
	ORDER BY pruvodce.menu_pozice
//-->
<div id="pruh">
		Badenweiler
</div>
<p class='nevyrazne vpravo clear'>Licenced under <a href='http://www.gnu.org/copyleft/fdl.html'>GFDL</a>, derived from <a href='http://en.wikipedia.org/wiki/Badenweiler'>Wikipedia</a>.</p>
<!--
		SELECT stranka.nadpis_es, stranka.popisek_es, url.url_es
		FROM stranka
		LEFT JOIN stranka_skryt_servery ON stranka.id = stranka_skryt_servery.id_stranka AND stranka_skryt_servery.id_server = 391
		INNER JOIN url ON stranka.id = url.tabulka_id AND url.tabulka = 'stranka'
		WHERE (stranka.id_mesto = 386 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_es)
		ORDER BY stranka.poradi
	//--><!--SELECT links.nadpis_es, links.odkaz_es 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.badenweiler.a-germany.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 = 'es' WHERE servery.id = 391//-->              
              <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="como-reservar-ayuda" title="">Como reservar</a>
&middot;                      <a href="privacy-statement" title="">Política de privacidad</a>
&middot;                      <a href="preguntas-frecuentes" title="">Preguntas frecuentes</a>
&middot;                      <a href="pages-map" title="">Pages Map</a>
                    <br />  
                  <span>Dirección de la oficina:</span> Durychova No.101, 142 00 Praga 4, República Checa<br />
<span>Horario:</span> Lu. - Vi. de  8 - 20 Hs. Fines de semana y fiestas 10 - 16 Hs.<br />
<span>E-mail</span>: <a href="mailto:info@a-germany.com">info@a-germany.com</a>

                </p>
                
                <p class="links">
                  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.badenweiler.a-germany.com%2Fes%2Fguia&amp;lang=es"></script>        
    </div>
  </body>
</html>