Počet prístupov: 5 003 765

Výsledky vyhľadávania

Top inzeráty

baner
Vrbov
Ceny od: 8 EUR
baner
Hozelec
Ceny od: 12 EUR
baner
Liptovská Teplička
Ceny od: 11 EUR
baner
Demänovská Dolina
Ceny od: 10 EUR
baner
Kežmarok
Ceny od: 18 EUR
baner
Poprad
Ceny od: 16 EUR
Promo baner
Promo baner
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 Ďalej »

CHALUPA YVONA, Vernár- Nízke Tatry

Chaty | Chalupy | Vernár | Nízke Tatry
Cena (osoba/noc): 8 EUR (241,01 Sk)
Kapacita: 0

 Chalupa Yvona Chalupa Yvona Chalupa YVONA sa nachádza na okraji rázovitej obce Vernár ležiacej 20 km od Popradu v Národnom parku Slovenský raj. Ak chcete zažiť krásu prírody, horský vzduch, štebot vtáčikov v objatí smrekov a tečúceho vernárskeho potoka, tak skúste nás nájsť. Blízke okolie je stvorené na vychádzky lesom, výlety, cykloturistiku a v zime lyžovanie v blízkom lyžiarskom stredisku. Výlety môžte podniknúť do Vysokých a Nízkych Tatier a Slovenského raja. Okrem turistického a cyklistického vyžitia je možnosť navštíviť aj kultúrne, historické pamiatky a jaskyne/ Levoča, Kežmarok, Červený Kláštor, Betliar, Krásna Hôrka, Spišský hrad , Dobšinská ľadová jaskyňa a Belianská ...

Autokepming Chminianska Nová Ves

Kempy | Chminianska Nová Ves
Cena (osoba/noc): 10 EUR (301,26 Sk)
Kapacita: 0

Ponúkame ubytovanie v chatkách, stanoch, karavanoch so spoločným sociálnym zariadením, sprchami a kuchynkou./foto, ceny dodám/. Autokemping je ideálnym miestom na stanovanie pre všetkých turistov, cykloturistov a karavanistov. Vítané sú aj školské výlety a školy v prírode. Tí, ktorí sa chcú ubytovať pohodlnejšie, môžu využiť chatky, ktoré sa nachádzajú hneď vedľa našej reštaurácie. Pre najmenších je pripravené detské ihrisko. Okolie Autokempingu je vynikajúcim miestom na odpočinok aj dokonalý relax. Jeho výborná poloha uľahčuje návštevníkom prístup k mnohým turistickým zaujímavostiam a lákadlám. Cenník ubytovania

Chata pod Belianskými Tatrami, Ždiar

Chaty | Chalupy | Ždiar | Vysoké Tatry
Cena (osoba/noc): 11 EUR (331,39 Sk)
Kapacita: 4

Chata pod Belianskymi Tatrami Užite si dovolenku v krásnom, tichom prostredí Belianskych Tatier. Pozorujte z útulnej dreveničky nočnú oblohu a v teplučku pri horiacom kozube prežite príjemný večer. Strávte zopár dní v rozprávkovej krajine v štýlovom drevenom zrube s vlastným komfortom. Na 50 m2 obytnej plochy (prízemie+podkrovie) nájdete všetko čo k dovolenke potrebujete- príjemné posedenie, plne vybavenú kuchyňu ( riad, chladnička, sklokeramicka varná doska, rýchlovarná konvica..), sprchovací kút a WC a na poschodí útulná spálňa a balkón s výhľadom na Belianske Tatry s ich velikánmi Ždiarskou Vidlou 2142 m.n.m. a Havranom 2152 m.n.m. Kapacita 4 osoby Ak by ste dost...

SPIŠSKÝ SALÁŠ, Levočská cesta 11, Spišské Podhradie

Motely | Spišské Podhradie | Slovenský Raj
Cena (osoba/noc): 17 EUR (512,14 Sk)
Kapacita: 4

Už niekoľko desaťročí šíri Spišský salaš tradíciu domácich spišských jedál, ako sú bryndzové halušky, bryndzové pirohy, domáca zabíjačka. Hostia s obľubou ochutnávajú tradičné pálenky či už gazdovskú slivovicu (52%) alebo Spišskú borovičku. Hlavnú reštauračnú budovu (72 miest) dopĺňa Furmanská (30 miest) a Bačovská izba (10 miest) pre spoločenské, firemné i rodinné príležitosti. Atraktívne okolie salaša umožňuje príjemné posedenie aj v letnom bufete a na haluškovej terase. Atmosféru dopĺňajú expozícia pôvodného poľnohospodárskeho náradia, detské hojdačky, kolotoč a príležitostne aj jazda na koňoch. Priamo v areáli saláša je možnosť campovania, či už karavánom, alebo v stane. Klienti si mô...

Chata pod Strážou

Chaty | Chalupy | Veľký Šariš | Šariš
Cena (osoba/noc): 15 EUR (451,89 Sk)
Kapacita: 5

V okolí sa nachádzajú potraviny, či už v Kanaši, asi 1 km alebo vo Veľkom Šariši približne 2 km.Keby ste chceli ísť na dobrú, slovenskú večeru alebo obed môžete navštíviť salaš Šariš park, ktorý je neďaleko od odbočky do Kanaša a od chaty vzdialený asi 1 km.Chata sa nachádza v peknom prostredí s čistým vzduchom.Z chaty je pekný výhľad na okolitú prírodu.V Kanaši sa nachádza tenisový kurt a detské ihrisko so šmýkalkou, ktoré sú určené iba pre deti a deti s rodičmi.Je tu aj možnosť turistiky.Cez voľný čas môžete vystúpiť na horu Stráž po vyznačenom turistickom chodníku.MHD zastávka je vzdialená asi 80 m a do Kanaša je možné dostať sa autobusom č. 14. V zimnom období, t.j. od 1.10. – 1.5. ...

Vila Marco, ubytovanie v súkromí*, Hozelec-Vysoké Tatry

Privát | Hozelec | Vysoké Tatry
Cena (osoba/noc): 12 EUR (361,51 Sk)
Kapacita: 6

Radi Vás privítame vo Vila Marco v obci Hozelec, 4 km od Popradu. Ubytovanie je vhodné pre rodinu s deťmi, pracujúcich, skupiny i jednotlivcov, k dispozícii 1 izba dvojlôžková + prístelok so samostatnou kúpeľňou, 1 izba dvojlôžková + prístelok. Maximálne 6 osôb, minimálne 1.Parkovanie vo dvore.Obchod:20 m, reštaurácia Koliba pri rieke v Poprade, 4,5 km-www.restika.szm.com . Výhodou je dobrá poloha a dostupnosť Vašich záľub pre oddych, relax a turistiku ( Vysoké Tatry, Slovenský raj, AQUACITY Poprad, termálne kúpaliská Vrbov, kultúrne pamiatky, Spišský Hrad, Kežmarok, Stará Ľubovňa ..) Tešíme sa na Vašu návštevu :-)

Apartmány Lomnica, Veľká Lomnica, Vysoké Tatry

Apartmány | Veľká Lomnica | Vysoké Tatry
Cena (osoba/noc): 9 EUR (271,13 Sk)
Kapacita: 6

Ponúkame ubytovanie v luxusnom apartmane vo Veľkej Lomnici. len 30min peso od golfového areálu Black stork. V apartmáne je vstupná chodba, šatník- úložný priestor, kúpeľňa s WC, spálňa, obývacia izba spojená s kuchyňou. Kúrenie je geotermálnou energiou. Z apartmánu je možné ísť do vyhliadkovej vežičky /18m/ s možnosťou posedenia. Poznámka k cene: K celkovej sume si účtuje majiteľ jednorazový poplatok za záverečné upratanie a posteľnú bielizeň 18 €

Domček u Vincka, Ždiar

Chaty | Chalupy | Ždiar | Belianské Tatry
Cena (osoba/noc): 10 EUR (301,26 Sk)
Kapacita: 7

Novovybudovaný štýlový goralský domček je celý postavený zo zrubového smrekového dreva. Drevený interiér dodáva domčeku nenahraditeľný pocit a pohodu s jedinečnou atmosférou. Nachádza sa v rázovitej goralskej obci Ždiar medzi Belianskými Tatrami a Spišskou Magurou. Domček má výbornú polohu, pretože je postavený na začiatku Blaščáckej doliny, priamo pod Antošovským vrchom v nádhernom a tichom prostredí, ktoré je stvorené na relax a oddych.

Chalupa u Stana, Žakovce

Chaty | Chalupy | Žakovce | Vysoké Tatry, Slovenský Raj
Cena (osoba/noc): 8 EUR (241,01 Sk)
Kapacita: 7

Chalupa u Stana, leží na okraji obce Žakovce, čo Vám zaručuje kľud a pohodu. Vychutnať si tu môžte príjemné záhradné posedenie pri ohnisku, alebo príjmne stráviť dni na známom Thermal park - Vrbov. Chalupa sa prenajíma ako celok za cenu 50,-€, pri viac ako 6 osob je to 60,-€/noc

Drevenica Valika, Jezersko, Pieniny

Drevenice | Jezersko | Zamagurie
Cena (osoba/noc): 10 EUR (301,26 Sk)
Kapacita: 8

Štýlova zariadená novopostavená drevenička s modro-červenými oknami Vám ponúka zaručený oddych a kľúd v prekrásnej zamagurskej prírode. Zimu môžte stráviť na lyžiarských svahoch a leto si zase môžte vychutnať krásnou prírodou.



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

Polohy inzerátov na mape

facebooktwitter
(default) 138 queries took 570 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `realcms_inzerat`37373
2DESCRIBE `realcms_obce`441
3DESCRIBE `realcms_okresy`441
4DESCRIBE `realcms_kraje`331
5DESCRIBE `realcms_zakaznik`43434
6DESCRIBE `realcms_druhy`441
7DESCRIBE `realcms_platnost_inzeratu`661
8DESCRIBE `realcms_restaurant_opening_hours`771
9DESCRIBE `realcms_restaurant_details`551
10DESCRIBE `realcms_restaurant_menus`12122
11DESCRIBE `realcms_restaurant_payments`331
12DESCRIBE `realcms_restaurant_payment_types`331
13DESCRIBE `realcms_charakteristiky`551
14DESCRIBE `realcms_char`551
15DESCRIBE `realcms_char_kategorie`221
16DESCRIBE `realcms_obrazok`771
17DESCRIBE `realcms_komentare`771
18DESCRIBE `realcms_strava_inzeraty`331
19DESCRIBE `realcms_stravovanie`331
20DESCRIBE `realcms_ceny`771
21DESCRIBE `realcms_meny`441
22DESCRIBE `realcms_ceny_nazvy`331
23DESCRIBE `realcms_zlavy`661
24DESCRIBE `realcms_zlavy_nazvy`331
25DESCRIBE `realcms_inzerat_vzdialenosti`551
26DESCRIBE `realcms_inzerat_vzdialenosti_mesta`551
27DESCRIBE `realcms_mesta`551
28DESCRIBE `realcms_lokality`331
29DESCRIBE `realcms_lokality_obce`221
30DESCRIBE `realcms_banery_lokality`331
31DESCRIBE `realcms_sutaz`441
32DESCRIBE `realcms_sutaz_udaje`11112
33DESCRIBE `realcms_druhy_zariadeni`441
34DESCRIBE `realcms_inzerat_vzdialenosti_zariadenia`551
35DESCRIBE `realcms_zariadenia`23233
36DESCRIBE `realcms_obrazok_zariadenia`551
37DESCRIBE `realcms_charakteristiky_zariadenia`441
38DESCRIBE `realcms_char_zariadenia`441
39DESCRIBE `realcms_banery`331
40DESCRIBE `realcms_banery_hlavna_stranka`221
41DESCRIBE `realcms_jazyky`331
42DESCRIBE `realcms_wysiwyg`661
43DESCRIBE `realcms_web_pristupy`441
44SELECT `Jazyk`.`id`, `Jazyk`.`jazyk`, `Jazyk`.`jazyk_slovom` FROM `realcms_jazyky` AS `Jazyk` WHERE `Jazyk`.`jazyk` = 'svk' LIMIT 1110
45SELECT `Texty`.`nadpis`, `Texty`.`name` FROM `realcms_wysiwyg` AS `Texty` WHERE `Texty`.`jazyk_id` = 1 770
46INSERT DELAYED INTO `realcms_web_pristupy` (`ip_adresa`, `created`) VALUES ('38.107.179.210', '2012-02-12 19:46:07') ON DUPLICATE KEY UPDATE pocet_pristupov=pocet_pristupov+120
47SELECT SUM(pocet_pristupov) AS pocet FROM `realcms_web_pristupy` AS `Pristup` WHERE 1 = 1 LIMIT 111109
48SELECT `Druh`.`iddruh`, `Druh`.`druh`, `Druh`.`zobrazeni`, `Druh`.`cena` FROM `realcms_druhy` AS `Druh` WHERE 1 = 1 12120
49SELECT `Stravovanie`.`id`, `Stravovanie`.`nazov_stravovania`, `Stravovanie`.`order` FROM `realcms_stravovanie` AS `Stravovanie` WHERE 1 = 1 440
50SELECT `Kraj`.`idkraj`, `Kraj`.`nazov`, `Kraj`.`idstat` FROM `realcms_kraje` AS `Kraj` WHERE `Kraj`.`idstat` = 'SK' 880
51SELECT `Mesto`.`id`, `Mesto`.`nazov`, `Mesto`.`nazov_seo`, `Mesto`.`latitude`, `Mesto`.`longitude` FROM `realcms_mesta` AS `Mesto` WHERE 1 = 1 ORDER BY `Mesto`.`nazov` asc 35350
52SELECT `ZariadenieDruh`.`id`, `ZariadenieDruh`.`zariadenie`, `ZariadenieDruh`.`alias`, `ZariadenieDruh`.`parent` FROM `realcms_druhy_zariadeni` AS `ZariadenieDruh` WHERE `ZariadenieDruh`.`parent` = 0 ORDER BY `ZariadenieDruh`.`zariadenie` ASC 16160
53SELECT `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) 12120
54SELECT `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 3330
55SELECT `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 110
56SELECT `Obec`.`idobec`, `Obec`.`nazov_obce`, `Obec`.`idokres`, `Obec`.`psc` FROM `realcms_obce` AS `Obec` WHERE `Obec`.`idobec` = 524077 110
57SELECT `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) 000
58SELECT `RestaurantDetail`.`id`, `RestaurantDetail`.`ad_id`, `RestaurantDetail`.`contact`, `RestaurantDetail`.`created`, `RestaurantDetail`.`modified` FROM `realcms_restaurant_details` AS `RestaurantDetail` WHERE `RestaurantDetail`.`ad_id` = (1888) 000
59SELECT `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) 000
60SELECT `RestaurantPayment`.`id`, `RestaurantPayment`.`ad_id`, `RestaurantPayment`.`payment_type_id` FROM `realcms_restaurant_payments` AS `RestaurantPayment` WHERE `RestaurantPayment`.`ad_id` = (1888) 000
61SELECT `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 110
62SELECT `Obec`.`idobec`, `Obec`.`nazov_obce`, `Obec`.`idokres`, `Obec`.`psc` FROM `realcms_obce` AS `Obec` WHERE `Obec`.`idobec` = 505285 110
63SELECT `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) 000
64SELECT `RestaurantDetail`.`id`, `RestaurantDetail`.`ad_id`, `RestaurantDetail`.`contact`, `RestaurantDetail`.`created`, `RestaurantDetail`.`modified` FROM `realcms_restaurant_details` AS `RestaurantDetail` WHERE `RestaurantDetail`.`ad_id` = (2292) 000
65SELECT `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) 000
66SELECT `RestaurantPayment`.`id`, `RestaurantPayment`.`ad_id`, `RestaurantPayment`.`payment_type_id` FROM `realcms_restaurant_payments` AS `RestaurantPayment` WHERE `RestaurantPayment`.`ad_id` = (2292) 000
67SELECT `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 110
68SELECT `Obec`.`idobec`, `Obec`.`nazov_obce`, `Obec`.`idokres`, `Obec`.`psc` FROM `realcms_obce` AS `Obec` WHERE `Obec`.`idobec` = 510998 110
69SELECT `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) 000
70SELECT `RestaurantDetail`.`id`, `RestaurantDetail`.`ad_id`, `RestaurantDetail`.`contact`, `RestaurantDetail`.`created`, `RestaurantDetail`.`modified` FROM `realcms_restaurant_details` AS `RestaurantDetail` WHERE `RestaurantDetail`.`ad_id` = (1936) 000
71SELECT `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) 000
72SELECT `RestaurantPayment`.`id`, `RestaurantPayment`.`ad_id`, `RestaurantPayment`.`payment_type_id` FROM `realcms_restaurant_payments` AS `RestaurantPayment` WHERE `RestaurantPayment`.`ad_id` = (1936) 000
73SELECT `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 64640
74SELECT `Kraj`.`idkraj`, `Kraj`.`nazov`, `Kraj`.`idstat` FROM `realcms_kraje` AS `Kraj` WHERE lower(`Kraj`.`nazov`) = 'prešovský' LIMIT 1110
75SELECT `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` = 7 ORDER BY `Baner`.`pozicia` ASC LIMIT 8661
76SELECT `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 110
77SELECT `Obec`.`idobec`, `Obec`.`nazov_obce`, `Obec`.`idokres`, `Obec`.`psc` FROM `realcms_obce` AS `Obec` WHERE `Obec`.`idobec` = 524077 110
78SELECT `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) 000
79SELECT `RestaurantDetail`.`id`, `RestaurantDetail`.`ad_id`, `RestaurantDetail`.`contact`, `RestaurantDetail`.`created`, `RestaurantDetail`.`modified` FROM `realcms_restaurant_details` AS `RestaurantDetail` WHERE `RestaurantDetail`.`ad_id` = (1888) 000
80SELECT `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) 000
81SELECT `RestaurantPayment`.`id`, `RestaurantPayment`.`ad_id`, `RestaurantPayment`.`payment_type_id` FROM `realcms_restaurant_payments` AS `RestaurantPayment` WHERE `RestaurantPayment`.`ad_id` = (1888) 000
82SELECT `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` = 1170 110
83SELECT `Obec`.`idobec`, `Obec`.`nazov_obce`, `Obec`.`idokres`, `Obec`.`psc` FROM `realcms_obce` AS `Obec` WHERE `Obec`.`idobec` = 523496 110
84SELECT `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` = (1170) 000
85SELECT `RestaurantDetail`.`id`, `RestaurantDetail`.`ad_id`, `RestaurantDetail`.`contact`, `RestaurantDetail`.`created`, `RestaurantDetail`.`modified` FROM `realcms_restaurant_details` AS `RestaurantDetail` WHERE `RestaurantDetail`.`ad_id` = (1170) 000
86SELECT `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` = (1170) 000
87SELECT `RestaurantPayment`.`id`, `RestaurantPayment`.`ad_id`, `RestaurantPayment`.`payment_type_id` FROM `realcms_restaurant_payments` AS `RestaurantPayment` WHERE `RestaurantPayment`.`ad_id` = (1170) 000
88SELECT `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` = 1047 110
89SELECT `Obec`.`idobec`, `Obec`.`nazov_obce`, `Obec`.`idokres`, `Obec`.`psc` FROM `realcms_obce` AS `Obec` WHERE `Obec`.`idobec` = 523631 110
90SELECT `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` = (1047) 000
91SELECT `RestaurantDetail`.`id`, `RestaurantDetail`.`ad_id`, `RestaurantDetail`.`contact`, `RestaurantDetail`.`created`, `RestaurantDetail`.`modified` FROM `realcms_restaurant_details` AS `RestaurantDetail` WHERE `RestaurantDetail`.`ad_id` = (1047) 000
92SELECT `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` = (1047) 000
93SELECT `RestaurantPayment`.`id`, `RestaurantPayment`.`ad_id`, `RestaurantPayment`.`payment_type_id` FROM `realcms_restaurant_payments` AS `RestaurantPayment` WHERE `RestaurantPayment`.`ad_id` = (1047) 000
94SELECT `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` = 1270 110
95SELECT `Obec`.`idobec`, `Obec`.`nazov_obce`, `Obec`.`idokres`, `Obec`.`psc` FROM `realcms_obce` AS `Obec` WHERE `Obec`.`idobec` = 510386 110
96SELECT `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` = (1270) 000
97SELECT `RestaurantDetail`.`id`, `RestaurantDetail`.`ad_id`, `RestaurantDetail`.`contact`, `RestaurantDetail`.`created`, `RestaurantDetail`.`modified` FROM `realcms_restaurant_details` AS `RestaurantDetail` WHERE `RestaurantDetail`.`ad_id` = (1270) 000
98SELECT `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` = (1270) 000
99SELECT `RestaurantPayment`.`id`, `RestaurantPayment`.`ad_id`, `RestaurantPayment`.`payment_type_id` FROM `realcms_restaurant_payments` AS `RestaurantPayment` WHERE `RestaurantPayment`.`ad_id` = (1270) 000
100SELECT `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` = 909 110
101SELECT `Obec`.`idobec`, `Obec`.`nazov_obce`, `Obec`.`idokres`, `Obec`.`psc` FROM `realcms_obce` AS `Obec` WHERE `Obec`.`idobec` = 523585 110
102SELECT `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` = (909) 000
103SELECT `RestaurantDetail`.`id`, `RestaurantDetail`.`ad_id`, `RestaurantDetail`.`contact`, `RestaurantDetail`.`created`, `RestaurantDetail`.`modified` FROM `realcms_restaurant_details` AS `RestaurantDetail` WHERE `RestaurantDetail`.`ad_id` = (909) 000
104SELECT `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` = (909) 000
105SELECT `RestaurantPayment`.`id`, `RestaurantPayment`.`ad_id`, `RestaurantPayment`.`payment_type_id` FROM `realcms_restaurant_payments` AS `RestaurantPayment` WHERE `RestaurantPayment`.`ad_id` = (909) 000
106SELECT `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` = 904 110
107SELECT `Obec`.`idobec`, `Obec`.`nazov_obce`, `Obec`.`idokres`, `Obec`.`psc` FROM `realcms_obce` AS `Obec` WHERE `Obec`.`idobec` = 523381 110
108SELECT `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` = (904) 000
109SELECT `RestaurantDetail`.`id`, `RestaurantDetail`.`ad_id`, `RestaurantDetail`.`contact`, `RestaurantDetail`.`created`, `RestaurantDetail`.`modified` FROM `realcms_restaurant_details` AS `RestaurantDetail` WHERE `RestaurantDetail`.`ad_id` = (904) 000
110SELECT `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` = (904) 000
111SELECT `RestaurantPayment`.`id`, `RestaurantPayment`.`ad_id`, `RestaurantPayment`.`payment_type_id` FROM `realcms_restaurant_payments` AS `RestaurantPayment` WHERE `RestaurantPayment`.`ad_id` = (904) 000
112SELECT `Obrazok`.`idobrazok`, `Obrazok`.`url`, `Obrazok`.`sort`, `Obrazok`.`inzerat_idinzerat` FROM `realcms_obrazok` AS `Obrazok` WHERE `Obrazok`.`inzerat_idinzerat` IN (1888, 1170, 1047, 1270, 909, 904) ORDER BY `Obrazok`.`sort` asc 949413
113SELECT `Kraj`.`idkraj`, `Kraj`.`nazov`, `Kraj`.`idstat` FROM `realcms_kraje` AS `Kraj` WHERE `Kraj`.`idstat` = 'SK' 880
114SELECT `Okres`.`idokres` FROM `realcms_okresy` AS `Okres` LEFT JOIN `realcms_kraje` AS `Kraj` ON (`Okres`.`idkraj` = `Kraj`.`idkraj`) WHERE `Okres`.`idkraj` = '7' 13131
115SELECT `Obec`.`idobec`, `Obec`.`nazov_obce`, `Obec`.`idokres`, `Obec`.`psc` FROM `realcms_obce` AS `Obec` WHERE `Obec`.`idokres` IN ('701', '702', '703', '704', '705', '706', '707', '708', '709', '710', '711', '712', '713') ORDER BY `Obec`.`nazov_obce` ASC 66766793
116SELECT 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 ('519014', '519022', '519006', '519007', '519049', '519057', '519065', '519073', '519081', '519090', '519103', '519111', '519138', '519154', '519162', '519171', '519189', '519201', '519219', '519227', '519235', '519243', '519251', '519260', '519278', '519286', '519294', '519308', '519324', '519341', '519359', '519367', '519375', '519383', '519405', '519413', '519421', '519430', '519456', '519464', '519472', '519481', '519499', '519502', '519511', '519529', '519545', '519553', '519570', '519588', '519600', '519618', '519626', '519634', '519642', '519669', '519677', '519685', '519693', '519707', '519715', '519723', '519731', '519936', '519740', '519758', '519766', '519774', '519782', '519791', '519804', '519812', '519821', '519839', '519847', '519855', '519863', '519871', '519880', '518964', '519901', '519910', '519928', '519944', '519952', '519961', '519979', '520012', '520021', '520055', '520063', '520110', '520152', '559644', '520195', '559598', '520225', '520233', '520241', '520004', '520268', '520276', '520292', '559547', '520331', '520349', '520357', '520373', '528803', '520403', '582140', '520446', '520454', '520462', '559652', '520497', '520501', '520527', '520535', '528897', '520543', '520560', '528951', '520624', '520667', '529010', '520683', '529061', '520250', '520721', '529087', '529095', '520772', '520781', '559636', '520896', '520900', '520926', '518638', '520977', '520985', '521019', '529249', '521027', '521035', '529273', '521043', '521086', '521116', '523399', '523411', '523429', '523461', '523470', '523500', '523526', '523534', '523551', '523569', '523577', '523585', '523607', '523615', '523623', '523682', '523674', '559938', '581241', '523712', '523739', '523771', '523780', '523798', '523801', '523810', '523828', '523836', '523861', '523887', '523909', '523976', '523984', '523992', '524000', '524042', '524051', '524069', '524077', '524085', '524115', '524123', '526371', '526380', '526401', '526410', '526428', '526452', '526461', '526479', '526487', '526495', '526517', '526525', '543179', '543225', '581640', '543276', '543292', '543314', '543381', '543390', '543420', '543446', '543454', '543462', '543471', '543578', '543608', '543624', '543641', '543675', '543691', '526606', '526614', '520071', '520098', '520101', '520128', '520187', '520314', '520411', '520471', '520519', '520578', '520586', '520616', '520691', '520705', '559610', '520713', '520853', '520861', '520951', '520993', '521001', '521060', '521078', '523402', '523437', '523445', '523496', '523488', '523518', '523542', '523593', '523631', '523658', '523721', '523747', '523763', '523381', '523844', '523852', '523879', '523925', '559890', '523933', '524107', '523950', '580368', '524018', '524026', '524034', '524093', '560103', '524131', '524158', '524174', '524191', '524212', '524221', '524255', '524263', '524271', '524301', '524336', '524352', '524361', '524387', '524395', '524409', '524417', '524425', '524433', '518522', '524450', '524468', '524476', '524506', '524514', '524549', '524522', '524531', '524581', '524590', '524620', '524638', '524646', '524654', '524662', '524697', '524701', '524727', '524735', '524743', '524751', '524760', '559971', '524786', '518590', '524794', '524808', '524832', '524841', '556823', '524867', '524883', '524905', '524913', '524930', '524964', '524999', '525014', '525022', '525031', '524140', '525057', '525065', '525073', '525111', '525138', '525154', '525162', '559989', '525171', '525189', '525197', '525201', '525251', '525260', '525278', '525286', '525294', '525324', '525332', '525341', '525383', '525391', '525405', '525413', '525430', '525448', '525456', '525472', '525499', '525502', '525511', '524182', '524204', '524239', '524247', '524280', '524298', '524310', '524328', '524344', '524379', '524441', '524492', '524557', '524565', '524573', '524603', '524611', '524671', '524689', '524778', '524816', '524824', '524875', '524921', '524948', '524956', '524981', '525006', '525049', '525081', '525090', '525103', '525120', '525146', '525219', '525235', '525243', '525308', '525316', '525359', '525367', '525375', '525421', '520039', '520080', '520136', '520161', '520179', '520209', '520217', '520284', '520322', '520365', '520381', '520390', '520438', '520489', '520551', '520594', '520632', '520641', '520659', '520675', '520730', '520748', '520764', '520802', '520829', '520811', '520845', '520870', '520888', '520918', '520934', '520942', '521051', '521108', '526673', '526681', '526690', '526703', '526711', '526720', '526738', '526746', '526754', '526762', '526771', '526789', '526797', '526801', '526819', '526827', '526835', '526843', '526851', '526860', '526878', '526886', '526894', '526908', '526916', '526924', '526932', '526941', '526959', '526967', '526975', '526983', '526991', '526665', '527009', '527017', '527025', '527033', '527041', '527050', '527068', '527076', '527084', '527092', '527114', '527157', '527165', '527173', '527181', '527190', '527203', '527262', '527289', '527297', '527335', '527343', '527386', '527408', '527416', '527467', '527793', '527475', '527513', '527521', '527530', '527572', '527581', '527611', '527637', '527700', '527726', '527718', '527815', '527823', '527840', '527866', '527912', '527921', '527939', '527971', '527980', '527998', '528005', '528013', '528021', '528048', '560073', '527122', '527131', '527149', '527211', '527220', '527238', '527246', '527254', '580601', '527271', '519197', '527301', '527319', '527327', '527351', '519316', '527360', '527378', '519332', '527394', '519391', '527424', '527432', '527441', '527459', '527483', '519448', '527491', '527505', '519537', '519561', '527548', '527556', '527564', '519596', '527599', '527602', '527629', '527645', '527653', '527661', '527670', '527688', '527696', '527734', '527742', '527751', '527769', '527777', '527785', '527807', '527831', '527858', '527106', '527874', '527882', '527891', '527904', '527947', '527955', '527963', '528030', '528056', '528064', '528072', '528081', '519987', '519995', '544060', '544078', '544086', '544094', '544108', '544116', '544124', '544132', '544141', '544159', '544167', '544175', '544183', '544191', '544205', '544213', '581674', '544221', '544230', '528731', '528749', '528757', '528765', '528773', '528781', '528790', '528811', '528820', '528838', '528846', '528854', '528862', '528871', '528889', '528901', '528919', '528927', '528935', '528943', '528960', '528978', '528986', '528994', '529001', '529028', '529036', '529044', '529052', '529079', '529109', '529125', '529133', '529141', '529150', '529168', '529176', '529184', '529192', '529206', '529214', '529222', '529231', '544051', '529117', '529257', '529265', '529281', '529290') AND `Inzerat`.`demo` = 0 1143
117SELECT `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 ('519014', '519022', '519006', '519007', '519049', '519057', '519065', '519073', '519081', '519090', '519103', '519111', '519138', '519154', '519162', '519171', '519189', '519201', '519219', '519227', '519235', '519243', '519251', '519260', '519278', '519286', '519294', '519308', '519324', '519341', '519359', '519367', '519375', '519383', '519405', '519413', '519421', '519430', '519456', '519464', '519472', '519481', '519499', '519502', '519511', '519529', '519545', '519553', '519570', '519588', '519600', '519618', '519626', '519634', '519642', '519669', '519677', '519685', '519693', '519707', '519715', '519723', '519731', '519936', '519740', '519758', '519766', '519774', '519782', '519791', '519804', '519812', '519821', '519839', '519847', '519855', '519863', '519871', '519880', '518964', '519901', '519910', '519928', '519944', '519952', '519961', '519979', '520012', '520021', '520055', '520063', '520110', '520152', '559644', '520195', '559598', '520225', '520233', '520241', '520004', '520268', '520276', '520292', '559547', '520331', '520349', '520357', '520373', '528803', '520403', '582140', '520446', '520454', '520462', '559652', '520497', '520501', '520527', '520535', '528897', '520543', '520560', '528951', '520624', '520667', '529010', '520683', '529061', '520250', '520721', '529087', '529095', '520772', '520781', '559636', '520896', '520900', '520926', '518638', '520977', '520985', '521019', '529249', '521027', '521035', '529273', '521043', '521086', '521116', '523399', '523411', '523429', '523461', '523470', '523500', '523526', '523534', '523551', '523569', '523577', '523585', '523607', '523615', '523623', '523682', '523674', '559938', '581241', '523712', '523739', '523771', '523780', '523798', '523801', '523810', '523828', '523836', '523861', '523887', '523909', '523976', '523984', '523992', '524000', '524042', '524051', '524069', '524077', '524085', '524115', '524123', '526371', '526380', '526401', '526410', '526428', '526452', '526461', '526479', '526487', '526495', '526517', '526525', '543179', '543225', '581640', '543276', '543292', '543314', '543381', '543390', '543420', '543446', '543454', '543462', '543471', '543578', '543608', '543624', '543641', '543675', '543691', '526606', '526614', '520071', '520098', '520101', '520128', '520187', '520314', '520411', '520471', '520519', '520578', '520586', '520616', '520691', '520705', '559610', '520713', '520853', '520861', '520951', '520993', '521001', '521060', '521078', '523402', '523437', '523445', '523496', '523488', '523518', '523542', '523593', '523631', '523658', '523721', '523747', '523763', '523381', '523844', '523852', '523879', '523925', '559890', '523933', '524107', '523950', '580368', '524018', '524026', '524034', '524093', '560103', '524131', '524158', '524174', '524191', '524212', '524221', '524255', '524263', '524271', '524301', '524336', '524352', '524361', '524387', '524395', '524409', '524417', '524425', '524433', '518522', '524450', '524468', '524476', '524506', '524514', '524549', '524522', '524531', '524581', '524590', '524620', '524638', '524646', '524654', '524662', '524697', '524701', '524727', '524735', '524743', '524751', '524760', '559971', '524786', '518590', '524794', '524808', '524832', '524841', '556823', '524867', '524883', '524905', '524913', '524930', '524964', '524999', '525014', '525022', '525031', '524140', '525057', '525065', '525073', '525111', '525138', '525154', '525162', '559989', '525171', '525189', '525197', '525201', '525251', '525260', '525278', '525286', '525294', '525324', '525332', '525341', '525383', '525391', '525405', '525413', '525430', '525448', '525456', '525472', '525499', '525502', '525511', '524182', '524204', '524239', '524247', '524280', '524298', '524310', '524328', '524344', '524379', '524441', '524492', '524557', '524565', '524573', '524603', '524611', '524671', '524689', '524778', '524816', '524824', '524875', '524921', '524948', '524956', '524981', '525006', '525049', '525081', '525090', '525103', '525120', '525146', '525219', '525235', '525243', '525308', '525316', '525359', '525367', '525375', '525421', '520039', '520080', '520136', '520161', '520179', '520209', '520217', '520284', '520322', '520365', '520381', '520390', '520438', '520489', '520551', '520594', '520632', '520641', '520659', '520675', '520730', '520748', '520764', '520802', '520829', '520811', '520845', '520870', '520888', '520918', '520934', '520942', '521051', '521108', '526673', '526681', '526690', '526703', '526711', '526720', '526738', '526746', '526754', '526762', '526771', '526789', '526797', '526801', '526819', '526827', '526835', '526843', '526851', '526860', '526878', '526886', '526894', '526908', '526916', '526924', '526932', '526941', '526959', '526967', '526975', '526983', '526991', '526665', '527009', '527017', '527025', '527033', '527041', '527050', '527068', '527076', '527084', '527092', '527114', '527157', '527165', '527173', '527181', '527190', '527203', '527262', '527289', '527297', '527335', '527343', '527386', '527408', '527416', '527467', '527793', '527475', '527513', '527521', '527530', '527572', '527581', '527611', '527637', '527700', '527726', '527718', '527815', '527823', '527840', '527866', '527912', '527921', '527939', '527971', '527980', '527998', '528005', '528013', '528021', '528048', '560073', '527122', '527131', '527149', '527211', '527220', '527238', '527246', '527254', '580601', '527271', '519197', '527301', '527319', '527327', '527351', '519316', '527360', '527378', '519332', '527394', '519391', '527424', '527432', '527441', '527459', '527483', '519448', '527491', '527505', '519537', '519561', '527548', '527556', '527564', '519596', '527599', '527602', '527629', '527645', '527653', '527661', '527670', '527688', '527696', '527734', '527742', '527751', '527769', '527777', '527785', '527807', '527831', '527858', '527106', '527874', '527882', '527891', '527904', '527947', '527955', '527963', '528030', '528056', '528064', '528072', '528081', '519987', '519995', '544060', '544078', '544086', '544094', '544108', '544116', '544124', '544132', '544141', '544159', '544167', '544175', '544183', '544191', '544205', '544213', '581674', '544221', '544230', '528731', '528749', '528757', '528765', '528773', '528781', '528790', '528811', '528820', '528838', '528846', '528854', '528862', '528871', '528889', '528901', '528919', '528927', '528935', '528943', '528960', '528978', '528986', '528994', '529001', '529028', '529036', '529044', '529052', '529079', '529109', '529125', '529133', '529141', '529150', '529168', '529176', '529184', '529192', '529206', '529214', '529222', '529231', '544051', '529117', '529257', '529265', '529281', '529290') AND `Inzerat`.`demo` = 0 ORDER BY `Inzerat`.`kapacita` asc LIMIT 10101087
118SELECT `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 (1242, 1688, 1103, 1943, 2059, 1170, 1115, 1102, 2067, 1129) 14141
119SELECT `RestaurantDetail`.`id`, `RestaurantDetail`.`ad_id`, `RestaurantDetail`.`contact`, `RestaurantDetail`.`created`, `RestaurantDetail`.`modified` FROM `realcms_restaurant_details` AS `RestaurantDetail` WHERE `RestaurantDetail`.`ad_id` IN (1242, 1688, 1103, 1943, 2059, 1170, 1115, 1102, 2067, 1129) 000
120SELECT `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 (1242, 1688, 1103, 1943, 2059, 1170, 1115, 1102, 2067, 1129) 220
121SELECT `RestaurantPayment`.`id`, `RestaurantPayment`.`ad_id`, `RestaurantPayment`.`payment_type_id` FROM `realcms_restaurant_payments` AS `RestaurantPayment` WHERE `RestaurantPayment`.`ad_id` IN (1242, 1688, 1103, 1943, 2059, 1170, 1115, 1102, 2067, 1129) 000
122SELECT `Charakteristika`.`id`, `Charakteristika`.`idinzerat`, `Charakteristika`.`idchar`, `Charakteristika`.`hodnota`, `Charakteristika`.`vyber` FROM `realcms_charakteristiky` AS `Charakteristika` WHERE `Charakteristika`.`idinzerat` IN (1242, 1688, 1103, 1943, 2059, 1170, 1115, 1102, 2067, 1129) 23923926
123SELECT `Obrazok`.`idobrazok`, `Obrazok`.`url`, `Obrazok`.`sort`, `Obrazok`.`inzerat_idinzerat` FROM `realcms_obrazok` AS `Obrazok` WHERE `Obrazok`.`inzerat_idinzerat` IN (1242, 1688, 1103, 1943, 2059, 1170, 1115, 1102, 2067, 1129) ORDER BY `Obrazok`.`sort` asc, `Obrazok`.`idobrazok` asc 13913913
124SELECT `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 (1242, 1688, 1103, 1943, 2059, 1170, 1115, 1102, 2067, 1129) 110
125SELECT `StravaInzerat`.`idinzerat`, `StravaInzerat`.`idstravy`, `StravaInzerat`.`value` FROM `realcms_strava_inzeraty` AS `StravaInzerat` WHERE `StravaInzerat`.`value` = 1 AND `StravaInzerat`.`idinzerat` IN (1242, 1688, 1103, 1943, 2059, 1170, 1115, 1102, 2067, 1129) 16161
126SELECT `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 (1242, 1688, 1103, 1943, 2059, 1170, 1115, 1102, 2067, 1129) ORDER BY `povina_cena` DESC 29291
127SELECT `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 (1242, 1688, 1103, 1943, 2059, 1170, 1115, 1102, 2067, 1129) 771
128SELECT `Vzdialenost1`.`id`, `Vzdialenost1`.`id_inzerat1`, `Vzdialenost1`.`id_inzerat2`, `Vzdialenost1`.`vzdialenost`, `Vzdialenost1`.`modified` FROM `realcms_inzerat_vzdialenosti` AS `Vzdialenost1` WHERE (`Vzdialenost1`.`id_inzerat1` = 1242 OR `Vzdialenost1`.`id_inzerat2` = 1242) ORDER BY `Vzdialenost1`.`vzdialenost` asc 107910791
129SELECT `Vzdialenost1`.`id`, `Vzdialenost1`.`id_inzerat1`, `Vzdialenost1`.`id_inzerat2`, `Vzdialenost1`.`vzdialenost`, `Vzdialenost1`.`modified` FROM `realcms_inzerat_vzdialenosti` AS `Vzdialenost1` WHERE (`Vzdialenost1`.`id_inzerat1` = 1688 OR `Vzdialenost1`.`id_inzerat2` = 1688) ORDER BY `Vzdialenost1`.`vzdialenost` asc 105410541
130SELECT `Vzdialenost1`.`id`, `Vzdialenost1`.`id_inzerat1`, `Vzdialenost1`.`id_inzerat2`, `Vzdialenost1`.`vzdialenost`, `Vzdialenost1`.`modified` FROM `realcms_inzerat_vzdialenosti` AS `Vzdialenost1` WHERE (`Vzdialenost1`.`id_inzerat1` = 1103 OR `Vzdialenost1`.`id_inzerat2` = 1103) ORDER BY `Vzdialenost1`.`vzdialenost` asc 108810881
131SELECT `Vzdialenost1`.`id`, `Vzdialenost1`.`id_inzerat1`, `Vzdialenost1`.`id_inzerat2`, `Vzdialenost1`.`vzdialenost`, `Vzdialenost1`.`modified` FROM `realcms_inzerat_vzdialenosti` AS `Vzdialenost1` WHERE (`Vzdialenost1`.`id_inzerat1` = 1943 OR `Vzdialenost1`.`id_inzerat2` = 1943) ORDER BY `Vzdialenost1`.`vzdialenost` asc 101810181
132SELECT `Vzdialenost1`.`id`, `Vzdialenost1`.`id_inzerat1`, `Vzdialenost1`.`id_inzerat2`, `Vzdialenost1`.`vzdialenost`, `Vzdialenost1`.`modified` FROM `realcms_inzerat_vzdialenosti` AS `Vzdialenost1` WHERE (`Vzdialenost1`.`id_inzerat1` = 2059 OR `Vzdialenost1`.`id_inzerat2` = 2059) ORDER BY `Vzdialenost1`.`vzdialenost` asc 10151015114
133SELECT `Vzdialenost1`.`id`, `Vzdialenost1`.`id_inzerat1`, `Vzdialenost1`.`id_inzerat2`, `Vzdialenost1`.`vzdialenost`, `Vzdialenost1`.`modified` FROM `realcms_inzerat_vzdialenosti` AS `Vzdialenost1` WHERE (`Vzdialenost1`.`id_inzerat1` = 1170 OR `Vzdialenost1`.`id_inzerat2` = 1170) ORDER BY `Vzdialenost1`.`vzdialenost` asc 108710871
134SELECT `Vzdialenost1`.`id`, `Vzdialenost1`.`id_inzerat1`, `Vzdialenost1`.`id_inzerat2`, `Vzdialenost1`.`vzdialenost`, `Vzdialenost1`.`modified` FROM `realcms_inzerat_vzdialenosti` AS `Vzdialenost1` WHERE (`Vzdialenost1`.`id_inzerat1` = 1115 OR `Vzdialenost1`.`id_inzerat2` = 1115) ORDER BY `Vzdialenost1`.`vzdialenost` asc 109710971
135SELECT `Vzdialenost1`.`id`, `Vzdialenost1`.`id_inzerat1`, `Vzdialenost1`.`id_inzerat2`, `Vzdialenost1`.`vzdialenost`, `Vzdialenost1`.`modified` FROM `realcms_inzerat_vzdialenosti` AS `Vzdialenost1` WHERE (`Vzdialenost1`.`id_inzerat1` = 1102 OR `Vzdialenost1`.`id_inzerat2` = 1102) ORDER BY `Vzdialenost1`.`vzdialenost` asc 108810881
136SELECT `Vzdialenost1`.`id`, `Vzdialenost1`.`id_inzerat1`, `Vzdialenost1`.`id_inzerat2`, `Vzdialenost1`.`vzdialenost`, `Vzdialenost1`.`modified` FROM `realcms_inzerat_vzdialenosti` AS `Vzdialenost1` WHERE (`Vzdialenost1`.`id_inzerat1` = 2067 OR `Vzdialenost1`.`id_inzerat2` = 2067) ORDER BY `Vzdialenost1`.`vzdialenost` asc 101610161
137SELECT `Vzdialenost1`.`id`, `Vzdialenost1`.`id_inzerat1`, `Vzdialenost1`.`id_inzerat2`, `Vzdialenost1`.`vzdialenost`, `Vzdialenost1`.`modified` FROM `realcms_inzerat_vzdialenosti` AS `Vzdialenost1` WHERE (`Vzdialenost1`.`id_inzerat1` = 1129 OR `Vzdialenost1`.`id_inzerat2` = 1129) ORDER BY `Vzdialenost1`.`vzdialenost` asc 107610761
138SELECT `VzdialenostMesta`.`id`, `VzdialenostMesta`.`id_inzerat`, `VzdialenostMesta`.`mesto`, `VzdialenostMesta`.`vzdialenost`, `VzdialenostMesta`.`updated` FROM `realcms_inzerat_vzdialenosti_mesta` AS `VzdialenostMesta` WHERE `VzdialenostMesta`.`id_inzerat` IN (1242, 1688, 1103, 1943, 2059, 1170, 1115, 1102, 2067, 1129) 3503505