Accomodations for Nitriansky country

Result of the searching

108 ads | sorted inteligent▼

Top accomodations

Château Appony ***...

Oponice
Ceny od: 65 EUR

CITY HOTEL NITRA *...

Nitra
Ceny od: 20 EUR

HOTEL PEKLO **** ,...

Komárno
Ceny od: 29 EUR

Rybárska bašta u H...

Nitra
Ceny od: 16,50 EUR

DREVENICA ALFA a P...

Podhájska
Ceny od: 9 EUR

HOTEL ZARA **** ,T...

Topoľčany
Ceny od: 0 EUR

Penzión HOFFER Nit...

Nitra
Ceny od: 16,50 EUR

« Back 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 Forward »

PRÁZDNINOVÝ DOM ALEX /krytý bazén,fitnes,masáže.../ ,Jabloňovce- Levice

Cottages | Bungalows | Jabloňovce | Štiavnické vrchy

Detail

Price (person/night): 0 EUR (0 Sk)

Capacity: 8

Prázdninový dom Alex sa nachádza v obci Jabloňovce v Štiavnických vrchoch. Rozloha domu je cca 170 m2. Má krytý bazén, vnútorný krb, vonkajší gril, terasu, fitness. Dom je vhodný pre rodiny s deťmi. Kompletne vybavená kuchyňa - umývačka riadu, mikrovlnka, rýchlovarná kanvica, hriankovač. V kúpeľni sa nachádza vaňa, automatická práčka... V spoločenskej miestnosti je TV SAT a audio súprava. K dispozícii sú dva 2 bicykle (detský a pre dospelého). Pre pohodu hostí ponúkame masáže: klasickú masáž, bankovanie, medovú masáž, masáž lávovými kameňmi, indickú masáž hlavy. 550 €/celý objekt/týždeň

CITY HOTEL NITRA ***,Nitra

Hotels | Nitra | Ponitrie

Detail

Price (person/night): 20 EUR (602,52 Sk)

Capacity: 50

City Hotel Nitra Predstavujeme Vám novopostavený Hotel City, ktorý sa nachádza priamo v centre mesta (na Svätoplukovom námestí) s prekrásnym výhľadom na divadlo, hrad a pešiu zónu. Recepcia V priestoroch recepcie je možné posedenie pre hostí, prípadne možnosť občerstvenia, pracovných jednaní a školení. Raňajky občerstvenie V cene izby sú zahrnuté raňajky vo forme švédskych stolov. Súčasťou hotela je aj Denný bar, ktorý ponúka v širokom sortimente alkoholické i nealkoholické nápoje, destiláty a domáce vína vysokej kvality. Ubytovanie Ubytovanie spĺňa kritériá pre náročných hostí. Ponúkame 22 dvojlôžkových izieb s balkónmi, vrátane 3 apartmánov + 3 jednolôžko...

Penzión EMESE - Búč

Pensions | Búč | Podunajská nížina

Detail

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

Capacity: 20

Penzión EMESE sa nachádza v tichej lokalite obce Búč. Penzión je známy svojím vidieckym štýlom ubytovania.Ubytovanie ponúka v 5 samostatných , štýlovo zariadených izbách so samostatnou kúpelňou a sociálnym zariadením. Zariadenie ponúka možnosť posedenia v altánku, pod klenbovou terasou, kúpanie v bazéne, grilovanie ,varenia gulášov.Ponúka uskladnenie bicyklov a požičanie člnu, ktorý je možné využiť na blízkom rybníku.Pre deti je pripravené detské ihrisko s pieskoviskom, hojdačkami, bicyklami.Penzión ponúka možnosť organizovania spoločenských a rodinných akcií a posedení. V obci sa nachádza zbierka rodin z bábik, predstavujúcich charakteristický ľudový odev na južnom Slovensku. Ďalšími ak...

Privát VODIČKA Štúrovo

Private accomodations | Štúrovo | Podunajská nížina

Detail

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

Capacity: 11

Kam na dovolenku lacno, a pritom bez straty komfortu ? Skúsili ste už "slovenské more" v Štúrove na Termálnom kúpalisku Vadaš ? Skúste raz, a budete sa vracať pravidelne do rozrastajúceho sa hraničného mesta, ktoré v lete prekypuje životom a kultúrnymi atrakciami, popri čom máte možnosť navštíviť významné historické pamiatky Európskeho charakteru : Bazilika v Ostrihome, historické centrum mesta Ostrihom, Vyšegrád, pamiatky mesta Budapešť,tropikárium v meste Budapešť.Okolie ponúka návštevu kaštiela Belá (8 km), plavbu loďou po rieke Dunaj ( Štúrovo - Vyšegrád ), jazdu vláčikom ( Štúrovo - Ostrihom ). V blízkom okolí sú výborné podmienky rybolovu ( rieky Dunaj, Hron a Ipeľ), turistiky ...

Chata LIMBA Duchonka

Cottages | Bungalows | Prašice | Duchonka

Detail

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

Capacity: 15

V príjemnom prostredí rekreačnej oblasti "Duchonka" v okrese Topoľčany Vám ponúkame možnosť strávenia príjemných chvíľ v kruhu rodiny a priateľov. Chata "Limba", ktorá je vzdialená len 200m od vodnej nádrže, Vám ponúka celoročné ubytovanie v šiestich dvojposteľových izbách, príjemné posedenie v spoločenskej miestnosti, kompletne vybavenú kuchyňu, sociálne zariadenie pozostávajúce z dvoch splachovacích WC, dvoch sprchovacích kútov, vírivého bazénu a sauny. V blízkosti chaty nachádzajúce sa ohnisko ulahodí tým, ktorí chcú večer stráviť za zvuku praskajúceho dreva pri táboráku. Chata disponuje možnosťou parkovania v uzamknutej garáži pre dve osobné autá. Štruktúra izieb: 6 dvojlôžkových ...

Penzion KORZO Hlavná 19,Štúrovo - Nové Zámky

Pensions | Štúrovo

Detail

Price (person/night): 17 EUR (512,14 Sk)

Capacity: 30

Penzión KORZO Vám ponúka ubytovanie v Štúrove - príjemnom malom mestečku na juhovýchodnom cípe západného Slovenska pri hraniciach s Maďarskom, kde rieka Dunaj opúšta Slovensko. Štúrovo je známe predovšetkým svojim termálnym kúpaliskom VADAŠ - obľúbeným miestom turistov aj zo zahraničia. Penzión sa nachádza asi 300 m od termálného kúpaliska. V ubytovacom areáli Vás čaká príjemná oáza zelene, z dvora penziónu vstupujete priamo na pešiu zónu - korzo, čo je veľmi príjemné napr. pri večerných prechádzkach, návšteve reštauračných zariadení a pod. Pre využitie voľného času je veľa možností: priestranný dvor, stolný tenis, detské ihrisko, altánok, gril, krb .Tieto možnosti sú pre vás pri...

PENZION "HUBERT*"-SNACK BAR,Topoľčany

Pensions | Topoľčany | Ponitrie

Detail

Price (person/night): 0 EUR (0 Sk)

Capacity: 12

Slušné ubytovanie v blízkosti centra Topoľčian s dobrou kuchyňou.

Ubytovanie na súkromí Karáseková Mária,Nitra

Private accomodations | Nitra | Ponitrie

Detail

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

Capacity: 5

Ubytovanie sa nachádza v dolnej časti Zobora, prístup z hlavnej cesty, medzi penziónmi VILA ÁRIA a ZOBORSKÁ, 15 minút chôdze do centra. Ubytovanie je vhodné na krátkodobý pobyt pre obchodných cestujúcich, turistov aj rodiny s deťmi /deti zdarma/. Ubytovaným na viac ako dva dni poskytneme zľavu. Jedná sa o ubytovanie hotelového typu so samostatným vchodom (absolútne súkromie). Platba: v hotovosti, faktúrou, na účet Kapacita: 2 izby, 1x izba pre 2 osoby, 1x izba pre 2 osoby + prístelka Reštaurácia: vedľa pizzéria Toscana Prevádzková doba: nonstop Mesto Nitra je správnym centrom Nitrianskeho kraja, ktorý tvoria okresy Nitra, Komárno, Levice, Nové Zámky, ...

PENZION LIPA ,Tlmače- Levice

Pensions | Tlmače | Pohronie

Detail

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

Capacity: 96

O NÁS Vitajte v penzióne LIPA, ktorý sa nachádza na sútoku Hrona, Slovenskej brány a na úpätí malebných Štiavnických vrchov. Hory, lúky, chlebodarné polia, rybolovné vody, romantické zákutia Hrona upokojujúce dušu, osviežujúce telo, to je to miesto kde Vás pozývame. V našom penzióne neponúkame len ubytovanie na slušnej úrovni, ale disponujeme aj veľmi kvalitnou kuchyňou, ktorá uspokojí aj tých najnáročnejších zákazníkov. Naša reštaurácia ponúka tradičné slovenské jedlá, špeciality z rýb, hydiny, diviny a mnoho ďalších špecialít. K našim jedlám Vám odporúčame ochutnať dobré vína, ktoré ukrýva naša pivnica. Pri ochutnávaní našich jedál a nápojov Vám prajeme dobrú chuť. Penzión Lipa spĺňa...

Privat TARR , Madachová 52 , Nána

Private accomodations | Nána

Detail

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

Capacity: 12

Ubytovacie zariadenie sa nachádza v tichej lokalite v obci Nána, vzdialenej 2 km od termálneho kúpaliska Vadaš v Štúrove. Privát ponúka ubytovanie v 2,4 a 6 postelovej izbe so spoločným hygienickým zariadením. Ďalej ponúka možnosť posedenia v altánku, pri ohnisku alebo na terase.Umožňuje uskladnenie bicyklov a pobyt s malým domácim zvieratkom. Blízke okolie ponúka možnosť rybolovu ( rieky Dunaj, Hron a Ipeľ), cykloturistiky a turistiky ( pohorie Burda).V blízkom okolí sa nachádza kaštiel Belá , historické mesto Ostrihom (Maďarská republika) a ďalšie turistické atrakcie.

« Back 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 Forward »

Accomodations on map

(default) 144 queries took 1075 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	2
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` = '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.210', '2012-02-06 15:52:37') 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	115
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 `Kraj`.`idkraj`, `Kraj`.`nazov`, `Kraj`.`idstat` FROM `realcms_kraje` AS `Kraj` WHERE lower(`Kraj`.`nazov`) = 'nitriansky' LIMIT 1	1	1	0
75	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 AND `Baner`.`kraj_id` = 4 ORDER BY `Baner`.`pozicia` ASC LIMIT 8	7	7	1
76	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
77	SELECT `Obec`.`idobec`, `Obec`.`nazov_obce`, `Obec`.`idokres`, `Obec`.`psc` FROM `realcms_obce` AS `Obec` WHERE `Obec`.`idobec` = 505285	1	1	0
78	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
79	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
80	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
81	SELECT `RestaurantPayment`.`id`, `RestaurantPayment`.`ad_id`, `RestaurantPayment`.`payment_type_id` FROM `realcms_restaurant_payments` AS `RestaurantPayment` WHERE `RestaurantPayment`.`ad_id` = (2292)	0	0	0
82	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` = 2145	1	1	0
83	SELECT `Obec`.`idobec`, `Obec`.`nazov_obce`, `Obec`.`idokres`, `Obec`.`psc` FROM `realcms_obce` AS `Obec` WHERE `Obec`.`idobec` = 500011	1	1	0
84	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` = (2145)	0	0	0
85	SELECT `RestaurantDetail`.`id`, `RestaurantDetail`.`ad_id`, `RestaurantDetail`.`contact`, `RestaurantDetail`.`created`, `RestaurantDetail`.`modified` FROM `realcms_restaurant_details` AS `RestaurantDetail` WHERE `RestaurantDetail`.`ad_id` = (2145)	0	0	0
86	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` = (2145)	0	0	0
87	SELECT `RestaurantPayment`.`id`, `RestaurantPayment`.`ad_id`, `RestaurantPayment`.`payment_type_id` FROM `realcms_restaurant_payments` AS `RestaurantPayment` WHERE `RestaurantPayment`.`ad_id` = (2145)	0	0	0
88	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` = 2165	1	1	1
89	SELECT `Obec`.`idobec`, `Obec`.`nazov_obce`, `Obec`.`idokres`, `Obec`.`psc` FROM `realcms_obce` AS `Obec` WHERE `Obec`.`idobec` = 501026	1	1	0
90	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` = (2165)	0	0	0
91	SELECT `RestaurantDetail`.`id`, `RestaurantDetail`.`ad_id`, `RestaurantDetail`.`contact`, `RestaurantDetail`.`created`, `RestaurantDetail`.`modified` FROM `realcms_restaurant_details` AS `RestaurantDetail` WHERE `RestaurantDetail`.`ad_id` = (2165)	0	0	0
92	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` = (2165)	0	0	0
93	SELECT `RestaurantPayment`.`id`, `RestaurantPayment`.`ad_id`, `RestaurantPayment`.`payment_type_id` FROM `realcms_restaurant_payments` AS `RestaurantPayment` WHERE `RestaurantPayment`.`ad_id` = (2165)	0	0	0
94	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` = 2230	1	1	1
95	SELECT `Obec`.`idobec`, `Obec`.`nazov_obce`, `Obec`.`idokres`, `Obec`.`psc` FROM `realcms_obce` AS `Obec` WHERE `Obec`.`idobec` = 500011	1	1	0
96	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` = (2230)	0	0	0
97	SELECT `RestaurantDetail`.`id`, `RestaurantDetail`.`ad_id`, `RestaurantDetail`.`contact`, `RestaurantDetail`.`created`, `RestaurantDetail`.`modified` FROM `realcms_restaurant_details` AS `RestaurantDetail` WHERE `RestaurantDetail`.`ad_id` = (2230)	0	0	0
98	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` = (2230)	0	0	0
99	SELECT `RestaurantPayment`.`id`, `RestaurantPayment`.`ad_id`, `RestaurantPayment`.`payment_type_id` FROM `realcms_restaurant_payments` AS `RestaurantPayment` WHERE `RestaurantPayment`.`ad_id` = (2230)	0	0	0
100	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` = 1369	1	1	1
101	SELECT `Obec`.`idobec`, `Obec`.`nazov_obce`, `Obec`.`idokres`, `Obec`.`psc` FROM `realcms_obce` AS `Obec` WHERE `Obec`.`idobec` = 503479	1	1	0
102	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` = (1369)	0	0	0
103	SELECT `RestaurantDetail`.`id`, `RestaurantDetail`.`ad_id`, `RestaurantDetail`.`contact`, `RestaurantDetail`.`created`, `RestaurantDetail`.`modified` FROM `realcms_restaurant_details` AS `RestaurantDetail` WHERE `RestaurantDetail`.`ad_id` = (1369)	0	0	0
104	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` = (1369)	0	0	0
105	SELECT `RestaurantPayment`.`id`, `RestaurantPayment`.`ad_id`, `RestaurantPayment`.`payment_type_id` FROM `realcms_restaurant_payments` AS `RestaurantPayment` WHERE `RestaurantPayment`.`ad_id` = (1369)	0	0	0
106	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` = 2096	1	1	1
107	SELECT `Obec`.`idobec`, `Obec`.`nazov_obce`, `Obec`.`idokres`, `Obec`.`psc` FROM `realcms_obce` AS `Obec` WHERE `Obec`.`idobec` = 504998	1	1	0
108	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` = (2096)	0	0	0
109	SELECT `RestaurantDetail`.`id`, `RestaurantDetail`.`ad_id`, `RestaurantDetail`.`contact`, `RestaurantDetail`.`created`, `RestaurantDetail`.`modified` FROM `realcms_restaurant_details` AS `RestaurantDetail` WHERE `RestaurantDetail`.`ad_id` = (2096)	0	0	0
110	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` = (2096)	0	0	0
111	SELECT `RestaurantPayment`.`id`, `RestaurantPayment`.`ad_id`, `RestaurantPayment`.`payment_type_id` FROM `realcms_restaurant_payments` AS `RestaurantPayment` WHERE `RestaurantPayment`.`ad_id` = (2096)	0	0	0
112	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` = 2228	1	1	1
113	SELECT `Obec`.`idobec`, `Obec`.`nazov_obce`, `Obec`.`idokres`, `Obec`.`psc` FROM `realcms_obce` AS `Obec` WHERE `Obec`.`idobec` = 500011	1	1	0
114	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` = (2228)	0	0	0
115	SELECT `RestaurantDetail`.`id`, `RestaurantDetail`.`ad_id`, `RestaurantDetail`.`contact`, `RestaurantDetail`.`created`, `RestaurantDetail`.`modified` FROM `realcms_restaurant_details` AS `RestaurantDetail` WHERE `RestaurantDetail`.`ad_id` = (2228)	0	0	0
116	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` = (2228)	0	0	0
117	SELECT `RestaurantPayment`.`id`, `RestaurantPayment`.`ad_id`, `RestaurantPayment`.`payment_type_id` FROM `realcms_restaurant_payments` AS `RestaurantPayment` WHERE `RestaurantPayment`.`ad_id` = (2228)	0	0	0
118	SELECT `Obrazok`.`idobrazok`, `Obrazok`.`url`, `Obrazok`.`sort`, `Obrazok`.`inzerat_idinzerat` FROM `realcms_obrazok` AS `Obrazok` WHERE `Obrazok`.`inzerat_idinzerat` IN (2292, 2145, 2165, 2230, 1369, 2096, 2228) ORDER BY `Obrazok`.`sort` asc	128	128	0
119	SELECT `Kraj`.`idkraj`, `Kraj`.`nazov`, `Kraj`.`idstat` FROM `realcms_kraje` AS `Kraj` WHERE `Kraj`.`idstat` = 'SK'	8	8	0
120	SELECT `Okres`.`idokres` FROM `realcms_okresy` AS `Okres` LEFT JOIN `realcms_kraje` AS `Kraj` ON (`Okres`.`idkraj` = `Kraj`.`idkraj`) WHERE `Okres`.`idkraj` = '4'	7	7	0
121	SELECT `Obec`.`idobec`, `Obec`.`nazov_obce`, `Obec`.`idokres`, `Obec`.`psc` FROM `realcms_obce` AS `Obec` WHERE `Obec`.`idokres` IN ('401', '402', '403', '404', '405', '406', '407') ORDER BY `Obec`.`nazov_obce` ASC	354	354	0
122	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 ('501034', '501395', '501042', '555819', '501069', '501077', '501085', '501093', '501107', '501123', '580911', '501140', '501158', '501166', '501174', '501182', '501191', '501204', '501026', '501212', '501221', '501239', '501247', '501255', '501263', '501271', '501280', '501301', '501310', '501328', '501336', '501344', '501115', '501352', '501361', '501379', '501387', '555827', '501409', '501417', '501425', '502049', '502057', '502065', '502073', '580937', '502090', '502103', '502111', '502120', '555843', '502154', '502162', '502171', '502189', '502197', '502201', '502219', '502227', '502243', '502251', '545350', '502260', '502278', '502286', '502294', '581895', '502324', '502332', '502341', '502359', '502367', '502375', '502383', '556777', '502391', '502413', '502472', '502421', '502430', '502448', '502456', '502464', '502031', '502481', '502499', '502502', '502511', '581135', '502537', '502570', '502588', '502596', '502600', '502618', '502626', '502634', '502642', '502651', '502669', '502677', '502693', '502707', '502715', '502723', '502731', '502740', '502758', '502766', '502782', '502791', '502804', '502812', '502821', '502847', '502863', '502871', '502880', '502898', '581160', '502910', '502928', '502936', '502944', '502952', '502961', '502979', '502987', '502995', '503002', '500020', '500046', '581623', '582697', '500071', '545589', '582387', '500101', '555886', '500135', '500160', '582425', '500194', '500232', '545635', '555959', '500313', '558320', '500356', '500372', '500381', '500399', '500402', '500411', '500453', '500470', '581097', '500488', '580899', '556785', '500534', '555908', '555851', '500569', '500577', '500011', '556696', '500631', '500640', '500666', '500674', '500682', '500691', '500704', '500712', '555991', '581691', '582719', '500780', '500798', '555967', '500844', '500518', '500887', '500895', '555860', '500917', '500933', '500941', '500950', '500992', '501018', '503029', '503037', '503045', '503053', '503061', '503070', '503088', '503096', '503100', '503118', '503126', '503134', '503151', '503169', '503177', '503185', '503193', '503207', '503215', '503223', '503231', '503240', '503258', '503266', '503274', '503282', '503291', '503312', '503321', '503339', '503347', '503355', '503363', '503371', '503398', '503401', '556092', '503436', '503011', '582361', '503452', '556033', '503479', '503487', '503495', '503509', '503517', '503525', '503533', '503541', '503550', '503568', '503576', '503584', '503592', '503606', '503614', '556050', '503631', '503380', '556025', '503649', '503711', '503720', '500241', '555878', '503886', '500739', '503932', '503991', '504025', '504068', '504092', '504165', '504190', '556220', '542661', '542695', '542709', '542717', '556297', '542792', '556262', '542881', '556351', '542938', '542954', '542971', '556165', '556157', '543039', '543063', '543071', '543101', '543110', '556149', '581704', '505021', '505048', '505064', '505137', '581305', '505226', '505234', '505242', '505251', '505285', '556211', '505340', '505374', '581658', '505404', '505421', '505439', '505498', '556327', '505510', '556238', '505536', '505561', '504998', '580457', '505617', '505641', '505676', '505714', '505749', '505757', '505773', '500062', '500127', '555916', '500151', '500283', '500305', '500321', '500364', '500429', '500437', '500461', '500500', '555924', '500542', '500551', '500585', '500593', '500607', '500658', '500721', '500747', '500755', '517305', '500810', '500828', '500836', '555932', '500909', '500925', '500968', '500976', '500984', '582816') AND `Inzerat`.`demo` = 0	1	1	35
123	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 ('501034', '501395', '501042', '555819', '501069', '501077', '501085', '501093', '501107', '501123', '580911', '501140', '501158', '501166', '501174', '501182', '501191', '501204', '501026', '501212', '501221', '501239', '501247', '501255', '501263', '501271', '501280', '501301', '501310', '501328', '501336', '501344', '501115', '501352', '501361', '501379', '501387', '555827', '501409', '501417', '501425', '502049', '502057', '502065', '502073', '580937', '502090', '502103', '502111', '502120', '555843', '502154', '502162', '502171', '502189', '502197', '502201', '502219', '502227', '502243', '502251', '545350', '502260', '502278', '502286', '502294', '581895', '502324', '502332', '502341', '502359', '502367', '502375', '502383', '556777', '502391', '502413', '502472', '502421', '502430', '502448', '502456', '502464', '502031', '502481', '502499', '502502', '502511', '581135', '502537', '502570', '502588', '502596', '502600', '502618', '502626', '502634', '502642', '502651', '502669', '502677', '502693', '502707', '502715', '502723', '502731', '502740', '502758', '502766', '502782', '502791', '502804', '502812', '502821', '502847', '502863', '502871', '502880', '502898', '581160', '502910', '502928', '502936', '502944', '502952', '502961', '502979', '502987', '502995', '503002', '500020', '500046', '581623', '582697', '500071', '545589', '582387', '500101', '555886', '500135', '500160', '582425', '500194', '500232', '545635', '555959', '500313', '558320', '500356', '500372', '500381', '500399', '500402', '500411', '500453', '500470', '581097', '500488', '580899', '556785', '500534', '555908', '555851', '500569', '500577', '500011', '556696', '500631', '500640', '500666', '500674', '500682', '500691', '500704', '500712', '555991', '581691', '582719', '500780', '500798', '555967', '500844', '500518', '500887', '500895', '555860', '500917', '500933', '500941', '500950', '500992', '501018', '503029', '503037', '503045', '503053', '503061', '503070', '503088', '503096', '503100', '503118', '503126', '503134', '503151', '503169', '503177', '503185', '503193', '503207', '503215', '503223', '503231', '503240', '503258', '503266', '503274', '503282', '503291', '503312', '503321', '503339', '503347', '503355', '503363', '503371', '503398', '503401', '556092', '503436', '503011', '582361', '503452', '556033', '503479', '503487', '503495', '503509', '503517', '503525', '503533', '503541', '503550', '503568', '503576', '503584', '503592', '503606', '503614', '556050', '503631', '503380', '556025', '503649', '503711', '503720', '500241', '555878', '503886', '500739', '503932', '503991', '504025', '504068', '504092', '504165', '504190', '556220', '542661', '542695', '542709', '542717', '556297', '542792', '556262', '542881', '556351', '542938', '542954', '542971', '556165', '556157', '543039', '543063', '543071', '543101', '543110', '556149', '581704', '505021', '505048', '505064', '505137', '581305', '505226', '505234', '505242', '505251', '505285', '556211', '505340', '505374', '581658', '505404', '505421', '505439', '505498', '556327', '505510', '556238', '505536', '505561', '504998', '580457', '505617', '505641', '505676', '505714', '505749', '505757', '505773', '500062', '500127', '555916', '500151', '500283', '500305', '500321', '500364', '500429', '500437', '500461', '500500', '555924', '500542', '500551', '500585', '500593', '500607', '500658', '500721', '500747', '500755', '517305', '500810', '500828', '500836', '555932', '500909', '500925', '500968', '500976', '500984', '582816') AND `Inzerat`.`demo` = 0 ORDER BY RAND(781769884) ASC LIMIT 40, 10	10	10	79
124	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 (1633, 2145, 1423, 1640, 2083, 1107, 2072, 1794, 1863, 937)	0	0	1
125	SELECT `RestaurantDetail`.`id`, `RestaurantDetail`.`ad_id`, `RestaurantDetail`.`contact`, `RestaurantDetail`.`created`, `RestaurantDetail`.`modified` FROM `realcms_restaurant_details` AS `RestaurantDetail` WHERE `RestaurantDetail`.`ad_id` IN (1633, 2145, 1423, 1640, 2083, 1107, 2072, 1794, 1863, 937)	0	0	0
126	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 (1633, 2145, 1423, 1640, 2083, 1107, 2072, 1794, 1863, 937)	0	0	0
127	SELECT `RestaurantPayment`.`id`, `RestaurantPayment`.`ad_id`, `RestaurantPayment`.`payment_type_id` FROM `realcms_restaurant_payments` AS `RestaurantPayment` WHERE `RestaurantPayment`.`ad_id` IN (1633, 2145, 1423, 1640, 2083, 1107, 2072, 1794, 1863, 937)	0	0	0
128	SELECT `Charakteristika`.`id`, `Charakteristika`.`idinzerat`, `Charakteristika`.`idchar`, `Charakteristika`.`hodnota`, `Charakteristika`.`vyber` FROM `realcms_charakteristiky` AS `Charakteristika` WHERE `Charakteristika`.`idinzerat` IN (1633, 2145, 1423, 1640, 2083, 1107, 2072, 1794, 1863, 937)	392	392	25
129	SELECT `Obrazok`.`idobrazok`, `Obrazok`.`url`, `Obrazok`.`sort`, `Obrazok`.`inzerat_idinzerat` FROM `realcms_obrazok` AS `Obrazok` WHERE `Obrazok`.`inzerat_idinzerat` IN (1633, 2145, 1423, 1640, 2083, 1107, 2072, 1794, 1863, 937) ORDER BY `Obrazok`.`sort` asc, `Obrazok`.`idobrazok` asc	136	136	16
130	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 (1633, 2145, 1423, 1640, 2083, 1107, 2072, 1794, 1863, 937)	0	0	1
131	SELECT `StravaInzerat`.`idinzerat`, `StravaInzerat`.`idstravy`, `StravaInzerat`.`value` FROM `realcms_strava_inzeraty` AS `StravaInzerat` WHERE `StravaInzerat`.`value` = 1 AND `StravaInzerat`.`idinzerat` IN (1633, 2145, 1423, 1640, 2083, 1107, 2072, 1794, 1863, 937)	18	18	1
132	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 (1633, 2145, 1423, 1640, 2083, 1107, 2072, 1794, 1863, 937) ORDER BY `povina_cena` DESC	19	19	2
133	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 (1633, 2145, 1423, 1640, 2083, 1107, 2072, 1794, 1863, 937)	5	5	1
134	SELECT `Vzdialenost1`.`id`, `Vzdialenost1`.`id_inzerat1`, `Vzdialenost1`.`id_inzerat2`, `Vzdialenost1`.`vzdialenost`, `Vzdialenost1`.`modified` FROM `realcms_inzerat_vzdialenosti` AS `Vzdialenost1` WHERE (`Vzdialenost1`.`id_inzerat1` = 1633 OR `Vzdialenost1`.`id_inzerat2` = 1633) ORDER BY `Vzdialenost1`.`vzdialenost` asc	1047	1047	1
135	SELECT `Vzdialenost1`.`id`, `Vzdialenost1`.`id_inzerat1`, `Vzdialenost1`.`id_inzerat2`, `Vzdialenost1`.`vzdialenost`, `Vzdialenost1`.`modified` FROM `realcms_inzerat_vzdialenosti` AS `Vzdialenost1` WHERE (`Vzdialenost1`.`id_inzerat1` = 2145 OR `Vzdialenost1`.`id_inzerat2` = 2145) ORDER BY `Vzdialenost1`.`vzdialenost` asc	993	993	1
136	SELECT `Vzdialenost1`.`id`, `Vzdialenost1`.`id_inzerat1`, `Vzdialenost1`.`id_inzerat2`, `Vzdialenost1`.`vzdialenost`, `Vzdialenost1`.`modified` FROM `realcms_inzerat_vzdialenosti` AS `Vzdialenost1` WHERE (`Vzdialenost1`.`id_inzerat1` = 1423 OR `Vzdialenost1`.`id_inzerat2` = 1423) ORDER BY `Vzdialenost1`.`vzdialenost` asc	1060	1060	127
137	SELECT `Vzdialenost1`.`id`, `Vzdialenost1`.`id_inzerat1`, `Vzdialenost1`.`id_inzerat2`, `Vzdialenost1`.`vzdialenost`, `Vzdialenost1`.`modified` FROM `realcms_inzerat_vzdialenosti` AS `Vzdialenost1` WHERE (`Vzdialenost1`.`id_inzerat1` = 1640 OR `Vzdialenost1`.`id_inzerat2` = 1640) ORDER BY `Vzdialenost1`.`vzdialenost` asc	1045	1045	112
138	SELECT `Vzdialenost1`.`id`, `Vzdialenost1`.`id_inzerat1`, `Vzdialenost1`.`id_inzerat2`, `Vzdialenost1`.`vzdialenost`, `Vzdialenost1`.`modified` FROM `realcms_inzerat_vzdialenosti` AS `Vzdialenost1` WHERE (`Vzdialenost1`.`id_inzerat1` = 2083 OR `Vzdialenost1`.`id_inzerat2` = 2083) ORDER BY `Vzdialenost1`.`vzdialenost` asc	1014	1014	1
139	SELECT `Vzdialenost1`.`id`, `Vzdialenost1`.`id_inzerat1`, `Vzdialenost1`.`id_inzerat2`, `Vzdialenost1`.`vzdialenost`, `Vzdialenost1`.`modified` FROM `realcms_inzerat_vzdialenosti` AS `Vzdialenost1` WHERE (`Vzdialenost1`.`id_inzerat1` = 1107 OR `Vzdialenost1`.`id_inzerat2` = 1107) ORDER BY `Vzdialenost1`.`vzdialenost` asc	1090	1090	125
140	SELECT `Vzdialenost1`.`id`, `Vzdialenost1`.`id_inzerat1`, `Vzdialenost1`.`id_inzerat2`, `Vzdialenost1`.`vzdialenost`, `Vzdialenost1`.`modified` FROM `realcms_inzerat_vzdialenosti` AS `Vzdialenost1` WHERE (`Vzdialenost1`.`id_inzerat1` = 2072 OR `Vzdialenost1`.`id_inzerat2` = 2072) ORDER BY `Vzdialenost1`.`vzdialenost` asc	1014	1014	124
141	SELECT `Vzdialenost1`.`id`, `Vzdialenost1`.`id_inzerat1`, `Vzdialenost1`.`id_inzerat2`, `Vzdialenost1`.`vzdialenost`, `Vzdialenost1`.`modified` FROM `realcms_inzerat_vzdialenosti` AS `Vzdialenost1` WHERE (`Vzdialenost1`.`id_inzerat1` = 1794 OR `Vzdialenost1`.`id_inzerat2` = 1794) ORDER BY `Vzdialenost1`.`vzdialenost` asc	1034	1034	1
142	SELECT `Vzdialenost1`.`id`, `Vzdialenost1`.`id_inzerat1`, `Vzdialenost1`.`id_inzerat2`, `Vzdialenost1`.`vzdialenost`, `Vzdialenost1`.`modified` FROM `realcms_inzerat_vzdialenosti` AS `Vzdialenost1` WHERE (`Vzdialenost1`.`id_inzerat1` = 1863 OR `Vzdialenost1`.`id_inzerat2` = 1863) ORDER BY `Vzdialenost1`.`vzdialenost` asc	1019	1019	119
143	SELECT `Vzdialenost1`.`id`, `Vzdialenost1`.`id_inzerat1`, `Vzdialenost1`.`id_inzerat2`, `Vzdialenost1`.`vzdialenost`, `Vzdialenost1`.`modified` FROM `realcms_inzerat_vzdialenosti` AS `Vzdialenost1` WHERE (`Vzdialenost1`.`id_inzerat1` = 937 OR `Vzdialenost1`.`id_inzerat2` = 937) ORDER BY `Vzdialenost1`.`vzdialenost` asc	1143	1143	115
144	SELECT `VzdialenostMesta`.`id`, `VzdialenostMesta`.`id_inzerat`, `VzdialenostMesta`.`mesto`, `VzdialenostMesta`.`vzdialenost`, `VzdialenostMesta`.`updated` FROM `realcms_inzerat_vzdialenosti_mesta` AS `VzdialenostMesta` WHERE `VzdialenostMesta`.`id_inzerat` IN (1633, 2145, 1423, 1640, 2083, 1107, 2072, 1794, 1863, 937)	350	350	15

(default) 144 queries took 1075 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.210', '2012-02-06 15:52:37') 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

115

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 `Kraj`.`idkraj`, `Kraj`.`nazov`, `Kraj`.`idstat` FROM `realcms_kraje` AS `Kraj` WHERE lower(`Kraj`.`nazov`) = 'nitriansky' LIMIT 1

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` = 500011

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

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

100

101

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

102

103

104

105

106

107

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

108

109

110

111

112

113

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

114

115

116

117

118

128

119

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

120

SELECT `Okres`.`idokres` FROM `realcms_okresy` AS `Okres` LEFT JOIN `realcms_kraje` AS `Kraj` ON (`Okres`.`idkraj` = `Kraj`.`idkraj`) WHERE `Okres`.`idkraj` = '4'

121

SELECT `Obec`.`idobec`, `Obec`.`nazov_obce`, `Obec`.`idokres`, `Obec`.`psc` FROM `realcms_obce` AS `Obec` WHERE `Obec`.`idokres` IN ('401', '402', '403', '404', '405', '406', '407') ORDER BY `Obec`.`nazov_obce` ASC

354

122

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 ('501034', '501395', '501042', '555819', '501069', '501077', '501085', '501093', '501107', '501123', '580911', '501140', '501158', '501166', '501174', '501182', '501191', '501204', '501026', '501212', '501221', '501239', '501247', '501255', '501263', '501271', '501280', '501301', '501310', '501328', '501336', '501344', '501115', '501352', '501361', '501379', '501387', '555827', '501409', '501417', '501425', '502049', '502057', '502065', '502073', '580937', '502090', '502103', '502111', '502120', '555843', '502154', '502162', '502171', '502189', '502197', '502201', '502219', '502227', '502243', '502251', '545350', '502260', '502278', '502286', '502294', '581895', '502324', '502332', '502341', '502359', '502367', '502375', '502383', '556777', '502391', '502413', '502472', '502421', '502430', '502448', '502456', '502464', '502031', '502481', '502499', '502502', '502511', '581135', '502537', '502570', '502588', '502596', '502600', '502618', '502626', '502634', '502642', '502651', '502669', '502677', '502693', '502707', '502715', '502723', '502731', '502740', '502758', '502766', '502782', '502791', '502804', '502812', '502821', '502847', '502863', '502871', '502880', '502898', '581160', '502910', '502928', '502936', '502944', '502952', '502961', '502979', '502987', '502995', '503002', '500020', '500046', '581623', '582697', '500071', '545589', '582387', '500101', '555886', '500135', '500160', '582425', '500194', '500232', '545635', '555959', '500313', '558320', '500356', '500372', '500381', '500399', '500402', '500411', '500453', '500470', '581097', '500488', '580899', '556785', '500534', '555908', '555851', '500569', '500577', '500011', '556696', '500631', '500640', '500666', '500674', '500682', '500691', '500704', '500712', '555991', '581691', '582719', '500780', '500798', '555967', '500844', '500518', '500887', '500895', '555860', '500917', '500933', '500941', '500950', '500992', '501018', '503029', '503037', '503045', '503053', '503061', '503070', '503088', '503096', '503100', '503118', '503126', '503134', '503151', '503169', '503177', '503185', '503193', '503207', '503215', '503223', '503231', '503240', '503258', '503266', '503274', '503282', '503291', '503312', '503321', '503339', '503347', '503355', '503363', '503371', '503398', '503401', '556092', '503436', '503011', '582361', '503452', '556033', '503479', '503487', '503495', '503509', '503517', '503525', '503533', '503541', '503550', '503568', '503576', '503584', '503592', '503606', '503614', '556050', '503631', '503380', '556025', '503649', '503711', '503720', '500241', '555878', '503886', '500739', '503932', '503991', '504025', '504068', '504092', '504165', '504190', '556220', '542661', '542695', '542709', '542717', '556297', '542792', '556262', '542881', '556351', '542938', '542954', '542971', '556165', '556157', '543039', '543063', '543071', '543101', '543110', '556149', '581704', '505021', '505048', '505064', '505137', '581305', '505226', '505234', '505242', '505251', '505285', '556211', '505340', '505374', '581658', '505404', '505421', '505439', '505498', '556327', '505510', '556238', '505536', '505561', '504998', '580457', '505617', '505641', '505676', '505714', '505749', '505757', '505773', '500062', '500127', '555916', '500151', '500283', '500305', '500321', '500364', '500429', '500437', '500461', '500500', '555924', '500542', '500551', '500585', '500593', '500607', '500658', '500721', '500747', '500755', '517305', '500810', '500828', '500836', '555932', '500909', '500925', '500968', '500976', '500984', '582816') AND `Inzerat`.`demo` = 0

123

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 ('501034', '501395', '501042', '555819', '501069', '501077', '501085', '501093', '501107', '501123', '580911', '501140', '501158', '501166', '501174', '501182', '501191', '501204', '501026', '501212', '501221', '501239', '501247', '501255', '501263', '501271', '501280', '501301', '501310', '501328', '501336', '501344', '501115', '501352', '501361', '501379', '501387', '555827', '501409', '501417', '501425', '502049', '502057', '502065', '502073', '580937', '502090', '502103', '502111', '502120', '555843', '502154', '502162', '502171', '502189', '502197', '502201', '502219', '502227', '502243', '502251', '545350', '502260', '502278', '502286', '502294', '581895', '502324', '502332', '502341', '502359', '502367', '502375', '502383', '556777', '502391', '502413', '502472', '502421', '502430', '502448', '502456', '502464', '502031', '502481', '502499', '502502', '502511', '581135', '502537', '502570', '502588', '502596', '502600', '502618', '502626', '502634', '502642', '502651', '502669', '502677', '502693', '502707', '502715', '502723', '502731', '502740', '502758', '502766', '502782', '502791', '502804', '502812', '502821', '502847', '502863', '502871', '502880', '502898', '581160', '502910', '502928', '502936', '502944', '502952', '502961', '502979', '502987', '502995', '503002', '500020', '500046', '581623', '582697', '500071', '545589', '582387', '500101', '555886', '500135', '500160', '582425', '500194', '500232', '545635', '555959', '500313', '558320', '500356', '500372', '500381', '500399', '500402', '500411', '500453', '500470', '581097', '500488', '580899', '556785', '500534', '555908', '555851', '500569', '500577', '500011', '556696', '500631', '500640', '500666', '500674', '500682', '500691', '500704', '500712', '555991', '581691', '582719', '500780', '500798', '555967', '500844', '500518', '500887', '500895', '555860', '500917', '500933', '500941', '500950', '500992', '501018', '503029', '503037', '503045', '503053', '503061', '503070', '503088', '503096', '503100', '503118', '503126', '503134', '503151', '503169', '503177', '503185', '503193', '503207', '503215', '503223', '503231', '503240', '503258', '503266', '503274', '503282', '503291', '503312', '503321', '503339', '503347', '503355', '503363', '503371', '503398', '503401', '556092', '503436', '503011', '582361', '503452', '556033', '503479', '503487', '503495', '503509', '503517', '503525', '503533', '503541', '503550', '503568', '503576', '503584', '503592', '503606', '503614', '556050', '503631', '503380', '556025', '503649', '503711', '503720', '500241', '555878', '503886', '500739', '503932', '503991', '504025', '504068', '504092', '504165', '504190', '556220', '542661', '542695', '542709', '542717', '556297', '542792', '556262', '542881', '556351', '542938', '542954', '542971', '556165', '556157', '543039', '543063', '543071', '543101', '543110', '556149', '581704', '505021', '505048', '505064', '505137', '581305', '505226', '505234', '505242', '505251', '505285', '556211', '505340', '505374', '581658', '505404', '505421', '505439', '505498', '556327', '505510', '556238', '505536', '505561', '504998', '580457', '505617', '505641', '505676', '505714', '505749', '505757', '505773', '500062', '500127', '555916', '500151', '500283', '500305', '500321', '500364', '500429', '500437', '500461', '500500', '555924', '500542', '500551', '500585', '500593', '500607', '500658', '500721', '500747', '500755', '517305', '500810', '500828', '500836', '555932', '500909', '500925', '500968', '500976', '500984', '582816') AND `Inzerat`.`demo` = 0 ORDER BY RAND(781769884) ASC LIMIT 40, 10

124

125

126

127

128

SELECT `Charakteristika`.`id`, `Charakteristika`.`idinzerat`, `Charakteristika`.`idchar`, `Charakteristika`.`hodnota`, `Charakteristika`.`vyber` FROM `realcms_charakteristiky` AS `Charakteristika` WHERE `Charakteristika`.`idinzerat` IN (1633, 2145, 1423, 1640, 2083, 1107, 2072, 1794, 1863, 937)

392

129

136

130

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 (1633, 2145, 1423, 1640, 2083, 1107, 2072, 1794, 1863, 937)

131

SELECT `StravaInzerat`.`idinzerat`, `StravaInzerat`.`idstravy`, `StravaInzerat`.`value` FROM `realcms_strava_inzeraty` AS `StravaInzerat` WHERE `StravaInzerat`.`value` = 1 AND `StravaInzerat`.`idinzerat` IN (1633, 2145, 1423, 1640, 2083, 1107, 2072, 1794, 1863, 937)

132

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 (1633, 2145, 1423, 1640, 2083, 1107, 2072, 1794, 1863, 937) ORDER BY `povina_cena` DESC

133

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 (1633, 2145, 1423, 1640, 2083, 1107, 2072, 1794, 1863, 937)

134

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

1047

135

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

993

136

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

1060

127

137

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

1045

112

138

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

1014

139

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

1090

125

140

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

1014

124

141

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

1034

142

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

1019

119

143

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

1143

115

144

SELECT `VzdialenostMesta`.`id`, `VzdialenostMesta`.`id_inzerat`, `VzdialenostMesta`.`mesto`, `VzdialenostMesta`.`vzdialenost`, `VzdialenostMesta`.`updated` FROM `realcms_inzerat_vzdialenosti_mesta` AS `VzdialenostMesta` WHERE `VzdialenostMesta`.`id_inzerat` IN (1633, 2145, 1423, 1640, 2083, 1107, 2072, 1794, 1863, 937)

350

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

Search

späť

Result of the searching

Top accomodations

PRÁZDNINOVÝ DOM ALEX /krytý bazén,fitnes,masáže.../ ,Jabloňovce- Levice

CITY HOTEL NITRA ***,Nitra

Penzión EMESE - Búč

Privát VODIČKA Štúrovo

Chata LIMBA Duchonka

Penzion KORZO Hlavná 19,Štúrovo - Nové Zámky

PENZION "HUBERT*"-SNACK BAR,Topoľčany

Ubytovanie na súkromí Karáseková Mária,Nitra

PENZION LIPA ,Tlmače- Levice

Privat TARR , Madachová 52 , Nána

Accomodations on map