BAŃSKA BYSTRZYCA - Dwór Tihanych

3.0 (1)

4106 1

foetus Updated Listopad 24, 2019

Napisz relację i oceń atrakcję Dodaj do ulubionych

Opis atrakcji turystycznej

Kraj / Region

Słowacja /

Miejscowość

Banska Bystrzyca

Nazwa atrakcji

Dwór Tihanych

Aktualne ceny

https://ssmuzeum.sk/tihanyiovsky-kastiel-3/

Kategoria

Zabytki, skanseny, muzea, wystawy

Dwór Tihanych (Kaštieľ Tihányiovský) leży w południowej dzielnicy Banskiej Bystrzycy - Radvan (dawniej odrebna miejscowość), nad rzeką Hron. Powstał na początku XVII wieku jako renesansowy dwór obronny rodu Tihany. Po kilku przebudowach, elementy oryginalnego wyglądu można zobaczyć już tylko w części płn.-zach. W 1989 r. otwarto w nim pierwszą wystawę "Przyroda Słowacji Środkowej", w ramach Muzeum Słowacji Środkowej, którego dwór stał się częścią jako placówka z oddziałem przyrodniczym. Do dziś jest to tematem stałej ekspozycji muzeum, złożonej z 2400 eksponatów i podzielonej na 8 części, z której każda omawia środowisko naturalne osobnego regionu Słowacji. W 2006 roku ekspozycja wzbogaciła się o system audio z dźwiękami prezentowanych zwierząt. Poza tym organizowane tu są wystawy czasowe oraz odbywają się spotkania z podróżnikami, konferencje i warsztaty twórcze. Muzeum jest czynne codziennie, przez cały rok w godzinach: pn.-pt.: 8:00-16:00 i so.-nd.: 9:00-16:00. Między 11:30 a 12:30 jest zawsze przerwa.

Photos

Mapa

Swap Start/End Start Address

End

Recenzje użytkowników

Liczba relacji: 1

Ocena atrakcji

3.0(1)

Already have an account?

Imię

Oceny (im wyższa tym lepsza)

Ocena atrakcji

Jak oceniasz tę atrakcję w skali 1-6 ?

Relacja - dodatkowe informacje

+ Zalety

- Wady

Wiek dziecka/i

Wiek dziecka lub dzieci w czasie pobytu w opisywanym miejscu (opcjonalnie).

Data pobytu

Przybliżona data pobytu w opisywanym miejscu, np. lipiec 2016 (ważne jest podanie roku)

Komentarze

You will be able to upload media right after you submit your review.

Zgadzam się na przetwarzanie danych osobowych podanych w tym formularzu. Ich Administratorem będzie serwis Wakacje z dzieciakiem. Dane osobowe przetwarzane będą na podstawie zgody (Art. 6 ust. 1 lit. a RODO) i przechowywane do czasu cofnięcia tej zgody. Pełne informacje na ten temat znajdują się na stronie Regulamin i Polityka Prywatności.

Styczeń 19, 2015 (Updated: Styczeń 19, 2015)

Ocena atrakcji

3.0

Dwór nie jest atrakcyjnym zabytkiem i stoi w dziwnym jak na taką budowlę miejscu - na zwykłym blokowisku. Trzeba kawałek podjechać autem z centrum.
Park zachował się w stanie szczątkowym, pozostaje więc tylko wystawa muzealna. I tu mieliśmy pecha, bo trwała zmiana ekspozycji i było zamknięte. Uprzejma pani wpuściła jednak mnie samego na szybki rekonesans.
Jest to typowe muzeum przyrodnicze, mnóstwo roślin i wypchanych zwierząt, ładne zdjęcia. Wydaje się, że jest ukierunkowane na słowackie wycieczki szkolne i obcy turyści są rzadkością. Tylko 1 sala posiada nowoczesne wyposażenie w postaci systemu audio odtwarzającego odgłosy różnych zwierząt, niestety było to wyłączone. Reszta to tradycyjne gablotki, czasem ze szkłem powiększającym. Jak na dzisiejsze czasy, ekspozycja nie zachwyca, ale może po zmianie jest już lepsza...

Relacja - dodatkowe informacje

Wiek dziecka/i

5 lat

Data pobytu

czerwiec 2013

foetus

Zgłoś tę recenzję Komentarze (0) | Czy ta relacja była pomocna? 0 0

S2Framework Debug Console

Database Queries (28)

SET SQL_BIG_SELECTS=1

SHOW TABLES LIKE '%_jreviews_config'

SELECT value FROM zcik5_jreviews_config WHERE id = 'cms_secret'

SELECT name FROM zcik5_jreviews_addons WHERE state = 1 ORDER BY ordering

SELECT id, language FROM zcik5_menu WHERE link LIKE "%com_kunena&view=user" AND published = 1 AND type = "component"

SELECT count(*) FROM zcik5_jreviews_categories AS JreviewCategory WHERE JreviewCategory.id = 248 AND JreviewCategory.option = 'com_content' AND JreviewCategory.criteriaid > 0

SELECT JreviewsCategory.id FROM zcik5_jreviews_categories AS JreviewsCategory LEFT JOIN zcik5_categories AS Category On JreviewsCategory.id = Category.id WHERE JreviewsCategory.`option`= "com_content" AND Category.published >= 0 AND Category.access IN ( 1,5)

SELECT Listing.id AS `Listing.listing_id`, Listing.alias AS `Listing.slug`, Listing.title AS `Listing.title`, Listing.introtext AS `Listing.summary`, Listing.fulltext AS `Listing.description`, Listing.images AS `Listing.images`, Listing.hits AS `Listing.hits`, Listing.catid AS `Listing.cat_id`, Listing.created_by AS `Listing.user_id`, Listing.created_by_alias AS `Listing.author_alias`, Listing.created AS `Listing.created`, Listing.modified AS `Listing.modified`, Listing.access AS `Listing.access`, Listing.state AS `Listing.state`, Listing.publish_up AS `Listing.publish_up`, Listing.publish_down AS `Listing.publish_down`, Listing.metakey AS `Listing.metakey`, Listing.metadesc AS `Listing.metadesc`, 'com_content' AS `Listing.extension`, Field.featured AS `Listing.featured`, JreviewsCategory.criteriaid AS `ListingType.listing_type_id`, Category.id AS `Category.cat_id`, Category.title AS `Category.title`, Category.alias AS `Category.slug`, Category.access AS `Category.access`, Category.params AS `Category.params`, Directory.id AS `Directory.dir_id`, Directory.title AS `Directory.title`, Directory.slug AS `Directory.slug`, User.id AS `User.user_id`, User.name AS `User.name`, User.username AS `User.username`, User.email AS `User.email`, User.block AS `User.block`, Claim.approved AS `Claim.approved`, Totals.user_rating AS `Review.user_rating`, Totals.user_rating_count AS `Review.user_rating_count`, Totals.user_criteria_rating AS `Review.user_criteria_rating`, Totals.user_criteria_rating_count AS `Review.user_criteria_rating_count`, Totals.user_comment_count AS `Review.user_review_count`, Totals.editor_rating AS `Review.editor_rating`, Totals.editor_rating_count AS `Review.editor_rating_count`, Totals.editor_criteria_rating AS `Review.editor_criteria_rating`, Totals.editor_criteria_rating_count AS `Review.editor_criteria_rating_count`, Totals.editor_comment_count AS `Review.editor_review_count`, Totals.media_count AS `Listing.media_count`, Totals.video_count AS `Listing.video_count`, Totals.photo_count AS `Listing.photo_count`, Totals.audio_count AS `Listing.audio_count`, Totals.attachment_count AS `Listing.attachment_count`, (Totals.media_count - Totals.media_count_user) AS `Listing.media_count_owner`, (Totals.video_count - Totals.video_count_user) AS `Listing.video_count_owner`, (Totals.photo_count - Totals.photo_count_user) AS `Listing.photo_count_owner`, (Totals.audio_count - Totals.audio_count_user) AS `Listing.audio_count_owner`, (Totals.attachment_count - Totals.attachment_count_user) AS `Listing.attachment_count_owner`, Totals.media_count_user AS `Listing.media_count_user`, Totals.video_count_user AS `Listing.video_count_user`, Totals.photo_count_user AS `Listing.photo_count_user`, Totals.audio_count_user AS `Listing.audio_count_user`, Totals.attachment_count_user AS `Listing.attachment_count_user`, Field.jr_latitude AS `Geomaps.lat`, Field.jr_longtitude AS `Geomaps.lon`, JreviewsCategory.marker_icon AS `Geomaps.marker_icon` FROM zcik5_content AS Listing LEFT JOIN zcik5_jreviews_listing_totals AS Totals ON Totals.listing_id = Listing.id AND Totals.extension = 'com_content' LEFT JOIN zcik5_jreviews_content AS Field ON Field.contentid = Listing.id LEFT JOIN zcik5_jreviews_categories AS JreviewsCategory ON JreviewsCategory.id = Listing.catid AND JreviewsCategory.`option` = 'com_content' LEFT JOIN zcik5_categories AS Category ON Category.id = Listing.catid AND Category.extension = 'com_content' LEFT JOIN zcik5_jreviews_directories AS Directory ON Directory.id = JreviewsCategory.dirid LEFT JOIN zcik5_users AS User ON User.id = Listing.created_by LEFT JOIN zcik5_jreviews_claims AS Claim ON Claim.listing_id = Listing.id AND Claim.user_id = Listing.created_by AND Claim.approved = 1 WHERE 1 = 1 AND ( (Listing.id = 591) AND Listing.catid IN (77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,106,119,123,128,129,131,132,133,138,145,146,150,159,160,166,217,221,236,248,249,252,257,258,271,277,278,280,815,816) AND Listing.state >= 0 )

SELECT groupid FROM zcik5_jreviews_groups WHERE groupid IN (1,2) AND type = 'content'

SELECT Field.fieldid AS `Field.field_id`, Field.groupid AS `Field.group_id`, Field.name AS `Field.name`, Field.title AS `Field.title`, Field.showtitle AS `Field.showTitle`, Field.description AS `Field.description`, Field.required AS `Field.required`, Field.type AS `Field.type`, Field.location AS `Field.location`, Field.options AS `Field.params`, Field.contentview AS `Field.contentView`, Field.listview AS `Field.listView`, Field.compareview AS `Field.compareView`, Field.listsort AS `Field.listSort`, Field.search AS `Field.search`, Field.access AS `Field.access`, Field.access_view AS `Field.accessView`, Field.published As `Field.published`, Field.ordering AS `Field.ordering`, `Group`.groupid AS `Group.group_id`, `Group`.title AS `Group.title`, `Group`.name AS `Group.name`, `Group`.showtitle AS `Group.showTitle`, `Group`.ordering AS `Group.ordering`, `Group`.control_field AS `Group.control_field`, `Group`.control_value AS `Group.control_value` FROM zcik5_jreviews_fields AS Field LEFT JOIN zcik5_jreviews_groups AS `Group` ON `Group`.groupid = Field.groupid WHERE Field.published = 1 AND Field.location = 'content' AND Field.groupid IN ( 1)

SELECT Listing.contentid AS element_id,jr_miejscowosc,jr_dokadnyadres,jr_kraj,jr_latitude,jr_longtitude,jr_nazwa,jr_woj,jr_aktualnycennik,jr_dodatkowycennik,jr_dodatkoweinfoo,jr_adres,jr_kategoria,jr_noclegrezerwuje,jr_jrnoclegibooking,jr_szczegoowyopis,jr_dostpno,jr_rekomendacja,jr_miejscowoscwoj,jr_emoji,jr_emoji2,jr_telefon FROM zcik5_jreviews_content AS Listing WHERE Listing.contentid IN (591)

SELECT * FROM zcik5_jreviews_fieldoptions WHERE fieldid IN ( '16','22','29','60') AND value IN ( 'banska-bystrzyca','zabytki-muzea-skanseny','rok','zla','amphora','classical-building') ORDER BY ordering ASC ,optionid ASC

SELECT content_id AS listing_id, count(*) AS favored FROM zcik5_jreviews_favorites AS Favorite WHERE Favorite.content_id IN (591) GROUP BY listing_id

SELECT tmp.media_id, tmp.listing_id, tmp.review_id, tmp.media_type, tmp.media_function, tmp.likes_rank, tmp.main_media, media.likes_up, media.likes_total, media.created, media.listing_id, media.review_id, media.user_id, media.filename, media.file_extension, media.rel_path, media.title, media.description, media.duration, media.media_info, media.metadata, media.embed, media.published, media.approved, media.access, media.views, media.filesize, media.extension FROM ( SELECT media_id, listing_id, review_id, media_type, media_function, main_media, views, likes_rank, created, ordering, CASE WHEN @id != listing_id AND media_type = 'photo' THEN @photo := 1 ELSE IF(media_type = 'photo' ,@photo := @photo + 1,NULL) END AS photo_rank, CASE WHEN @id != listing_id AND media_type = 'video' THEN @video := 1 ELSE IF(media_type = 'video' ,@video := @video + 1,NULL) END AS video_rank, CASE WHEN @id != listing_id AND media_type = 'attachment' THEN @attachment := 1 ELSE IF(media_type = 'attachment',@attachment := @attachment + 1,NULL) END AS attachment_rank, CASE WHEN @id != listing_id AND media_type = 'audio' THEN @audio := 1 ELSE IF(media_type = 'audio',@audio := @audio + 1,NULL) END AS audio_rank, @id := listing_id FROM ( SELECT media_id, review_id, listing_id, user_id, media_type, media_function, likes_rank, likes_up, likes_total, created, main_media, ordering, views FROM zcik5_jreviews_media WHERE listing_id IN (591) AND published = 1 AND approved = 1 AND access IN (1,5) AND extension = 'com_content' ) mtmp JOIN (SELECT @id := NULL, @photo := 0, @video := 0, @attachment := 0, @audio := 0) r ORDER BY main_media DESC, listing_id, media_type, ordering ) tmp JOIN zcik5_jreviews_media AS media ON media.media_id = tmp.media_id WHERE (tmp.photo_rank >= 0) OR (tmp.video_rank >= 0) OR (tmp.attachment_rank > 0) OR (tmp.audio_rank > 0) ORDER BY tmp.main_media DESC, tmp.listing_id, tmp.media_type, tmp.ordering

SELECT Community.userid AS `Community.user_id`, Community.userid AS `Community.community_user_id`, Community.userid AS `User.user_id`, Community.avatar AS `Community.avatar`, User.name AS `User.name`, User.username AS `User.username`, User.block As `User.block`, User.name AS `User.email` FROM zcik5_kunena_users AS Community LEFT JOIN zcik5_users AS User ON Community.userid = User.id WHERE 1 = 1 AND ( Community.userid IN (46) )

SELECT rating_range, count(*) AS count FROM (SELECT CASE WHEN ROUND(rating,1) > 0 AND rating < 1.8 THEN 1 WHEN ROUND(rating,1) >= 1.8 AND ROUND(rating,1) < 3 THEN 2 WHEN ROUND(rating,1) >= 3 AND ROUND(rating,1) < 4.2 THEN 3 WHEN ROUND(rating,1) >= 4.2 AND ROUND(rating,1) < 5.4 THEN 4 WHEN ROUND(rating,1) >= 5.4 THEN 5 END as rating_range FROM zcik5_jreviews_comments WHERE pid = 591 AND published = 1 AND mode = 'com_content' AND rating > 0 AND author = 0 ) AS ReviewRange GROUP BY rating_range

SELECT media_id from zcik5_jreviews_media WHERE listing_id = 591 AND main_media = 1 ORDER BY media_id ASC LIMIT 1

UPDATE zcik5_jreviews_media SET main_media = 0 WHERE listing_id = 591 and review_id = 0 and media_id != 2541

SELECT images FROM zcik5_content WHERE id = 591

SELECT Review.id AS `Review.review_id`, Review.pid AS `Review.listing_id`, Review.mode AS `Review.extension`, Review.created AS `Review.created`, Review.modified AS `Review.modified`, Review.userid AS `Review.user_id`, User.id AS `User.user_id`, CASE WHEN CHAR_LENGTH(User.name) THEN User.name ELSE Review.name END AS `User.name`, CASE WHEN CHAR_LENGTH(User.username) THEN User.username ELSE Review.username END AS `User.username`, User.block AS `User.block`, Review.email AS `User.email`, Review.ipaddress AS `User.ipaddress`, ReviewerRank.`rank` AS `User.reviewer_rank`, ReviewerRank.reviews AS `User.review_count`, Review.title AS `Review.title`, Review.comments AS `Review.comments`, Review.posts AS `Review.posts`, Review.author AS `Review.editor`, Review.published AS `Review.published`, IF(Review.rating=0,"na",Review.rating) AS `Rating.average_rating`, Review.vote_helpful AS `Vote.yes`, (Review.vote_total - Review.vote_helpful) AS `Vote.no`, (Review.vote_helpful/Review.vote_total)*Review.vote_helpful AS `Vote.helpful`, Review.owner_reply_text AS `Review.owner_reply_text`, Review.owner_reply_approved AS `Review.owner_reply_approved`, Review.owner_reply_created AS `Review.owner_reply_created`, Review.media_count AS `Review.media_count`, Review.video_count AS `Review.video_count`, Review.photo_count AS `Review.photo_count`, Review.audio_count AS `Review.audio_count`, Review.attachment_count AS `Review.attachment_count`, Review.listing_type_id AS `ListingType.listing_type_id`, Review.owner_reply_approved As `Review.owner_reply_approved`, Review.owner_reply_text As `Review.owner_reply_text` FROM zcik5_jreviews_comments AS Review LEFT JOIN zcik5_users AS User ON Review.userid = User.id LEFT JOIN zcik5_jreviews_reviewer_ranks AS ReviewerRank ON Review.userid = ReviewerRank.user_id LEFT JOIN zcik5_content AS Listing ON Listing.id = Review.pid LEFT JOIN zcik5_jreviews_listing_totals AS Totals ON Totals.listing_id = Review.pid AND Totals.extension = 'com_content' LEFT JOIN zcik5_jreviews_categories AS JreviewsCategory ON JreviewsCategory.id = Listing.catid AND JreviewsCategory.`option` = 'com_content' WHERE 1 = 1 AND ( Review.pid = 591 AND Review.mode = 'com_content' AND Review.published = 1 AND Review.author = 0 AND JreviewsCategory.option = 'com_content' ) ORDER BY `Review.created` DESC LIMIT 20

SELECT review_id, criteria_id, IF(rating=0,'na',rating) AS rating FROM zcik5_jreviews_review_ratings WHERE review_id IN (473)

SELECT tmp.media_id, tmp.listing_id, tmp.review_id, tmp.media_type, tmp.media_function, tmp.likes_rank, tmp.main_media, media.likes_up, media.likes_total, media.created, media.listing_id, media.review_id, media.user_id, media.filename, media.file_extension, media.rel_path, media.title, media.description, media.duration, media.media_info, media.metadata, media.embed, media.published, media.approved, media.access, media.views, media.filesize, media.extension FROM ( SELECT media_id, listing_id, review_id, media_type, media_function, main_media, views, likes_rank, created, ordering, CASE WHEN @id != review_id AND media_type = 'photo' THEN @photo := 1 ELSE IF(media_type = 'photo' ,@photo := @photo + 1,NULL) END AS photo_rank, CASE WHEN @id != review_id AND media_type = 'video' THEN @video := 1 ELSE IF(media_type = 'video' ,@video := @video + 1,NULL) END AS video_rank, CASE WHEN @id != review_id AND media_type = 'attachment' THEN @attachment := 1 ELSE IF(media_type = 'attachment',@attachment := @attachment + 1,NULL) END AS attachment_rank, CASE WHEN @id != review_id AND media_type = 'audio' THEN @audio := 1 ELSE IF(media_type = 'audio',@audio := @audio + 1,NULL) END AS audio_rank, @id := review_id FROM ( SELECT media_id, review_id, listing_id, user_id, media_type, media_function, likes_rank, likes_up, likes_total, created, main_media, ordering, views FROM zcik5_jreviews_media WHERE review_id IN (473) AND published = 1 AND approved = 1 AND access IN (1,5) ) mtmp JOIN (SELECT @id := NULL, @photo := 0, @video := 0, @attachment := 0, @audio := 0) r ORDER BY main_media DESC, review_id, media_type, ordering ) tmp JOIN zcik5_jreviews_media AS media ON media.media_id = tmp.media_id WHERE (tmp.photo_rank >= 0) OR (tmp.video_rank >= 0) OR (tmp.attachment_rank > 0) OR (tmp.audio_rank > 0) ORDER BY tmp.main_media DESC, tmp.review_id, tmp.media_type, tmp.ordering

SELECT groupid FROM zcik5_jreviews_groups WHERE groupid IN (1,2) AND type = 'review'

SELECT Review.reviewid AS element_id,jr_zalety,jr_wady,jr_wiekdzieckadzieci,jr_datapobytu FROM zcik5_jreviews_review_fields AS Review WHERE Review.reviewid IN (473)

SELECT Field.fieldid AS `Field.id`, Field.groupid AS `Field.groupid`, Field.name AS `Field.name`, Field.title AS `Field.title`, Field.showtitle AS `Field.showTitle`, Field.description AS `Field.description`, Field.required AS `Field.required`, Field.type AS `Field.type`, Field.location AS `Field.location`, Field.options AS `Field.params`, Field.search AS `Field.search`, Field.access AS `Field.access`, Field.access_view AS `Field.accessView`, Field.published As `Field.published`, Field.compareview AS `Field.compareView`, Field.control_field AS `Field.control_field`, Field.control_value AS `Field.control_value`, `Group`.groupid AS `Group.group_id`, `Group`.title AS `Group.title`, `Group`.name AS `Group.name`, `Group`.showtitle AS `Group.showTitle`, `Group`.control_field AS `Group.control_field`, `Group`.control_value AS `Group.control_value` FROM zcik5_jreviews_fields AS Field INNER JOIN zcik5_jreviews_groups AS `Group` ON (`Group`.groupid = Field.groupid AND `Group`.groupid IN (2) AND `Group`.type = 'review' ) WHERE Field.published = 1 AND Field.location = 'review' GROUP BY Field.fieldid, Field.groupid, Field.name, Field.title, Field.showtitle, Field.description, Field.required, Field.type, Field.location, Field.options, Field.search, Field.access, Field.access_view, Field.published, Field.compareview, Field.control_field, Field.control_value, Field.ordering, `Group`.groupid, `Group`.title, `Group`.name, `Group`.showtitle, `Group`.control_field, `Group`.control_value, `Group`.ordering ORDER BY `Group`.ordering, Field.ordering

SELECT Listing.catid FROM zcik5_content AS Listing RIGHT JOIN zcik5_jreviews_categories AS Category ON Listing.catid = Category.id AND Category.option = 'com_content' WHERE Listing.id = 591

SELECT Category.id AS `Category.cat_id`, Category.title AS `Category.title`, Category.alias AS `Category.slug`, Category.description AS `Category.description`, Category.level AS `Category.level`, Category.params AS `Category.params`, Category.parent_id AS `Category.parent_id`, JreviewsCategory.tmpl AS `Category.tmpl`, JreviewsCategory.tmpl_suffix AS `Category.tmpl_suffix`, Directory.id AS `Directory.dir_id`, Directory.slug AS `Directory.slug`, Directory.title AS `Directory.title`, Directory.description AS `Directory.description`, JreviewsCategory.criteriaid AS `ListingType.listing_type_id` FROM zcik5_categories AS Category INNER JOIN zcik5_jreviews_categories AS JreviewsCategory ON Category.id = JreviewsCategory.id AND JreviewsCategory.option = "com_content" LEFT JOIN zcik5_jreviews_directories AS Directory ON JreviewsCategory.dirid = Directory.id WHERE 1 = 1 AND ( Category.id=248 )

BAŃSKA BYSTRZYCA - Dwór Tihanych

Opis atrakcji turystycznej

Photos

Mapa

Recenzje użytkowników

Relacja - dodatkowe informacje

Spis treści

Spis atrakcji wg lokalizacji

S2Framework Debug Console

Database Queries (28)

Zaloguj się

Resetowanie hasła

Przypomnienie

BAŃSKA BYSTRZYCA - Dwór Tihanych

Opis atrakcji turystycznej

Photos

Mapa

Recenzje użytkowników

Relacja - dodatkowe informacje

Spis treści

Spis atrakcji wg lokalizacji

S2Framework Debug Console

Database Queries (28)