GYULA - Miejscowość turystyczna

4.0 (1)

3392 1

foetus Updated Listopad 23, 2019

Napisz relację i oceń atrakcję Dodaj do ulubionych

Opis atrakcji turystycznej

Kraj / Region

Węgry /

Miejscowość

Gyula

Nazwa atrakcji

Miejscowość turystyczna

Kategoria

Miejscowości

Gyula to ok. 35-tysięczne miasto na południowo-wschodnich krańcach Węgier. W XVI i XVII stuleciu była pod okupacją turecką a od roku 1715 posiadała status stolicy województwa, utracony po II wojnie św. Oprócz Węgrów zamieszkują ją Rumuni i Niemcy (kiedyś należała do nich osobna część miasta). Pozostałością bogatej historii jest dobrze zachowany średniowieczny zamek, zamieniony na muzeum i instytucję kulturalną - odbywają się tu przedstawienia w ramach Teatru Zamkowego i Festiwalu Szekspirowskiego. Wizytówką Gyuli jest kompleks termalny Varfurdo, powstały w dawnym parku przyzamkowym. Oferuje on kąpielisko otwarte i kryty aquapark oraz liczne zabiegi lecznicze i relaksacyjne. Regionalnym produktem, z którego słynie miasto to dobrze przyprawiona kiełbasa (Gyulai Kolbasz), której przepis powstał w końcu XIX w. Produkt zyskał popularność dzięki rzeźnikowi J. Balongowi, który w 1910 r. otrzymał za niego I nagrodę na targach w Brukseli oraz jego uczniowi A . Steberlowi, który dostał tę samą nagrodę w 1935 r. Przez miasto (obrzeżami) przepływają 2 rzeki: Feher i Fekete Koros, a przez jego środek w XVIII wieku poprowadzono sztuczny kanał Eloviz-csatorna łączacy 3 miejscowości: Gyula, Békéscsaba i Békés.

Photos

Mapa

Swap Start/End Start Address

End

Recenzje użytkowników

Liczba relacji: 1

Ocena atrakcji

4.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.

Marzec 14, 2016 (Updated: Marzec 15, 2016)

Ocena atrakcji

4.0

Gyula to małe miasto z dużym basenem. Znajduje się on w centrum, między zamkiem, a starówką. Są to główne punkty turystyczne Gyuli, więc najlepiej znaleźć nocleg koło kąpieliska, aby wszędzie mieć blisko (tutejszy basen nie posiada własnego kempingu). Zamek to jednorazowa atrakcja, ale mieszcząca się w jego bastionie knajpa/restauracja na wolnym powietrzu to fajne miejsce na spędzenie wieczoru. My byliśmy podczas Mundialu w Brazylii i transmitowano tu mecze na wielkim telebimie. Przychodziło mnóstwo ludzi, ale było dużo wystawionych stolików. Poza tym na stawie zamkowym jest scena, więc pewnie są tam organizowane jakieś koncerty czy przedstawienia. Dziedziniec zamku też bywa przystosowywany na scenę teatralną w weekendy, co może nieco popsuć (tak jak nam) zwiedzanie zabytku.
Starówka Gyuli nie jest specjalnie atrakcyjna. Najciekawszym elementem jest most na kanale wodnym, wyglądający jak średniowieczna budowla między ceglanymi wieżami, ale powstał on w XIX wieku. W jego otoczeniu, a także nad samą wodą działa w sumie kilka małych, przyjemnych knajpek, ale nie ma ich za wiele. Za mostem jest większa restauracja i 2 bardzo ładne fontanny. Jedna na rondzie, więc niedostępna, a druga znacznie większa o podłużnym kształcie z płytką wodą stała się jednym z symboli miasta, bo umieszcza się ją na pocztówkach i folderach. Przypomina fontannę chodnikową i mogłaby być świetnym miejscem do zabawy dla dzieci, ale zawsze gdy tam przychodziliśmy po godz. 20 była już wyłączona - kompletny nonsens!!
Dalej są punkty z fastfoodami, w tym bardzo popularna hamburgerownia. Trafiają się tu duże kolejki, ale warto spróbować ich jedzenia. Podobnie jak miejscowych pikantnych kiełbas Gyulai Kolbasz - pewnie da się je dostać gdzieś w centrum, ale my poszliśmy na łatwiznę i kupiliśmy po prostu w markecie Tesco (ul. Csabai 3). Trzymając się gastronomii, Gyula słynie również ze stuletniej cukierni, ale za późno się zorientowaliśmy i była już zamknięta.
Wspomniany kanał wodny przepływa przez całe miasto i dodaje mu sporo uroku. Można na nim popływać wypożyczonym sprzętem, ale patrząc z mostu przy basenie jak duże i gęste trawy rosną w wodzie, myślę że dla turystów jest przeznaczony tylko niewielki akwen. Jednak i tak wydaje się to ciekawszą atrakcją niż pływanie po niewielkim stawie zamkowym. Na przeciw basenu, przy drodze prowadzącej do zamku (ul. Part) znajduje się plac z dmuchańcami dla dzieci, ale był otwarty w takich godzinach, że nie mieliśmy kiedy z niego skorzystać.
Ogólnie miejscowość jest dobra na długi weekend, ale na dłużej byłoby tu nudno. Mimo rozreklamowania, m.in. przez Makłowicza, nie oferuje turystom zbyt wiele (poza super basenem). Na obrzeżach miasta widać ścieżki rowerowe, więc być może miłośnicy 2 kółek znajdą tu jakieś fajne trasy. Położenie również nie jest jej atutem. Leży daleko od Polski, a w najbliższej okolicy nie znalazłem żadnych atrakcji, poza nieco już oddalonym kompleksem termalnym w Oroshaza. Granica z Rumunią jest o rzut beretem, ale i po tamtej stronie nie ma w pobliżu nic ciekawego.

Relacja - dodatkowe informacje

Wiek dziecka/i

6 lat

Data pobytu

czerwiec 2014

foetus

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

S2Framework Debug Console

Database Queries (77)

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"

INSERT INTO zcik5_jreviews_config ( id, value ) VALUES ('media_likes_rebuild_last','1789852973') ON DUPLICATE KEY UPDATE value = VALUES(value)

SELECT * FROM zcik5_jreviews_config AS `Config`

INSERT INTO zcik5_jreviews_media (media_id, likes_up, likes_total) (SELECT media_id AS media_id, SUM(IF(vote = 1, 1, 0)) AS likes_up, COUNT(*) AS likes_total FROM zcik5_jreviews_media_likes GROUP BY media_id ORDER BY NULL ) ON DUPLICATE KEY UPDATE likes_up = VALUES(likes_up), likes_total = VALUES(likes_total);

SELECT @max_likes := MAX(likes_total) FROM zcik5_jreviews_media;

INSERT INTO zcik5_jreviews_media (media_id, likes_rank) (SELECT media_id AS media_id, (SUM(IF(vote = 1, 1,0))/COUNT(*)) * (COUNT(*)/@max_likes) * 16000000 AS likes_rank FROM zcik5_jreviews_media_likes GROUP BY media_id ORDER BY NULL ) ON DUPLICATE KEY UPDATE likes_rank = VALUES(likes_rank);

SELECT count(*) FROM zcik5_jreviews_categories AS JreviewCategory WHERE JreviewCategory.id = 277 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 = 675) 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 path FROM zcik5_categories WHERE id = 277

SELECT id AS cat_id, lft FROM zcik5_categories WHERE path IN ( 'swiat','swiat/wegry')

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 (675)

SELECT * FROM zcik5_jreviews_fieldoptions WHERE fieldid IN ( '16','22','60') AND value IN ( 'gyula','miejscowoci','cityscape') 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 (675) 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 (675) 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 = 675 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 = 675 AND main_media = 1 ORDER BY media_id ASC LIMIT 1

UPDATE zcik5_jreviews_media SET main_media = 0 WHERE listing_id = 675 and review_id = 0 and media_id != 1369

SELECT images FROM zcik5_content WHERE id = 675

SELECT path FROM zcik5_categories WHERE id = 78

SELECT id AS cat_id, lft FROM zcik5_categories WHERE path IN ( 'swiat')

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 = 675 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 (600)

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 (600) 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 (600)

SELECT Category.path FROM zcik5_categories AS Category WHERE Category.extension = "com_content" AND Category.access NOT IN ( 1,5)

SELECT Category.id AS `Category.cat_id`, Category.title AS `Category.title`, Category.path AS `Category.path`, IF(CategoryListingCount.listing_count > 0,CategoryListingCount.listing_count,0) AS `Category.listing_count`, 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`, Category.metadesc AS `Category.metadesc`, Category.metakey AS `Category.metakey`, JreviewsCategory.criteriaid AS `ListingType.listing_type_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` FROM zcik5_categories AS Category INNER JOIN ( SELECT ParentCategory.id, COUNT(Listing.id) as listing_count FROM zcik5_categories AS Category, zcik5_categories AS ParentCategory, zcik5_content AS Listing WHERE Category.lft BETWEEN ParentCategory.lft AND ParentCategory.rgt AND Category.id IN (SELECT id FROM zcik5_jreviews_categories WHERE `option` = "com_content") AND Category.id = Listing.catid AND Category.extension = "com_content" AND Category.level > 0 AND Listing.state = 1 AND ( Listing.publish_up IS NULL OR Listing.publish_up <= UTC_TIMESTAMP ) AND (Listing.publish_down IS NULL OR Listing.publish_down = 0 OR Listing.publish_down > UTC_TIMESTAMP) GROUP BY ParentCategory.id ) AS CategoryListingCount ON CategoryListingCount.id = Category.id 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.published = 1 AND Category.extension = "com_content" AND Category.level <= 2 AND Directory.id IN ( 1) ) ORDER BY Category.lft # Removed directory from order by because it makes the query SLOW # Instead we run a much faster query below to re-order the output array

SELECT path FROM zcik5_categories WHERE id = 77

SELECT id AS cat_id, lft FROM zcik5_categories WHERE path IN ( 'polska')

SELECT path FROM zcik5_categories WHERE id = 92

SELECT id AS cat_id, lft FROM zcik5_categories WHERE path IN ( 'polska','polska/woj-dolnoslaskie')

SELECT path FROM zcik5_categories WHERE id = 87

SELECT id AS cat_id, lft FROM zcik5_categories WHERE path IN ( 'polska','polska/woj-kujawsko-pomorskie')

SELECT path FROM zcik5_categories WHERE id = 80

SELECT id AS cat_id, lft FROM zcik5_categories WHERE path IN ( 'polska','polska/woj-lubelskie')

SELECT path FROM zcik5_categories WHERE id = 94

SELECT id AS cat_id, lft FROM zcik5_categories WHERE path IN ( 'polska','polska/woj-lodzkie')

SELECT path FROM zcik5_categories WHERE id = 93

SELECT id AS cat_id, lft FROM zcik5_categories WHERE path IN ( 'polska','polska/woj-mazowieckie')

SELECT path FROM zcik5_categories WHERE id = 90

SELECT id AS cat_id, lft FROM zcik5_categories WHERE path IN ( 'polska','polska/woj-opolskie')

SELECT path FROM zcik5_categories WHERE id = 79

SELECT id AS cat_id, lft FROM zcik5_categories WHERE path IN ( 'polska','polska/woj-podkarpackie')

SELECT path FROM zcik5_categories WHERE id = 91

SELECT id AS cat_id, lft FROM zcik5_categories WHERE path IN ( 'polska','polska/woj-podlaskie')

SELECT path FROM zcik5_categories WHERE id = 89

SELECT id AS cat_id, lft FROM zcik5_categories WHERE path IN ( 'polska','polska/woj-slaskie')

SELECT path FROM zcik5_categories WHERE id = 82

SELECT id AS cat_id, lft FROM zcik5_categories WHERE path IN ( 'polska','polska/woj-swietokrzyskie')

SELECT path FROM zcik5_categories WHERE id = 88

SELECT id AS cat_id, lft FROM zcik5_categories WHERE path IN ( 'polska','polska/woj-wielkopolskie')

SELECT path FROM zcik5_categories WHERE id = 85

SELECT id AS cat_id, lft FROM zcik5_categories WHERE path IN ( 'polska','polska/woj-warminsko-mazurskie')

SELECT path FROM zcik5_categories WHERE id = 84

SELECT id AS cat_id, lft FROM zcik5_categories WHERE path IN ( 'polska','polska/woj-zachodniopomorskie')

SELECT path FROM zcik5_categories WHERE id = 128

SELECT id AS cat_id, lft FROM zcik5_categories WHERE path IN ( 'swiat','swiat/chorwacja')

SELECT path FROM zcik5_categories WHERE id = 132

SELECT id AS cat_id, lft FROM zcik5_categories WHERE path IN ( 'swiat','swiat/czechy')

SELECT path FROM zcik5_categories WHERE id = 217

SELECT id AS cat_id, lft FROM zcik5_categories WHERE path IN ( 'swiat','swiat/niemcy')

SELECT path FROM zcik5_categories WHERE id = 248

SELECT id AS cat_id, lft FROM zcik5_categories WHERE path IN ( 'swiat','swiat/slowacja')

SELECT path FROM zcik5_categories WHERE id = 278

SELECT id AS cat_id, lft FROM zcik5_categories WHERE path IN ( 'swiat','swiat/wielka-brytania')

SELECT id FROM zcik5_jreviews_directories ORDER BY `title`

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 = 675

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=277 )

GYULA - Miejscowość turystyczna

Opis atrakcji turystycznej

Photos

Mapa

Recenzje użytkowników

Relacja - dodatkowe informacje

Spis treści

Spis atrakcji wg lokalizacji

S2Framework Debug Console

Database Queries (77)

Zaloguj się

Resetowanie hasła

Przypomnienie

GYULA - Miejscowość turystyczna

Opis atrakcji turystycznej

Photos

Mapa

Recenzje użytkowników

Relacja - dodatkowe informacje

Spis treści

Spis atrakcji wg lokalizacji

S2Framework Debug Console

Database Queries (77)