▼

Vyhľadávanie

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

Počet prístupov: 4 993 427
Aktuality

Billboardová kampaň december 2009 - január 2010

16.12.2009 20:17

Trnava 2

 

16.12.2009 20:17

Trnava 1

 

16.12.2009 20:16

Varín, okr. Žilina

 

16.12.2009 20:16

Vrútky

 

 

16.12.2009 20:15

Vrútky 2

16.12.2009 20:15

Zvolen Metro

 

16.12.2009 20:14

Žiar nad Hronom

 

16.12.2009 20:13

Žilina

 

16.12.2009 20:12

Žilina 2

 

16.12.2009 20:18

Trenčín

 

1 | 2 | 3 | 4 | 5 Ďalej »

Podsekcie

Bilboardová kampaň júl- august 2010 Billboardy december 2010 Billboardová kampaň december 2009 - január 2010 Billboardová kampaň február - marec 2010 Obchodní zástupcovia
facebooktwitter
(default) 73 queries took 168 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `realcms_pobocky`12122
2DESCRIBE `realcms_uzivatel`21213
3DESCRIBE `realcms_cms_kategorie`11112
4DESCRIBE `realcms_cms_clanky`992
5DESCRIBE `realcms_kraje`331
6DESCRIBE `realcms_okresy`441
7DESCRIBE `realcms_obce`441
8DESCRIBE `realcms_druhy`441
9DESCRIBE `realcms_inzerat`37373
10DESCRIBE `realcms_zakaznik`43434
11DESCRIBE `realcms_platnost_inzeratu`661
12DESCRIBE `realcms_restaurant_opening_hours`771
13DESCRIBE `realcms_restaurant_details`551
14DESCRIBE `realcms_restaurant_menus`12122
15DESCRIBE `realcms_restaurant_payments`331
16DESCRIBE `realcms_restaurant_payment_types`331
17DESCRIBE `realcms_charakteristiky`551
18DESCRIBE `realcms_char`551
19DESCRIBE `realcms_char_kategorie`221
20DESCRIBE `realcms_obrazok`771
21DESCRIBE `realcms_komentare`772
22DESCRIBE `realcms_strava_inzeraty`331
23DESCRIBE `realcms_stravovanie`331
24DESCRIBE `realcms_ceny`772
25DESCRIBE `realcms_meny`441
26DESCRIBE `realcms_ceny_nazvy`331
27DESCRIBE `realcms_zlavy`661
28DESCRIBE `realcms_zlavy_nazvy`331
29DESCRIBE `realcms_inzerat_vzdialenosti`551
30DESCRIBE `realcms_inzerat_vzdialenosti_mesta`551
31DESCRIBE `realcms_mesta`551
32DESCRIBE `realcms_banery`331
33DESCRIBE `realcms_banery_hlavna_stranka`221
34DESCRIBE `realcms_jazyky`331
35DESCRIBE `realcms_wysiwyg`661
36DESCRIBE `realcms_druhy_zariadeni`441
37DESCRIBE `realcms_web_pristupy`441
38SELECT `Jazyk`.`id`, `Jazyk`.`jazyk`, `Jazyk`.`jazyk_slovom` FROM `realcms_jazyky` AS `Jazyk` WHERE `Jazyk`.`jazyk` = 'svk' LIMIT 1110
39SELECT `Texty`.`nadpis`, `Texty`.`name` FROM `realcms_wysiwyg` AS `Texty` WHERE `Texty`.`jazyk_id` = 1 770
40INSERT DELAYED INTO `realcms_web_pristupy` (`ip_adresa`, `created`) VALUES ('38.107.179.210', '2012-02-10 14:19:15') ON DUPLICATE KEY UPDATE pocet_pristupov=pocet_pristupov+120
41SELECT SUM(pocet_pristupov) AS pocet FROM `realcms_web_pristupy` AS `Pristup` WHERE 1 = 1 LIMIT 111115
42SELECT `Druh`.`iddruh`, `Druh`.`druh`, `Druh`.`zobrazeni`, `Druh`.`cena` FROM `realcms_druhy` AS `Druh` WHERE 1 = 1 12120
43SELECT `Stravovanie`.`id`, `Stravovanie`.`nazov_stravovania`, `Stravovanie`.`order` FROM `realcms_stravovanie` AS `Stravovanie` WHERE 1 = 1 440
44SELECT `Kraj`.`idkraj`, `Kraj`.`nazov`, `Kraj`.`idstat` FROM `realcms_kraje` AS `Kraj` WHERE `Kraj`.`idstat` = 'SK' 880
45SELECT `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
46SELECT `ZariadenieDruh`.`id`, `ZariadenieDruh`.`zariadenie`, `ZariadenieDruh`.`alias`, `ZariadenieDruh`.`parent` FROM `realcms_druhy_zariadeni` AS `ZariadenieDruh` WHERE `ZariadenieDruh`.`parent` = 0 ORDER BY `ZariadenieDruh`.`zariadenie` ASC 16160
47SELECT `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
48SELECT `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 3331
49SELECT `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
50SELECT `Obec`.`idobec`, `Obec`.`nazov_obce`, `Obec`.`idokres`, `Obec`.`psc` FROM `realcms_obce` AS `Obec` WHERE `Obec`.`idobec` = 524077 110
51SELECT `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
52SELECT `RestaurantDetail`.`id`, `RestaurantDetail`.`ad_id`, `RestaurantDetail`.`contact`, `RestaurantDetail`.`created`, `RestaurantDetail`.`modified` FROM `realcms_restaurant_details` AS `RestaurantDetail` WHERE `RestaurantDetail`.`ad_id` = (1888) 000
53SELECT `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
54SELECT `RestaurantPayment`.`id`, `RestaurantPayment`.`ad_id`, `RestaurantPayment`.`payment_type_id` FROM `realcms_restaurant_payments` AS `RestaurantPayment` WHERE `RestaurantPayment`.`ad_id` = (1888) 000
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` = 2292 110
56SELECT `Obec`.`idobec`, `Obec`.`nazov_obce`, `Obec`.`idokres`, `Obec`.`psc` FROM `realcms_obce` AS `Obec` WHERE `Obec`.`idobec` = 505285 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` = (2292) 000
58SELECT `RestaurantDetail`.`id`, `RestaurantDetail`.`ad_id`, `RestaurantDetail`.`contact`, `RestaurantDetail`.`created`, `RestaurantDetail`.`modified` FROM `realcms_restaurant_details` AS `RestaurantDetail` WHERE `RestaurantDetail`.`ad_id` = (2292) 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` = (2292) 000
60SELECT `RestaurantPayment`.`id`, `RestaurantPayment`.`ad_id`, `RestaurantPayment`.`payment_type_id` FROM `realcms_restaurant_payments` AS `RestaurantPayment` WHERE `RestaurantPayment`.`ad_id` = (2292) 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` = 1936 110
62SELECT `Obec`.`idobec`, `Obec`.`nazov_obce`, `Obec`.`idokres`, `Obec`.`psc` FROM `realcms_obce` AS `Obec` WHERE `Obec`.`idobec` = 510998 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` = (1936) 000
64SELECT `RestaurantDetail`.`id`, `RestaurantDetail`.`ad_id`, `RestaurantDetail`.`contact`, `RestaurantDetail`.`created`, `RestaurantDetail`.`modified` FROM `realcms_restaurant_details` AS `RestaurantDetail` WHERE `RestaurantDetail`.`ad_id` = (1936) 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` = (1936) 000
66SELECT `RestaurantPayment`.`id`, `RestaurantPayment`.`ad_id`, `RestaurantPayment`.`payment_type_id` FROM `realcms_restaurant_payments` AS `RestaurantPayment` WHERE `RestaurantPayment`.`ad_id` = (1936) 000
67SELECT `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
68SELECT `CmsKategoria`.`id`, `CmsKategoria`.`nazov`, `CmsKategoria`.`alias`, `CmsKategoria`.`autor`, `CmsKategoria`.`parent_id`, `CmsKategoria`.`typ`, `CmsKategoria`.`publikovana`, `CmsKategoria`.`datum_vytvorene`, `CmsKategoria`.`datum_zmenene`, `CmsKategoria`.`zoradenie`, `CmsKategoria`.`idRK` FROM `realcms_cms_kategorie` AS `CmsKategoria` WHERE `parent_id` = 0 AND `publikovana` = 1 AND `idrk` = 116 ORDER BY `zoradenie` ASC 110
69SELECT `CmsClanok`.`id`, `CmsClanok`.`nazov`, `CmsClanok`.`alias`, `CmsClanok`.`text`, `CmsClanok`.`vytvorene`, `CmsClanok`.`zmenene`, `CmsClanok`.`autor`, `CmsClanok`.`kategoria_id`, `CmsClanok`.`zoradenie` FROM `realcms_cms_clanky` AS `CmsClanok` WHERE `CmsClanok`.`kategoria_id` = (1) ORDER BY `vytvorene` DESC 110
70SELECT `CmsPodkategoria`.`id`, `CmsPodkategoria`.`nazov`, `CmsPodkategoria`.`alias`, `CmsPodkategoria`.`autor`, `CmsPodkategoria`.`parent_id`, `CmsPodkategoria`.`typ`, `CmsPodkategoria`.`publikovana`, `CmsPodkategoria`.`datum_vytvorene`, `CmsPodkategoria`.`datum_zmenene`, `CmsPodkategoria`.`zoradenie`, `CmsPodkategoria`.`idRK` FROM `realcms_cms_kategorie` AS `CmsPodkategoria` WHERE `publikovana` = 1 AND `CmsPodkategoria`.`parent_id` = (1) ORDER BY `CmsPodkategoria`.`zoradenie` ASC 440
71SELECT `CmsKategoria`.`id`, `CmsKategoria`.`nazov`, `CmsKategoria`.`alias`, `CmsKategoria`.`autor`, `CmsKategoria`.`parent_id`, `CmsKategoria`.`typ`, `CmsKategoria`.`publikovana`, `CmsKategoria`.`datum_vytvorene`, `CmsKategoria`.`datum_zmenene`, `CmsKategoria`.`zoradenie`, `CmsKategoria`.`idRK` FROM `realcms_cms_kategorie` AS `CmsKategoria` WHERE `CmsKategoria`.`alias` = 'billboardova-kampan-januar' AND `publikovana` = 1 AND `idrk` = 116 ORDER BY `zoradenie` ASC LIMIT 1111
72SELECT COUNT(*) AS `count` FROM `realcms_cms_clanky` AS `CmsClanok` WHERE `CmsClanok`.`kategoria_id` = 8 110
73SELECT `CmsClanok`.`nazov`, `CmsClanok`.`alias`, `CmsClanok`.`text`, `CmsClanok`.`vytvorene` FROM `realcms_cms_clanky` AS `CmsClanok` WHERE `CmsClanok`.`kategoria_id` = 8 LIMIT 1010101