▼

Vyhľadávanie

Kľúčové slovo
Lokalita
Kraj
Typ
Cena ubytovania
od
do
Kapacita
od
do
Stravovanie
Mesto

Počet prístupov: 4 999 367
Aktuality
späť

Penzión Barca *** Košice, Barca

Zdielať Zobrazení: 2 677

Cena (osoba/noc) od: 37,50 EUR (1 129,73 Sk)

V okolí

Aquaparky Letné kúpaliska Kúpele Lyžiarské strediská Jazerá a nádrže Hrady a zámky ZOO a botanika Golf Jaskyne Ďalšie...
 

Druh

-

Penzióny


Adresa

-

Gavlovičova 1, Košice - mestská časť Barca (okr. Košice IV)


Lokalita

-

Košice


Kapacita

-

48


Stravovanie

-

Plná penzia, Polpenzia, Raňajky, Bez stravy


Kontakt na ubytovateľa

recepcia

+421 557 283 100,
+421 918 341 466

Napíšte mail majiteľovi

http://www.pensionbarca.sk

Pension Barca je situovaný v blízkosti centra mesta Košice a letiska, v jej mestskej časti Barca, podľa ktorej bol aj pomenovaný. Postavený bol roku 2001 a bol zaradený do kategórie Pension ***.
Štýl ubytovania v Pensione Barca je prispôsobený každému i tomu najnáročnejšiemu hosťovi - Skrátka hotel pre každého.

Pension Barca Vám ponúka ubytovanie v 2 apartmánoch, 13 dvojposteľových izieb a 6 hosťovských izieb s manželskou posteľou. Samotné izby majú komfortný štýl s nádychom luxusu a atmosférou domova. Izby sú umiestnené v hotelovej hlavnej budove a taktiež v bungalovoch, kde izby zahŕňajú aj vlastný balkón.. Všetky izby Vám umožňujú lákavý výhľad na letnú záhradu v areáli ubytovania.

Všetkých 21 je vybavených vlastnou kúpeľňou a toaletou, farebným TV s príjmom satelitných programov, minibarom, rádiobudíkom, telefónom s priamou voľbou a samozrejme prípojkou na internet.

Apartmány pozostávajú z obývacej miestnosti a spálne s manželskými posteľami. Kúpelne apartmánov Vám ponúkame so sprchovým kútom alebo s vaňou a samozrejme sociálnym zariadením.
V Pensione Barca si svoj pobyt môžete spríjemniť oddychom v Relax Centre, kde sa nachádza klasická zmiešaná sauna s kapacitou 6 miest a odpočivárňou, samozrejmosťou je možnosť výborného uvoľnenia pri masáži.

Atypický hotelový bazén ponúka relax spojený s možnosťou občerstvenia priamo pri bazéne.

Bazén a Relax Centrum sú sprístupnene v letnom aj zimnom období a to nielen pre hotelových hostí.
Neoddeliteľnou súčasťou Pensionu Barca je aj možnosť využitia športových aktivít ako je Tenis v letných obdobiach alebo Bowling celoročne, nielen pre záujemcov športu a ubytovaných hostí. Zapožičanie nástrojov na hru je ďalšou možnosťou a samozrejme vašou výhodou.

V roku 2004 sa konala súťaž týždenníka Trend pod názvom Top Trend reštaurácie a hotely. Medzi ocenených sa umiestnil aj Pension Barca v rámci kategórie o najlepší Penzión z celého Slovenska, a to na druhom až štvrtom mieste.

Ceny

37,50 EUR (1 129,73 Sk)

Charakteristiky  ID 1197

Charakteristiky objektu

Televízor

Samostatný vstup

WiFi zadarmo

WiFi platené

Parkovanie na voľnom priestranstve

Počet parkovacích miest25

Klimatizácia

Možnosť prístelky

Kúrenie - plynové

Kúpeľňa a WC v každej izbe

Počet WC25

Počet kúpeľní21

Oplotený pozemok

CD prehrávač

Hračky pre deti

Detský kútik

Vhodné pre skupinové pobyty

Izby s manželskou posteľou

Balkón / Loggia

Bezbariérový prístup

Bar

Možnosť platiť kreditnou kartou

Terasa

Gril

Kuchyňa

Detské ihrisko

Spoločenská miestnosť

Vonkajšie posedenie (altánok)

Krb - vnútorný

Krb

Ohnisko

Charakteristiky izieb

Trezor

Internet

Satelit

Rýchlovarná kanvica

Televízor

Rádio

Minibar

Aktivity

Lyžovanie

Turistika

Bowling

Cyklistika / Cykloturistika

Tenis

Služby Wellness

Sauna

Jacuzzi

Športová masáž

Masáže

Krytá plaváreň

Vnútorný bazén

Kongresové služby

Premietacie plátno

Usporiadateľská služba

Počet kongresových sál1

Maximálny počet ľudí pre kongresové centrum80

Poloha

Tlačiť mapuvybraté zariadenieubytovanie v okolíreštaurácie v okolí


Nájdi cestu

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
 

Komentáre

Je obrázok nečitateľný?

Poslať známemu

Je obrázok nečitateľný?
 
facebooktwitter
(default) 155 queries took 205 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `realcms_inzerat`37374
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.213', '2012-02-11 18:57:09') 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 111111
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` = 1197 AND `Inzerat`.`demo` = 0 LIMIT 1111
75SELECT `Obec`.`idobec`, `Obec`.`nazov_obce`, `Obec`.`idokres`, `Obec`.`psc` FROM `realcms_obce` AS `Obec` WHERE `Obec`.`idobec` = 599093 110
76SELECT `Okres`.`idokres`, `Okres`.`nazov`, `Okres`.`idkraj`, `Okres`.`zobrazeni` FROM `realcms_okresy` AS `Okres` WHERE `Okres`.`idokres` = '805' 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` = 3009 111
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` = 1197 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` = (1197) 000
81SELECT `RestaurantDetail`.`id`, `RestaurantDetail`.`ad_id`, `RestaurantDetail`.`contact`, `RestaurantDetail`.`created`, `RestaurantDetail`.`modified` FROM `realcms_restaurant_details` AS `RestaurantDetail` WHERE `RestaurantDetail`.`ad_id` = (1197) 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` = (1197) 000
83SELECT `RestaurantPayment`.`id`, `RestaurantPayment`.`ad_id`, `RestaurantPayment`.`payment_type_id` FROM `realcms_restaurant_payments` AS `RestaurantPayment` WHERE `RestaurantPayment`.`ad_id` = (1197) 000
84SELECT `Charakteristika`.`id`, `Charakteristika`.`idinzerat`, `Charakteristika`.`idchar`, `Charakteristika`.`hodnota`, `Charakteristika`.`vyber` FROM `realcms_charakteristiky` AS `Charakteristika` WHERE `Charakteristika`.`idinzerat` = (1197) 535324
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` = 85 110
87SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 84 110
88SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 83 110
89SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 82 110
90SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 70 110
91SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 65 110
92SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 64 110
93SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 63 110
94SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 62 110
95SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 61 110
96SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 58 110
97SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 57 110
98SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 56 110
99SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 53 110
100SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 50 110
101SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 49 110
102SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 46 110
103SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 43 110
104SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 42 110
105SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 41 110
106SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 40 110
107SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 39 110
108SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 38 110
109SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 37 110
110SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 36 110
111SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 35 110
112SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 33 110
113SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 32 110
114SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 31 110
115SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 30 110
116SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 29 110
117SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 28 110
118SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 27 110
119SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 26 110
120SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 24 110
121SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 23 110
122SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 22 110
123SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 21 110
124SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 19 110
125SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 18 110
126SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 17 110
127SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 34 110
128SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 15 110
129SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 14 110
130SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 13 110
131SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 11 110
132SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 10 110
133SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 8 110
134SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 4 110
135SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 3 110
136SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 2 110
137SELECT `CharDetail`.`id_kategorie`, `CharDetail`.`nazov_char`, `CharDetail`.`typ` FROM `realcms_char` AS `CharDetail` WHERE `CharDetail`.`id` = 1 110
138SELECT `Obrazok`.`idobrazok`, `Obrazok`.`url`, `Obrazok`.`sort`, `Obrazok`.`inzerat_idinzerat` FROM `realcms_obrazok` AS `Obrazok` WHERE `Obrazok`.`inzerat_idinzerat` = (1197) ORDER BY `Obrazok`.`sort` asc, `Obrazok`.`idobrazok` asc 242412
139SELECT `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` = (1197) 000
140SELECT `StravaInzerat`.`idinzerat`, `StravaInzerat`.`idstravy`, `StravaInzerat`.`value` FROM `realcms_strava_inzeraty` AS `StravaInzerat` WHERE `StravaInzerat`.`value` = 1 AND `StravaInzerat`.`idinzerat` = (1197) 440
141SELECT `Stravovanie`.`id`, `Stravovanie`.`nazov_stravovania`, `Stravovanie`.`order` FROM `realcms_stravovanie` AS `Stravovanie` WHERE `Stravovanie`.`id` = 4 110
142SELECT `Stravovanie`.`id`, `Stravovanie`.`nazov_stravovania`, `Stravovanie`.`order` FROM `realcms_stravovanie` AS `Stravovanie` WHERE `Stravovanie`.`id` = 3 110
143SELECT `Stravovanie`.`id`, `Stravovanie`.`nazov_stravovania`, `Stravovanie`.`order` FROM `realcms_stravovanie` AS `Stravovanie` WHERE `Stravovanie`.`id` = 2 110
144SELECT `Stravovanie`.`id`, `Stravovanie`.`nazov_stravovania`, `Stravovanie`.`order` FROM `realcms_stravovanie` AS `Stravovanie` WHERE `Stravovanie`.`id` = 1 110
145SELECT `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` = (1197) ORDER BY `povina_cena` DESC 111
146SELECT `Mena`.`idmena`, `Mena`.`nazov_meny`, `Mena`.`hodnota`, `Mena`.`sort` FROM `realcms_meny` AS `Mena` WHERE `Mena`.`idmena` = 0 000
147SELECT `CenaNazov`.`id`, `CenaNazov`.`nazov`, `CenaNazov`.`sort` FROM `realcms_ceny_nazvy` AS `CenaNazov` WHERE `CenaNazov`.`id` = 0 000
148SELECT `Zlava`.`id`, `Zlava`.`idinzerat`, `Zlava`.`id_zlava_nazov`, `Zlava`.`zlava`, `Zlava`.`poznamka_k_zlave`, `Zlava`.`mena` FROM `realcms_zlavy` AS `Zlava` WHERE `Zlava`.`idinzerat` = (1197) 000
149UPDATE `realcms_inzerat` AS `Inzerat` SET `Inzerat`.`zobrazeni` = Inzerat.zobrazeni + 1 WHERE `Inzerat`.`idinzerat` = 119711
150SELECT `Kraj`.`idkraj`, `Kraj`.`nazov`, `Kraj`.`idstat` FROM `realcms_kraje` AS `Kraj` WHERE `Kraj`.`idkraj` = '8' LIMIT 1110
151SELECT `Okres`.`idokres`, `Okres`.`nazov`, `Okres`.`idkraj`, `Okres`.`zobrazeni` FROM `realcms_okresy` AS `Okres` WHERE `Okres`.`idkraj` = ('8') ORDER BY `Okres`.`nazov` ASC 11110
152SELECT `CharKategoria`.`id`, `CharKategoria`.`nazov_ketegorie` FROM `realcms_char_kategorie` AS `CharKategoria` WHERE 1 = 1 550
153SELECT `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` = 1197 AND `Komentar`.`ip_adresa` = '38.107.179.213' 000
154SELECT `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` = 1197 000
155SELECT `ZariadenieDruh`.`id`, `ZariadenieDruh`.`zariadenie`, `ZariadenieDruh`.`alias`, `ZariadenieDruh`.`parent` FROM `realcms_druhy_zariadeni` AS `ZariadenieDruh` WHERE 1 = 1 28280