Ubytovanie v lokalite Zemplín

Výsledky vyhľadávania

27 inzerátov | zoradené podľa ceny zostupne▼

Top inzeráty

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" => "svk",
	"podstranky" => array(
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array()
),
	"pocet_pristupov" => 5001404,
	"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:1/sort:Inzerat.cena/direction:desc"
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:1/sort:Inzerat.cena/direction:desc"
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:1/sort:Inzerat.cena/direction:desc"
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:1/sort:Inzerat.cena/direction:desc"
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:1/sort:Inzerat.cena/direction:desc"
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:1/sort:Inzerat.cena/direction:desc"
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 = 1329039943
SessionHelper::$sessionTime = false
SessionHelper::$watchKeys = array
SessionHelper::$id = NULL
SessionHelper::$_log = NULL
SessionHelper::$base = ""
SessionHelper::$webroot = "/"
SessionHelper::$here = "/lokalita/Zemplin/page:1/sort:Inzerat.cena/direction:desc"
SessionHelper::$params = array
SessionHelper::$action = "lokalita"
SessionHelper::$data = NULL
SessionHelper::$themeWeb = NULL
SessionHelper::$plugin = NULL
)
$loadHelpers	=	false
$cached	=	false
$loadedHelpers	=	array()
$jazyk	=	"svk"
$podstranky	=	array(
	array(
	"Texty" => array()
),
	array(
	"Texty" => array()
),
	array(
	"Texty" => array()
),
	array(
	"Texty" => array()
),
	array(
	"Texty" => array()
),
	array(
	"Texty" => array()
),
	array(
	"Texty" => array()
)
)
$pocet_pristupov	=	5001404
$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:1/sort:Inzerat.cena/direction:desc"
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:1/sort:Inzerat.cena/direction:desc"
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:1/sort:Inzerat.cena/direction:desc"
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:1/sort:Inzerat.cena/direction:desc"
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:1/sort:Inzerat.cena/direction:desc"
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:1/sort:Inzerat.cena/direction:desc"
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 = 1329039943
SessionHelper::$sessionTime = false
SessionHelper::$watchKeys = array
SessionHelper::$id = NULL
SessionHelper::$_log = NULL
SessionHelper::$base = ""
SessionHelper::$webroot = "/"
SessionHelper::$here = "/lokalita/Zemplin/page:1/sort:Inzerat.cena/direction:desc"
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" => "4918",
	"je_mapa" => "1",
	"suradnice" => "48.798836,22.004671",
	"zoom" => "14",
	"map_type" => "G_NORMAL_MAP",
	"idmajitel" => "4824",
	"idmakler1" => "606",
	"idmakler2" => "0",
	"synchro_inzeraty" => "1328978412",
	"synchro_zariadenia" => "1328929806",
	"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

viac

1 | 2 | 3 Ďalej »

Motel Angelika - Zalužice - Zemplínska Šírava

Motely | Zalužice | Zemplínska Šírava

Detail

Cena (osoba/noc): 33 EUR (994,16 Sk)

Kapacita: 24

Motel Angelika sa nachádza v blízkosti mesta Michalovce v obci Zalužice na hlavnom ťahu v smere Michalovce – Ukrajina. V blízkom okolí motela sa nachádzajú rekreačné strediská Zemplínska šírava, Morské oko a Vinné jazero.Motel ponúka 8 pekne zariadených dvojposteľových izieb s možnosťou pridania prístelky. Každá izba je vybavená vlastnou kúpelňou so sprchovacím kútom alebo vaňou a farebným televízorom so satelitným napojením.Pre ubytovaných hostí je k dispozícii parkovisko priamo v areáli motela.Pre hosti ponúkame tiež možnosť raňajok podľa ponuky, ktoré niesu zahrnuté v cene ubytovania. Ubytovacie služby sú ponúkané NON STOP.Rozprávame slovensky, anglicky,poľsky a chorvátsky. Cenník u...

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

Penzióny | Veľká Tŕňa | Tokajská oblasť

Detail

Cena (osoba/noc): 33 EUR (994,16 Sk)

Kapacita: 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ť...

Penzión Milénium

Penzióny | Humenné | Zemplín

Detail

Cena (osoba/noc): 27 EUR (813,40 Sk)

Kapacita: 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 - Reštaurácia - Biela Labuť, Michalovce

Penzióny | Michalovce

Detail

Cena (osoba/noc): 25 EUR (753,15 Sk)

Kapacita: 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...

Hotel Armales *** Poloniny (okr.Snina)

Hotely | Stakčín | Poloniny

Detail

Cena (osoba/noc): 18 EUR (542,27 Sk)

Kapacita: 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č...

Vojenská Zotavovňa a hotel Zemplínska Šírava,Michalovce

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

Detail

Cena (osoba/noc): 17 EUR (512,14 Sk)

Kapacita: 400

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.

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

Penzióny | Vinné | Zemplínska Sírava - Vinné Jazero

Detail

Cena (osoba/noc): 16 EUR (482,02 Sk)

Kapacita: 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.

Penzión Odysea - Vinné Jazero, Zemplínska Šírava

Penzióny | Vinné | Zemplínska Šírava

Detail

Cena (osoba/noc): 15 EUR (451,89 Sk)

Kapacita: 28

Penzión Odysea je situovaný do nádhernej scenérie Vinného Jazera, ktoré sa nachádza v tichom prostredí neďaleko Zemplínskej Šíravy. Ponúka svoje služby celoročne pre rodiny s deťmi, ktoré si môžu priniesť aj ich domáceho miláčika, ale najme pre tých,ktorý si chcú maximálne oddýchnuť a načerpať množstvo zážitkov a energie či už z turistických potuliek(neďaleko je Vinnianský hrad),v ponuke je množstvo spoločenských akcií,možnosti vodných športov a atrakcií,rybolovu,hubárčenia,v blízkosti sú nádherné vinice s lákavými pivnicami...kvalitného vína.Penzión Odysea ďalej ponúka aj reštauračné služby s kvalitnou kuchyňou a prívetivým personálom.

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

Penzióny | Kaluža | Zemplínska Šírava

Detail

Cena (osoba/noc): 15 EUR (451,89 Sk)

Kapacita: 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 Opál, Vranov nad Topľou - Zamutov

Penzióny | Zámutov | Vranov nad Topľou

Detail

Cena (osoba/noc): 14 EUR (421,76 Sk)

Kapacita: 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...

1 | 2 | 3 Ďalej »

Polohy inzerátov na mape

(default) 100 queries took 718 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	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	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` = 'svk' LIMIT 1	1	1	0
45	SELECT `Texty`.`nadpis`, `Texty`.`name` FROM `realcms_wysiwyg` AS `Texty` WHERE `Texty`.`jazyk_id` = 1	7	7	0
46	INSERT DELAYED INTO `realcms_web_pristupy` (`ip_adresa`, `created`) VALUES ('38.107.179.211', '2012-02-12 10:45:39') 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	1
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	1
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	1
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	0
76	SELECT `BanerLokalita`.`lokalita_id`, `BanerLokalita`.`pozicia`, `BanerLokalita`.`idinzerat`, `Inzerat`.`idinzerat`, `Inzerat`.`uzivatel_iduzivatel`, `Inzerat`.`nazov`, `Inzerat`.`alias`, `Inzerat`.`variabilny_symbol`, `Inzerat`.`text`, `Inzerat`.`cas`, `Inzerat`.`cas_zmeneny`, `Inzerat`.`druh`, `Inzerat`.`typ`, `Inzerat`.`obec`, `Inzerat`.`id_kat_uzemia`, `Inzerat`.`cena`, `Inzerat`.`platba_za_mesiac`, `Inzerat`.`dlzka_predplatenia`, `Inzerat`.`platnost_zmluvy_do`, `Inzerat`.`podpis_zmluvy`, `Inzerat`.`ulica`, `Inzerat`.`lokalita`, `Inzerat`.`schvaleny`, `Inzerat`.`top`, `Inzerat`.`kapacita`, `Inzerat`.`zobrazeni`, `Inzerat`.`je_mapa`, `Inzerat`.`suradnice`, `Inzerat`.`zoom`, `Inzerat`.`map_type`, `Inzerat`.`idmajitel`, `Inzerat`.`idmakler1`, `Inzerat`.`idmakler2`, `Inzerat`.`synchro_inzeraty`, `Inzerat`.`synchro_zariadenia`, `Inzerat`.`demo`, `Inzerat`.`demo_do`, `Inzerat`.`nestandardny`, `Inzerat`.`nestandardny_od`, `Inzerat`.`nestandardny_do` FROM `realcms_banery_lokality` AS `BanerLokalita` LEFT JOIN `realcms_inzerat` AS `Inzerat` ON (`BanerLokalita`.`idinzerat` = `Inzerat`.`idinzerat`) WHERE `BanerLokalita`.`lokalita_id` = 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	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 `Inzerat`.`cena` desc LIMIT 10	10	10	41
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 (1176, 1146, 1556, 881, 1125, 1171, 895, 954, 1059, 999)	70	70	2
81	SELECT `RestaurantDetail`.`id`, `RestaurantDetail`.`ad_id`, `RestaurantDetail`.`contact`, `RestaurantDetail`.`created`, `RestaurantDetail`.`modified` FROM `realcms_restaurant_details` AS `RestaurantDetail` WHERE `RestaurantDetail`.`ad_id` IN (1176, 1146, 1556, 881, 1125, 1171, 895, 954, 1059, 999)	9	9	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 (1176, 1146, 1556, 881, 1125, 1171, 895, 954, 1059, 999)	2	2	0
83	SELECT `RestaurantPayment`.`id`, `RestaurantPayment`.`ad_id`, `RestaurantPayment`.`payment_type_id` FROM `realcms_restaurant_payments` AS `RestaurantPayment` WHERE `RestaurantPayment`.`ad_id` IN (1176, 1146, 1556, 881, 1125, 1171, 895, 954, 1059, 999)	2	2	0
84	SELECT `Charakteristika`.`id`, `Charakteristika`.`idinzerat`, `Charakteristika`.`idchar`, `Charakteristika`.`hodnota`, `Charakteristika`.`vyber` FROM `realcms_charakteristiky` AS `Charakteristika` WHERE `Charakteristika`.`idinzerat` IN (1176, 1146, 1556, 881, 1125, 1171, 895, 954, 1059, 999)	408	408	25
85	SELECT `Obrazok`.`idobrazok`, `Obrazok`.`url`, `Obrazok`.`sort`, `Obrazok`.`inzerat_idinzerat` FROM `realcms_obrazok` AS `Obrazok` WHERE `Obrazok`.`inzerat_idinzerat` IN (1176, 1146, 1556, 881, 1125, 1171, 895, 954, 1059, 999) ORDER BY `Obrazok`.`sort` asc, `Obrazok`.`idobrazok` asc	241	241	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 (1176, 1146, 1556, 881, 1125, 1171, 895, 954, 1059, 999)	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 (1176, 1146, 1556, 881, 1125, 1171, 895, 954, 1059, 999)	38	38	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 (1176, 1146, 1556, 881, 1125, 1171, 895, 954, 1059, 999) ORDER BY `povina_cena` DESC	19	19	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 (1176, 1146, 1556, 881, 1125, 1171, 895, 954, 1059, 999)	2	2	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` = 1176 OR `Vzdialenost1`.`id_inzerat2` = 1176) ORDER BY `Vzdialenost1`.`vzdialenost` asc	1071	1071	113
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	1
92	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	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` = 881 OR `Vzdialenost1`.`id_inzerat2` = 881) ORDER BY `Vzdialenost1`.`vzdialenost` asc	1137	1137	1
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	1
95	SELECT `Vzdialenost1`.`id`, `Vzdialenost1`.`id_inzerat1`, `Vzdialenost1`.`id_inzerat2`, `Vzdialenost1`.`vzdialenost`, `Vzdialenost1`.`modified` FROM `realcms_inzerat_vzdialenosti` AS `Vzdialenost1` WHERE (`Vzdialenost1`.`id_inzerat1` = 1171 OR `Vzdialenost1`.`id_inzerat2` = 1171) ORDER BY `Vzdialenost1`.`vzdialenost` asc	1069	1069	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` = 895 OR `Vzdialenost1`.`id_inzerat2` = 895) ORDER BY `Vzdialenost1`.`vzdialenost` asc	1105	1105	150
97	SELECT `Vzdialenost1`.`id`, `Vzdialenost1`.`id_inzerat1`, `Vzdialenost1`.`id_inzerat2`, `Vzdialenost1`.`vzdialenost`, `Vzdialenost1`.`modified` FROM `realcms_inzerat_vzdialenosti` AS `Vzdialenost1` WHERE (`Vzdialenost1`.`id_inzerat1` = 954 OR `Vzdialenost1`.`id_inzerat2` = 954) ORDER BY `Vzdialenost1`.`vzdialenost` asc	1131	1131	1
98	SELECT `Vzdialenost1`.`id`, `Vzdialenost1`.`id_inzerat1`, `Vzdialenost1`.`id_inzerat2`, `Vzdialenost1`.`vzdialenost`, `Vzdialenost1`.`modified` FROM `realcms_inzerat_vzdialenosti` AS `Vzdialenost1` WHERE (`Vzdialenost1`.`id_inzerat1` = 1059 OR `Vzdialenost1`.`id_inzerat2` = 1059) ORDER BY `Vzdialenost1`.`vzdialenost` asc	1015	1015	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` = 999 OR `Vzdialenost1`.`id_inzerat2` = 999) ORDER BY `Vzdialenost1`.`vzdialenost` asc	1131	1131	159
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 (1176, 1146, 1556, 881, 1125, 1171, 895, 954, 1059, 999)	350	350	13

(default) 100 queries took 718 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` = 'svk' LIMIT 1

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

INSERT DELAYED INTO `realcms_web_pristupy` (`ip_adresa`, `created`) VALUES ('38.107.179.211', '2012-02-12 10:45:39') 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 `Inzerat`.`cena` desc LIMIT 10

SELECT `Charakteristika`.`id`, `Charakteristika`.`idinzerat`, `Charakteristika`.`idchar`, `Charakteristika`.`hodnota`, `Charakteristika`.`vyber` FROM `realcms_charakteristiky` AS `Charakteristika` WHERE `Charakteristika`.`idinzerat` IN (1176, 1146, 1556, 881, 1125, 1171, 895, 954, 1059, 999)

408

241

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 (1176, 1146, 1556, 881, 1125, 1171, 895, 954, 1059, 999)

SELECT `StravaInzerat`.`idinzerat`, `StravaInzerat`.`idstravy`, `StravaInzerat`.`value` FROM `realcms_strava_inzeraty` AS `StravaInzerat` WHERE `StravaInzerat`.`value` = 1 AND `StravaInzerat`.`idinzerat` IN (1176, 1146, 1556, 881, 1125, 1171, 895, 954, 1059, 999)

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 (1176, 1146, 1556, 881, 1125, 1171, 895, 954, 1059, 999) 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 (1176, 1146, 1556, 881, 1125, 1171, 895, 954, 1059, 999)

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

1071

113

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

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

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

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

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

1069

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

150

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

1131

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

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

159

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 (1176, 1146, 1556, 881, 1125, 1171, 895, 954, 1059, 999)

350

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

Vyhľadávanie

Výsledky vyhľadávania

Top inzeráty

Polohy inzerátov na mape