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" => 4978301,
	"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()
),
	"site" => "ubytko123",
	"map" => MapHelper
MapHelper::$helpers = array
MapHelper::$restaurant = false
MapHelper::$base = ""
MapHelper::$webroot = "/"
MapHelper::$themeWeb = NULL
MapHelper::$here = "/lokalita/Zemplin/page:3"
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:3"
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:3"
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:3"
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:3"
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:3"
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 = 1328541383
SessionHelper::$sessionTime = false
SessionHelper::$watchKeys = array
SessionHelper::$id = NULL
SessionHelper::$_log = NULL
SessionHelper::$base = ""
SessionHelper::$webroot = "/"
SessionHelper::$here = "/lokalita/Zemplin/page:3"
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	=	4978301
$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()
)
)
$site	=	"ubytko123"
$map	=	MapHelper
MapHelper::$helpers = array
MapHelper::$restaurant = false
MapHelper::$base = ""
MapHelper::$webroot = "/"
MapHelper::$themeWeb = NULL
MapHelper::$here = "/lokalita/Zemplin/page:3"
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:3"
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:3"
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:3"
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:3"
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:3"
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 = 1328541383
SessionHelper::$sessionTime = false
SessionHelper::$watchKeys = array
SessionHelper::$id = NULL
SessionHelper::$_log = NULL
SessionHelper::$base = ""
SessionHelper::$webroot = "/"
SessionHelper::$here = "/lokalita/Zemplin/page:3"
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" => "4894",
	"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

Penzion Lucus, Vinné Jazero, Zemplínska Šírava

Pensions | Vinné | Zemplínska Sírava - Vinné Jazero

Detail

Price (person/night): 16 EUR (482,02 Sk)

Capacity: 40

Penzion Lucus sa nachádza v krásnej prírodnej scenérii Vinianského Jazera, v tesnej blízkosti sa nachádza Zemplínska Šírava a je to len pár km od mesta Michalovce. Vytvára ideálne podmienky na rekreáciu v priebehu celého roka. Penzion Lucus má ducha rodinného podniku v indiánskom štýle. Ponúka, okrem reštauračných služieb, jacuzzi, parkovanie v rámci pavilonu, strážené a nepretržite monitorované parkovisko SBS, WIFI zdarma, tenisový kurt, bazén a plno prekvapení od milého personálu, ktorý Vám splní všetky Vaše želania a priania.

Chata ADRIANA Slnečný Lúč Zemplínska Šírava

Cottages | Bungalows | Vinné | Zemplínska Šírava

Detail

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

Capacity: 10

Radi Vás privítame v novopostavenej chate Adriana, ktorá ponúka celoročné ubytovanie. Nachádza sa pár km od mesta Michalovce na Zemplínskej šírave v stredisku Hôrka. Vo vzdialenosti cca 200 m sa nachádza pekná štrková pláž. Popri nej sa tiahnu rôzne menšie stánky s občerstvením i väčšie reštaurácie. Neďaleko je veľký športový areál s tenisovými kurtmi, ihriskom plážového volejbalu, minigolf a detské ihrisko. Je tu hippocentrum – výuka, vychádzkové jazdenie a jazda v koči. Možná plavba výletnou loďou. V blízkosti chaty sa nachádza nákupné stredisko, informačné centrum, reštaurácie, večer disco. Na prízemí je kuchyňa, obývacia hala s krbom a rozkladacou sedačkou, kúpeľňa so sprchou a W...

Penzión Luna, Michalovce

Pensions | Michalovce | Zemplín

Detail

Price (person/night): 12,50 EUR (376,58 Sk)

Capacity: 20

Penzión LUNA sa nachádza v malebnom meste v srdci Zemplína v meste Michalovce. Je situovaný v tichej štvrti z ktorej je blízko do centa mesta cca 250 m, cca 200 m je veľké nákupné centrum, fitness centrá, rozmanité butiky a prevádzky ponúkajúce nespočetné množstvo služieb a relaxu. Penzión ďalej ponúka okrem maximálneho pohodlia aj reštauračné služby s výbornou kuchyňou a skvelým personálom.

Turistická ubytovňa pri Strednej odbornej škole technickej, Michalovce

Apartments | Michalovce | Dolný Zemplín

Detail

Price (person/night): 7,80 EUR (234,98 Sk)

Capacity: 260

Turistická ubytovňa sa nachádza v okrajovej časti mesta Michalovce, blízko európskej cesty E50, smerom na hraničný prechod Vyšné Nemecké ( Ukrajina ). V blízkosti sa nachádza Zemplínska Šírava a Vinianske jazero pre milovníkov vodných športov a kúpania. V meste je možnosť si prezrieť rôzne historické pamiatky. K ubytovni je veľmi dobrá dostupnosť autom, autobusom prípadne mestskou hromadnou dopravou. Naša ubytovňa ponúka ubytovanie v dvojposteľových a trojposteľových izbách bunkového systému so sociálnym zariadením. Na každom poschodí je k dispozícií kuchynka a spoločenská miestnosť.Pre náročnejších je možnosť sa ubytovať v apartmáne. Počas týždňa je možnosť stravovať sa v našej jedáln...

Hotel Armales *** Poloniny (okr.Snina)

Hotels | Stakčín | Poloniny

Detail

Price (person/night): 18 EUR (542,27 Sk)

Capacity: 40

Dovoľujeme si vás pozvať na návštevu trojhviezdičkového hotela ARMALES v Stakčíne, ktorý tvorí vstupnú bránu do Národného parku POLONINY, vyznačujúceho sa neopakovateľnou flórou a faunou. Je obklopený prekrásnymi kopcami pohoria Vihorlat so Sninským kameňom a Morským okom, vodnou nádržou Starina a pohorím Východné Karpaty. Prekrásna scenéria okolia hotela Armales predstavuje neopakovateľný zážitok. Ubytovaným je k dispozícií reštaurácia, nočný bar, espresso so zimnou terasou. Hotel poskytuje stravovacie služby v reštaurácii, espresse s terasou a v nočnom bare. K dispozícii je sauna, perličkové kúpele, masáže. Ponúkame turistiku a hubárstvo so sprievodcom, cykloturistiku, možnosti poľovač...

Hotel Euro Penzión Salaš *** Zemplínska Šírava

Pensions | Kaluža | Zemplínska Šírava

Detail

Price (person/night): 15 EUR (451,89 Sk)

Capacity: 38

Premýšľate, že sa sem vyberiete ? Príjemné prostredie Salaša je vyhľadávaným miestom pre všetkých návštevníkov Zemplínskej šíravy, nie len počas letnej turistickej sezóny, ale aj mimo nej. Naše jedálne lístky ponúkajú najrôznejšie druhy jedál salašníckej, slovenskej kuchyne. Pre tých, ktorí sa rozhodnú prenocovať ponúkame ubytovanie v luxusných izbách a apartmánoch.

Penzión - Reštaurácia - Biela Labuť, Michalovce

Pensions | Michalovce

Detail

Price (person/night): 25 EUR (753,15 Sk)

Capacity: 63

Penzión Biela Labuť je situovaný na západnom okraji mesta Michalovce v blízkosti obchodného centra Hypernova a neďalekej železničnej stanice (100 m). Leží na hlavnom ťahu smerom na Zemplínsku šíravu. Areál má samostatné parkovisko v zadnej časti penziónu. Penzión Biela Labuť je štandardne vybavený dvoj- a trojposteľovými izbami s príslušenstvom je tu možnosť doplniť prístelky, alebo si objednať s ponuky 3 apartmánov. Celodenné stravovanie je priamo v hotelovej reštaurácii, ktorá počas celého roka ponúka špeciality regionálnej kuchyne. K pohode hostí prispieva letná reštaurácia so zastrešenou terasou a barom. Nad kvalitou obsluhy a spokojnosťou hostí dbá majiteľka penziónu. Mimo letnej tu...

« Back 1 | 2 | 3

Accomodations on map

(default) 97 queries took 994 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	1
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	2
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	1
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	1
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	2
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.213', '2012-02-06 16:16: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	109
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	62
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	12
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	28
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 20, 10	7	7	48
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 (895, 1729, 956, 1033, 1125, 1059, 881)	14	14	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 (895, 1729, 956, 1033, 1125, 1059, 881)	1	1	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 (895, 1729, 956, 1033, 1125, 1059, 881)	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 (895, 1729, 956, 1033, 1125, 1059, 881)	0	0	0
84	SELECT `Charakteristika`.`id`, `Charakteristika`.`idinzerat`, `Charakteristika`.`idchar`, `Charakteristika`.`hodnota`, `Charakteristika`.`vyber` FROM `realcms_charakteristiky` AS `Charakteristika` WHERE `Charakteristika`.`idinzerat` IN (895, 1729, 956, 1033, 1125, 1059, 881)	279	279	25
85	SELECT `Obrazok`.`idobrazok`, `Obrazok`.`url`, `Obrazok`.`sort`, `Obrazok`.`inzerat_idinzerat` FROM `realcms_obrazok` AS `Obrazok` WHERE `Obrazok`.`inzerat_idinzerat` IN (895, 1729, 956, 1033, 1125, 1059, 881) ORDER BY `Obrazok`.`sort` asc, `Obrazok`.`idobrazok` asc	151	151	13
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 (895, 1729, 956, 1033, 1125, 1059, 881)	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 (895, 1729, 956, 1033, 1125, 1059, 881)	25	25	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 (895, 1729, 956, 1033, 1125, 1059, 881) ORDER BY `povina_cena` DESC	10	10	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 (895, 1729, 956, 1033, 1125, 1059, 881)	1	1	0
90	SELECT `Vzdialenost1`.`id`, `Vzdialenost1`.`id_inzerat1`, `Vzdialenost1`.`id_inzerat2`, `Vzdialenost1`.`vzdialenost`, `Vzdialenost1`.`modified` FROM `realcms_inzerat_vzdialenosti` AS `Vzdialenost1` WHERE (`Vzdialenost1`.`id_inzerat1` = 895 OR `Vzdialenost1`.`id_inzerat2` = 895) ORDER BY `Vzdialenost1`.`vzdialenost` asc	1105	1105	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` = 1729 OR `Vzdialenost1`.`id_inzerat2` = 1729) ORDER BY `Vzdialenost1`.`vzdialenost` asc	1040	1040	122
92	SELECT `Vzdialenost1`.`id`, `Vzdialenost1`.`id_inzerat1`, `Vzdialenost1`.`id_inzerat2`, `Vzdialenost1`.`vzdialenost`, `Vzdialenost1`.`modified` FROM `realcms_inzerat_vzdialenosti` AS `Vzdialenost1` WHERE (`Vzdialenost1`.`id_inzerat1` = 956 OR `Vzdialenost1`.`id_inzerat2` = 956) ORDER BY `Vzdialenost1`.`vzdialenost` asc	1135	1135	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` = 1033 OR `Vzdialenost1`.`id_inzerat2` = 1033) ORDER BY `Vzdialenost1`.`vzdialenost` asc	1129	1129	113
94	SELECT `Vzdialenost1`.`id`, `Vzdialenost1`.`id_inzerat1`, `Vzdialenost1`.`id_inzerat2`, `Vzdialenost1`.`vzdialenost`, `Vzdialenost1`.`modified` FROM `realcms_inzerat_vzdialenosti` AS `Vzdialenost1` WHERE (`Vzdialenost1`.`id_inzerat1` = 1125 OR `Vzdialenost1`.`id_inzerat2` = 1125) ORDER BY `Vzdialenost1`.`vzdialenost` asc	1077	1077	125
95	SELECT `Vzdialenost1`.`id`, `Vzdialenost1`.`id_inzerat1`, `Vzdialenost1`.`id_inzerat2`, `Vzdialenost1`.`vzdialenost`, `Vzdialenost1`.`modified` FROM `realcms_inzerat_vzdialenosti` AS `Vzdialenost1` WHERE (`Vzdialenost1`.`id_inzerat1` = 1059 OR `Vzdialenost1`.`id_inzerat2` = 1059) ORDER BY `Vzdialenost1`.`vzdialenost` asc	1015	1015	139
96	SELECT `Vzdialenost1`.`id`, `Vzdialenost1`.`id_inzerat1`, `Vzdialenost1`.`id_inzerat2`, `Vzdialenost1`.`vzdialenost`, `Vzdialenost1`.`modified` FROM `realcms_inzerat_vzdialenosti` AS `Vzdialenost1` WHERE (`Vzdialenost1`.`id_inzerat1` = 881 OR `Vzdialenost1`.`id_inzerat2` = 881) ORDER BY `Vzdialenost1`.`vzdialenost` asc	1137	1137	118
97	SELECT `VzdialenostMesta`.`id`, `VzdialenostMesta`.`id_inzerat`, `VzdialenostMesta`.`mesto`, `VzdialenostMesta`.`vzdialenost`, `VzdialenostMesta`.`updated` FROM `realcms_inzerat_vzdialenosti_mesta` AS `VzdialenostMesta` WHERE `VzdialenostMesta`.`id_inzerat` IN (895, 1729, 956, 1033, 1125, 1059, 881)	245	245	22

(default) 97 queries took 994 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.213', '2012-02-06 16:16: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

109

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 20, 10

SELECT `Charakteristika`.`id`, `Charakteristika`.`idinzerat`, `Charakteristika`.`idchar`, `Charakteristika`.`hodnota`, `Charakteristika`.`vyber` FROM `realcms_charakteristiky` AS `Charakteristika` WHERE `Charakteristika`.`idinzerat` IN (895, 1729, 956, 1033, 1125, 1059, 881)

279

151

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 (895, 1729, 956, 1033, 1125, 1059, 881)

SELECT `StravaInzerat`.`idinzerat`, `StravaInzerat`.`idstravy`, `StravaInzerat`.`value` FROM `realcms_strava_inzeraty` AS `StravaInzerat` WHERE `StravaInzerat`.`value` = 1 AND `StravaInzerat`.`idinzerat` IN (895, 1729, 956, 1033, 1125, 1059, 881)

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 (895, 1729, 956, 1033, 1125, 1059, 881) 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 (895, 1729, 956, 1033, 1125, 1059, 881)

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

1105

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

1040

122

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

1135

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

1129

113

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

1077

125

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

1015

139

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

1137

118

SELECT `VzdialenostMesta`.`id`, `VzdialenostMesta`.`id_inzerat`, `VzdialenostMesta`.`mesto`, `VzdialenostMesta`.`vzdialenost`, `VzdialenostMesta`.`updated` FROM `realcms_inzerat_vzdialenosti_mesta` AS `VzdialenostMesta` WHERE `VzdialenostMesta`.`id_inzerat` IN (895, 1729, 956, 1033, 1125, 1059, 881)

245

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

Penzion Lucus, Vinné Jazero, Zemplínska Šírava

Chata ADRIANA Slnečný Lúč Zemplínska Šírava

Penzión Luna, Michalovce

Turistická ubytovňa pri Strednej odbornej škole technickej, Michalovce

Hotel Armales *** Poloniny (okr.Snina)

Hotel Euro Penzión Salaš *** Zemplínska Šírava

Penzión - Reštaurácia - Biela Labuť, Michalovce

Accomodations on map