▼

Search

Keywords
Location
Country
Type
Accomodation price
from
to
Capacity
from
to
Meal
City

Počet prístupov: 4 978 175
News
späť

Penzión Dubová

Zdielať Views: 1 979

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

V okolí

Wildwater Kingdom Letné kúpaliska Kúpele Ski resorts Jazerá a nádrže Castles and Chateaux ZOO a botanika Golf Caves Ďalšie...
 

Type

-

Pensions


Address

-

Námestie SNP 26, Rajec (county Žilina)


Location

-

Žilina


Capacity

-

12


Contact landlord

Marta Cádriková

+421 415 422 346,
+421 903 886 689

Napíšte mail majiteľovi

http://www.penziondubova.eu

Penzión Dubová** sa nachádza priamo v historickom centre mestečka Rajec s cca 6.000 obyvateľmi. Je vybudovaný z pôvodného meštianskeho domu. Okrem kvalitného ubytovania (kde je zaužívaný štandard vyššej kategórie), máte možnosť využiť reštauráciu s príjemnou atmosférou, výbornou kuchyňou aj obsluhou. Cez leto si môžete posedieť na letnej terase priamo na námestí a máte mestečko na dlani.

Prices

10 EUR (301,26 Sk)

Person / night 10 EUR (301,26 Sk) occupancy / stay

Zľavy

dieťa do 12 rokov EUR (0 Sk) objekt / pobyt

Characteristic  ID 1834

Charakteristiky objektu

TV

Parkovanie na voľnom priestranstve

Parking capacity30

Extra bed

Heating - gas

Bathroom and WC in each room

No. of WC4

No. of bathrooms4

CD player

Rooms with double bed

Bar

Terrace

Pets accepted

Family bedroom

Charakteristiky izieb

Satellite

TV

Radio

Activities

Agroturistika

Mushroom-picking

Skying

Turism

Cycling

Golf

Tennis

Location

Print a mapvybraté zariadenieubytovanie v okolíreštaurácie v okolí


Find a path

Atrakcie v okolí

AquaparkyJaskyneWellness pobyty
Lyžiarské strediskáKiná a divadláCyklotrasy
BowlingUNESCOMotokáry
GolfHrady a zámkySquash
TenisLetné kúpaliskáPaintball
ŠportoviskáRančePlte a rafting
Liečebné kúpeleJazerá a vodné nádržeSoľné jaskyne
Konferenčné zariadeniaZOO a botanické záhradyKúpele a kúpaliska
TuristikaMúzeaAdrenalín a Zábava
JaskyneWellness pobytyKultúrne pamiatky
 

Comments

Is the picture unreadable?

Send to a friend

Is the picture unreadable?
 
facebooktwitter
(default) 126 queries took 167 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`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` = 'eng' LIMIT 1110
45SELECT `Texty`.`nadpis`, `Texty`.`name` FROM `realcms_wysiwyg` AS `Texty` WHERE `Texty`.`jazyk_id` = 2 550
46INSERT DELAYED INTO `realcms_web_pristupy` (`ip_adresa`, `created`) VALUES ('38.107.179.213', '2012-02-06 15:37:44') ON DUPLICATE KEY UPDATE pocet_pristupov=pocet_pristupov+121
47SELECT SUM(pocet_pristupov) AS pocet FROM `realcms_web_pristupy` AS `Pristup` WHERE 1 = 1 LIMIT 111112
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 `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 `Inzerat`.`schvaleny` = 1 AND `Inzerat`.`idinzerat` = 1834 AND `Inzerat`.`demo` = 0 LIMIT 1111
75SELECT `Obec`.`idobec`, `Obec`.`nazov_obce`, `Obec`.`idokres`, `Obec`.`psc` FROM `realcms_obce` AS `Obec` WHERE `Obec`.`idobec` = 517917 110
76SELECT `Okres`.`idokres`, `Okres`.`nazov`, `Okres`.`idkraj`, `Okres`.`zobrazeni` FROM `realcms_okresy` AS `Okres` WHERE `Okres`.`idokres` = '511' 110
77SELECT `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` FROM `realcms_zakaznik` AS `Ubytovatel` WHERE `Ubytovatel`.`id_uzivatel` = 6828 110
78SELECT `Druh`.`iddruh`, `Druh`.`druh`, `Druh`.`zobrazeni`, `Druh`.`cena` FROM `realcms_druhy` AS `Druh` WHERE `Druh`.`iddruh` = 2 110
79SELECT `PlatnostInzeratu`.`idinzerat`, `PlatnostInzeratu`.`do`, `PlatnostInzeratu`.`upozornenie_makler_1`, `PlatnostInzeratu`.`upozornenie_makler_2`, `PlatnostInzeratu`.`upozornenie_zakaznik_1`, `PlatnostInzeratu`.`upozornenie_zakaznik_2` FROM `realcms_platnost_inzeratu` AS `PlatnostInzeratu` WHERE `PlatnostInzeratu`.`idinzerat` = 1834 110
80SELECT `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` = (1834) 000
81SELECT `RestaurantDetail`.`id`, `RestaurantDetail`.`ad_id`, `RestaurantDetail`.`contact`, `RestaurantDetail`.`created`, `RestaurantDetail`.`modified` FROM `realcms_restaurant_details` AS `RestaurantDetail` WHERE `RestaurantDetail`.`ad_id` = (1834) 000
82SELECT `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` = (1834) 000
83SELECT `RestaurantPayment`.`id`, `RestaurantPayment`.`ad_id`, `RestaurantPayment`.`payment_type_id` FROM `realcms_restaurant_payments` AS `RestaurantPayment` WHERE `RestaurantPayment`.`ad_id` = (1834) 000
84SELECT `Charakteristika`.`id`, `Charakteristika`.`idinzerat`, `Charakteristika`.`idchar`, `Charakteristika`.`hodnota`, `Charakteristika`.`vyber` FROM `realcms_charakteristiky` AS `Charakteristika` WHERE `Charakteristika`.`idinzerat` = (1834) 24240
85SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 90 110
86SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 87 110
87SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 82 110
88SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 79 110
89SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 62 110
90SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 61 110
91SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 58 110
92SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 56 110
93SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 54 110
94SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 53 110
95SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 39 110
96SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 38 110
97SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 37 110
98SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 35 110
99SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 33 110
100SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 32 110
101SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 30 110
102SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 26 110
103SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 21 110
104SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 18 110
105SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 34 110
106SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 15 110
107SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 12 110
108SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 11 110
109SELECT `Obrazok`.`idobrazok`, `Obrazok`.`url`, `Obrazok`.`sort`, `Obrazok`.`inzerat_idinzerat` FROM `realcms_obrazok` AS `Obrazok` WHERE `Obrazok`.`inzerat_idinzerat` = (1834) ORDER BY `Obrazok`.`sort` asc, `Obrazok`.`idobrazok` asc 880
110SELECT `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` = (1834) 000
111SELECT `StravaInzerat`.`idinzerat`, `StravaInzerat`.`idstravy`, `StravaInzerat`.`value` FROM `realcms_strava_inzeraty` AS `StravaInzerat` WHERE `StravaInzerat`.`value` = 1 AND `StravaInzerat`.`idinzerat` = (1834) 000
112SELECT `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` = (1834) ORDER BY `povina_cena` DESC 221
113SELECT `Mena`.`idmena`, `Mena`.`nazov_meny`, `Mena`.`hodnota`, `Mena`.`sort` FROM `realcms_meny` AS `Mena` WHERE `Mena`.`idmena` = 0 000
114SELECT `Mena`.`idmena`, `Mena`.`nazov_meny`, `Mena`.`hodnota`, `Mena`.`sort` FROM `realcms_meny` AS `Mena` WHERE `Mena`.`idmena` = 7 110
115SELECT `CenaNazov`.`id`, `CenaNazov`.`nazov`, `CenaNazov`.`sort` FROM `realcms_ceny_nazvy` AS `CenaNazov` WHERE `CenaNazov`.`id` = 0 000
116SELECT `CenaNazov`.`id`, `CenaNazov`.`nazov`, `CenaNazov`.`sort` FROM `realcms_ceny_nazvy` AS `CenaNazov` WHERE `CenaNazov`.`id` = 1 110
117SELECT `Zlava`.`id`, `Zlava`.`idinzerat`, `Zlava`.`id_zlava_nazov`, `Zlava`.`zlava`, `Zlava`.`poznamka_k_zlave`, `Zlava`.`mena` FROM `realcms_zlavy` AS `Zlava` WHERE `Zlava`.`idinzerat` = (1834) 110
118SELECT `Mena`.`idmena`, `Mena`.`nazov_meny`, `Mena`.`hodnota`, `Mena`.`sort` FROM `realcms_meny` AS `Mena` WHERE `Mena`.`idmena` = 7 110
119SELECT `ZlavaNazov`.`id`, `ZlavaNazov`.`nazov`, `ZlavaNazov`.`sort` FROM `realcms_zlavy_nazvy` AS `ZlavaNazov` WHERE `ZlavaNazov`.`id` = 1 110
120UPDATE `realcms_inzerat` AS `Inzerat` SET `Inzerat`.`zobrazeni` = Inzerat.zobrazeni + 1 WHERE `Inzerat`.`idinzerat` = 183411
121SELECT `Kraj`.`idkraj`, `Kraj`.`nazov`, `Kraj`.`idstat` FROM `realcms_kraje` AS `Kraj` WHERE `Kraj`.`idkraj` = '5' LIMIT 1110
122SELECT `Okres`.`idokres`, `Okres`.`nazov`, `Okres`.`idkraj`, `Okres`.`zobrazeni` FROM `realcms_okresy` AS `Okres` WHERE `Okres`.`idkraj` = ('5') ORDER BY `Okres`.`nazov` ASC 11110
123SELECT `CharKategoria`.`id`, `CharKategoria`.`nazov_ketegorie` FROM `realcms_char_kategorie` AS `CharKategoria` WHERE 1 = 1 550
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` = 1834 AND `Komentar`.`ip_adresa` = '38.107.179.213' 000
125SELECT `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` = 1834 000
126SELECT `ZariadenieDruh`.`id`, `ZariadenieDruh`.`zariadenie`, `ZariadenieDruh`.`alias`, `ZariadenieDruh`.`parent` FROM `realcms_druhy_zariadeni` AS `ZariadenieDruh` WHERE 1 = 1 28280