Ubytovanie v lokalite Ponitrie

Výsledky vyhľadávania

84 inzerátov | zoradené podľa ceny vzostupne▼

Top inzeráty

Hotel Bojnický vín...

Notice (8): Undefined index:  Obec [APP/views/elements/banery_vodorovne.ctp, line 68]

Code | Context

$___viewFn	=	"/var/www/virtual/ubytko123.sk/web/app/views/elements/banery_vodorovne.ctp"
$___dataForView	=	array(
	"jazyk" => "svk",
	"podstranky" => array(
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array()
),
	"pocet_pristupov" => 5001452,
	"druhy" => array(
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array()
),
	"strava" => array(
	array(),
	array(),
	array(),
	array()
),
	"kraje" => array(
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array()
),
	"vzdialenostiMesta" => array(
	"banska-bystrica" => "Banská Bystrica",
	"banska-stiavnica" => "Banská Štiavnica",
	"bardejov" => "Bardejov",
	"bratislava" => "Bratislava",
	"brezno" => "Brezno",
	"cadca" => "Čadca",
	"dolny-kubin" => "Dolný Kubín",
	"humenne" => "Humenné",
	"kezmarok" => "Kežmarok",
	"komarno" => "Komárno",
	"kosice" => "Košice",
	"kremnica" => "Kremnica",
	"levice" => "Levice",
	"liptovsky-mikulas" => "Liptovský Mikuláš",
	"martin" => "Martin",
	"michalovce" => "Michalovce",
	"nitra" => "Nitra",
	"nove-zamky" => "Nové Zámky",
	"piestany" => "Piešťany",
	"poprad" => "Poprad",
	"povazska-bystrica" => "Považská Bystrica",
	"presov" => "Prešov",
	"prievidza " => "Prievidza ",
	"roznava" => "Rožňava",
	"ruzomberok" => "Ružomberok",
	"snina" => "Snina",
	"spisska-nova-ves" => "Spišská Nová Ves",
	"stara-lubovna" => "Stará Ľubovňa",
	"sturovo" => "Štúrovo",
	"trebisov" => "Trebišov",
	"trencin" => "Trenčín",
	"trnava" => "Trnava",
	"vranov-nad-toplou" => "Vranov nad Topľou",
	"zilina" => "Žilina",
	"zvolen" => "Zvolen"
),
	"top_menu" => array(
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array()
),
	"banery" => array(
	array(),
	array(),
	array()
),
	"banery2" => array(
	array(),
	array()
),
	"meta_description" => "Sieť ubytovacích zariadení na Slovensku, ubytovanie na Slovensku, lacné ubytovanie",
	"meta_keywords" => "ubytovanie, ubytovanie na Slovensku, ubytovanie v Tatrách, lacne ubytovanie, on-line ubytovanie, rezervácia ubytovania, hotely, penzióny, chaty, hotel, penzion, chata, ubytovanie rezervácia, ubytování, ubytovani na slovensku, chaty a chalupy, lacné ubytovanie, chalupa, donovaly, dovolenka, orava, zuberec, chalupy, prenajom, liptov, turistika, tatralandia, penzión, hostely, hostel, ubytovanie nitra, ubytovanie zemplín, ubytovanie košice",
	"lokalita_nazov" => "Ponitrie",
	"data" => array(
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array()
),
	"site" => "ubytko123",
	"map" => MapHelper
MapHelper::$helpers = array
MapHelper::$restaurant = false
MapHelper::$base = ""
MapHelper::$webroot = "/"
MapHelper::$themeWeb = NULL
MapHelper::$here = "/lokalita/Ponitrie/page:1/sort:Inzerat.cena/direction:asc"
MapHelper::$params = array
MapHelper::$action = "lokalita"
MapHelper::$plugin = NULL
MapHelper::$data = NULL
MapHelper::$namedArgs = NULL
MapHelper::$argSeparator = NULL
MapHelper::$validationErrors = NULL
MapHelper::$tags = array
MapHelper::$__tainted = NULL
MapHelper::$__cleaned = NULL
MapHelper::$_log = NULL
MapHelper::$Html = HtmlHelper object,
	"html" => HtmlHelper
HtmlHelper::$tags = array
HtmlHelper::$base = ""
HtmlHelper::$here = "/lokalita/Ponitrie/page:1/sort:Inzerat.cena/direction:asc"
HtmlHelper::$params = array
HtmlHelper::$action = "lokalita"
HtmlHelper::$data = NULL
HtmlHelper::$_crumbs = array
HtmlHelper::$__docTypes = array
HtmlHelper::$helpers = NULL
HtmlHelper::$webroot = "/"
HtmlHelper::$themeWeb = NULL
HtmlHelper::$plugin = NULL
HtmlHelper::$namedArgs = NULL
HtmlHelper::$argSeparator = NULL
HtmlHelper::$validationErrors = NULL
HtmlHelper::$__tainted = NULL
HtmlHelper::$__cleaned = NULL
HtmlHelper::$_log = NULL,
	"ajax" => AjaxHelper
AjaxHelper::$helpers = array
AjaxHelper::$Html = HtmlHelper object
AjaxHelper::$Javascript = JavascriptHelper object
AjaxHelper::$callbacks = array
AjaxHelper::$ajaxOptions = array
AjaxHelper::$ajaxFormOptions = array
AjaxHelper::$editorOptions = array
AjaxHelper::$ajaxFormCallbacks = array
AjaxHelper::$__ajaxBuffer = array
AjaxHelper::$base = ""
AjaxHelper::$webroot = "/"
AjaxHelper::$themeWeb = NULL
AjaxHelper::$here = "/lokalita/Ponitrie/page:1/sort:Inzerat.cena/direction:asc"
AjaxHelper::$params = array
AjaxHelper::$action = "lokalita"
AjaxHelper::$plugin = NULL
AjaxHelper::$data = NULL
AjaxHelper::$namedArgs = NULL
AjaxHelper::$argSeparator = NULL
AjaxHelper::$validationErrors = NULL
AjaxHelper::$tags = array
AjaxHelper::$__tainted = NULL
AjaxHelper::$__cleaned = NULL
AjaxHelper::$_log = NULL
AjaxHelper::$Form = FormHelper object,
	"javascript" => JavascriptHelper
JavascriptHelper::$useNative = true
JavascriptHelper::$enabled = true
JavascriptHelper::$safe = false
JavascriptHelper::$tags = array
JavascriptHelper::$_blockOptions = array
JavascriptHelper::$_cachedEvents = array
JavascriptHelper::$_cacheEvents = false
JavascriptHelper::$_cacheToFile = false
JavascriptHelper::$_cacheAll = false
JavascriptHelper::$_rules = array
JavascriptHelper::$__scriptBuffer = NULL
JavascriptHelper::$helpers = NULL
JavascriptHelper::$base = ""
JavascriptHelper::$webroot = "/"
JavascriptHelper::$themeWeb = NULL
JavascriptHelper::$here = "/lokalita/Ponitrie/page:1/sort:Inzerat.cena/direction:asc"
JavascriptHelper::$params = array
JavascriptHelper::$action = "lokalita"
JavascriptHelper::$plugin = NULL
JavascriptHelper::$data = NULL
JavascriptHelper::$namedArgs = NULL
JavascriptHelper::$argSeparator = NULL
JavascriptHelper::$validationErrors = NULL
JavascriptHelper::$__tainted = NULL
JavascriptHelper::$__cleaned = NULL
JavascriptHelper::$_log = NULL,
	"form" => FormHelper
FormHelper::$helpers = array
FormHelper::$fieldset = array
FormHelper::$__options = array
FormHelper::$fields = array
FormHelper::$requestType = NULL
FormHelper::$base = ""
FormHelper::$webroot = "/"
FormHelper::$themeWeb = NULL
FormHelper::$here = "/lokalita/Ponitrie/page:1/sort:Inzerat.cena/direction:asc"
FormHelper::$params = array
FormHelper::$action = "lokalita"
FormHelper::$plugin = NULL
FormHelper::$data = NULL
FormHelper::$namedArgs = NULL
FormHelper::$argSeparator = NULL
FormHelper::$validationErrors = NULL
FormHelper::$tags = array
FormHelper::$__tainted = NULL
FormHelper::$__cleaned = NULL
FormHelper::$_log = NULL
FormHelper::$Html = HtmlHelper object,
	"paginator" => PaginatorHelper
PaginatorHelper::$helpers = array
PaginatorHelper::$__defaultModel = "Inzerat"
PaginatorHelper::$options = array
PaginatorHelper::$base = ""
PaginatorHelper::$webroot = "/"
PaginatorHelper::$themeWeb = NULL
PaginatorHelper::$here = "/lokalita/Ponitrie/page:1/sort:Inzerat.cena/direction:asc"
PaginatorHelper::$params = array
PaginatorHelper::$action = "lokalita"
PaginatorHelper::$plugin = NULL
PaginatorHelper::$data = NULL
PaginatorHelper::$namedArgs = NULL
PaginatorHelper::$argSeparator = NULL
PaginatorHelper::$validationErrors = NULL
PaginatorHelper::$tags = array
PaginatorHelper::$__tainted = NULL
PaginatorHelper::$__cleaned = NULL
PaginatorHelper::$_log = NULL
PaginatorHelper::$Html = HtmlHelper object
PaginatorHelper::$Ajax = AjaxHelper object,
	"session" => SessionHelper
SessionHelper::$helpers = NULL
SessionHelper::$__active = true
SessionHelper::$valid = false
SessionHelper::$error = false
SessionHelper::$_userAgent = "ddbb511fa838dcaa9a2557dae2832f72"
SessionHelper::$path = "/"
SessionHelper::$lastError = NULL
SessionHelper::$security = NULL
SessionHelper::$time = 1329040807
SessionHelper::$sessionTime = false
SessionHelper::$watchKeys = array
SessionHelper::$id = NULL
SessionHelper::$_log = NULL
SessionHelper::$base = ""
SessionHelper::$webroot = "/"
SessionHelper::$here = "/lokalita/Ponitrie/page:1/sort:Inzerat.cena/direction:asc"
SessionHelper::$params = array
SessionHelper::$action = "lokalita"
SessionHelper::$data = NULL
SessionHelper::$themeWeb = NULL
SessionHelper::$plugin = NULL
)
$loadHelpers	=	false
$cached	=	false
$loadedHelpers	=	array()
$jazyk	=	"svk"
$podstranky	=	array(
	array(
	"Texty" => array()
),
	array(
	"Texty" => array()
),
	array(
	"Texty" => array()
),
	array(
	"Texty" => array()
),
	array(
	"Texty" => array()
),
	array(
	"Texty" => array()
),
	array(
	"Texty" => array()
)
)
$pocet_pristupov	=	5001452
$druhy	=	array(
	array(
	"Druh" => array()
),
	array(
	"Druh" => array()
),
	array(
	"Druh" => array()
),
	array(
	"Druh" => array()
),
	array(
	"Druh" => array()
),
	array(
	"Druh" => array()
),
	array(
	"Druh" => array()
),
	array(
	"Druh" => array()
),
	array(
	"Druh" => array()
),
	array(
	"Druh" => array()
),
	array(
	"Druh" => array()
),
	array(
	"Druh" => array()
)
)
$strava	=	array(
	array(
	"Stravovanie" => array()
),
	array(
	"Stravovanie" => array()
),
	array(
	"Stravovanie" => array()
),
	array(
	"Stravovanie" => array()
)
)
$kraje	=	array(
	array(
	"Kraj" => array()
),
	array(
	"Kraj" => array()
),
	array(
	"Kraj" => array()
),
	array(
	"Kraj" => array()
),
	array(
	"Kraj" => array()
),
	array(
	"Kraj" => array()
),
	array(
	"Kraj" => array()
),
	array(
	"Kraj" => array()
)
)
$vzdialenostiMesta	=	array(
	"banska-bystrica" => "Banská Bystrica",
	"banska-stiavnica" => "Banská Štiavnica",
	"bardejov" => "Bardejov",
	"bratislava" => "Bratislava",
	"brezno" => "Brezno",
	"cadca" => "Čadca",
	"dolny-kubin" => "Dolný Kubín",
	"humenne" => "Humenné",
	"kezmarok" => "Kežmarok",
	"komarno" => "Komárno",
	"kosice" => "Košice",
	"kremnica" => "Kremnica",
	"levice" => "Levice",
	"liptovsky-mikulas" => "Liptovský Mikuláš",
	"martin" => "Martin",
	"michalovce" => "Michalovce",
	"nitra" => "Nitra",
	"nove-zamky" => "Nové Zámky",
	"piestany" => "Piešťany",
	"poprad" => "Poprad",
	"povazska-bystrica" => "Považská Bystrica",
	"presov" => "Prešov",
	"prievidza " => "Prievidza ",
	"roznava" => "Rožňava",
	"ruzomberok" => "Ružomberok",
	"snina" => "Snina",
	"spisska-nova-ves" => "Spišská Nová Ves",
	"stara-lubovna" => "Stará Ľubovňa",
	"sturovo" => "Štúrovo",
	"trebisov" => "Trebišov",
	"trencin" => "Trenčín",
	"trnava" => "Trnava",
	"vranov-nad-toplou" => "Vranov nad Topľou",
	"zilina" => "Žilina",
	"zvolen" => "Zvolen"
)
$top_menu	=	array(
	array(
	"ZariadenieDruh" => array(),
	"Submenu" => array()
),
	array(
	"ZariadenieDruh" => array(),
	"Submenu" => array()
),
	array(
	"ZariadenieDruh" => array(),
	"Submenu" => array()
),
	array(
	"ZariadenieDruh" => array(),
	"Submenu" => array()
),
	array(
	"ZariadenieDruh" => array(),
	"Submenu" => array()
),
	array(
	"ZariadenieDruh" => array(),
	"Submenu" => array()
),
	array(
	"ZariadenieDruh" => array(),
	"Submenu" => array()
),
	array(
	"ZariadenieDruh" => array(),
	"Submenu" => array()
),
	array(
	"ZariadenieDruh" => array(),
	"Submenu" => array()
),
	array(
	"ZariadenieDruh" => array(),
	"Submenu" => array()
),
	array(
	"ZariadenieDruh" => array(),
	"Submenu" => array()
),
	array(
	"ZariadenieDruh" => array(),
	"Submenu" => array()
),
	array(
	"ZariadenieDruh" => array(),
	"Submenu" => array()
),
	array(
	"ZariadenieDruh" => array(),
	"Submenu" => array()
),
	array(
	"ZariadenieDruh" => array(),
	"Submenu" => array()
),
	array(
	"ZariadenieDruh" => array(),
	"Submenu" => array()
)
)
$banery	=	array(
	array(
	"Baner" => array(),
	"Inzerat" => array(),
	"Obrazok" => array()
),
	array(
	"Baner" => array(),
	"Inzerat" => array(),
	"Obrazok" => array()
),
	array(
	"Baner" => array(),
	"Inzerat" => array(),
	"Obrazok" => array()
)
)
$banery2	=	array(
	array(
	"BanerLokalita" => array(),
	"Inzerat" => array(),
	"Obrazok" => array()
),
	array(
	"BanerLokalita" => array(),
	"Inzerat" => array(),
	"Obrazok" => array()
)
)
$meta_description	=	"Sieť ubytovacích zariadení na Slovensku, ubytovanie na Slovensku, lacné ubytovanie"
$meta_keywords	=	"ubytovanie, ubytovanie na Slovensku, ubytovanie v Tatrách, lacne ubytovanie, on-line ubytovanie, rezervácia ubytovania, hotely, penzióny, chaty, hotel, penzion, chata, ubytovanie rezervácia, ubytování, ubytovani na slovensku, chaty a chalupy, lacné ubytovanie, chalupa, donovaly, dovolenka, orava, zuberec, chalupy, prenajom, liptov, turistika, tatralandia, penzión, hostely, hostel, ubytovanie nitra, ubytovanie zemplín, ubytovanie košice"
$lokalita_nazov	=	"Ponitrie"
$data	=	array(
	array(
	"Inzerat" => array(),
	"Obec" => array(),
	"Ubytovatel" => array(),
	"Druh" => array(),
	"PlatnostInzeratu" => array(),
	"RestaurantOpeningHour" => array(),
	"RestaurantDetail" => array(),
	"RestaurantMenu" => array(),
	"RestaurantPayment" => array(),
	"Charakteristika" => array(),
	"Obrazok" => array(),
	"Komentar" => array(),
	"StravaInzerat" => array(),
	"Cena" => array(),
	"Zlava" => array(),
	"Vzdialenost1" => array(),
	"VzdialenostMesta" => array()
),
	array(
	"Inzerat" => array(),
	"Obec" => array(),
	"Ubytovatel" => array(),
	"Druh" => array(),
	"PlatnostInzeratu" => array(),
	"RestaurantOpeningHour" => array(),
	"RestaurantDetail" => array(),
	"RestaurantMenu" => array(),
	"RestaurantPayment" => array(),
	"Charakteristika" => array(),
	"Obrazok" => array(),
	"Komentar" => array(),
	"StravaInzerat" => array(),
	"Cena" => array(),
	"Zlava" => array(),
	"Vzdialenost1" => array(),
	"VzdialenostMesta" => array()
),
	array(
	"Inzerat" => array(),
	"Obec" => array(),
	"Ubytovatel" => array(),
	"Druh" => array(),
	"PlatnostInzeratu" => array(),
	"RestaurantOpeningHour" => array(),
	"RestaurantDetail" => array(),
	"RestaurantMenu" => array(),
	"RestaurantPayment" => array(),
	"Charakteristika" => array(),
	"Obrazok" => array(),
	"Komentar" => array(),
	"StravaInzerat" => array(),
	"Cena" => array(),
	"Zlava" => array(),
	"Vzdialenost1" => array(),
	"VzdialenostMesta" => array()
),
	array(
	"Inzerat" => array(),
	"Obec" => array(),
	"Ubytovatel" => array(),
	"Druh" => array(),
	"PlatnostInzeratu" => array(),
	"RestaurantOpeningHour" => array(),
	"RestaurantDetail" => array(),
	"RestaurantMenu" => array(),
	"RestaurantPayment" => array(),
	"Charakteristika" => array(),
	"Obrazok" => array(),
	"Komentar" => array(),
	"StravaInzerat" => array(),
	"Cena" => array(),
	"Zlava" => array(),
	"Vzdialenost1" => array(),
	"VzdialenostMesta" => array()
),
	array(
	"Inzerat" => array(),
	"Obec" => array(),
	"Ubytovatel" => array(),
	"Druh" => array(),
	"PlatnostInzeratu" => array(),
	"RestaurantOpeningHour" => array(),
	"RestaurantDetail" => array(),
	"RestaurantMenu" => array(),
	"RestaurantPayment" => array(),
	"Charakteristika" => array(),
	"Obrazok" => array(),
	"Komentar" => array(),
	"StravaInzerat" => array(),
	"Cena" => array(),
	"Zlava" => array(),
	"Vzdialenost1" => array(),
	"VzdialenostMesta" => array()
),
	array(
	"Inzerat" => array(),
	"Obec" => array(),
	"Ubytovatel" => array(),
	"Druh" => array(),
	"PlatnostInzeratu" => array(),
	"RestaurantOpeningHour" => array(),
	"RestaurantDetail" => array(),
	"RestaurantMenu" => array(),
	"RestaurantPayment" => array(),
	"Charakteristika" => array(),
	"Obrazok" => array(),
	"Komentar" => array(),
	"StravaInzerat" => array(),
	"Cena" => array(),
	"Zlava" => array(),
	"Vzdialenost1" => array(),
	"VzdialenostMesta" => array()
),
	array(
	"Inzerat" => array(),
	"Obec" => array(),
	"Ubytovatel" => array(),
	"Druh" => array(),
	"PlatnostInzeratu" => array(),
	"RestaurantOpeningHour" => array(),
	"RestaurantDetail" => array(),
	"RestaurantMenu" => array(),
	"RestaurantPayment" => array(),
	"Charakteristika" => array(),
	"Obrazok" => array(),
	"Komentar" => array(),
	"StravaInzerat" => array(),
	"Cena" => array(),
	"Zlava" => array(),
	"Vzdialenost1" => array(),
	"VzdialenostMesta" => array()
),
	array(
	"Inzerat" => array(),
	"Obec" => array(),
	"Ubytovatel" => array(),
	"Druh" => array(),
	"PlatnostInzeratu" => array(),
	"RestaurantOpeningHour" => array(),
	"RestaurantDetail" => array(),
	"RestaurantMenu" => array(),
	"RestaurantPayment" => array(),
	"Charakteristika" => array(),
	"Obrazok" => array(),
	"Komentar" => array(),
	"StravaInzerat" => array(),
	"Cena" => array(),
	"Zlava" => array(),
	"Vzdialenost1" => array(),
	"VzdialenostMesta" => array()
),
	array(
	"Inzerat" => array(),
	"Obec" => array(),
	"Ubytovatel" => array(),
	"Druh" => array(),
	"PlatnostInzeratu" => array(),
	"RestaurantOpeningHour" => array(),
	"RestaurantDetail" => array(),
	"RestaurantMenu" => array(),
	"RestaurantPayment" => array(),
	"Charakteristika" => array(),
	"Obrazok" => array(),
	"Komentar" => array(),
	"StravaInzerat" => array(),
	"Cena" => array(),
	"Zlava" => array(),
	"Vzdialenost1" => array(),
	"VzdialenostMesta" => array()
),
	array(
	"Inzerat" => array(),
	"Obec" => array(),
	"Ubytovatel" => array(),
	"Druh" => array(),
	"PlatnostInzeratu" => array(),
	"RestaurantOpeningHour" => array(),
	"RestaurantDetail" => array(),
	"RestaurantMenu" => array(),
	"RestaurantPayment" => array(),
	"Charakteristika" => array(),
	"Obrazok" => array(),
	"Komentar" => array(),
	"StravaInzerat" => array(),
	"Cena" => array(),
	"Zlava" => array(),
	"Vzdialenost1" => array(),
	"VzdialenostMesta" => array()
)
)
$site	=	"ubytko123"
$map	=	MapHelper
MapHelper::$helpers = array
MapHelper::$restaurant = false
MapHelper::$base = ""
MapHelper::$webroot = "/"
MapHelper::$themeWeb = NULL
MapHelper::$here = "/lokalita/Ponitrie/page:1/sort:Inzerat.cena/direction:asc"
MapHelper::$params = array
MapHelper::$action = "lokalita"
MapHelper::$plugin = NULL
MapHelper::$data = NULL
MapHelper::$namedArgs = NULL
MapHelper::$argSeparator = NULL
MapHelper::$validationErrors = NULL
MapHelper::$tags = array
MapHelper::$__tainted = NULL
MapHelper::$__cleaned = NULL
MapHelper::$_log = NULL
MapHelper::$Html = HtmlHelper object
$html	=	HtmlHelper
HtmlHelper::$tags = array
HtmlHelper::$base = ""
HtmlHelper::$here = "/lokalita/Ponitrie/page:1/sort:Inzerat.cena/direction:asc"
HtmlHelper::$params = array
HtmlHelper::$action = "lokalita"
HtmlHelper::$data = NULL
HtmlHelper::$_crumbs = array
HtmlHelper::$__docTypes = array
HtmlHelper::$helpers = NULL
HtmlHelper::$webroot = "/"
HtmlHelper::$themeWeb = NULL
HtmlHelper::$plugin = NULL
HtmlHelper::$namedArgs = NULL
HtmlHelper::$argSeparator = NULL
HtmlHelper::$validationErrors = NULL
HtmlHelper::$__tainted = NULL
HtmlHelper::$__cleaned = NULL
HtmlHelper::$_log = NULL
$ajax	=	AjaxHelper
AjaxHelper::$helpers = array
AjaxHelper::$Html = HtmlHelper object
AjaxHelper::$Javascript = JavascriptHelper object
AjaxHelper::$callbacks = array
AjaxHelper::$ajaxOptions = array
AjaxHelper::$ajaxFormOptions = array
AjaxHelper::$editorOptions = array
AjaxHelper::$ajaxFormCallbacks = array
AjaxHelper::$__ajaxBuffer = array
AjaxHelper::$base = ""
AjaxHelper::$webroot = "/"
AjaxHelper::$themeWeb = NULL
AjaxHelper::$here = "/lokalita/Ponitrie/page:1/sort:Inzerat.cena/direction:asc"
AjaxHelper::$params = array
AjaxHelper::$action = "lokalita"
AjaxHelper::$plugin = NULL
AjaxHelper::$data = NULL
AjaxHelper::$namedArgs = NULL
AjaxHelper::$argSeparator = NULL
AjaxHelper::$validationErrors = NULL
AjaxHelper::$tags = array
AjaxHelper::$__tainted = NULL
AjaxHelper::$__cleaned = NULL
AjaxHelper::$_log = NULL
AjaxHelper::$Form = FormHelper object
$javascript	=	JavascriptHelper
JavascriptHelper::$useNative = true
JavascriptHelper::$enabled = true
JavascriptHelper::$safe = false
JavascriptHelper::$tags = array
JavascriptHelper::$_blockOptions = array
JavascriptHelper::$_cachedEvents = array
JavascriptHelper::$_cacheEvents = false
JavascriptHelper::$_cacheToFile = false
JavascriptHelper::$_cacheAll = false
JavascriptHelper::$_rules = array
JavascriptHelper::$__scriptBuffer = NULL
JavascriptHelper::$helpers = NULL
JavascriptHelper::$base = ""
JavascriptHelper::$webroot = "/"
JavascriptHelper::$themeWeb = NULL
JavascriptHelper::$here = "/lokalita/Ponitrie/page:1/sort:Inzerat.cena/direction:asc"
JavascriptHelper::$params = array
JavascriptHelper::$action = "lokalita"
JavascriptHelper::$plugin = NULL
JavascriptHelper::$data = NULL
JavascriptHelper::$namedArgs = NULL
JavascriptHelper::$argSeparator = NULL
JavascriptHelper::$validationErrors = NULL
JavascriptHelper::$__tainted = NULL
JavascriptHelper::$__cleaned = NULL
JavascriptHelper::$_log = NULL
$form	=	FormHelper
FormHelper::$helpers = array
FormHelper::$fieldset = array
FormHelper::$__options = array
FormHelper::$fields = array
FormHelper::$requestType = NULL
FormHelper::$base = ""
FormHelper::$webroot = "/"
FormHelper::$themeWeb = NULL
FormHelper::$here = "/lokalita/Ponitrie/page:1/sort:Inzerat.cena/direction:asc"
FormHelper::$params = array
FormHelper::$action = "lokalita"
FormHelper::$plugin = NULL
FormHelper::$data = NULL
FormHelper::$namedArgs = NULL
FormHelper::$argSeparator = NULL
FormHelper::$validationErrors = NULL
FormHelper::$tags = array
FormHelper::$__tainted = NULL
FormHelper::$__cleaned = NULL
FormHelper::$_log = NULL
FormHelper::$Html = HtmlHelper object
$paginator	=	PaginatorHelper
PaginatorHelper::$helpers = array
PaginatorHelper::$__defaultModel = "Inzerat"
PaginatorHelper::$options = array
PaginatorHelper::$base = ""
PaginatorHelper::$webroot = "/"
PaginatorHelper::$themeWeb = NULL
PaginatorHelper::$here = "/lokalita/Ponitrie/page:1/sort:Inzerat.cena/direction:asc"
PaginatorHelper::$params = array
PaginatorHelper::$action = "lokalita"
PaginatorHelper::$plugin = NULL
PaginatorHelper::$data = NULL
PaginatorHelper::$namedArgs = NULL
PaginatorHelper::$argSeparator = NULL
PaginatorHelper::$validationErrors = NULL
PaginatorHelper::$tags = array
PaginatorHelper::$__tainted = NULL
PaginatorHelper::$__cleaned = NULL
PaginatorHelper::$_log = NULL
PaginatorHelper::$Html = HtmlHelper object
PaginatorHelper::$Ajax = AjaxHelper object
$session	=	SessionHelper
SessionHelper::$helpers = NULL
SessionHelper::$__active = true
SessionHelper::$valid = false
SessionHelper::$error = false
SessionHelper::$_userAgent = "ddbb511fa838dcaa9a2557dae2832f72"
SessionHelper::$path = "/"
SessionHelper::$lastError = NULL
SessionHelper::$security = NULL
SessionHelper::$time = 1329040807
SessionHelper::$sessionTime = false
SessionHelper::$watchKeys = array
SessionHelper::$id = NULL
SessionHelper::$_log = NULL
SessionHelper::$base = ""
SessionHelper::$webroot = "/"
SessionHelper::$here = "/lokalita/Ponitrie/page:1/sort:Inzerat.cena/direction:asc"
SessionHelper::$params = array
SessionHelper::$action = "lokalita"
SessionHelper::$data = NULL
SessionHelper::$themeWeb = NULL
SessionHelper::$plugin = NULL
$baner	=	array(
	"BanerLokalita" => array(
	"lokalita_id" => "6",
	"pozicia" => "1",
	"idinzerat" => "1751"
),
	"Inzerat" => array(
	"idinzerat" => "1751",
	"uzivatel_iduzivatel" => "506",
	"nazov" => "Hotel Bojnický vínny dom - Bojnice,
Chuť na ktorú sa nezabúda!",
	"alias" => "1751-Hotel-Bojnick",
	"variabilny_symbol" => "31885276",
	"text" => "U nás môžete prežiť romantickú večeru pri sviečkach priamo vo wellness len v županoch!
Hotel Bojnický vínny dom sa nachádza v prekrásnom turistickom centre Slovenska, v mestečku Bojnice. Pozývame Vás vychutnať si naše luxusné izby s výhľadom na Bojnický zámok, výbornú reštauráciu, oddýchnuť si vo vínnom wellness, relaxovať príjemnou masážou, alebo si posedieť pri pohári kvalitného vína v našej degustačnej miestnosti, ktorá je súčasťou vinotéky. Bojnický vínny dom je spojením tradície, šarmu a nezabudnuteľnej atmosféry. 
Prežite u nás romantické chvíle, svadbu, či inú dôležitú udalosť Vášho života.
Dovoľte nám postarať sa o Vás.",
	"cas" => "1269497122",
	"cas_zmeneny" => "1280953761",
	"druh" => "1",
	"typ" => null,
	"obec" => "513903",
	"id_kat_uzemia" => "",
	"cena" => "30",
	"platba_za_mesiac" => "240",
	"dlzka_predplatenia" => "4",
	"platnost_zmluvy_do" => "1308866400",
	"podpis_zmluvy" => "1269298800",
	"ulica" => "Hurbanovo námestie 57/60",
	"lokalita" => "Ponitrie",
	"schvaleny" => "1",
	"top" => "0",
	"kapacita" => "25",
	"zobrazeni" => "3261",
	"je_mapa" => "1",
	"suradnice" => "48.778895,18.581851",
	"zoom" => "14",
	"map_type" => "G_NORMAL_MAP",
	"idmajitel" => "6639",
	"idmakler1" => "0",
	"idmakler2" => "0",
	"synchro_inzeraty" => "1328949623",
	"synchro_zariadenia" => "1328915571",
	"demo" => "0",
	"demo_do" => "1272171922",
	"nestandardny" => "0",
	"nestandardny_od" => "0",
	"nestandardny_do" => "0"
),
	"Obrazok" => array(
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array()
)
)
$baner_img	=	"<img src="http://system.ubytko123.sk/thumbs/13408.jpg" alt="baner" width="152" height="114" />"

          <div class="ad_description_container">

              <div class="ad_description">

                    <?php echo $baner['Inzerat']['Obec']['nazov_obce']; ?><br/>

include - APP/views/elements/banery_vodorovne.ctp, line 68
View::_render() - CORE/cake/libs/view/view.php, line 666
View::element() - CORE/cake/libs/view/view.php, line 343
View::renderElement() - CORE/cake/libs/view/view.php, line 923
include_once - APP/views/inzerat/list.ctp, line 71
include - APP/views/inzerat/lokalita.ctp, line 11
View::_render() - CORE/cake/libs/view/view.php, line 666
View::render() - CORE/cake/libs/view/view.php, line 376
Controller::render() - CORE/cake/libs/controller/controller.php, line 803
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 230
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 194
[main] - APP/webroot/index.php, line 88

Ceny od: 30 EUR

viac

HOTEL PEKLO **** ,...

Ceny od: 29 EUR

viac

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 Ďalej »

HOTEL POD ZÁMKOM **** /wellness,kongress/ Bojnice - Prievidza

Hotely | Bojnice | Ponitrie

Detail

Cena (osoba/noc): 0 EUR (0 Sk)

Kapacita: 126

Hotel pod zámkom je hotel európskej triedy typu WELLNESS. Svojim hosťom poskytuje široký rozsah služieb vysokého štandartu. Náš hotel sa nachádza v prekásnom a turisticky najvyhľadávanejšom kúpeľnom mestečku Slovenska - Bojniciach na námestí pod Bojnickým zámkom. Kongresová hala s kapacitou 190 miest je vybavená tlmočníckymi kabínkami a kvalitnou audiovizuálnou technikou s možnosťou pripojenia na počítačovú sieť. Pre náročnejších sú k dispozícii kongresové apartmány. Kongresovú halu ponúkame aj pre firemné a spoločenské podujatia. Rokovací salónik poskytuje rokovací priestor pre 20 - 30 osôb. Je vhodný pre pracovné obedy, večere a stretnutia. Fitness, vírivý kúpeľ, fí...

PENZION SIGNÁL,Bojnice- Prievidza

Penzióny | Bojnice | PONITRIE

Detail

Cena (osoba/noc): 0 EUR (0 Sk)

Kapacita: 37

Penzión Signál sa nachádza nad mestom Bojnice, cca 800 m od centra Bojníc, v chatovej oblasti nad zoologickou záhradou v peknom prostredí s prekrásnym výhľadom na mesto a jeho blízke okolie. Ponúkame oddych a ubytovanie s možnosťou stravovania pre jednotlivcov, rodiny s deťmi ako aj akcie uzavretej spoločnosti. Celková kapacita penziónu je 37 postelí ( vrátane prísteliek ). Súčasťou penziónu je aj terasa s pekným výhľadom na okolitú prírodu. Bezprostredne pred penziónom sa nachádza veľké ohnisko. Parkovanie je možné pred penziónom. Akcie uzavretej spoločnosti ( svadby, stretávky, školenia, školy v prírode...) – cena dohodou Rozloženie izieb : Apartm...

UBYTOVANIE U MILKY - Bojnice, Prievidza

Privát | Bojnice | PONITRIE

Detail

Cena (osoba/noc): 0 EUR (0 Sk)

Kapacita: 9

Ubytovacie zariadenie sa nachádza v nádhernom prostredí kúpeľného mesta Bojnice cca 10 minút peši od ZOO a Zámku a Múzea v praveku. Dom je situovaný neďaleko historického centra. Okolie ponúka návštevníkom množstvo zaujímavých príležitostí na strávenie voľných chvíľ.Naše ubytovacie zariadenie nájdete aj na www.najlacne.sk .

HOTEL A REŠTAURÁCIA EDEN , Handlová - Prievidza

Hotely | Handlová | Ponitrie

Detail

Cena (osoba/noc): 0 EUR (0 Sk)

Kapacita: 20

Príjemné ubytovanie za veľmi výhodnú cenu v tichej časti mesta Handlová.Príjemný mladý personál Vás s radosťou privíta tak v reštaurácii ako aj v Rajskom Hotely EDEN. Reštaurácia je známa svojou dobrou kuchyňou a hlavne veľkými porciami jedla /aj rozvoz obedového menu/. Výlety: Bojnice,Prievidza,Jaskyňa v praveku,Čičmany,Nitrianske Rudno,Zoo,ski Remata,ski Kľačno,Štiavnické jazerá,Skalka,Nízke Tatry,Vysoké Tatry,Bratislava,Banská Štiavnica,Dudince,Sliač,Kováčová,Liptov,Turiec,Bešeňová,Tatralandia,Jasná,Veľká Rača...

PENZION ASSO ,Bojnice - Prievidza

Penzióny | Bojnice | PONITRIE

Detail

Cena (osoba/noc): 0 EUR (0 Sk)

Kapacita: 10

Penzión ASSO sa nachádza priamo v centre kúpeľného mesta Bojnice. Na ubytovanie ponúka 5 dvojposteľových izieb s televízorom, wc a kúpeľňou. Hosťom je k dispozícii spoločenská miestnosť s kuchynským kútom, chladničkou, mikrovlnkou, vhodná tiež na organizovanie rôznych samostatných akcií. Výlety: Bojnice,Prievidza,Jaskyňa v praveku,Čičmany,Nitrianske Rudno,Zoo,ski Remata,ski Kľačno,Štiavnické jazerá,Skalka,Nízke Tatry,Vysoké Tatry,Bratislava,Banská Štiavnica,Dudince,Sliač,Kováčová,Liptov,Turiec,Bešeňová,Tatralandia,Jasná,Veľká Rača...

Apartmánové ubytovanie Zelený dom - Bojnice

Penzióny | Bojnice | Ponitrie

Detail

Cena (osoba/noc): 0 EUR (0 Sk)

Kapacita: 27

Penzión Zelený dom ponúka celkovo 21 lôžok v ôsmich izbách. Z tohto počtu sú štyri izby 2-lôžkové, tri 4-lôžkové a jedna izba jednolôžková. Na želanie zákazníka môže byť každá izba doplnená o prístelok. Čaká tu na vás pokojná atmosféra a ochotný personál. Počas vášho pobytu u nás môžete bezplatne využiť parkovacie miesto v uzavretom priestore nášho penziónu. Zelený dom je vzdialený od centra mesta a Bojnického zámku len 5 minút chôdze. Na izbách sa nachádza vlastné sociálne zariadenie (kúpeľňa, WC, sprcha), kompletná kuchynka, chladnička a TV. Interiér je vkusne vybavený novým dreveným nábytkom a doplnkami, ktoré tvoria príjemnú atmosféru pre oddych v našom penzióne. Možnosť pripojenia ...

Ubytovanie PETRO, Bojnice/Opatovce nad Nitrou/okres Prievidza

Privát | Bojnice | Ponitrie

Detail

Cena (osoba/noc): 0 EUR (0 Sk)

Kapacita: 10

Ubytovanie v súkromí sa nachádza v tichom prostredí, blízko kúpeľného mesta Bojnice. Je to 25 minút chôdze od Bojnického zámku, ZOO ako aj kúpaliska Čajka s tobogánmi a len 10 minút od kúpeľov, kde je možnosť kúpania sa v termálnych bazénoch situovaných vo vnútornom aj vonkajšom prostredí. Umiestnenie ubytovania je v dostatočnej vzdialenosti od hlavnej cesty, čo zaručuje tichý a nerušený pobyt. Parkovisko pre 3 až 4 automobily je situované na pozemku ubytovacieho zariadenia, je chránené a poskytované ako bonus k ubytovaniu. Zariadenie sa skladá z 2 a 3 lôžkových izieb s lódžiami, s možnosťou prístelky, zo spoločenskej miestnosti s terasou, vybavenej kuchynky, kúpeľne s WC...

HOTEL ZARA **** ,Topoľčany

Hotely | Topoľčany | PONITRIE

Detail

Cena (osoba/noc): 0 EUR (0 Sk)

Kapacita: 31

Milí návštevníci Hotel Zara bol otvorený v januári 2009 s myšlienkou priblížiť Vám exotiku a temperament ďalekého Španielska. S jeho názvom sa spája komfort a kvalitné služby na profesionálnej úrovni. Doprajte si oddych a ubytujte sa v luxusne zariadených izbách a apartmánoch nášho hotela. My sa Vám odvďačíme službami na vysokej úrovni a vytvorením pokojnej rodinnej atmosféry. Každá izba je vybavená klimatizáciou, farebným televízorom so satelitným prijímačom, telefónom a chladničkou. Ak potrebujete byť v neustálom spojení s Vašimi známymi alebo spolupracovníkmi, môžete využiť bezplatné wi-fi pripojenie, ktorého pokrytie je v celom areáli hotela. Pre gurmánov a tých, ktorí radi sk...

PENZION ORION , Prievidza

Penzióny | Prievidza | PONITRIE

Detail

Cena (osoba/noc): 0 EUR (0 Sk)

Kapacita: 50

O nás Penzión Orion sa nachádza v tichej časti Prievidze, necelých 15 minút chôdze od centra mesta. Ubytovanie ponúka od roku 1985, v rokoch 2004 a 2008 však prešiel rozsiahlou rekonštrukciou. Penzión má 18 dvoj a troj posteľových izieb a 2 apartmány, s maximálnou celkovou kapacitou 50 ľudí. Každá izba je vybavená sociálnym zariadením a televízorom. V blízkom okolí sa nachádza sieť reštaurácii, kde si na svoje prídu milovníci slovenskej, ale aj mexickej, či čínskej kuchyne. S 10 minút chôdze vzdialenou autobusovou a vlakovou stanicou, 15 minút vzdialeným centrom, ležiac takmer na priamom ťahu na Bojnice, je Penzión Orion ideálnym miestom nielen pre turistov a obchodných cestujuc...

PENZION ALENA , Bojnice /centrum/ ,Prievidza

Privát | Bojnice | PONITRIE

Detail

Cena (osoba/noc): 0 EUR (0 Sk)

Kapacita: 18

O penzióne... Rozhodli ste sa navštíviť BOJNICE? Využite služby penziónu "ALENA", ktorý sa nachádza v tichej uličke pod romantickým zámkom neďaleko centra. Čakajú na Vás tieto atrakcie: # Nádherný BOJNICKÝ ZÁMOK www.bojnicecastle.sk # Najkrajšia ZOO na Slovensku www.zoobojnice.sk # Zaujímavé vystúpenia sokoliarov a šermiarov Aquila www.aquila.sk # Známe kúpalisko Čajka / kontakt: 00421465430528 begin_of_the_skype_highlighting 00421465430528 end_of_the_skype_highlighting begin_of_the_skype_highlighting 00421465430528 end_of_the_skype_highlighting / # Skvelé liečivé termálne kúpele www.kupele-bojnice.sk # Vzácna Prepoštská jaskyňa www.muzeumpr...

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 Ďalej »

Adrenalín a Zábava	Aquaparky	Hrady a zámky	Jaskyne	Jazerá a vodné nádrže	Kiná a divadlá	Konferenčné zariadenia	Kúpele a kúpaliska
Lyžiarské strediská	Múzea	Ranče	Športoviská	Turistika	UNESCO	Wellness pobyty	ZOO a botanické záhrady

Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `realcms_inzerat`	37	37	5
2	DESCRIBE `realcms_obce`	4	4	2
3	DESCRIBE `realcms_okresy`	4	4	3
4	DESCRIBE `realcms_kraje`	3	3	2
5	DESCRIBE `realcms_zakaznik`	43	43	7
6	DESCRIBE `realcms_druhy`	4	4	2
7	DESCRIBE `realcms_platnost_inzeratu`	6	6	2
8	DESCRIBE `realcms_restaurant_opening_hours`	7	7	2
9	DESCRIBE `realcms_restaurant_details`	5	5	2
10	DESCRIBE `realcms_restaurant_menus`	12	12	2
11	DESCRIBE `realcms_restaurant_payments`	3	3	2
12	DESCRIBE `realcms_restaurant_payment_types`	3	3	2
13	DESCRIBE `realcms_charakteristiky`	5	5	2
14	DESCRIBE `realcms_char`	5	5	1
15	DESCRIBE `realcms_char_kategorie`	2	2	2
16	DESCRIBE `realcms_obrazok`	7	7	2
17	DESCRIBE `realcms_komentare`	7	7	2
18	DESCRIBE `realcms_strava_inzeraty`	3	3	2
19	DESCRIBE `realcms_stravovanie`	3	3	2
20	DESCRIBE `realcms_ceny`	7	7	2
21	DESCRIBE `realcms_meny`	4	4	2
22	DESCRIBE `realcms_ceny_nazvy`	3	3	2
23	DESCRIBE `realcms_zlavy`	6	6	2
24	DESCRIBE `realcms_zlavy_nazvy`	3	3	2
25	DESCRIBE `realcms_inzerat_vzdialenosti`	5	5	1
26	DESCRIBE `realcms_inzerat_vzdialenosti_mesta`	5	5	2
27	DESCRIBE `realcms_mesta`	5	5	2
28	DESCRIBE `realcms_lokality`	3	3	2
29	DESCRIBE `realcms_lokality_obce`	2	2	2
30	DESCRIBE `realcms_banery_lokality`	3	3	2
31	DESCRIBE `realcms_sutaz`	4	4	1
32	DESCRIBE `realcms_sutaz_udaje`	11	11	3
33	DESCRIBE `realcms_druhy_zariadeni`	4	4	2
34	DESCRIBE `realcms_inzerat_vzdialenosti_zariadenia`	5	5	2
35	DESCRIBE `realcms_zariadenia`	23	23	4
36	DESCRIBE `realcms_obrazok_zariadenia`	5	5	2
37	DESCRIBE `realcms_charakteristiky_zariadenia`	4	4	2
38	DESCRIBE `realcms_char_zariadenia`	4	4	2
39	DESCRIBE `realcms_banery`	3	3	1
40	DESCRIBE `realcms_banery_hlavna_stranka`	2	2	2
41	DESCRIBE `realcms_jazyky`	3	3	2
42	DESCRIBE `realcms_wysiwyg`	6	6	1
43	DESCRIBE `realcms_web_pristupy`	4	4	2
44	SELECT `Jazyk`.`id`, `Jazyk`.`jazyk`, `Jazyk`.`jazyk_slovom` FROM `realcms_jazyky` AS `Jazyk` WHERE `Jazyk`.`jazyk` = 'svk' LIMIT 1	1	1	0
45	SELECT `Texty`.`nadpis`, `Texty`.`name` FROM `realcms_wysiwyg` AS `Texty` WHERE `Texty`.`jazyk_id` = 1	7	7	0
46	INSERT DELAYED INTO `realcms_web_pristupy` (`ip_adresa`, `created`) VALUES ('38.107.179.211', '2012-02-12 11:00:03') ON DUPLICATE KEY UPDATE pocet_pristupov=pocet_pristupov+1	2		1
47	SELECT SUM(pocet_pristupov) AS pocet FROM `realcms_web_pristupy` AS `Pristup` WHERE 1 = 1 LIMIT 1	1	1	118
48	SELECT `Druh`.`iddruh`, `Druh`.`druh`, `Druh`.`zobrazeni`, `Druh`.`cena` FROM `realcms_druhy` AS `Druh` WHERE 1 = 1	12	12	0
49	SELECT `Stravovanie`.`id`, `Stravovanie`.`nazov_stravovania`, `Stravovanie`.`order` FROM `realcms_stravovanie` AS `Stravovanie` WHERE 1 = 1	4	4	0
50	SELECT `Kraj`.`idkraj`, `Kraj`.`nazov`, `Kraj`.`idstat` FROM `realcms_kraje` AS `Kraj` WHERE `Kraj`.`idstat` = 'SK'	8	8	0
51	SELECT `Mesto`.`id`, `Mesto`.`nazov`, `Mesto`.`nazov_seo`, `Mesto`.`latitude`, `Mesto`.`longitude` FROM `realcms_mesta` AS `Mesto` WHERE 1 = 1 ORDER BY `Mesto`.`nazov` asc	35	35	0
52	SELECT `ZariadenieDruh`.`id`, `ZariadenieDruh`.`zariadenie`, `ZariadenieDruh`.`alias`, `ZariadenieDruh`.`parent` FROM `realcms_druhy_zariadeni` AS `ZariadenieDruh` WHERE `ZariadenieDruh`.`parent` = 0 ORDER BY `ZariadenieDruh`.`zariadenie` ASC	16	16	0
53	SELECT `Submenu`.`id`, `Submenu`.`zariadenie`, `Submenu`.`alias`, `Submenu`.`parent` FROM `realcms_druhy_zariadeni` AS `Submenu` WHERE `Submenu`.`parent` IN (31, 1, 12, 10, 15, 21, 8, 30, 2, 23, 14, 6, 9, 11, 22, 16)	12	12	0
54	SELECT `Baner`.`kraj_id`, `Baner`.`pozicia`, `Baner`.`idinzerat`, `Inzerat`.`idinzerat`, `Inzerat`.`uzivatel_iduzivatel`, `Inzerat`.`nazov`, `Inzerat`.`alias`, `Inzerat`.`variabilny_symbol`, `Inzerat`.`text`, `Inzerat`.`cas`, `Inzerat`.`cas_zmeneny`, `Inzerat`.`druh`, `Inzerat`.`typ`, `Inzerat`.`obec`, `Inzerat`.`id_kat_uzemia`, `Inzerat`.`cena`, `Inzerat`.`platba_za_mesiac`, `Inzerat`.`dlzka_predplatenia`, `Inzerat`.`platnost_zmluvy_do`, `Inzerat`.`podpis_zmluvy`, `Inzerat`.`ulica`, `Inzerat`.`lokalita`, `Inzerat`.`schvaleny`, `Inzerat`.`top`, `Inzerat`.`kapacita`, `Inzerat`.`zobrazeni`, `Inzerat`.`je_mapa`, `Inzerat`.`suradnice`, `Inzerat`.`zoom`, `Inzerat`.`map_type`, `Inzerat`.`idmajitel`, `Inzerat`.`idmakler1`, `Inzerat`.`idmakler2`, `Inzerat`.`synchro_inzeraty`, `Inzerat`.`synchro_zariadenia`, `Inzerat`.`demo`, `Inzerat`.`demo_do`, `Inzerat`.`nestandardny`, `Inzerat`.`nestandardny_od`, `Inzerat`.`nestandardny_do` FROM `realcms_banery` AS `Baner` LEFT JOIN `realcms_inzerat` AS `Inzerat` ON (`Baner`.`idinzerat` = `Inzerat`.`idinzerat`) WHERE `Inzerat`.`idinzerat` IS NOT NULL ORDER BY `Baner`.`pozicia` ASC LIMIT 3	3	3	0
55	SELECT `Inzerat`.`idinzerat`, `Inzerat`.`uzivatel_iduzivatel`, `Inzerat`.`nazov`, `Inzerat`.`alias`, `Inzerat`.`variabilny_symbol`, `Inzerat`.`text`, `Inzerat`.`cas`, `Inzerat`.`cas_zmeneny`, `Inzerat`.`druh`, `Inzerat`.`typ`, `Inzerat`.`obec`, `Inzerat`.`id_kat_uzemia`, `Inzerat`.`cena`, `Inzerat`.`platba_za_mesiac`, `Inzerat`.`dlzka_predplatenia`, `Inzerat`.`platnost_zmluvy_do`, `Inzerat`.`podpis_zmluvy`, `Inzerat`.`ulica`, `Inzerat`.`lokalita`, `Inzerat`.`schvaleny`, `Inzerat`.`top`, `Inzerat`.`kapacita`, `Inzerat`.`zobrazeni`, `Inzerat`.`je_mapa`, `Inzerat`.`suradnice`, `Inzerat`.`zoom`, `Inzerat`.`map_type`, `Inzerat`.`idmajitel`, `Inzerat`.`idmakler1`, `Inzerat`.`idmakler2`, `Inzerat`.`synchro_inzeraty`, `Inzerat`.`synchro_zariadenia`, `Inzerat`.`demo`, `Inzerat`.`demo_do`, `Inzerat`.`nestandardny`, `Inzerat`.`nestandardny_od`, `Inzerat`.`nestandardny_do` FROM `realcms_inzerat` AS `Inzerat` WHERE `Inzerat`.`idinzerat` = 1888	1	1	0
56	SELECT `Obec`.`idobec`, `Obec`.`nazov_obce`, `Obec`.`idokres`, `Obec`.`psc` FROM `realcms_obce` AS `Obec` WHERE `Obec`.`idobec` = 524077	1	1	0
57	SELECT `RestaurantOpeningHour`.`id`, `RestaurantOpeningHour`.`ad_id`, `RestaurantOpeningHour`.`open`, `RestaurantOpeningHour`.`day`, `RestaurantOpeningHour`.`from`, `RestaurantOpeningHour`.`to`, `RestaurantOpeningHour`.`modified` FROM `realcms_restaurant_opening_hours` AS `RestaurantOpeningHour` WHERE `RestaurantOpeningHour`.`ad_id` = (1888)	0	0	0
58	SELECT `RestaurantDetail`.`id`, `RestaurantDetail`.`ad_id`, `RestaurantDetail`.`contact`, `RestaurantDetail`.`created`, `RestaurantDetail`.`modified` FROM `realcms_restaurant_details` AS `RestaurantDetail` WHERE `RestaurantDetail`.`ad_id` = (1888)	0	0	0
59	SELECT `RestaurantMenu`.`id`, `RestaurantMenu`.`ad_id`, `RestaurantMenu`.`status`, `RestaurantMenu`.`type`, `RestaurantMenu`.`menu_date`, `RestaurantMenu`.`menu_week`, `RestaurantMenu`.`name`, `RestaurantMenu`.`price`, `RestaurantMenu`.`description`, `RestaurantMenu`.`created`, `RestaurantMenu`.`image_url`, `RestaurantMenu`.`modified` FROM `realcms_restaurant_menus` AS `RestaurantMenu` WHERE `RestaurantMenu`.`ad_id` = (1888)	0	0	0
60	SELECT `RestaurantPayment`.`id`, `RestaurantPayment`.`ad_id`, `RestaurantPayment`.`payment_type_id` FROM `realcms_restaurant_payments` AS `RestaurantPayment` WHERE `RestaurantPayment`.`ad_id` = (1888)	0	0	0
61	SELECT `Inzerat`.`idinzerat`, `Inzerat`.`uzivatel_iduzivatel`, `Inzerat`.`nazov`, `Inzerat`.`alias`, `Inzerat`.`variabilny_symbol`, `Inzerat`.`text`, `Inzerat`.`cas`, `Inzerat`.`cas_zmeneny`, `Inzerat`.`druh`, `Inzerat`.`typ`, `Inzerat`.`obec`, `Inzerat`.`id_kat_uzemia`, `Inzerat`.`cena`, `Inzerat`.`platba_za_mesiac`, `Inzerat`.`dlzka_predplatenia`, `Inzerat`.`platnost_zmluvy_do`, `Inzerat`.`podpis_zmluvy`, `Inzerat`.`ulica`, `Inzerat`.`lokalita`, `Inzerat`.`schvaleny`, `Inzerat`.`top`, `Inzerat`.`kapacita`, `Inzerat`.`zobrazeni`, `Inzerat`.`je_mapa`, `Inzerat`.`suradnice`, `Inzerat`.`zoom`, `Inzerat`.`map_type`, `Inzerat`.`idmajitel`, `Inzerat`.`idmakler1`, `Inzerat`.`idmakler2`, `Inzerat`.`synchro_inzeraty`, `Inzerat`.`synchro_zariadenia`, `Inzerat`.`demo`, `Inzerat`.`demo_do`, `Inzerat`.`nestandardny`, `Inzerat`.`nestandardny_od`, `Inzerat`.`nestandardny_do` FROM `realcms_inzerat` AS `Inzerat` WHERE `Inzerat`.`idinzerat` = 2292	1	1	0
62	SELECT `Obec`.`idobec`, `Obec`.`nazov_obce`, `Obec`.`idokres`, `Obec`.`psc` FROM `realcms_obce` AS `Obec` WHERE `Obec`.`idobec` = 505285	1	1	0
63	SELECT `RestaurantOpeningHour`.`id`, `RestaurantOpeningHour`.`ad_id`, `RestaurantOpeningHour`.`open`, `RestaurantOpeningHour`.`day`, `RestaurantOpeningHour`.`from`, `RestaurantOpeningHour`.`to`, `RestaurantOpeningHour`.`modified` FROM `realcms_restaurant_opening_hours` AS `RestaurantOpeningHour` WHERE `RestaurantOpeningHour`.`ad_id` = (2292)	0	0	0
64	SELECT `RestaurantDetail`.`id`, `RestaurantDetail`.`ad_id`, `RestaurantDetail`.`contact`, `RestaurantDetail`.`created`, `RestaurantDetail`.`modified` FROM `realcms_restaurant_details` AS `RestaurantDetail` WHERE `RestaurantDetail`.`ad_id` = (2292)	0	0	0
65	SELECT `RestaurantMenu`.`id`, `RestaurantMenu`.`ad_id`, `RestaurantMenu`.`status`, `RestaurantMenu`.`type`, `RestaurantMenu`.`menu_date`, `RestaurantMenu`.`menu_week`, `RestaurantMenu`.`name`, `RestaurantMenu`.`price`, `RestaurantMenu`.`description`, `RestaurantMenu`.`created`, `RestaurantMenu`.`image_url`, `RestaurantMenu`.`modified` FROM `realcms_restaurant_menus` AS `RestaurantMenu` WHERE `RestaurantMenu`.`ad_id` = (2292)	0	0	0
66	SELECT `RestaurantPayment`.`id`, `RestaurantPayment`.`ad_id`, `RestaurantPayment`.`payment_type_id` FROM `realcms_restaurant_payments` AS `RestaurantPayment` WHERE `RestaurantPayment`.`ad_id` = (2292)	0	0	0
67	SELECT `Inzerat`.`idinzerat`, `Inzerat`.`uzivatel_iduzivatel`, `Inzerat`.`nazov`, `Inzerat`.`alias`, `Inzerat`.`variabilny_symbol`, `Inzerat`.`text`, `Inzerat`.`cas`, `Inzerat`.`cas_zmeneny`, `Inzerat`.`druh`, `Inzerat`.`typ`, `Inzerat`.`obec`, `Inzerat`.`id_kat_uzemia`, `Inzerat`.`cena`, `Inzerat`.`platba_za_mesiac`, `Inzerat`.`dlzka_predplatenia`, `Inzerat`.`platnost_zmluvy_do`, `Inzerat`.`podpis_zmluvy`, `Inzerat`.`ulica`, `Inzerat`.`lokalita`, `Inzerat`.`schvaleny`, `Inzerat`.`top`, `Inzerat`.`kapacita`, `Inzerat`.`zobrazeni`, `Inzerat`.`je_mapa`, `Inzerat`.`suradnice`, `Inzerat`.`zoom`, `Inzerat`.`map_type`, `Inzerat`.`idmajitel`, `Inzerat`.`idmakler1`, `Inzerat`.`idmakler2`, `Inzerat`.`synchro_inzeraty`, `Inzerat`.`synchro_zariadenia`, `Inzerat`.`demo`, `Inzerat`.`demo_do`, `Inzerat`.`nestandardny`, `Inzerat`.`nestandardny_od`, `Inzerat`.`nestandardny_do` FROM `realcms_inzerat` AS `Inzerat` WHERE `Inzerat`.`idinzerat` = 1936	1	1	0
68	SELECT `Obec`.`idobec`, `Obec`.`nazov_obce`, `Obec`.`idokres`, `Obec`.`psc` FROM `realcms_obce` AS `Obec` WHERE `Obec`.`idobec` = 510998	1	1	0
69	SELECT `RestaurantOpeningHour`.`id`, `RestaurantOpeningHour`.`ad_id`, `RestaurantOpeningHour`.`open`, `RestaurantOpeningHour`.`day`, `RestaurantOpeningHour`.`from`, `RestaurantOpeningHour`.`to`, `RestaurantOpeningHour`.`modified` FROM `realcms_restaurant_opening_hours` AS `RestaurantOpeningHour` WHERE `RestaurantOpeningHour`.`ad_id` = (1936)	0	0	0
70	SELECT `RestaurantDetail`.`id`, `RestaurantDetail`.`ad_id`, `RestaurantDetail`.`contact`, `RestaurantDetail`.`created`, `RestaurantDetail`.`modified` FROM `realcms_restaurant_details` AS `RestaurantDetail` WHERE `RestaurantDetail`.`ad_id` = (1936)	0	0	0
71	SELECT `RestaurantMenu`.`id`, `RestaurantMenu`.`ad_id`, `RestaurantMenu`.`status`, `RestaurantMenu`.`type`, `RestaurantMenu`.`menu_date`, `RestaurantMenu`.`menu_week`, `RestaurantMenu`.`name`, `RestaurantMenu`.`price`, `RestaurantMenu`.`description`, `RestaurantMenu`.`created`, `RestaurantMenu`.`image_url`, `RestaurantMenu`.`modified` FROM `realcms_restaurant_menus` AS `RestaurantMenu` WHERE `RestaurantMenu`.`ad_id` = (1936)	0	0	0
72	SELECT `RestaurantPayment`.`id`, `RestaurantPayment`.`ad_id`, `RestaurantPayment`.`payment_type_id` FROM `realcms_restaurant_payments` AS `RestaurantPayment` WHERE `RestaurantPayment`.`ad_id` = (1936)	0	0	0
73	SELECT `Obrazok`.`idobrazok`, `Obrazok`.`url`, `Obrazok`.`sort`, `Obrazok`.`inzerat_idinzerat` FROM `realcms_obrazok` AS `Obrazok` WHERE `Obrazok`.`inzerat_idinzerat` IN (1888, 2292, 1936) ORDER BY `Obrazok`.`sort` asc	64	64	0
74	SELECT `Lokalita`.`id`, `Lokalita`.`lokalita`, `Lokalita`.`lokalita_seo` FROM `realcms_lokality` AS `Lokalita` WHERE lower(`Lokalita`.`lokalita_seo`) = 'Ponitrie' LIMIT 1	1	1	0
75	SELECT `Obec`.`idobec`, `Obec`.`nazov_obce`, `Obec`.`idokres`, `Obec`.`psc`, `LokalitaObce`.`lokalita_id`, `LokalitaObce`.`obec_id` FROM `realcms_obce` AS `Obec` JOIN `realcms_lokality_obce` AS `LokalitaObce` ON (`LokalitaObce`.`lokalita_id` = 6 AND `LokalitaObce`.`obec_id` = `Obec`.`idobec`) WHERE 1 = 1	534	534	0
76	SELECT `BanerLokalita`.`lokalita_id`, `BanerLokalita`.`pozicia`, `BanerLokalita`.`idinzerat`, `Inzerat`.`idinzerat`, `Inzerat`.`uzivatel_iduzivatel`, `Inzerat`.`nazov`, `Inzerat`.`alias`, `Inzerat`.`variabilny_symbol`, `Inzerat`.`text`, `Inzerat`.`cas`, `Inzerat`.`cas_zmeneny`, `Inzerat`.`druh`, `Inzerat`.`typ`, `Inzerat`.`obec`, `Inzerat`.`id_kat_uzemia`, `Inzerat`.`cena`, `Inzerat`.`platba_za_mesiac`, `Inzerat`.`dlzka_predplatenia`, `Inzerat`.`platnost_zmluvy_do`, `Inzerat`.`podpis_zmluvy`, `Inzerat`.`ulica`, `Inzerat`.`lokalita`, `Inzerat`.`schvaleny`, `Inzerat`.`top`, `Inzerat`.`kapacita`, `Inzerat`.`zobrazeni`, `Inzerat`.`je_mapa`, `Inzerat`.`suradnice`, `Inzerat`.`zoom`, `Inzerat`.`map_type`, `Inzerat`.`idmajitel`, `Inzerat`.`idmakler1`, `Inzerat`.`idmakler2`, `Inzerat`.`synchro_inzeraty`, `Inzerat`.`synchro_zariadenia`, `Inzerat`.`demo`, `Inzerat`.`demo_do`, `Inzerat`.`nestandardny`, `Inzerat`.`nestandardny_od`, `Inzerat`.`nestandardny_do` FROM `realcms_banery_lokality` AS `BanerLokalita` LEFT JOIN `realcms_inzerat` AS `Inzerat` ON (`BanerLokalita`.`idinzerat` = `Inzerat`.`idinzerat`) WHERE `BanerLokalita`.`lokalita_id` = 6 AND `BanerLokalita`.`idinzerat` != 0 AND `Inzerat`.`idinzerat` IS NOT NULL ORDER BY `BanerLokalita`.`pozicia` ASC LIMIT 8	2	2	1
77	SELECT `Obrazok`.`idobrazok`, `Obrazok`.`url`, `Obrazok`.`sort`, `Obrazok`.`inzerat_idinzerat` FROM `realcms_obrazok` AS `Obrazok` WHERE `Obrazok`.`inzerat_idinzerat` IN (1751, 2165) ORDER BY `Obrazok`.`sort` asc	43	43	0
78	SELECT COUNT(*) AS `count` FROM `realcms_inzerat` AS `Inzerat` LEFT JOIN `realcms_obce` AS `Obec` ON (`Inzerat`.`obec` = `Obec`.`idobec`) LEFT JOIN `realcms_zakaznik` AS `Ubytovatel` ON (`Inzerat`.`idmajitel` = `Ubytovatel`.`id_uzivatel`) LEFT JOIN `realcms_druhy` AS `Druh` ON (`Inzerat`.`druh` = `Druh`.`iddruh`) LEFT JOIN `realcms_platnost_inzeratu` AS `PlatnostInzeratu` ON (`PlatnostInzeratu`.`idinzerat` = `Inzerat`.`idinzerat`) WHERE NOT (`Inzerat`.`druh` = '12') AND `Inzerat`.`schvaleny` = 1 AND `Inzerat`.`obec` IN ('500011', '500020', '500429', '500437', '500453', '500461', '500470', '500488', '500500', '500518', '500534', '500542', '500551', '500569', '500577', '500585', '500593', '500607', '500631', '500640', '500658', '500666', '500674', '500682', '500691', '500704', '500712', '500721', '500747', '500755', '500780', '500798', '500810', '500828', '500836', '500844', '500887', '500895', '500909', '500917', '500925', '500933', '500941', '500950', '500968', '500976', '500984', '500992', '501018', '504998', '505021', '505048', '505056', '505064', '505072', '505102', '505129', '505137', '505153', '505170', '505196', '505200', '505226', '505234', '505242', '505251', '505277', '505285', '505307', '505315', '505323', '505331', '505340', '505358', '505374', '505382', '505404', '505412', '505421', '505439', '505447', '505455', '505463', '505471', '505480', '505498', '505510', '505536', '505544', '505552', '505561', '505579', '505595', '505617', '505625', '505633', '505641', '505676', '505684', '505692', '505706', '505714', '505722', '505731', '505749', '505757', '505765', '505773', '505790', '505803', '505811', '513881', '513903', '513911', '513920', '513938', '513946', '513954', '513962', '513971', '513989', '513997', '514004', '514012', '514021', '514039', '514063', '514071', '514080', '514098', '514101', '514110', '514128', '514136', '514144', '514179', '514187', '514209', '514217', '514225', '514233', '514241', '514250', '514268', '514284', '514292', '514306', '514314', '514322', '514331', '514349', '514357', '514365', '514373', '514381', '514390', '514403', '514411', '514420', '514438', '514454', '517305', '542652', '542661', '542695', '542709', '542717', '542733', '542741', '542776', '542792', '542806', '542822', '542849', '542857', '542873', '542881', '542890', '542920', '542938', '542954', '542962', '542971', '543004', '543039', '543047', '543055', '543063', '543071', '543080', '543101', '543110', '543136', '545589', '545635', '545651', '555851', '555860', '555886', '555908', '555916', '555924', '555932', '555959', '555967', '555991', '556149', '556157', '556165', '556173', '556190', '556211', '556220', '556238', '556246', '556262', '556271', '556289', '556297', '556327', '556351', '556360', '556408', '556416', '556696', '556742', '556785', '556793', '557706', '557714', '558320', '580449', '580457', '580899', '580953', '581097', '581305', '581623', '581658', '581691', '581704', '582387', '582425', '582697', '582719', '582816', '500046', '500062', '500071', '500101', '500127', '500135', '500151', '500160', '500194', '500232', '500283', '500305', '500313', '500321', '500356', '500364', '500372', '500381', '500399', '500402', '500411') AND `Inzerat`.`demo` = 0	1	1	32
79	SELECT `Inzerat`.`idinzerat`, `Inzerat`.`uzivatel_iduzivatel`, `Inzerat`.`nazov`, `Inzerat`.`alias`, `Inzerat`.`variabilny_symbol`, `Inzerat`.`text`, `Inzerat`.`cas`, `Inzerat`.`cas_zmeneny`, `Inzerat`.`druh`, `Inzerat`.`typ`, `Inzerat`.`obec`, `Inzerat`.`id_kat_uzemia`, `Inzerat`.`cena`, `Inzerat`.`platba_za_mesiac`, `Inzerat`.`dlzka_predplatenia`, `Inzerat`.`platnost_zmluvy_do`, `Inzerat`.`podpis_zmluvy`, `Inzerat`.`ulica`, `Inzerat`.`lokalita`, `Inzerat`.`schvaleny`, `Inzerat`.`top`, `Inzerat`.`kapacita`, `Inzerat`.`zobrazeni`, `Inzerat`.`je_mapa`, `Inzerat`.`suradnice`, `Inzerat`.`zoom`, `Inzerat`.`map_type`, `Inzerat`.`idmajitel`, `Inzerat`.`idmakler1`, `Inzerat`.`idmakler2`, `Inzerat`.`synchro_inzeraty`, `Inzerat`.`synchro_zariadenia`, `Inzerat`.`demo`, `Inzerat`.`demo_do`, `Inzerat`.`nestandardny`, `Inzerat`.`nestandardny_od`, `Inzerat`.`nestandardny_do`, `Obec`.`idobec`, `Obec`.`nazov_obce`, `Obec`.`idokres`, `Obec`.`psc`, `Ubytovatel`.`id_uzivatel`, `Ubytovatel`.`meno`, `Ubytovatel`.`priezvisko`, `Ubytovatel`.`ulica`, `Ubytovatel`.`mesto`, `Ubytovatel`.`psc`, `Ubytovatel`.`fakturacna_ulica`, `Ubytovatel`.`fakturacna_mesto`, `Ubytovatel`.`fakturacna_psc`, `Ubytovatel`.`fakturacny_email`, `Ubytovatel`.`telefon`, `Ubytovatel`.`telefon_zobrazit`, `Ubytovatel`.`telefon1`, `Ubytovatel`.`telefon1_zobrazit`, `Ubytovatel`.`telefon2`, `Ubytovatel`.`telefon2_zobrazit`, `Ubytovatel`.`telefon3`, `Ubytovatel`.`telefon3_zobrazit`, `Ubytovatel`.`telefon4`, `Ubytovatel`.`telefon4_zobrazit`, `Ubytovatel`.`telefon5`, `Ubytovatel`.`telefon5_zobrazit`, `Ubytovatel`.`web`, `Ubytovatel`.`fax`, `Ubytovatel`.`email`, `Ubytovatel`.`spolocnost`, `Ubytovatel`.`ico`, `Ubytovatel`.`dic`, `Ubytovatel`.`icdph`, `Ubytovatel`.`cislo_uctu`, `Ubytovatel`.`kod_banky`, `Ubytovatel`.`poznamka`, `Ubytovatel`.`datum_pridania`, `Ubytovatel`.`datum_zmeny`, `Ubytovatel`.`iduzivatel`, `Ubytovatel`.`kraj`, `Ubytovatel`.`okres`, `Ubytovatel`.`obec`, `Ubytovatel`.`druh`, `Ubytovatel`.`typ`, `Ubytovatel`.`cena`, `Ubytovatel`.`velkost`, `Ubytovatel`.`posielat_statistiky`, `Druh`.`iddruh`, `Druh`.`druh`, `Druh`.`zobrazeni`, `Druh`.`cena`, `PlatnostInzeratu`.`idinzerat`, `PlatnostInzeratu`.`do`, `PlatnostInzeratu`.`upozornenie_makler_1`, `PlatnostInzeratu`.`upozornenie_makler_2`, `PlatnostInzeratu`.`upozornenie_zakaznik_1`, `PlatnostInzeratu`.`upozornenie_zakaznik_2` FROM `realcms_inzerat` AS `Inzerat` LEFT JOIN `realcms_obce` AS `Obec` ON (`Inzerat`.`obec` = `Obec`.`idobec`) LEFT JOIN `realcms_zakaznik` AS `Ubytovatel` ON (`Inzerat`.`idmajitel` = `Ubytovatel`.`id_uzivatel`) LEFT JOIN `realcms_druhy` AS `Druh` ON (`Inzerat`.`druh` = `Druh`.`iddruh`) LEFT JOIN `realcms_platnost_inzeratu` AS `PlatnostInzeratu` ON (`PlatnostInzeratu`.`idinzerat` = `Inzerat`.`idinzerat`) WHERE NOT (`Inzerat`.`druh` = '12') AND `Inzerat`.`schvaleny` = 1 AND `Inzerat`.`obec` IN ('500011', '500020', '500429', '500437', '500453', '500461', '500470', '500488', '500500', '500518', '500534', '500542', '500551', '500569', '500577', '500585', '500593', '500607', '500631', '500640', '500658', '500666', '500674', '500682', '500691', '500704', '500712', '500721', '500747', '500755', '500780', '500798', '500810', '500828', '500836', '500844', '500887', '500895', '500909', '500917', '500925', '500933', '500941', '500950', '500968', '500976', '500984', '500992', '501018', '504998', '505021', '505048', '505056', '505064', '505072', '505102', '505129', '505137', '505153', '505170', '505196', '505200', '505226', '505234', '505242', '505251', '505277', '505285', '505307', '505315', '505323', '505331', '505340', '505358', '505374', '505382', '505404', '505412', '505421', '505439', '505447', '505455', '505463', '505471', '505480', '505498', '505510', '505536', '505544', '505552', '505561', '505579', '505595', '505617', '505625', '505633', '505641', '505676', '505684', '505692', '505706', '505714', '505722', '505731', '505749', '505757', '505765', '505773', '505790', '505803', '505811', '513881', '513903', '513911', '513920', '513938', '513946', '513954', '513962', '513971', '513989', '513997', '514004', '514012', '514021', '514039', '514063', '514071', '514080', '514098', '514101', '514110', '514128', '514136', '514144', '514179', '514187', '514209', '514217', '514225', '514233', '514241', '514250', '514268', '514284', '514292', '514306', '514314', '514322', '514331', '514349', '514357', '514365', '514373', '514381', '514390', '514403', '514411', '514420', '514438', '514454', '517305', '542652', '542661', '542695', '542709', '542717', '542733', '542741', '542776', '542792', '542806', '542822', '542849', '542857', '542873', '542881', '542890', '542920', '542938', '542954', '542962', '542971', '543004', '543039', '543047', '543055', '543063', '543071', '543080', '543101', '543110', '543136', '545589', '545635', '545651', '555851', '555860', '555886', '555908', '555916', '555924', '555932', '555959', '555967', '555991', '556149', '556157', '556165', '556173', '556190', '556211', '556220', '556238', '556246', '556262', '556271', '556289', '556297', '556327', '556351', '556360', '556408', '556416', '556696', '556742', '556785', '556793', '557706', '557714', '558320', '580449', '580457', '580899', '580953', '581097', '581305', '581623', '581658', '581691', '581704', '582387', '582425', '582697', '582719', '582816', '500046', '500062', '500071', '500101', '500127', '500135', '500151', '500160', '500194', '500232', '500283', '500305', '500313', '500321', '500356', '500364', '500372', '500381', '500399', '500402', '500411') AND `Inzerat`.`demo` = 0 ORDER BY `Inzerat`.`cena` asc LIMIT 10	10	10	45
80	SELECT `RestaurantOpeningHour`.`id`, `RestaurantOpeningHour`.`ad_id`, `RestaurantOpeningHour`.`open`, `RestaurantOpeningHour`.`day`, `RestaurantOpeningHour`.`from`, `RestaurantOpeningHour`.`to`, `RestaurantOpeningHour`.`modified` FROM `realcms_restaurant_opening_hours` AS `RestaurantOpeningHour` WHERE `RestaurantOpeningHour`.`ad_id` IN (2064, 2063, 2051, 2005, 1989, 2287, 2113, 2096, 1981, 1997)	0	0	1
81	SELECT `RestaurantDetail`.`id`, `RestaurantDetail`.`ad_id`, `RestaurantDetail`.`contact`, `RestaurantDetail`.`created`, `RestaurantDetail`.`modified` FROM `realcms_restaurant_details` AS `RestaurantDetail` WHERE `RestaurantDetail`.`ad_id` IN (2064, 2063, 2051, 2005, 1989, 2287, 2113, 2096, 1981, 1997)	0	0	0
82	SELECT `RestaurantMenu`.`id`, `RestaurantMenu`.`ad_id`, `RestaurantMenu`.`status`, `RestaurantMenu`.`type`, `RestaurantMenu`.`menu_date`, `RestaurantMenu`.`menu_week`, `RestaurantMenu`.`name`, `RestaurantMenu`.`price`, `RestaurantMenu`.`description`, `RestaurantMenu`.`created`, `RestaurantMenu`.`image_url`, `RestaurantMenu`.`modified` FROM `realcms_restaurant_menus` AS `RestaurantMenu` WHERE `RestaurantMenu`.`ad_id` IN (2064, 2063, 2051, 2005, 1989, 2287, 2113, 2096, 1981, 1997)	0	0	1
83	SELECT `RestaurantPayment`.`id`, `RestaurantPayment`.`ad_id`, `RestaurantPayment`.`payment_type_id` FROM `realcms_restaurant_payments` AS `RestaurantPayment` WHERE `RestaurantPayment`.`ad_id` IN (2064, 2063, 2051, 2005, 1989, 2287, 2113, 2096, 1981, 1997)	0	0	0
84	SELECT `Charakteristika`.`id`, `Charakteristika`.`idinzerat`, `Charakteristika`.`idchar`, `Charakteristika`.`hodnota`, `Charakteristika`.`vyber` FROM `realcms_charakteristiky` AS `Charakteristika` WHERE `Charakteristika`.`idinzerat` IN (2064, 2063, 2051, 2005, 1989, 2287, 2113, 2096, 1981, 1997)	423	423	27
85	SELECT `Obrazok`.`idobrazok`, `Obrazok`.`url`, `Obrazok`.`sort`, `Obrazok`.`inzerat_idinzerat` FROM `realcms_obrazok` AS `Obrazok` WHERE `Obrazok`.`inzerat_idinzerat` IN (2064, 2063, 2051, 2005, 1989, 2287, 2113, 2096, 1981, 1997) ORDER BY `Obrazok`.`sort` asc, `Obrazok`.`idobrazok` asc	191	191	15
86	SELECT `Komentar`.`id`, `Komentar`.`nick`, `Komentar`.`email`, `Komentar`.`komentar`, `Komentar`.`inzerat_id`, `Komentar`.`ip_adresa`, `Komentar`.`created` FROM `realcms_komentare` AS `Komentar` WHERE `Komentar`.`inzerat_id` IN (2064, 2063, 2051, 2005, 1989, 2287, 2113, 2096, 1981, 1997)	0	0	0
87	SELECT `StravaInzerat`.`idinzerat`, `StravaInzerat`.`idstravy`, `StravaInzerat`.`value` FROM `realcms_strava_inzeraty` AS `StravaInzerat` WHERE `StravaInzerat`.`value` = 1 AND `StravaInzerat`.`idinzerat` IN (2064, 2063, 2051, 2005, 1989, 2287, 2113, 2096, 1981, 1997)	22	22	1
88	SELECT `Cena`.`id`, `Cena`.`idinzerat`, `Cena`.`id_ceny_nazvy`, `Cena`.`cena`, `Cena`.`poznamka_k_cene`, `Cena`.`mena`, `Cena`.`povina_cena` FROM `realcms_ceny` AS `Cena` WHERE `Cena`.`idinzerat` IN (2064, 2063, 2051, 2005, 1989, 2287, 2113, 2096, 1981, 1997) ORDER BY `povina_cena` DESC	19	19	2
89	SELECT `Zlava`.`id`, `Zlava`.`idinzerat`, `Zlava`.`id_zlava_nazov`, `Zlava`.`zlava`, `Zlava`.`poznamka_k_zlave`, `Zlava`.`mena` FROM `realcms_zlavy` AS `Zlava` WHERE `Zlava`.`idinzerat` IN (2064, 2063, 2051, 2005, 1989, 2287, 2113, 2096, 1981, 1997)	5	5	1
90	SELECT `Vzdialenost1`.`id`, `Vzdialenost1`.`id_inzerat1`, `Vzdialenost1`.`id_inzerat2`, `Vzdialenost1`.`vzdialenost`, `Vzdialenost1`.`modified` FROM `realcms_inzerat_vzdialenosti` AS `Vzdialenost1` WHERE (`Vzdialenost1`.`id_inzerat1` = 2064 OR `Vzdialenost1`.`id_inzerat2` = 2064) ORDER BY `Vzdialenost1`.`vzdialenost` asc	1014	1014	1
91	SELECT `Vzdialenost1`.`id`, `Vzdialenost1`.`id_inzerat1`, `Vzdialenost1`.`id_inzerat2`, `Vzdialenost1`.`vzdialenost`, `Vzdialenost1`.`modified` FROM `realcms_inzerat_vzdialenosti` AS `Vzdialenost1` WHERE (`Vzdialenost1`.`id_inzerat1` = 2063 OR `Vzdialenost1`.`id_inzerat2` = 2063) ORDER BY `Vzdialenost1`.`vzdialenost` asc	1014	1014	151
92	SELECT `Vzdialenost1`.`id`, `Vzdialenost1`.`id_inzerat1`, `Vzdialenost1`.`id_inzerat2`, `Vzdialenost1`.`vzdialenost`, `Vzdialenost1`.`modified` FROM `realcms_inzerat_vzdialenosti` AS `Vzdialenost1` WHERE (`Vzdialenost1`.`id_inzerat1` = 2051 OR `Vzdialenost1`.`id_inzerat2` = 2051) ORDER BY `Vzdialenost1`.`vzdialenost` asc	1016	1016	1
93	SELECT `Vzdialenost1`.`id`, `Vzdialenost1`.`id_inzerat1`, `Vzdialenost1`.`id_inzerat2`, `Vzdialenost1`.`vzdialenost`, `Vzdialenost1`.`modified` FROM `realcms_inzerat_vzdialenosti` AS `Vzdialenost1` WHERE (`Vzdialenost1`.`id_inzerat1` = 2005 OR `Vzdialenost1`.`id_inzerat2` = 2005) ORDER BY `Vzdialenost1`.`vzdialenost` asc	975	975	114
94	SELECT `Vzdialenost1`.`id`, `Vzdialenost1`.`id_inzerat1`, `Vzdialenost1`.`id_inzerat2`, `Vzdialenost1`.`vzdialenost`, `Vzdialenost1`.`modified` FROM `realcms_inzerat_vzdialenosti` AS `Vzdialenost1` WHERE (`Vzdialenost1`.`id_inzerat1` = 1989 OR `Vzdialenost1`.`id_inzerat2` = 1989) ORDER BY `Vzdialenost1`.`vzdialenost` asc	1020	1020	114
95	SELECT `Vzdialenost1`.`id`, `Vzdialenost1`.`id_inzerat1`, `Vzdialenost1`.`id_inzerat2`, `Vzdialenost1`.`vzdialenost`, `Vzdialenost1`.`modified` FROM `realcms_inzerat_vzdialenosti` AS `Vzdialenost1` WHERE (`Vzdialenost1`.`id_inzerat1` = 2287 OR `Vzdialenost1`.`id_inzerat2` = 2287) ORDER BY `Vzdialenost1`.`vzdialenost` asc	853	853	112
96	SELECT `Vzdialenost1`.`id`, `Vzdialenost1`.`id_inzerat1`, `Vzdialenost1`.`id_inzerat2`, `Vzdialenost1`.`vzdialenost`, `Vzdialenost1`.`modified` FROM `realcms_inzerat_vzdialenosti` AS `Vzdialenost1` WHERE (`Vzdialenost1`.`id_inzerat1` = 2113 OR `Vzdialenost1`.`id_inzerat2` = 2113) ORDER BY `Vzdialenost1`.`vzdialenost` asc	1011	1011	1
97	SELECT `Vzdialenost1`.`id`, `Vzdialenost1`.`id_inzerat1`, `Vzdialenost1`.`id_inzerat2`, `Vzdialenost1`.`vzdialenost`, `Vzdialenost1`.`modified` FROM `realcms_inzerat_vzdialenosti` AS `Vzdialenost1` WHERE (`Vzdialenost1`.`id_inzerat1` = 2096 OR `Vzdialenost1`.`id_inzerat2` = 2096) ORDER BY `Vzdialenost1`.`vzdialenost` asc	1013	1013	1
98	SELECT `Vzdialenost1`.`id`, `Vzdialenost1`.`id_inzerat1`, `Vzdialenost1`.`id_inzerat2`, `Vzdialenost1`.`vzdialenost`, `Vzdialenost1`.`modified` FROM `realcms_inzerat_vzdialenosti` AS `Vzdialenost1` WHERE (`Vzdialenost1`.`id_inzerat1` = 1981 OR `Vzdialenost1`.`id_inzerat2` = 1981) ORDER BY `Vzdialenost1`.`vzdialenost` asc	1018	1018	118
99	SELECT `Vzdialenost1`.`id`, `Vzdialenost1`.`id_inzerat1`, `Vzdialenost1`.`id_inzerat2`, `Vzdialenost1`.`vzdialenost`, `Vzdialenost1`.`modified` FROM `realcms_inzerat_vzdialenosti` AS `Vzdialenost1` WHERE (`Vzdialenost1`.`id_inzerat1` = 1997 OR `Vzdialenost1`.`id_inzerat2` = 1997) ORDER BY `Vzdialenost1`.`vzdialenost` asc	1112	1112	1
100	SELECT `VzdialenostMesta`.`id`, `VzdialenostMesta`.`id_inzerat`, `VzdialenostMesta`.`mesto`, `VzdialenostMesta`.`vzdialenost`, `VzdialenostMesta`.`updated` FROM `realcms_inzerat_vzdialenosti_mesta` AS `VzdialenostMesta` WHERE `VzdialenostMesta`.`id_inzerat` IN (2064, 2063, 2051, 2005, 1989, 2287, 2113, 2096, 1981, 1997)	350	350	4

Vyhľadávanie

Výsledky vyhľadávania

Top inzeráty

HOTEL POD ZÁMKOM **** /wellness,kongress/ Bojnice - Prievidza

PENZION SIGNÁL,Bojnice- Prievidza

UBYTOVANIE U MILKY - Bojnice, Prievidza

HOTEL A REŠTAURÁCIA EDEN , Handlová - Prievidza

PENZION ASSO ,Bojnice - Prievidza

Apartmánové ubytovanie Zelený dom - Bojnice

Ubytovanie PETRO, Bojnice/Opatovce nad Nitrou/okres Prievidza

HOTEL ZARA **** ,Topoľčany

PENZION ORION , Prievidza

PENZION ALENA , Bojnice /centrum/ ,Prievidza

Polohy inzerátov na mape