Inzeráty pre Nitriansky kraj

Výsledky vyhľadávania

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

Top inzeráty

Château Appony ***...

Oponice
Ceny od: 65 EUR

viac

CITY HOTEL NITRA *...

Nitra
Ceny od: 20 EUR

viac

HOTEL PEKLO **** ,...

Komárno
Ceny od: 29 EUR

viac

Rybárska bašta u H...

Nitra
Ceny od: 16,50 EUR

viac

DREVENICA ALFA a P...

Podhájska
Ceny od: 9 EUR

viac

HOTEL ZARA **** ,T...

Topoľčany
Ceny od: 0 EUR

viac

Penzión HOFFER Nit...

Nitra
Ceny od: 16,50 EUR

viac

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

VILLA GRACIA Patince 461,Patince-Areál kúpaliska

Apartmány | Patince | Patince-Kúpalisko

Detail

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

Kapacita: 16

Úvod Ponúkame Vám možnosť ubytovania v rekreačnom areáli známeho termálneho kúpaliska Patince s rozlohou takmer 30ha. V areáli vyvierajúci termálny prameň priaznivo pôsobí na pohybové ústrojenstvo a jeho choroby a preto priťahuje širokú vrstvu obyvateľstva zo Slovenska i zahraničia. Vyhľadávaným miestom je aj pre rodinné dovolenky, pretože areál a jeho okolie ponúka široký výber aktívneho, pasívneho oddychu a ďalšie rekreačné, turistické i cyklistické možnosti. Interiér: Nadštandardné ubytovanie v novopostavených prízemných apartmánoch v Patinciach v areáli kúpaliska, cca 200m od wellness centra. Objekt je rozdelený na štyri samostatné apartmány..V každom apartmáne sú dve ...

EL PASO Štúrovo

Chaty | Chalupy | Štúrovo

Detail

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

Kapacita: 66

Chata El Paso sa nachádza v areáli kúpaliska. Každá izba(2,3,alebo 4 postelová) má nasledujúcu výbavu: samostatné sociálne zariadenie, wc, kompletne vybavenú kuchyňu s nerezovým riadom, chladnička, rýchlovarná kanvica, dvojplatnička, tv, samostatná terasa s letným posadením a parkovisko. Na kúpalisku Vadaš nájdete 7 vonkajších a 2 kryté bazény, medzi nimi masážny bazén, vonkajší sedací bazén s celoročnou prevádzkou a jedinečný bazén s umelým vlnobitím,ktorý je najväčší svojho druhu na Slovensku. Okolie ponúka možnosť návštevy kaštiela Belá (8 km), historického mesta Ostrihom (2 km) v Maďarskej republike. V blízkom okolí sú výborné podmienky rybolovu ( rieky Dunaj, Hron a Ipeľ), turistiky...

HOTEL GOLDEN EAGLE **** ,Levice

Hotely | Levice | Pohronie

Detail

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

Kapacita: 40

Úplne nový HOTEL GOLDEN EAGLE **** sa nachádza v historickom centre mesta Levice. Kompletne zrekonštruovaná historická budova je zapísaná v zozname chránených kultúrnych pamiatok. V pešej dostupnosti /5 min. chôdze/ sa nachádza pešia zóna centra mesta Levice. HOTEL GOLDEN EAGLE **** ponúka vysoký štandart ubytovania,stravovania a relaxu. UBYTOVANIE V 3 poschodovom hotely sa nachádza 25 hosťovských izieb. Z toho je: 10 jednoposteľových 13 dvojposteľových 2 apartmány Izby sú ukážkovou kombináciou špičkového designu,v ktorom sa spája krása farby s čistotou dreva a noblesou ušlachtilého kovu.

CHATA KAKTUS-Areál termálneho kúpaliska VADAŠ,Štúrovo

Chaty | Chalupy | Štúrovo | Podunajsko

Detail

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

Kapacita: 20

Chata Kaktus sa nachádza priamo v areáli termálného kúpaliska VADAŠ v novej časti WESTEND. Každá izba je pre 2,3alebo 4 osoby. Izby sú vybavené manželskou posteľou, rozkladacou pohovkou,TV, kompletne vybaveným kuchynským kútom - varič, varná kanvica, mikrovlnKa, chladnička, vlastným sociálnym zariadením so sprchovacím kútom, WC a samostatným umývadlom. Na príjemné posedenie na poschodí Vám poslúži malá terasa, kde sa nachádza stôl a stoličky.No a na prízemí je veľká spoločná terasa. Ubytovacie zariadenie má vlastnú velkú trampolínu pre deti, šmykľavku,a vždy výborných klientov ako ste i vy.V cene ubytovania je vstup na kúpalisko,parkovisko,postelné prádlo,upratovanie pred a po odchode tur...

Privát Laura Pozba

Privát | Pozba | Podunajská nížina

Detail

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

Kapacita: 12

Privát LAURA- poskytujeme celoročné ubytovanie v rod. dome v obci Pozba, ktorý sa nachádza 2 km. od Termálneho kúpaliska Podhájska. Dom je komplet vybavený a nadštandardne zariadený. Pri dome je kryté záhradné posedenie, gril, ohnisko na guláš, veľká záhrada so samostatným vchodom s možnosťou loptových hier, stanovania, kempovania, parkovanie vo dvore. Reštaurácia 450 m., autobus, vlak 150m., obchod 200 m. Rozloženie izieb 1x 2, 2x 4, 2x kúpeľňa, 1x kuchyňa. Naša obec sa nachádza na juho-západnom Slovensku v blízkosti miest Vráble, Šurany, Nové Zámky, Želiezovce a Levice. Územnosprávne patrí do Nitrianskeho samosprávneho kraja a okresu Nové Zámky. Do obce sa dá dostať o.i. cestný...

Apartmány Zuzana Trávnica

Apartmány | Trávnica | Podunajská nížina

Detail

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

Kapacita: 8

Kapacita: 8/[2]+[2]+[2]+[2] Popis: Ponúkame v Trávnici č. 176 /pri kostole/ novovybudované apartmánové 4 izby pre 2 osoby s WC a sprcha. K dispozícii je spoločná kuchyňa a jedáleň, posedenie na terase aj parkovanie áut v uzatvorenom dvore. Odvoz a dovoz na kúpalisko do Podhájskej zabezpečíme. Priamo v obci sú možné prechádzky a potulky k rybníkom, kde je možnosť zapožičania vodných bicyklov, k lipovej aleji prípadne po okolí /napr. Mariánska čeľaď – starobylý kláštor za Podhájskou/. V neďalekej Podhájskej sa nachádza termálne kúpalisko s dvomi plaveckými bazénmi, s dvomi bazénmi s termálnou vodou, toboganom, ihriskom na plážový volejbal, požičovňou bicyklov, poskytujúce tiež masáže,...

HOTEL ZARA **** ,Topoľčany

Hotely | Topoľčany | PONITRIE

Detail

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

Kapacita: 31

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

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

Chaty | Chalupy | Jabloňovce | Štiavnické vrchy

Detail

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

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

CHATY PRI KÚPALISKU SANTOVKA- Santovka,Levice

Chaty | Chalupy | Santovka | Pohronie

Detail

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

Kapacita: 20

4 Samostatné chaty v blizkosti kúpaliska Santovka.Oplotený pozemok,gril,krb,detské ihrisko,zeleň.Každá chta samostatné wc,kúpelňa kapacita cca 7ludí. Výlety: Brhlovce,Margita-Ilona,Dudince,Levice...

PENZION BAŽANTNICA a SOĽNÁ JASKYŇA - Starý Tekov ,Levice

Penzióny | Starý Tekov | Pohronie

Detail

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

Kapacita: 16

Štýlovo zariadený penzión sa nachádza v areáli našej bažantej farmy v Starom Tekove. Okrem dvoch hlavných spoločenských sál a poľovníckeho salónika sú súčasťou penziónu útulne zariadené izby, poskytujúce možnosť ubytovania (kapacita 16 osôb, kúpelne, soc.zariadenia). Polohou a zdravým prostredím je chata vhodná aj pre rodiny s deťmi, s možnosťou slnenia sa na terase, tanečných večerov, grilovania špecialít. Je vhodná aj pre ubytovanie pre pracovníkov na služobných cestách, študijné pobyty a pod. V prípade zájmu, prosím svoju návštevu ohláste dopredu telefonicky, faxom alebo mailom. Penzión sa využíva na organizovanie rôznych spoločenských akcií: - rodinné oslavy - ...

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

Polohy inzerátov na mape

(default) 144 queries took 541 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `realcms_inzerat`	37	37	5
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	3
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:12:50') 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	110
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	2
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	1
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	34
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 `Inzerat`.`cena` asc LIMIT 10	10	10	53
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 (1371, 1013, 1846, 1494, 1711, 1525, 2096, 1633, 1872, 1832)	7	7	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 (1371, 1013, 1846, 1494, 1711, 1525, 2096, 1633, 1872, 1832)	1	1	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 (1371, 1013, 1846, 1494, 1711, 1525, 2096, 1633, 1872, 1832)	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 (1371, 1013, 1846, 1494, 1711, 1525, 2096, 1633, 1872, 1832)	0	0	0
128	SELECT `Charakteristika`.`id`, `Charakteristika`.`idinzerat`, `Charakteristika`.`idchar`, `Charakteristika`.`hodnota`, `Charakteristika`.`vyber` FROM `realcms_charakteristiky` AS `Charakteristika` WHERE `Charakteristika`.`idinzerat` IN (1371, 1013, 1846, 1494, 1711, 1525, 2096, 1633, 1872, 1832)	422	422	25
129	SELECT `Obrazok`.`idobrazok`, `Obrazok`.`url`, `Obrazok`.`sort`, `Obrazok`.`inzerat_idinzerat` FROM `realcms_obrazok` AS `Obrazok` WHERE `Obrazok`.`inzerat_idinzerat` IN (1371, 1013, 1846, 1494, 1711, 1525, 2096, 1633, 1872, 1832) ORDER BY `Obrazok`.`sort` asc, `Obrazok`.`idobrazok` asc	155	155	13
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 (1371, 1013, 1846, 1494, 1711, 1525, 2096, 1633, 1872, 1832)	3	3	1
131	SELECT `StravaInzerat`.`idinzerat`, `StravaInzerat`.`idstravy`, `StravaInzerat`.`value` FROM `realcms_strava_inzeraty` AS `StravaInzerat` WHERE `StravaInzerat`.`value` = 1 AND `StravaInzerat`.`idinzerat` IN (1371, 1013, 1846, 1494, 1711, 1525, 2096, 1633, 1872, 1832)	17	17	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 (1371, 1013, 1846, 1494, 1711, 1525, 2096, 1633, 1872, 1832) ORDER BY `povina_cena` DESC	17	17	1
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 (1371, 1013, 1846, 1494, 1711, 1525, 2096, 1633, 1872, 1832)	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` = 1371 OR `Vzdialenost1`.`id_inzerat2` = 1371) ORDER BY `Vzdialenost1`.`vzdialenost` asc	1059	1059	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` = 1013 OR `Vzdialenost1`.`id_inzerat2` = 1013) ORDER BY `Vzdialenost1`.`vzdialenost` asc	1129	1129	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` = 1846 OR `Vzdialenost1`.`id_inzerat2` = 1846) ORDER BY `Vzdialenost1`.`vzdialenost` asc	1026	1026	1
137	SELECT `Vzdialenost1`.`id`, `Vzdialenost1`.`id_inzerat1`, `Vzdialenost1`.`id_inzerat2`, `Vzdialenost1`.`vzdialenost`, `Vzdialenost1`.`modified` FROM `realcms_inzerat_vzdialenosti` AS `Vzdialenost1` WHERE (`Vzdialenost1`.`id_inzerat1` = 1494 OR `Vzdialenost1`.`id_inzerat2` = 1494) ORDER BY `Vzdialenost1`.`vzdialenost` asc	1057	1057	1
138	SELECT `Vzdialenost1`.`id`, `Vzdialenost1`.`id_inzerat1`, `Vzdialenost1`.`id_inzerat2`, `Vzdialenost1`.`vzdialenost`, `Vzdialenost1`.`modified` FROM `realcms_inzerat_vzdialenosti` AS `Vzdialenost1` WHERE (`Vzdialenost1`.`id_inzerat1` = 1711 OR `Vzdialenost1`.`id_inzerat2` = 1711) ORDER BY `Vzdialenost1`.`vzdialenost` asc	1055	1055	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` = 1525 OR `Vzdialenost1`.`id_inzerat2` = 1525) ORDER BY `Vzdialenost1`.`vzdialenost` asc	1049	1049	1
140	SELECT `Vzdialenost1`.`id`, `Vzdialenost1`.`id_inzerat1`, `Vzdialenost1`.`id_inzerat2`, `Vzdialenost1`.`vzdialenost`, `Vzdialenost1`.`modified` FROM `realcms_inzerat_vzdialenosti` AS `Vzdialenost1` WHERE (`Vzdialenost1`.`id_inzerat1` = 2096 OR `Vzdialenost1`.`id_inzerat2` = 2096) ORDER BY `Vzdialenost1`.`vzdialenost` asc	1013	1013	1
141	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	112
142	SELECT `Vzdialenost1`.`id`, `Vzdialenost1`.`id_inzerat1`, `Vzdialenost1`.`id_inzerat2`, `Vzdialenost1`.`vzdialenost`, `Vzdialenost1`.`modified` FROM `realcms_inzerat_vzdialenosti` AS `Vzdialenost1` WHERE (`Vzdialenost1`.`id_inzerat1` = 1872 OR `Vzdialenost1`.`id_inzerat2` = 1872) ORDER BY `Vzdialenost1`.`vzdialenost` asc	1026	1026	1
143	SELECT `Vzdialenost1`.`id`, `Vzdialenost1`.`id_inzerat1`, `Vzdialenost1`.`id_inzerat2`, `Vzdialenost1`.`vzdialenost`, `Vzdialenost1`.`modified` FROM `realcms_inzerat_vzdialenosti` AS `Vzdialenost1` WHERE (`Vzdialenost1`.`id_inzerat1` = 1832 OR `Vzdialenost1`.`id_inzerat2` = 1832) ORDER BY `Vzdialenost1`.`vzdialenost` asc	1025	1025	116
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 (1371, 1013, 1846, 1494, 1711, 1525, 2096, 1633, 1872, 1832)	350	350	5

(default) 144 queries took 541 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:12:50') 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

110

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 `Inzerat`.`cena` asc LIMIT 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 (1371, 1013, 1846, 1494, 1711, 1525, 2096, 1633, 1872, 1832)

422

129

155

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 (1371, 1013, 1846, 1494, 1711, 1525, 2096, 1633, 1872, 1832)

131

SELECT `StravaInzerat`.`idinzerat`, `StravaInzerat`.`idstravy`, `StravaInzerat`.`value` FROM `realcms_strava_inzeraty` AS `StravaInzerat` WHERE `StravaInzerat`.`value` = 1 AND `StravaInzerat`.`idinzerat` IN (1371, 1013, 1846, 1494, 1711, 1525, 2096, 1633, 1872, 1832)

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 (1371, 1013, 1846, 1494, 1711, 1525, 2096, 1633, 1872, 1832) 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 (1371, 1013, 1846, 1494, 1711, 1525, 2096, 1633, 1872, 1832)

134

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

1059

135

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

1129

136

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

1026

137

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

1057

138

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

1055

139

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

1049

140

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

1013

141

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

112

142

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

1026

143

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

1025

116

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 (1371, 1013, 1846, 1494, 1711, 1525, 2096, 1633, 1872, 1832)

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

späť

Výsledky vyhľadávania

Top inzeráty

VILLA GRACIA Patince 461,Patince-Areál kúpaliska

EL PASO Štúrovo

HOTEL GOLDEN EAGLE **** ,Levice

CHATA KAKTUS-Areál termálneho kúpaliska VADAŠ,Štúrovo

Privát Laura Pozba

Apartmány Zuzana Trávnica

HOTEL ZARA **** ,Topoľčany

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

CHATY PRI KÚPALISKU SANTOVKA- Santovka,Levice

PENZION BAŽANTNICA a SOĽNÁ JASKYŇA - Starý Tekov ,Levice

Polohy inzerátov na mape