Ubytovanie v lokalite Zemplín

Result of the searching

27 ads | sorted inteligent▼

Top accomodations

Vojenská Zotavovňa...

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" => "eng",
	"podstranky" => array(
	array(),
	array(),
	array(),
	array(),
	array()
),
	"pocet_pristupov" => 4978338,
	"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()
),
	"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" => "Zemplín",
	"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/Zemplin/page:2"
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/Zemplin/page:2"
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/Zemplin/page:2"
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/Zemplin/page:2"
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/Zemplin/page:2"
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/Zemplin/page:2"
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 = 1328542344
SessionHelper::$sessionTime = false
SessionHelper::$watchKeys = array
SessionHelper::$id = NULL
SessionHelper::$_log = NULL
SessionHelper::$base = ""
SessionHelper::$webroot = "/"
SessionHelper::$here = "/lokalita/Zemplin/page:2"
SessionHelper::$params = array
SessionHelper::$action = "lokalita"
SessionHelper::$data = NULL
SessionHelper::$themeWeb = NULL
SessionHelper::$plugin = NULL
)
$loadHelpers	=	false
$cached	=	false
$loadedHelpers	=	array()
$jazyk	=	"eng"
$podstranky	=	array(
	array(
	"Texty" => array()
),
	array(
	"Texty" => array()
),
	array(
	"Texty" => array()
),
	array(
	"Texty" => array()
),
	array(
	"Texty" => array()
)
)
$pocet_pristupov	=	4978338
$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()
)
)
$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	=	"Zemplín"
$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/Zemplin/page:2"
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/Zemplin/page:2"
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/Zemplin/page:2"
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/Zemplin/page:2"
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/Zemplin/page:2"
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/Zemplin/page:2"
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 = 1328542344
SessionHelper::$sessionTime = false
SessionHelper::$watchKeys = array
SessionHelper::$id = NULL
SessionHelper::$_log = NULL
SessionHelper::$base = ""
SessionHelper::$webroot = "/"
SessionHelper::$here = "/lokalita/Zemplin/page:2"
SessionHelper::$params = array
SessionHelper::$action = "lokalita"
SessionHelper::$data = NULL
SessionHelper::$themeWeb = NULL
SessionHelper::$plugin = NULL
$baner	=	array(
	"BanerLokalita" => array(
	"lokalita_id" => "20",
	"pozicia" => "1",
	"idinzerat" => "1171"
),
	"Inzerat" => array(
	"idinzerat" => "1171",
	"uzivatel_iduzivatel" => "589",
	"nazov" => "Vojenská Zotavovňa a hotel Zemplínska Šírava,Michalovce",
	"alias" => "1171-Vojensk",
	"variabilny_symbol" => "36659207",
	"text" => "Vojenská zotavovňa a hotel, sa nachádza v centre rekreačnej oblasti Zemplínska šírava, 13 km od mesta Michalovce. Vodná nádrž poskytuje vhodné podmienky pre celoročnú rekreáciu.
V rekreačnom komplexe zotavovne a hotela je možné využiť: tenisové kurty, volej-balové ihriská, miniaturgolf , krytý plavecký bazén, posilovňu , saunu, vodolieč-bu, elektroliečbu.
Pláž a lodenica v areáli poskytuje svoje služby od 1.6. do 30.9. V lete i zime je turistika obohatená o autokarovú ponuku zájazdov za kultúrno - historickými a prírodnými zaujímavosťami celého Zemplínskeho regiónu.",
	"cas" => "1264700156",
	"cas_zmeneny" => "1278838006",
	"druh" => "1",
	"typ" => null,
	"obec" => "522589",
	"id_kat_uzemia" => "",
	"cena" => "17",
	"platba_za_mesiac" => "180",
	"dlzka_predplatenia" => "4",
	"platnost_zmluvy_do" => "1318024800",
	"podpis_zmluvy" => "1278540000",
	"ulica" => "Medvedia Hora č.p. 556",
	"lokalita" => "Zemplínska Šírava",
	"schvaleny" => "1",
	"top" => "0",
	"kapacita" => "400",
	"zobrazeni" => "4895",
	"je_mapa" => "1",
	"suradnice" => "48.798836,22.004671",
	"zoom" => "14",
	"map_type" => "G_NORMAL_MAP",
	"idmajitel" => "4824",
	"idmakler1" => "606",
	"idmakler2" => "0",
	"synchro_inzeraty" => "1328431218",
	"synchro_zariadenia" => "1328483525",
	"demo" => "0",
	"demo_do" => "1267378556",
	"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(),
	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/20841.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: 17 EUR

« Back 1 | 2 | 3 Forward »

Penzión Milénium

Pensions | Humenné | Zemplín

Detail

Price (person/night): 27 EUR (813,40 Sk)

Capacity: 10

Našou snahou je Vaša maximálna spokojnosť a pohodlie. Radi Vás obslúžime v príjemnom prostredí reštaurácie s kapacitou cca 40 miest, ktorá je súčasťou penziónu. V reštaurácii sa nachádza aj salónik. V prípade priaznivého počasia Vám ponúkame posedenie na vonkajšej terase s kapacitou cca 20 miest. V reštaurácii sa nachádza LCD TV, ktorý je vhodný pri uzavretých firemných a iných akciách. V penzióne Vám ponúkame ubytovanie pre podnikateľov, obchodných cestujúcich, turistov a občanov mesta. Vybavenie izieb: - televízor - satelitný /káblový/ príjem TV - internet na izbe - sušič vlasov na izbe - balkón (3 x) - kúpeľňa na izbe - sprchovací kút - pripojenie na inernet s v...

Penzión Tokaj Ostrožovič,Tokajská oblasť

Pensions | Veľká Tŕňa | Tokajská oblasť

Detail

Price (person/night): 33 EUR (994,16 Sk)

Capacity: 30

Sme vinohradnícko-vinárska firma s 20 ročnou tradíciou. V našom penzióne,ktorý sa nachádza priamo v uzavretom areáli vinárskej firmy,Vás radi privítame s možnosťou usporiadania kongresov,školení,firemných a rodinných osláv do 40 osôb.Je Vám k dispozícií ubytovanie,free wifi,tiež spoločenská miestnosť so zázemím pre grilovanie. U nás si môžete vychutnať špeciality zemplínskej kuchyne. Taktiež je Vám k dispozícií vínna sála,tokajská pivnica s možnosťou ochutnávky vín (výťah do vínnej pivnice). Veľmi radi Vás prevedieme aj našimi vinohradmi. Priamo od nás výrobcov si môžete pre seba a svojich blízkych kúpiť víno v širokom sortimente a v darčekovom balení. Pre milovníkov športu je tu možnosť...

CHATA NÁBYTOK Turistická ubytovňa

Cottages | Bungalows | Nová Kelča | Domaša

Detail

Price (person/night): 7 EUR (210,88 Sk)

Capacity: 25

Chata Nábytok sa nachádza v centre rekreačnej oblasti Domaša časť Nová Kelča, ponúka ubytovanie v 2-, 3- a 4-, 6- posteľových izbách. Možnosť stravovania je v reštaurácii Zuzana. Jej súčasťou je i bar a vonkajšie posedenie. Bezpečné parkovanie je priamo pri zariadení, ktoré je v cene ubytovania. V chate sa nachádza detský kútik, stolný futbal, pingpong a rekreačne volejbal a nohejbal. Chata sa nachádza v peknom prostredí, s možnosťou opekania, grilovania (gril je k dispozícii ubytovaným hosťom) , a hlavne kúpania, nachádza sa iba 100 m od vodnej nádrže, ktorá si vďaka samočistiacej schopnosti ako jedna z mála na Slovensku zachováva stále čistú a modrastú vodu. Cenník: Izba I. Tried...

Motorest Milka, Ubľa Východné Karpaty(okr.Snina)

Motels | Ubľa | Východne Karpaty

Detail

Price (person/night): 8 EUR (241,01 Sk)

Capacity: 12

Motorest MILKA má pre svojich hostí pripravené ubytovanie s kapacitou 12 lôžok. Návštevníkom motorestu sú k dispozícii apartmány, hosťovské a podkrovné izby s možnosťou prístelky. V apartmánoch sa nachádza kozub, kúpelňa, vírivá vaňa, WC, jedálenský stôl, TV satelit a malá terasa. Ubytovaným hosťom je k dispozícii spoločenská miestnosť s televízorom, ktorej súčasťou je aj kútik pre spoločenské hry. Každý hosť má vyhradené aj vlastné garážovacie miesto v areáli motorestu ktoré je strážené 24 hod. U nás si môžete pochutnať na studených a teplých predjedlách, jedlách z bravčového, hydinového, hovädzieho alebo morčacieho mäsa. Chutné sú tiež jedlá z rýb, syra a cestovín. Taktiež Vám priprav...

Penzión Opál, Vranov nad Topľou - Zamutov

Pensions | Zámutov | Vranov nad Topľou

Detail

Price (person/night): 14 EUR (421,76 Sk)

Capacity: 33

Penzión* Opál sa nachádza v rázovitej obci Zámutov na úpätí Slanských vrchov okres Vranov nad Topľou. Penzión je spravovaný zväčša členmi rodiny a my sa snažíme, aby sa aj naši hostia cítili ako doma. Okrem ubytovania a vynikajúcej kuchyne ponúkame aj možnosť prenájmu miestnosti na rôzne spoločenské podujatia (napr. oslavy, svadby alebo školenia). K penziónu patrí veľká záhrada s grilom, tenisovým kurtom, golfovým putting green a multifunkčným ihriskom s umelým trávnikom. V zime si môžu naši hostia zalyžovať na neďalekom lyžiarskom vleku, ktorý taktiež patrí k penziónu. Okolité Slanské vrchy ako aj obec Zámutov taktiež ponúkajú množstvo možností na turistiku a oddych – jazda na koni, strel...

Chata Mirka - Biela Hora - Zemplínska Šírava

Cottages | Bungalows | Vinné | Zemplinska šírava

Detail

Price (person/night): 7 EUR (210,88 Sk)

Capacity: 8

Ubytovanie v chatke v tichom prostredí vo vzdialenosti asi 100 m od brehu vodnej nádrže Zemplínska Šírava. Asi 5 km sú vzdialené bazény. V tesnej blízkosti chatky sa nachádza reštaurácia U starého kapra viď.foto-galéria. Súčasťou chatky je terasa so stolom a stoličkami, kde môžte stráviť príjemné chvíle pohody.

Ubytovanie pri SOŠ vinársko-ovocinárskej, Viničky, Tokajská oblasť

Apartments | Viničky | Tokajská oblasť

Detail

Price (person/night): 14 EUR (421,76 Sk)

Capacity: 43

Ubytovanie internátneho typu sa nachádza priamo v areáli školy, v prekrásnom prostredí tokajských vinohradov. Je tu veľmi dobrá dostupnosť autom, autobusom aj vlakom - zo susednej obce Borša. Ponúkame štandardné ubytovanie v jedenástich izbách, z toho je desať izieb štvorposteľových a jedna trojposteľová. K dispozícií je aj spoločenská miestnosť. Počas týždňa sa naši návštevníci majú možnosť stravovať v školskej jedálni a počas víkendov je možnosť objednávky pre skupiny. Na základe objednávky je možnosť prehliadky našich pivníc s degustáciou vín, rôznych ponúk. Priamo od nás si môžu návštevníci kúpiť kvalitné tokajské víno. Ponúkame aj organizáciu pracovných podujatí, konferencií a firemný...

Penzión u Račka** - Areál pohody - Humenné

Pensions | Brestov | Humenné

Detail

Price (person/night): 13 EUR (391,64 Sk)

Capacity: 14

Našim cieľom je poskytovanie štandardného ubytovania pre turistov, turistické pobyty, obchodných cestujúcich, zahraničné návštevy, samozrejme aj pre rodinné relaxačné pobyty . Hodnotenie penziónu bonitou dve hviezdičky. Penzión je po kompletnej rekonštrukcii, každá izba má samostatnú kúpeľňu s masážnym sprchovým kútom, umývadlom a WC. Na každej izbe je TV. Ubytovaní hostia majú možnosť využitia osobitného vchodu. Súčasťou penziónu je salónik, vhodný aj ako konferenčná miestnosť pre firemené pracovné pobyty, akcie. Celková kapacita ubytovania je 14 hostí. Hosťom ubytovaným viac ako 7 dní poskytujeme zľavu 10%.

Penzión Neptún, Zemplínska Šírava - Hôrka

Pensions | Michalovce | Zemplínska Šírava

Detail

Price (person/night): 10 EUR (301,26 Sk)

Capacity: 16

Chata Neptún sa nachádza vo veľmi peknom prostredí v rekreačnom stredisku Hôrka. Jej umiestnenie poskytuje rekreantom veľa súkromia. Veľké trávnaté plochy, štrková pláž, bezpečný vstup do vody a tiché prostredie uvítajú hlavne rodiny s deťmi. Priľahlé zákutia poskytujú raj pre rybárov. Vzdialenosť od vody je cca 50 m. Ubytovanie : Chata pozostáva zo 4 apartmánov. Každý z nich má samostatný vchod, kúpeľňu, kuchynský kútik a 4 miesta na spanie (2 v obývacej časti a 2 v spálni). Z terasy je pekný výhľad na vodu. K dispozícii sú tenisové kurty, detské ihriská s pieskoviskom, hojdačkami, preliezkami a šmýkačkami. Ďalšie možnosti priamo v stredisku, prístav s loďou, diskotéka, reštaurácie...

Detský tábor - Zemplínska Šírava

Recreational houses | Kaluža | Zemplinska Šírava

Detail

Price (person/night): 8 EUR (241,01 Sk)

Capacity: 30

Chatky detského tábora sa nachádzajú priamo v areáli hotela Vojenskej zotavovne Zemplínska Šírava. Tieto priestory je možné využívať ako na detský tábor, tak aj školy v prírode, alebo plavecké výcviky. Hotel Vojenskej zotavovne je luxusným zariadením, ktoré ponúka pre svojich klientov všetky možnosti využitia. Má svoje športoviská - tenisové kurty, multifunkčné ihrisko s umelým trávnikom a osvetlením, bazény, welnes služby a pod.

« Back 1 | 2 | 3 Forward »

Accomodations on map

(default) 100 queries took 1185 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `realcms_inzerat`	37	37	3
2	DESCRIBE `realcms_obce`	4	4	1
3	DESCRIBE `realcms_okresy`	4	4	1
4	DESCRIBE `realcms_kraje`	3	3	1
5	DESCRIBE `realcms_zakaznik`	43	43	4
6	DESCRIBE `realcms_druhy`	4	4	1
7	DESCRIBE `realcms_platnost_inzeratu`	6	6	1
8	DESCRIBE `realcms_restaurant_opening_hours`	7	7	2
9	DESCRIBE `realcms_restaurant_details`	5	5	1
10	DESCRIBE `realcms_restaurant_menus`	12	12	2
11	DESCRIBE `realcms_restaurant_payments`	3	3	1
12	DESCRIBE `realcms_restaurant_payment_types`	3	3	1
13	DESCRIBE `realcms_charakteristiky`	5	5	1
14	DESCRIBE `realcms_char`	5	5	1
15	DESCRIBE `realcms_char_kategorie`	2	2	1
16	DESCRIBE `realcms_obrazok`	7	7	1
17	DESCRIBE `realcms_komentare`	7	7	1
18	DESCRIBE `realcms_strava_inzeraty`	3	3	1
19	DESCRIBE `realcms_stravovanie`	3	3	1
20	DESCRIBE `realcms_ceny`	7	7	2
21	DESCRIBE `realcms_meny`	4	4	1
22	DESCRIBE `realcms_ceny_nazvy`	3	3	1
23	DESCRIBE `realcms_zlavy`	6	6	1
24	DESCRIBE `realcms_zlavy_nazvy`	3	3	1
25	DESCRIBE `realcms_inzerat_vzdialenosti`	5	5	1
26	DESCRIBE `realcms_inzerat_vzdialenosti_mesta`	5	5	2
27	DESCRIBE `realcms_mesta`	5	5	1
28	DESCRIBE `realcms_lokality`	3	3	1
29	DESCRIBE `realcms_lokality_obce`	2	2	1
30	DESCRIBE `realcms_banery_lokality`	3	3	1
31	DESCRIBE `realcms_sutaz`	4	4	1
32	DESCRIBE `realcms_sutaz_udaje`	11	11	2
33	DESCRIBE `realcms_druhy_zariadeni`	4	4	1
34	DESCRIBE `realcms_inzerat_vzdialenosti_zariadenia`	5	5	1
35	DESCRIBE `realcms_zariadenia`	23	23	3
36	DESCRIBE `realcms_obrazok_zariadenia`	5	5	1
37	DESCRIBE `realcms_charakteristiky_zariadenia`	4	4	1
38	DESCRIBE `realcms_char_zariadenia`	4	4	1
39	DESCRIBE `realcms_banery`	3	3	1
40	DESCRIBE `realcms_banery_hlavna_stranka`	2	2	1
41	DESCRIBE `realcms_jazyky`	3	3	1
42	DESCRIBE `realcms_wysiwyg`	6	6	1
43	DESCRIBE `realcms_web_pristupy`	4	4	1
44	SELECT `Jazyk`.`id`, `Jazyk`.`jazyk`, `Jazyk`.`jazyk_slovom` FROM `realcms_jazyky` AS `Jazyk` WHERE `Jazyk`.`jazyk` = 'eng' LIMIT 1	1	1	0
45	SELECT `Texty`.`nadpis`, `Texty`.`name` FROM `realcms_wysiwyg` AS `Texty` WHERE `Texty`.`jazyk_id` = 2	5	5	0
46	INSERT DELAYED INTO `realcms_web_pristupy` (`ip_adresa`, `created`) VALUES ('38.107.179.214', '2012-02-06 16:32:20') ON DUPLICATE KEY UPDATE pocet_pristupov=pocet_pristupov+1	2		0
47	SELECT SUM(pocet_pristupov) AS pocet FROM `realcms_web_pristupy` AS `Pristup` WHERE 1 = 1 LIMIT 1	1	1	116
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`) = 'Zemplin' 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` = 20 AND `LokalitaObce`.`obec_id` = `Obec`.`idobec`) WHERE 1 = 1	788	788	1
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` = 20 AND `BanerLokalita`.`idinzerat` != 0 AND `Inzerat`.`idinzerat` IS NOT NULL ORDER BY `BanerLokalita`.`pozicia` ASC LIMIT 8	1	1	1
77	SELECT `Obrazok`.`idobrazok`, `Obrazok`.`url`, `Obrazok`.`sort`, `Obrazok`.`inzerat_idinzerat` FROM `realcms_obrazok` AS `Obrazok` WHERE `Obrazok`.`inzerat_idinzerat` = (1171) ORDER BY `Obrazok`.`sort` asc	35	35	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 ('513792', '513806', '513831', '513849', '513857', '518638', '520004', '520012', '520021', '520039', '520055', '520063', '520071', '520080', '520098', '520101', '520110', '520128', '520136', '520152', '520161', '520179', '520187', '520195', '520209', '520217', '520225', '520233', '520241', '520250', '520268', '520276', '520284', '520292', '520314', '520322', '520331', '520349', '520357', '520365', '520373', '520381', '520390', '520403', '520411', '520438', '520446', '520454', '520462', '520471', '520489', '520497', '520501', '520519', '520527', '520535', '520543', '520551', '520560', '520578', '520586', '520594', '520616', '520624', '520632', '520641', '520659', '520667', '520675', '520683', '520691', '520705', '520713', '520721', '520730', '520748', '520764', '520772', '520781', '520802', '520811', '520829', '520845', '520853', '520861', '520870', '520888', '520896', '520900', '520918', '520926', '520934', '520942', '520951', '520977', '520985', '520993', '521001', '521019', '521027', '521035', '521043', '521051', '521060', '521078', '521086', '521108', '521116', '522279', '522287', '522295', '522309', '522317', '522325', '522333', '522341', '522350', '522368', '522376', '522384', '522392', '522406', '522414', '522422', '522431', '522449', '522457', '522465', '522473', '522481', '522490', '522503', '522511', '522520', '522538', '522546', '522554', '522562', '522571', '522589', '522597', '522601', '522627', '522635', '522643', '522651', '522660', '522678', '522686', '522694', '522708', '522716', '522724', '522732', '522741', '522759', '522767', '522783', '522791', '522805', '522813', '522821', '522830', '522848', '522856', '522864', '522872', '522881', '522899', '522902', '522911', '522929', '522937', '522945', '522953', '522961', '522970', '522988', '522996', '523003', '523011', '523020', '523038', '523046', '523054', '523062', '523071', '523089', '523097', '523101', '523119', '523127', '523135', '523143', '523151', '523160', '523178', '523186', '523194', '523208', '523216', '523224', '523232', '523241', '523259', '523267', '523275', '523283', '523291', '523305', '523313', '523321', '523330', '523348', '523356', '523364', '523372', '528099', '528102', '528111', '528129', '528137', '528145', '528153', '528161', '528170', '528188', '528200', '528218', '528226', '528234', '528242', '528251', '528269', '528277', '528285', '528293', '528307', '528315', '528323', '528331', '528340', '528358', '528366', '528374', '528382', '528391', '528404', '528412', '528421', '528439', '528447', '528455', '528463', '528471', '528480', '528498', '528501', '528510', '528528', '528536', '528544', '528552', '528561', '528579', '528587', '528609', '528617', '528625', '528633', '528641', '528650', '528668', '528676', '528684', '528692', '528706', '528714', '528722', '528731', '528749', '528757', '528765', '528773', '528781', '528790', '528803', '528811', '528820', '528838', '528846', '528854', '528862', '528871', '528889', '528897', '528901', '528919', '528927', '528935', '528943', '528951', '528960', '528978', '528986', '528994', '529001', '529010', '529028', '529036', '529044', '529052', '529061', '529079', '529087', '529095', '529109', '529117', '529125', '529133', '529141', '529150', '529168', '529176', '529184', '529192', '529206', '529214', '529222', '529231', '529249', '529257', '529265', '529273', '529281', '529290', '543730', '543748', '543756', '543764', '543772', '543781', '543799', '543802', '543811', '543829', '543845', '543853', '543861', '543870', '543888', '543896', '543900', '543918', '543926', '543934', '543942', '543951', '543969', '543977', '543985', '543993', '544001', '544019', '544027', '544035', '544043', '544051', '544060', '544078', '544086', '544094', '544108', '544116', '544124', '544132', '544141', '544159', '544167', '544175', '544183', '544191', '544205', '544213', '544221', '544230', '559547', '559598', '559610', '559636', '559644', '559652', '581674', '582140') AND `Inzerat`.`demo` = 0	1	1	25
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 ('513792', '513806', '513831', '513849', '513857', '518638', '520004', '520012', '520021', '520039', '520055', '520063', '520071', '520080', '520098', '520101', '520110', '520128', '520136', '520152', '520161', '520179', '520187', '520195', '520209', '520217', '520225', '520233', '520241', '520250', '520268', '520276', '520284', '520292', '520314', '520322', '520331', '520349', '520357', '520365', '520373', '520381', '520390', '520403', '520411', '520438', '520446', '520454', '520462', '520471', '520489', '520497', '520501', '520519', '520527', '520535', '520543', '520551', '520560', '520578', '520586', '520594', '520616', '520624', '520632', '520641', '520659', '520667', '520675', '520683', '520691', '520705', '520713', '520721', '520730', '520748', '520764', '520772', '520781', '520802', '520811', '520829', '520845', '520853', '520861', '520870', '520888', '520896', '520900', '520918', '520926', '520934', '520942', '520951', '520977', '520985', '520993', '521001', '521019', '521027', '521035', '521043', '521051', '521060', '521078', '521086', '521108', '521116', '522279', '522287', '522295', '522309', '522317', '522325', '522333', '522341', '522350', '522368', '522376', '522384', '522392', '522406', '522414', '522422', '522431', '522449', '522457', '522465', '522473', '522481', '522490', '522503', '522511', '522520', '522538', '522546', '522554', '522562', '522571', '522589', '522597', '522601', '522627', '522635', '522643', '522651', '522660', '522678', '522686', '522694', '522708', '522716', '522724', '522732', '522741', '522759', '522767', '522783', '522791', '522805', '522813', '522821', '522830', '522848', '522856', '522864', '522872', '522881', '522899', '522902', '522911', '522929', '522937', '522945', '522953', '522961', '522970', '522988', '522996', '523003', '523011', '523020', '523038', '523046', '523054', '523062', '523071', '523089', '523097', '523101', '523119', '523127', '523135', '523143', '523151', '523160', '523178', '523186', '523194', '523208', '523216', '523224', '523232', '523241', '523259', '523267', '523275', '523283', '523291', '523305', '523313', '523321', '523330', '523348', '523356', '523364', '523372', '528099', '528102', '528111', '528129', '528137', '528145', '528153', '528161', '528170', '528188', '528200', '528218', '528226', '528234', '528242', '528251', '528269', '528277', '528285', '528293', '528307', '528315', '528323', '528331', '528340', '528358', '528366', '528374', '528382', '528391', '528404', '528412', '528421', '528439', '528447', '528455', '528463', '528471', '528480', '528498', '528501', '528510', '528528', '528536', '528544', '528552', '528561', '528579', '528587', '528609', '528617', '528625', '528633', '528641', '528650', '528668', '528676', '528684', '528692', '528706', '528714', '528722', '528731', '528749', '528757', '528765', '528773', '528781', '528790', '528803', '528811', '528820', '528838', '528846', '528854', '528862', '528871', '528889', '528897', '528901', '528919', '528927', '528935', '528943', '528951', '528960', '528978', '528986', '528994', '529001', '529010', '529028', '529036', '529044', '529052', '529061', '529079', '529087', '529095', '529109', '529117', '529125', '529133', '529141', '529150', '529168', '529176', '529184', '529192', '529206', '529214', '529222', '529231', '529249', '529257', '529265', '529273', '529281', '529290', '543730', '543748', '543756', '543764', '543772', '543781', '543799', '543802', '543811', '543829', '543845', '543853', '543861', '543870', '543888', '543896', '543900', '543918', '543926', '543934', '543942', '543951', '543969', '543977', '543985', '543993', '544001', '544019', '544027', '544035', '544043', '544051', '544060', '544078', '544086', '544094', '544108', '544116', '544124', '544132', '544141', '544159', '544167', '544175', '544183', '544191', '544205', '544213', '544221', '544230', '559547', '559598', '559610', '559636', '559644', '559652', '581674', '582140') AND `Inzerat`.`demo` = 0 ORDER BY RAND(781769884) ASC LIMIT 10, 10	10	10	40
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 (1556, 1146, 1884, 1124, 999, 2081, 1264, 1025, 2187, 2138)	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 (1556, 1146, 1884, 1124, 999, 2081, 1264, 1025, 2187, 2138)	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 (1556, 1146, 1884, 1124, 999, 2081, 1264, 1025, 2187, 2138)	0	0	0
83	SELECT `RestaurantPayment`.`id`, `RestaurantPayment`.`ad_id`, `RestaurantPayment`.`payment_type_id` FROM `realcms_restaurant_payments` AS `RestaurantPayment` WHERE `RestaurantPayment`.`ad_id` IN (1556, 1146, 1884, 1124, 999, 2081, 1264, 1025, 2187, 2138)	0	0	0
84	SELECT `Charakteristika`.`id`, `Charakteristika`.`idinzerat`, `Charakteristika`.`idchar`, `Charakteristika`.`hodnota`, `Charakteristika`.`vyber` FROM `realcms_charakteristiky` AS `Charakteristika` WHERE `Charakteristika`.`idinzerat` IN (1556, 1146, 1884, 1124, 999, 2081, 1264, 1025, 2187, 2138)	315	315	25
85	SELECT `Obrazok`.`idobrazok`, `Obrazok`.`url`, `Obrazok`.`sort`, `Obrazok`.`inzerat_idinzerat` FROM `realcms_obrazok` AS `Obrazok` WHERE `Obrazok`.`inzerat_idinzerat` IN (1556, 1146, 1884, 1124, 999, 2081, 1264, 1025, 2187, 2138) ORDER BY `Obrazok`.`sort` asc, `Obrazok`.`idobrazok` asc	180	180	14
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 (1556, 1146, 1884, 1124, 999, 2081, 1264, 1025, 2187, 2138)	3	3	1
87	SELECT `StravaInzerat`.`idinzerat`, `StravaInzerat`.`idstravy`, `StravaInzerat`.`value` FROM `realcms_strava_inzeraty` AS `StravaInzerat` WHERE `StravaInzerat`.`value` = 1 AND `StravaInzerat`.`idinzerat` IN (1556, 1146, 1884, 1124, 999, 2081, 1264, 1025, 2187, 2138)	28	28	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 (1556, 1146, 1884, 1124, 999, 2081, 1264, 1025, 2187, 2138) ORDER BY `povina_cena` DESC	23	23	1
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 (1556, 1146, 1884, 1124, 999, 2081, 1264, 1025, 2187, 2138)	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` = 1556 OR `Vzdialenost1`.`id_inzerat2` = 1556) ORDER BY `Vzdialenost1`.`vzdialenost` asc	1041	1041	159
91	SELECT `Vzdialenost1`.`id`, `Vzdialenost1`.`id_inzerat1`, `Vzdialenost1`.`id_inzerat2`, `Vzdialenost1`.`vzdialenost`, `Vzdialenost1`.`modified` FROM `realcms_inzerat_vzdialenosti` AS `Vzdialenost1` WHERE (`Vzdialenost1`.`id_inzerat1` = 1146 OR `Vzdialenost1`.`id_inzerat2` = 1146) ORDER BY `Vzdialenost1`.`vzdialenost` asc	1067	1067	124
92	SELECT `Vzdialenost1`.`id`, `Vzdialenost1`.`id_inzerat1`, `Vzdialenost1`.`id_inzerat2`, `Vzdialenost1`.`vzdialenost`, `Vzdialenost1`.`modified` FROM `realcms_inzerat_vzdialenosti` AS `Vzdialenost1` WHERE (`Vzdialenost1`.`id_inzerat1` = 1884 OR `Vzdialenost1`.`id_inzerat2` = 1884) ORDER BY `Vzdialenost1`.`vzdialenost` asc	1014	1014	114
93	SELECT `Vzdialenost1`.`id`, `Vzdialenost1`.`id_inzerat1`, `Vzdialenost1`.`id_inzerat2`, `Vzdialenost1`.`vzdialenost`, `Vzdialenost1`.`modified` FROM `realcms_inzerat_vzdialenosti` AS `Vzdialenost1` WHERE (`Vzdialenost1`.`id_inzerat1` = 1124 OR `Vzdialenost1`.`id_inzerat2` = 1124) ORDER BY `Vzdialenost1`.`vzdialenost` asc	1074	1074	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` = 999 OR `Vzdialenost1`.`id_inzerat2` = 999) ORDER BY `Vzdialenost1`.`vzdialenost` asc	1131	1131	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` = 2081 OR `Vzdialenost1`.`id_inzerat2` = 2081) ORDER BY `Vzdialenost1`.`vzdialenost` asc	1014	1014	1
96	SELECT `Vzdialenost1`.`id`, `Vzdialenost1`.`id_inzerat1`, `Vzdialenost1`.`id_inzerat2`, `Vzdialenost1`.`vzdialenost`, `Vzdialenost1`.`modified` FROM `realcms_inzerat_vzdialenosti` AS `Vzdialenost1` WHERE (`Vzdialenost1`.`id_inzerat1` = 1264 OR `Vzdialenost1`.`id_inzerat2` = 1264) ORDER BY `Vzdialenost1`.`vzdialenost` asc	1074	1074	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` = 1025 OR `Vzdialenost1`.`id_inzerat2` = 1025) ORDER BY `Vzdialenost1`.`vzdialenost` asc	1127	1127	141
98	SELECT `Vzdialenost1`.`id`, `Vzdialenost1`.`id_inzerat1`, `Vzdialenost1`.`id_inzerat2`, `Vzdialenost1`.`vzdialenost`, `Vzdialenost1`.`modified` FROM `realcms_inzerat_vzdialenosti` AS `Vzdialenost1` WHERE (`Vzdialenost1`.`id_inzerat1` = 2187 OR `Vzdialenost1`.`id_inzerat2` = 2187) ORDER BY `Vzdialenost1`.`vzdialenost` asc	971	971	1
99	SELECT `Vzdialenost1`.`id`, `Vzdialenost1`.`id_inzerat1`, `Vzdialenost1`.`id_inzerat2`, `Vzdialenost1`.`vzdialenost`, `Vzdialenost1`.`modified` FROM `realcms_inzerat_vzdialenosti` AS `Vzdialenost1` WHERE (`Vzdialenost1`.`id_inzerat1` = 2138 OR `Vzdialenost1`.`id_inzerat2` = 2138) ORDER BY `Vzdialenost1`.`vzdialenost` asc	997	997	113
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 (1556, 1146, 1884, 1124, 999, 2081, 1264, 1025, 2187, 2138)	350	350	21

(default) 100 queries took 1185 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `realcms_inzerat`

DESCRIBE `realcms_obce`

DESCRIBE `realcms_okresy`

DESCRIBE `realcms_kraje`

DESCRIBE `realcms_zakaznik`

DESCRIBE `realcms_druhy`

DESCRIBE `realcms_platnost_inzeratu`

DESCRIBE `realcms_restaurant_opening_hours`

DESCRIBE `realcms_restaurant_details`

DESCRIBE `realcms_restaurant_menus`

DESCRIBE `realcms_restaurant_payments`

DESCRIBE `realcms_restaurant_payment_types`

DESCRIBE `realcms_charakteristiky`

DESCRIBE `realcms_char`

DESCRIBE `realcms_char_kategorie`

DESCRIBE `realcms_obrazok`

DESCRIBE `realcms_komentare`

DESCRIBE `realcms_strava_inzeraty`

DESCRIBE `realcms_stravovanie`

DESCRIBE `realcms_ceny`

DESCRIBE `realcms_meny`

DESCRIBE `realcms_ceny_nazvy`

DESCRIBE `realcms_zlavy`

DESCRIBE `realcms_zlavy_nazvy`

DESCRIBE `realcms_inzerat_vzdialenosti`

DESCRIBE `realcms_inzerat_vzdialenosti_mesta`

DESCRIBE `realcms_mesta`

DESCRIBE `realcms_lokality`

DESCRIBE `realcms_lokality_obce`

DESCRIBE `realcms_banery_lokality`

DESCRIBE `realcms_sutaz`

DESCRIBE `realcms_sutaz_udaje`

DESCRIBE `realcms_druhy_zariadeni`

DESCRIBE `realcms_inzerat_vzdialenosti_zariadenia`

DESCRIBE `realcms_zariadenia`

DESCRIBE `realcms_obrazok_zariadenia`

DESCRIBE `realcms_charakteristiky_zariadenia`

DESCRIBE `realcms_char_zariadenia`

DESCRIBE `realcms_banery`

DESCRIBE `realcms_banery_hlavna_stranka`

DESCRIBE `realcms_jazyky`

DESCRIBE `realcms_wysiwyg`

DESCRIBE `realcms_web_pristupy`

SELECT `Jazyk`.`id`, `Jazyk`.`jazyk`, `Jazyk`.`jazyk_slovom` FROM `realcms_jazyky` AS `Jazyk` WHERE `Jazyk`.`jazyk` = 'eng' LIMIT 1

SELECT `Texty`.`nadpis`, `Texty`.`name` FROM `realcms_wysiwyg` AS `Texty` WHERE `Texty`.`jazyk_id` = 2

INSERT DELAYED INTO `realcms_web_pristupy` (`ip_adresa`, `created`) VALUES ('38.107.179.214', '2012-02-06 16:32:20') ON DUPLICATE KEY UPDATE pocet_pristupov=pocet_pristupov+1

SELECT SUM(pocet_pristupov) AS pocet FROM `realcms_web_pristupy` AS `Pristup` WHERE 1 = 1 LIMIT 1

116

SELECT `Druh`.`iddruh`, `Druh`.`druh`, `Druh`.`zobrazeni`, `Druh`.`cena` FROM `realcms_druhy` AS `Druh` WHERE 1 = 1

SELECT `Stravovanie`.`id`, `Stravovanie`.`nazov_stravovania`, `Stravovanie`.`order` FROM `realcms_stravovanie` AS `Stravovanie` WHERE 1 = 1

SELECT `Kraj`.`idkraj`, `Kraj`.`nazov`, `Kraj`.`idstat` FROM `realcms_kraje` AS `Kraj` WHERE `Kraj`.`idstat` = 'SK'

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

SELECT `ZariadenieDruh`.`id`, `ZariadenieDruh`.`zariadenie`, `ZariadenieDruh`.`alias`, `ZariadenieDruh`.`parent` FROM `realcms_druhy_zariadeni` AS `ZariadenieDruh` WHERE `ZariadenieDruh`.`parent` = 0 ORDER BY `ZariadenieDruh`.`zariadenie` ASC

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)

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

SELECT `Obec`.`idobec`, `Obec`.`nazov_obce`, `Obec`.`idokres`, `Obec`.`psc` FROM `realcms_obce` AS `Obec` WHERE `Obec`.`idobec` = 524077

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)

SELECT `RestaurantDetail`.`id`, `RestaurantDetail`.`ad_id`, `RestaurantDetail`.`contact`, `RestaurantDetail`.`created`, `RestaurantDetail`.`modified` FROM `realcms_restaurant_details` AS `RestaurantDetail` WHERE `RestaurantDetail`.`ad_id` = (1888)

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)

SELECT `RestaurantPayment`.`id`, `RestaurantPayment`.`ad_id`, `RestaurantPayment`.`payment_type_id` FROM `realcms_restaurant_payments` AS `RestaurantPayment` WHERE `RestaurantPayment`.`ad_id` = (1888)

SELECT `Obec`.`idobec`, `Obec`.`nazov_obce`, `Obec`.`idokres`, `Obec`.`psc` FROM `realcms_obce` AS `Obec` WHERE `Obec`.`idobec` = 505285

SELECT `Obec`.`idobec`, `Obec`.`nazov_obce`, `Obec`.`idokres`, `Obec`.`psc` FROM `realcms_obce` AS `Obec` WHERE `Obec`.`idobec` = 510998

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

SELECT `Lokalita`.`id`, `Lokalita`.`lokalita`, `Lokalita`.`lokalita_seo` FROM `realcms_lokality` AS `Lokalita` WHERE lower(`Lokalita`.`lokalita_seo`) = 'Zemplin' LIMIT 1

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` = 20 AND `LokalitaObce`.`obec_id` = `Obec`.`idobec`) WHERE 1 = 1

788

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` = 20 AND `BanerLokalita`.`idinzerat` != 0 AND `Inzerat`.`idinzerat` IS NOT NULL ORDER BY `BanerLokalita`.`pozicia` ASC LIMIT 8

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 ('513792', '513806', '513831', '513849', '513857', '518638', '520004', '520012', '520021', '520039', '520055', '520063', '520071', '520080', '520098', '520101', '520110', '520128', '520136', '520152', '520161', '520179', '520187', '520195', '520209', '520217', '520225', '520233', '520241', '520250', '520268', '520276', '520284', '520292', '520314', '520322', '520331', '520349', '520357', '520365', '520373', '520381', '520390', '520403', '520411', '520438', '520446', '520454', '520462', '520471', '520489', '520497', '520501', '520519', '520527', '520535', '520543', '520551', '520560', '520578', '520586', '520594', '520616', '520624', '520632', '520641', '520659', '520667', '520675', '520683', '520691', '520705', '520713', '520721', '520730', '520748', '520764', '520772', '520781', '520802', '520811', '520829', '520845', '520853', '520861', '520870', '520888', '520896', '520900', '520918', '520926', '520934', '520942', '520951', '520977', '520985', '520993', '521001', '521019', '521027', '521035', '521043', '521051', '521060', '521078', '521086', '521108', '521116', '522279', '522287', '522295', '522309', '522317', '522325', '522333', '522341', '522350', '522368', '522376', '522384', '522392', '522406', '522414', '522422', '522431', '522449', '522457', '522465', '522473', '522481', '522490', '522503', '522511', '522520', '522538', '522546', '522554', '522562', '522571', '522589', '522597', '522601', '522627', '522635', '522643', '522651', '522660', '522678', '522686', '522694', '522708', '522716', '522724', '522732', '522741', '522759', '522767', '522783', '522791', '522805', '522813', '522821', '522830', '522848', '522856', '522864', '522872', '522881', '522899', '522902', '522911', '522929', '522937', '522945', '522953', '522961', '522970', '522988', '522996', '523003', '523011', '523020', '523038', '523046', '523054', '523062', '523071', '523089', '523097', '523101', '523119', '523127', '523135', '523143', '523151', '523160', '523178', '523186', '523194', '523208', '523216', '523224', '523232', '523241', '523259', '523267', '523275', '523283', '523291', '523305', '523313', '523321', '523330', '523348', '523356', '523364', '523372', '528099', '528102', '528111', '528129', '528137', '528145', '528153', '528161', '528170', '528188', '528200', '528218', '528226', '528234', '528242', '528251', '528269', '528277', '528285', '528293', '528307', '528315', '528323', '528331', '528340', '528358', '528366', '528374', '528382', '528391', '528404', '528412', '528421', '528439', '528447', '528455', '528463', '528471', '528480', '528498', '528501', '528510', '528528', '528536', '528544', '528552', '528561', '528579', '528587', '528609', '528617', '528625', '528633', '528641', '528650', '528668', '528676', '528684', '528692', '528706', '528714', '528722', '528731', '528749', '528757', '528765', '528773', '528781', '528790', '528803', '528811', '528820', '528838', '528846', '528854', '528862', '528871', '528889', '528897', '528901', '528919', '528927', '528935', '528943', '528951', '528960', '528978', '528986', '528994', '529001', '529010', '529028', '529036', '529044', '529052', '529061', '529079', '529087', '529095', '529109', '529117', '529125', '529133', '529141', '529150', '529168', '529176', '529184', '529192', '529206', '529214', '529222', '529231', '529249', '529257', '529265', '529273', '529281', '529290', '543730', '543748', '543756', '543764', '543772', '543781', '543799', '543802', '543811', '543829', '543845', '543853', '543861', '543870', '543888', '543896', '543900', '543918', '543926', '543934', '543942', '543951', '543969', '543977', '543985', '543993', '544001', '544019', '544027', '544035', '544043', '544051', '544060', '544078', '544086', '544094', '544108', '544116', '544124', '544132', '544141', '544159', '544167', '544175', '544183', '544191', '544205', '544213', '544221', '544230', '559547', '559598', '559610', '559636', '559644', '559652', '581674', '582140') AND `Inzerat`.`demo` = 0

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 ('513792', '513806', '513831', '513849', '513857', '518638', '520004', '520012', '520021', '520039', '520055', '520063', '520071', '520080', '520098', '520101', '520110', '520128', '520136', '520152', '520161', '520179', '520187', '520195', '520209', '520217', '520225', '520233', '520241', '520250', '520268', '520276', '520284', '520292', '520314', '520322', '520331', '520349', '520357', '520365', '520373', '520381', '520390', '520403', '520411', '520438', '520446', '520454', '520462', '520471', '520489', '520497', '520501', '520519', '520527', '520535', '520543', '520551', '520560', '520578', '520586', '520594', '520616', '520624', '520632', '520641', '520659', '520667', '520675', '520683', '520691', '520705', '520713', '520721', '520730', '520748', '520764', '520772', '520781', '520802', '520811', '520829', '520845', '520853', '520861', '520870', '520888', '520896', '520900', '520918', '520926', '520934', '520942', '520951', '520977', '520985', '520993', '521001', '521019', '521027', '521035', '521043', '521051', '521060', '521078', '521086', '521108', '521116', '522279', '522287', '522295', '522309', '522317', '522325', '522333', '522341', '522350', '522368', '522376', '522384', '522392', '522406', '522414', '522422', '522431', '522449', '522457', '522465', '522473', '522481', '522490', '522503', '522511', '522520', '522538', '522546', '522554', '522562', '522571', '522589', '522597', '522601', '522627', '522635', '522643', '522651', '522660', '522678', '522686', '522694', '522708', '522716', '522724', '522732', '522741', '522759', '522767', '522783', '522791', '522805', '522813', '522821', '522830', '522848', '522856', '522864', '522872', '522881', '522899', '522902', '522911', '522929', '522937', '522945', '522953', '522961', '522970', '522988', '522996', '523003', '523011', '523020', '523038', '523046', '523054', '523062', '523071', '523089', '523097', '523101', '523119', '523127', '523135', '523143', '523151', '523160', '523178', '523186', '523194', '523208', '523216', '523224', '523232', '523241', '523259', '523267', '523275', '523283', '523291', '523305', '523313', '523321', '523330', '523348', '523356', '523364', '523372', '528099', '528102', '528111', '528129', '528137', '528145', '528153', '528161', '528170', '528188', '528200', '528218', '528226', '528234', '528242', '528251', '528269', '528277', '528285', '528293', '528307', '528315', '528323', '528331', '528340', '528358', '528366', '528374', '528382', '528391', '528404', '528412', '528421', '528439', '528447', '528455', '528463', '528471', '528480', '528498', '528501', '528510', '528528', '528536', '528544', '528552', '528561', '528579', '528587', '528609', '528617', '528625', '528633', '528641', '528650', '528668', '528676', '528684', '528692', '528706', '528714', '528722', '528731', '528749', '528757', '528765', '528773', '528781', '528790', '528803', '528811', '528820', '528838', '528846', '528854', '528862', '528871', '528889', '528897', '528901', '528919', '528927', '528935', '528943', '528951', '528960', '528978', '528986', '528994', '529001', '529010', '529028', '529036', '529044', '529052', '529061', '529079', '529087', '529095', '529109', '529117', '529125', '529133', '529141', '529150', '529168', '529176', '529184', '529192', '529206', '529214', '529222', '529231', '529249', '529257', '529265', '529273', '529281', '529290', '543730', '543748', '543756', '543764', '543772', '543781', '543799', '543802', '543811', '543829', '543845', '543853', '543861', '543870', '543888', '543896', '543900', '543918', '543926', '543934', '543942', '543951', '543969', '543977', '543985', '543993', '544001', '544019', '544027', '544035', '544043', '544051', '544060', '544078', '544086', '544094', '544108', '544116', '544124', '544132', '544141', '544159', '544167', '544175', '544183', '544191', '544205', '544213', '544221', '544230', '559547', '559598', '559610', '559636', '559644', '559652', '581674', '582140') AND `Inzerat`.`demo` = 0 ORDER BY RAND(781769884) ASC LIMIT 10, 10

SELECT `Charakteristika`.`id`, `Charakteristika`.`idinzerat`, `Charakteristika`.`idchar`, `Charakteristika`.`hodnota`, `Charakteristika`.`vyber` FROM `realcms_charakteristiky` AS `Charakteristika` WHERE `Charakteristika`.`idinzerat` IN (1556, 1146, 1884, 1124, 999, 2081, 1264, 1025, 2187, 2138)

315

180

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 (1556, 1146, 1884, 1124, 999, 2081, 1264, 1025, 2187, 2138)

SELECT `StravaInzerat`.`idinzerat`, `StravaInzerat`.`idstravy`, `StravaInzerat`.`value` FROM `realcms_strava_inzeraty` AS `StravaInzerat` WHERE `StravaInzerat`.`value` = 1 AND `StravaInzerat`.`idinzerat` IN (1556, 1146, 1884, 1124, 999, 2081, 1264, 1025, 2187, 2138)

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 (1556, 1146, 1884, 1124, 999, 2081, 1264, 1025, 2187, 2138) ORDER BY `povina_cena` DESC

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 (1556, 1146, 1884, 1124, 999, 2081, 1264, 1025, 2187, 2138)

SELECT `Vzdialenost1`.`id`, `Vzdialenost1`.`id_inzerat1`, `Vzdialenost1`.`id_inzerat2`, `Vzdialenost1`.`vzdialenost`, `Vzdialenost1`.`modified` FROM `realcms_inzerat_vzdialenosti` AS `Vzdialenost1` WHERE (`Vzdialenost1`.`id_inzerat1` = 1556 OR `Vzdialenost1`.`id_inzerat2` = 1556) ORDER BY `Vzdialenost1`.`vzdialenost` asc

1041

159

SELECT `Vzdialenost1`.`id`, `Vzdialenost1`.`id_inzerat1`, `Vzdialenost1`.`id_inzerat2`, `Vzdialenost1`.`vzdialenost`, `Vzdialenost1`.`modified` FROM `realcms_inzerat_vzdialenosti` AS `Vzdialenost1` WHERE (`Vzdialenost1`.`id_inzerat1` = 1146 OR `Vzdialenost1`.`id_inzerat2` = 1146) ORDER BY `Vzdialenost1`.`vzdialenost` asc

1067

124

SELECT `Vzdialenost1`.`id`, `Vzdialenost1`.`id_inzerat1`, `Vzdialenost1`.`id_inzerat2`, `Vzdialenost1`.`vzdialenost`, `Vzdialenost1`.`modified` FROM `realcms_inzerat_vzdialenosti` AS `Vzdialenost1` WHERE (`Vzdialenost1`.`id_inzerat1` = 1884 OR `Vzdialenost1`.`id_inzerat2` = 1884) ORDER BY `Vzdialenost1`.`vzdialenost` asc

1014

114

SELECT `Vzdialenost1`.`id`, `Vzdialenost1`.`id_inzerat1`, `Vzdialenost1`.`id_inzerat2`, `Vzdialenost1`.`vzdialenost`, `Vzdialenost1`.`modified` FROM `realcms_inzerat_vzdialenosti` AS `Vzdialenost1` WHERE (`Vzdialenost1`.`id_inzerat1` = 1124 OR `Vzdialenost1`.`id_inzerat2` = 1124) ORDER BY `Vzdialenost1`.`vzdialenost` asc

1074

114

SELECT `Vzdialenost1`.`id`, `Vzdialenost1`.`id_inzerat1`, `Vzdialenost1`.`id_inzerat2`, `Vzdialenost1`.`vzdialenost`, `Vzdialenost1`.`modified` FROM `realcms_inzerat_vzdialenosti` AS `Vzdialenost1` WHERE (`Vzdialenost1`.`id_inzerat1` = 999 OR `Vzdialenost1`.`id_inzerat2` = 999) ORDER BY `Vzdialenost1`.`vzdialenost` asc

1131

114

SELECT `Vzdialenost1`.`id`, `Vzdialenost1`.`id_inzerat1`, `Vzdialenost1`.`id_inzerat2`, `Vzdialenost1`.`vzdialenost`, `Vzdialenost1`.`modified` FROM `realcms_inzerat_vzdialenosti` AS `Vzdialenost1` WHERE (`Vzdialenost1`.`id_inzerat1` = 2081 OR `Vzdialenost1`.`id_inzerat2` = 2081) ORDER BY `Vzdialenost1`.`vzdialenost` asc

1014

SELECT `Vzdialenost1`.`id`, `Vzdialenost1`.`id_inzerat1`, `Vzdialenost1`.`id_inzerat2`, `Vzdialenost1`.`vzdialenost`, `Vzdialenost1`.`modified` FROM `realcms_inzerat_vzdialenosti` AS `Vzdialenost1` WHERE (`Vzdialenost1`.`id_inzerat1` = 1264 OR `Vzdialenost1`.`id_inzerat2` = 1264) ORDER BY `Vzdialenost1`.`vzdialenost` asc

1074

SELECT `Vzdialenost1`.`id`, `Vzdialenost1`.`id_inzerat1`, `Vzdialenost1`.`id_inzerat2`, `Vzdialenost1`.`vzdialenost`, `Vzdialenost1`.`modified` FROM `realcms_inzerat_vzdialenosti` AS `Vzdialenost1` WHERE (`Vzdialenost1`.`id_inzerat1` = 1025 OR `Vzdialenost1`.`id_inzerat2` = 1025) ORDER BY `Vzdialenost1`.`vzdialenost` asc

1127

141

SELECT `Vzdialenost1`.`id`, `Vzdialenost1`.`id_inzerat1`, `Vzdialenost1`.`id_inzerat2`, `Vzdialenost1`.`vzdialenost`, `Vzdialenost1`.`modified` FROM `realcms_inzerat_vzdialenosti` AS `Vzdialenost1` WHERE (`Vzdialenost1`.`id_inzerat1` = 2187 OR `Vzdialenost1`.`id_inzerat2` = 2187) ORDER BY `Vzdialenost1`.`vzdialenost` asc

971

SELECT `Vzdialenost1`.`id`, `Vzdialenost1`.`id_inzerat1`, `Vzdialenost1`.`id_inzerat2`, `Vzdialenost1`.`vzdialenost`, `Vzdialenost1`.`modified` FROM `realcms_inzerat_vzdialenosti` AS `Vzdialenost1` WHERE (`Vzdialenost1`.`id_inzerat1` = 2138 OR `Vzdialenost1`.`id_inzerat2` = 2138) ORDER BY `Vzdialenost1`.`vzdialenost` asc

997

113

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 (1556, 1146, 1884, 1124, 999, 2081, 1264, 1025, 2187, 2138)

350

Adrenalín a Zábava	Wildwater Kingdom	Castles and Chateaux	Caves	Lakes and reservoirs	Cinemas and theaters	Conference halls	Kúpele a kúpaliska
Ski resorts	Museums	Ranches	Playgrounds	Turism	UNESCO	Wellness stays	ZOO

Search

Result of the searching

Top accomodations

Accomodations on map