Počet prístupov: 5 003 360

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 »

Grand hotel Bellevue **** Vysoké Tatry

Hotely | Vysoké Tatry
Cena (osoba/noc): 100 EUR (3 012,60 Sk)
Kapacita: 269

Hotelový komplex Grand Hotel Bellevue sa nachádza v najstaršej osade Vysokých Tatier – Starom Smokovci – v nadmorskej výške 1 010 m na úpätí Slavkovského štítu, na mieste nazvanom Pekná vyhliadka. Jej preklad do francúzskeho jazyka poskytol aj názov hotela BELLEVUE. Ak ste stúpencami aktívneho oddychu, prijmite pozvanie na bowling, alebo na zápas v squashi. Zašportovať si môžete v našom moderne vybavenom fitness centre, zahrať si môžete squash, stolný tenis, loptové hry, bowling na dvoch dráhach, alebo zacvičiť aerobik. GRAND HOTEL BELLEVUE vám ponúka rôzne športové aktivity: * fitnes centrum * squash * bowling * biliard * stolný tenis * telocvičňa Okre...

Kontakt Wellness hotel **** Stará Lesná 180, Vysoké Tatry

Hotely | Stará Lesná | Vysoké Tatry
Cena (osoba/noc): 85 EUR (2 560,71 Sk)
Kapacita: 90

Hotel Kontakt sa nachádza ha hranici Tatranského národného parku neďaleko známeho rekreačného strediska Tatranská Lomnica. Moderný wellness hotel s kvalitnými službami Vám poskytne príjemne prostredie pre oddych a šport.Nájdete tu relaxačné miestnosti, sauny, parné kúpele, výrivky, Jacuzzi a bazén v ktorom si môžete zrekreovať telo i dušu. V hoteli Kontakt Wellness je k dispozícií celá rada masáží a zkrášlovacích procedúr. K dispozícii sú komplexné služby a miestnosti pre konferencie, školenia, semináre a prezentácie.

Hotel Patria **** Štrbské Pleso, Vysoké Tatry

Hotely | Vysoké Tatry
Cena (osoba/noc): 58 EUR (1 747,31 Sk)
Kapacita: 310

Exkluzívny hotel, považovaný za najkrajší vo Vysokých Tatrách, ukrýva pre Vás pestrú mozaiku nádherných prekvapení. V nevšednom prostredí tu nájdete pohodlie, veľký výber gastronomických špecialít, osvieženie i úslužný personál, pripravený vždy poskytnúť širokú škálu hotelových služieb. Dominantnou stavbou Štrbského Plesa (1355 m n. m.) je hotel PATRIA, nazvaný podľa neďalekého štítu Patria (vlasť), vysokého 2203 m n. m. Je situovaný pri brehu vysokohorského plesa v závere Mlynickej doliny, citlivo zasadený do tatranskej prírody. V novootvorenej štýlovej reštaurácii KOLIBA PATRIA si môžete vybrať z bohatého sortimentu špecialít slovenskej kuchyne. Táto štýlová reštaurácia na brehu jaz...

Penzión TAVEL Prešov

Penzióny | Prešov
Cena (osoba/noc): 52 EUR (1 566,55 Sk)
Kapacita: 20

Penzión Tavel sa nachádza v historickom centre mesta Prešov vo vzdialenosti 100m od kostola Sv. Mikulša. Penzión ponúka 8 dvoj posteľových izieb, 4 prístelky. Všetky izby majú vlastné sociálne zariadenie (sprchovací kút a WC), TV. Súčasťou penziónu je výťah, kongresová miestnosť, recepcia s Lobby barom a salónikom s celodennou prevádzkou. Penzión má vlastné parkovisko.V penzióne je možné usporiadať spoločenské akcie - výročia, svadby, firemné akcie, školenia. V našich priestoroch sa nachádza aj predajňa liehovín za určite pre Vás zaujímavé cenové relácie. V penzióne je možné usporiadať spoločenské akcie - výročia, svadby, firemné akcie, školenia s kapacitou do 50 osôb. Hodnotenie z Tr...

Hotel Sobota *** Poprad - Spišská Sobota

Hotely | Poprad | Vysoké Tatry
Cena (osoba/noc): 49 EUR (1 476,17 Sk)
Kapacita: 58

Hotel Sobota *** vstúpil na trh cestovného ruchu v roku 2005. Sídli v Poprade – Spišskej Sobote, meste známom ako brána do najmenších veľhôr sveta – Vysokých Tatier. Osobný prístup k hosťom, kvalitné služby, profesionálna obsluha, príjemné prostredie, pohodlie, spoľahlivosť... Sme hotel, ktorý popri komfortnom ubytovaní ponúka aj kvalitné stravovacie služby, je taktiež vhodný na organizovanie banketových podujatí ako i rôznych seminárov a školení, aby tak oslovil aj tých najnáročnejších klientov a prispel k príjemne strávenej dovolenke. This non-smoking hotel is set amidst a mountainous natural environment in a tranquil location near the airport and old town, offering excellent amenit...

Penzión Brahama

Penzióny | Prešov
Cena (osoba/noc): 49 EUR (1 476,17 Sk)
Kapacita: 30

Penzión Brahama sa nachádza v tesnej blízkosti historického centra mesta Prešov, ale pritom je situovaný v tichom prostredí s vlastným parkoviskom. Je to penzión s veľmi útu lným ubytovaním a výbornou kuchyňou. V jeho priestoroch vám ponúkame ubytovanie v dvanástich dvojlôžkových izbách s možnosťou prístelky alebo v priestrannom apartmáne. K výbave izieb patrí klimatizácia, kúpelňa so sprchovacím kútom, televízny prijímač so satelitnými kanálmi a telefón. Posedenie pri dobrom jedle alebo výbornej káve vám spríjemní prostredie klimatizovaného snack-baru s možnosťou pripojenia internetu.

Penzión - Reštaurácia ALEX

Penzióny | Prešov | Šariš
Cena (osoba/noc): 40 EUR (1 205,04 Sk)
Kapacita: 20

Pension ALEX Vám ponúka ubytovanie v novozrekonštruovanom pôvodnom meštianskom dome v centre mesta Prešov.2 apartmány (s výrivkovou vaňou) a 5 jedno až trojposteľové izby sú zariadené v modernom štýle s kompletným vybavením. V modernom štýle je zariadený aj restaurant ALEX, ktorý slúži aj ako raňajková miestnosť s možnosťou stravovania počas celého dňa. Restaurant je vhodný aj na rôzne rodinne, firemné a spoločenské oslavy, kurzy či odborné školenia s kapacitou 30+30 miest +30 letná terasa.

Hotel International **** Veľká Lomnica, Vysoké Tatry

Hotely | Veľká Lomnica | Vysoké Tatry
Cena (osoba/noc): 39 EUR (1 174,91 Sk)
Kapacita: 61

GPS: 49° 08´13´´ N, 20°20´23´´ E Hotel International**** je súčasťou golfového rezortu vo Veľkej Lomnici a poskytuje kvalitné a komplexné služby nielen golfistom počas celého roka. Elegantný, štýlový a vďaka svojej polohe priamo na golfovom ihrisku aj jedinečný hotel. Samotná stavba je navrhnutá tak, aby čo najviac vynikli danosti prostredia, v ktorom sa nachádza. Hotel pre svojích hostí ponúka služby spojené s golfom - golfový simulátor, obchod a požičovňa s golfovým výstrojom, golfová akadémia a profesionálnych trénerov golfu.

Hotel Crocus **** Štrbské Pleso, Vysoké Tatry

Hotely | Vysoké Tatry
Cena (osoba/noc): 36 EUR (1 084,54 Sk)
Kapacita: 130

Moderný Hotel **** CROCUS sa nachádza priamo v centre Štrbského Plesa medzi centrálnym parkoviskom a železničnou stanicou. Hotel poskytuje nadštandardné ubytovanie v 65 komfortných apartmánoch pre individuálnu, rodinnú a firemnú klientelu. Ich súčasťou je TV-SAT, bezplatný prístup na internet, trezor, telefón, krbová piecka, kuchynský kút a samostatný šatník.

Penzion JANTÁR, Záhradná 670, Batizovce, Poprad

Penzióny | Batizovce
Cena (osoba/noc): 33 EUR (994,16 Sk)
Kapacita: 31

Penzión Jantár*** je situovaný pod Vysokými Tatrami, v nadmorskej výške 800m v obci Batizovce, vzdialenej 8km od Popradu.Penzión Jantár*** predstavuje vysokú kvalitu služieb, je zárukou spokojnosti aj najnáročnejších hostí. Ponúka nadštandardné ubytovanie v dvojposteľových, trojposteľových izbách, apartmánoch a v rodinnej izbe. Celková kapacita je 31 lôžok. Každá izba je vybavená TV, minibarom, telefónom a kúpeľňou. Stravovacie služby sú poskytované v stredisku Reštaurácia s kapacitou 56 osôb, s možnosťou organizovania firemných prezentácii a rodinných osláv. Súčasťou penziónu je vlastné parkovisko, tenisový kurt a sauna.



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

Polohy inzerátov na mape

facebooktwitter
(default) 138 queries took 637 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `realcms_inzerat`37374
2DESCRIBE `realcms_obce`444
3DESCRIBE `realcms_okresy`441
4DESCRIBE `realcms_kraje`331
5DESCRIBE `realcms_zakaznik`43436
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`772
21DESCRIBE `realcms_meny`441
22DESCRIBE `realcms_ceny_nazvy`331
23DESCRIBE `realcms_zlavy`661
24DESCRIBE `realcms_zlavy_nazvy`331
25DESCRIBE `realcms_inzerat_vzdialenosti`552
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`23232
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.213', '2012-02-12 18:43:41') 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 441
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 111
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 111
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 111
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 111
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 111
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 94940
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' 13130
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 6676670
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 1149
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`.`cena` desc LIMIT 101010101
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 (1213, 1098, 1220, 1061, 1118, 2047, 1250, 1106, 2000, 906) 21211
119SELECT `RestaurantDetail`.`id`, `RestaurantDetail`.`ad_id`, `RestaurantDetail`.`contact`, `RestaurantDetail`.`created`, `RestaurantDetail`.`modified` FROM `realcms_restaurant_details` AS `RestaurantDetail` WHERE `RestaurantDetail`.`ad_id` IN (1213, 1098, 1220, 1061, 1118, 2047, 1250, 1106, 2000, 906) 111
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 (1213, 1098, 1220, 1061, 1118, 2047, 1250, 1106, 2000, 906) 001
121SELECT `RestaurantPayment`.`id`, `RestaurantPayment`.`ad_id`, `RestaurantPayment`.`payment_type_id` FROM `realcms_restaurant_payments` AS `RestaurantPayment` WHERE `RestaurantPayment`.`ad_id` IN (1213, 1098, 1220, 1061, 1118, 2047, 1250, 1106, 2000, 906) 000
122SELECT `Charakteristika`.`id`, `Charakteristika`.`idinzerat`, `Charakteristika`.`idchar`, `Charakteristika`.`hodnota`, `Charakteristika`.`vyber` FROM `realcms_charakteristiky` AS `Charakteristika` WHERE `Charakteristika`.`idinzerat` IN (1213, 1098, 1220, 1061, 1118, 2047, 1250, 1106, 2000, 906) 41541525
123SELECT `Obrazok`.`idobrazok`, `Obrazok`.`url`, `Obrazok`.`sort`, `Obrazok`.`inzerat_idinzerat` FROM `realcms_obrazok` AS `Obrazok` WHERE `Obrazok`.`inzerat_idinzerat` IN (1213, 1098, 1220, 1061, 1118, 2047, 1250, 1106, 2000, 906) ORDER BY `Obrazok`.`sort` asc, `Obrazok`.`idobrazok` asc 21221216
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 (1213, 1098, 1220, 1061, 1118, 2047, 1250, 1106, 2000, 906) 111
125SELECT `StravaInzerat`.`idinzerat`, `StravaInzerat`.`idstravy`, `StravaInzerat`.`value` FROM `realcms_strava_inzeraty` AS `StravaInzerat` WHERE `StravaInzerat`.`value` = 1 AND `StravaInzerat`.`idinzerat` IN (1213, 1098, 1220, 1061, 1118, 2047, 1250, 1106, 2000, 906) 22221
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 (1213, 1098, 1220, 1061, 1118, 2047, 1250, 1106, 2000, 906) ORDER BY `povina_cena` DESC 38382
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 (1213, 1098, 1220, 1061, 1118, 2047, 1250, 1106, 2000, 906) 661
128SELECT `Vzdialenost1`.`id`, `Vzdialenost1`.`id_inzerat1`, `Vzdialenost1`.`id_inzerat2`, `Vzdialenost1`.`vzdialenost`, `Vzdialenost1`.`modified` FROM `realcms_inzerat_vzdialenosti` AS `Vzdialenost1` WHERE (`Vzdialenost1`.`id_inzerat1` = 1213 OR `Vzdialenost1`.`id_inzerat2` = 1213) ORDER BY `Vzdialenost1`.`vzdialenost` asc 106810681
129SELECT `Vzdialenost1`.`id`, `Vzdialenost1`.`id_inzerat1`, `Vzdialenost1`.`id_inzerat2`, `Vzdialenost1`.`vzdialenost`, `Vzdialenost1`.`modified` FROM `realcms_inzerat_vzdialenosti` AS `Vzdialenost1` WHERE (`Vzdialenost1`.`id_inzerat1` = 1098 OR `Vzdialenost1`.`id_inzerat2` = 1098) ORDER BY `Vzdialenost1`.`vzdialenost` asc 109610961
130SELECT `Vzdialenost1`.`id`, `Vzdialenost1`.`id_inzerat1`, `Vzdialenost1`.`id_inzerat2`, `Vzdialenost1`.`vzdialenost`, `Vzdialenost1`.`modified` FROM `realcms_inzerat_vzdialenosti` AS `Vzdialenost1` WHERE (`Vzdialenost1`.`id_inzerat1` = 1220 OR `Vzdialenost1`.`id_inzerat2` = 1220) ORDER BY `Vzdialenost1`.`vzdialenost` asc 106010601
131SELECT `Vzdialenost1`.`id`, `Vzdialenost1`.`id_inzerat1`, `Vzdialenost1`.`id_inzerat2`, `Vzdialenost1`.`vzdialenost`, `Vzdialenost1`.`modified` FROM `realcms_inzerat_vzdialenosti` AS `Vzdialenost1` WHERE (`Vzdialenost1`.`id_inzerat1` = 1061 OR `Vzdialenost1`.`id_inzerat2` = 1061) ORDER BY `Vzdialenost1`.`vzdialenost` asc 11401140127
132SELECT `Vzdialenost1`.`id`, `Vzdialenost1`.`id_inzerat1`, `Vzdialenost1`.`id_inzerat2`, `Vzdialenost1`.`vzdialenost`, `Vzdialenost1`.`modified` FROM `realcms_inzerat_vzdialenosti` AS `Vzdialenost1` WHERE (`Vzdialenost1`.`id_inzerat1` = 1118 OR `Vzdialenost1`.`id_inzerat2` = 1118) ORDER BY `Vzdialenost1`.`vzdialenost` asc 106710671
133SELECT `Vzdialenost1`.`id`, `Vzdialenost1`.`id_inzerat1`, `Vzdialenost1`.`id_inzerat2`, `Vzdialenost1`.`vzdialenost`, `Vzdialenost1`.`modified` FROM `realcms_inzerat_vzdialenosti` AS `Vzdialenost1` WHERE (`Vzdialenost1`.`id_inzerat1` = 2047 OR `Vzdialenost1`.`id_inzerat2` = 2047) ORDER BY `Vzdialenost1`.`vzdialenost` asc 10161016123
134SELECT `Vzdialenost1`.`id`, `Vzdialenost1`.`id_inzerat1`, `Vzdialenost1`.`id_inzerat2`, `Vzdialenost1`.`vzdialenost`, `Vzdialenost1`.`modified` FROM `realcms_inzerat_vzdialenosti` AS `Vzdialenost1` WHERE (`Vzdialenost1`.`id_inzerat1` = 1250 OR `Vzdialenost1`.`id_inzerat2` = 1250) ORDER BY `Vzdialenost1`.`vzdialenost` asc 107110711
135SELECT `Vzdialenost1`.`id`, `Vzdialenost1`.`id_inzerat1`, `Vzdialenost1`.`id_inzerat2`, `Vzdialenost1`.`vzdialenost`, `Vzdialenost1`.`modified` FROM `realcms_inzerat_vzdialenosti` AS `Vzdialenost1` WHERE (`Vzdialenost1`.`id_inzerat1` = 1106 OR `Vzdialenost1`.`id_inzerat2` = 1106) ORDER BY `Vzdialenost1`.`vzdialenost` asc 109010901
136SELECT `Vzdialenost1`.`id`, `Vzdialenost1`.`id_inzerat1`, `Vzdialenost1`.`id_inzerat2`, `Vzdialenost1`.`vzdialenost`, `Vzdialenost1`.`modified` FROM `realcms_inzerat_vzdialenosti` AS `Vzdialenost1` WHERE (`Vzdialenost1`.`id_inzerat1` = 2000 OR `Vzdialenost1`.`id_inzerat2` = 2000) 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` = 906 OR `Vzdialenost1`.`id_inzerat2` = 906) ORDER BY `Vzdialenost1`.`vzdialenost` asc 113211321
138SELECT `VzdialenostMesta`.`id`, `VzdialenostMesta`.`id_inzerat`, `VzdialenostMesta`.`mesto`, `VzdialenostMesta`.`vzdialenost`, `VzdialenostMesta`.`updated` FROM `realcms_inzerat_vzdialenosti_mesta` AS `VzdialenostMesta` WHERE `VzdialenostMesta`.`id_inzerat` IN (1213, 1098, 1220, 1061, 1118, 2047, 1250, 1106, 2000, 906) 3503505