CHORZÓW - ZOO

4.5 (2)

11256 1

Ina Updated Lipiec 14, 2019

Napisz relację i oceń atrakcję Dodaj do ulubionych

Opis atrakcji turystycznej

Kraj / Region

Polska / Śląskie

Miejscowość

Chorzów

Nazwa atrakcji

ZOO

Aktualne ceny

http://zoo.silesia.pl/cennik

Dodat. ceny/info

http://www.trollandia.pl/zoolandia/chorz%C3%B3w-zoo.html#cennik

Kategoria

Zoo, akwaria, stadniny

Atrakcja całoroczna

Śląski Ogród Zoologiczny jest położony na terenie Wojewódzkiego Parku Kultury i Wypoczynku im. gen. Jerzego Ziętka w Chorzowie. Obejmuje obszarem 49 ha będąc trzecim największym co do powierzchni ogrodem zoologicznym w Polsce. Jego początki sięgają roku 1954, kiedy to zaczęto budować klatki dla zwierząt. Następnie zostały przeniesione do niego pierwsze gatunki zwierząt z zoo w Katowicach i Bytomiu. W chorzowskim zoo znajduje się łącznie 2201 zwierząt z 280 gatunków. W roku 1975 zakończono budowę Kotliny Dinozaurów z betonowymi rekonstrukcjami 16 dinozaurów, których szczątki odnalazła polska grupa paleontologów na pustyni Gobi w latach 60-tych. Ogród w Chorzowie jest czynny cały rok w godz. 9-19 (maj-wrzesień, po sezonie krócej) i odwiedza go rocznie aż 400 tysięcy osób.

Photos

Mapa

Swap Start/End Start Address

End

Recenzje użytkowników

Liczba relacji: 2

Ocena atrakcji

4.5(2)

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.

Lipiec 13, 2019

Ocena atrakcji

4.0

zwierzęta dobrze widać, ale jedzenie w pierwszym barze po ok 50min zwiedzania okropne

Relacja - dodatkowe informacje

Wiek dziecka/i

2 i 4

Data pobytu

2 lipiec 2019

marzenia

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

Wrzesień 18, 2011 (Updated: Wrzesień 18, 2011)

Ocena atrakcji

5.0

Trafić do chorzowskiego zoo jest bardzo łatwo, pod warunkiem, że już się wie, gdzie to jest. Nie ma co wypatrywać jakichkolwiek reklam czy kierunkowskazów. Trzeba po prostu zaparkować przy wesołym miasteczku dobrze oznakowane) i przejść w głąb parku (leży po prawej stronie).
Bardzo cieszyliśmy się na tą wycieczkę, szczególnie ze względu na żyrafy, których syn jeszcze nie widział. No i oczywiście przy kasie okazało się, że żyraf jak i krokodyli brak... Najwyraźniej nie tylko my byliśmy zawiedzeni, bo kilkoro dzieci w pobliżu marudziło, że nie ma "dziraf".
Trochę się wkurzyliśmy, bo socjalistyczna mentalność jest tu wszechobecna. Przyjechaliśmy w piątek rozpoczynający długi weekend majowy, więc chyba okres największego ruchu turystycznego, a tu nie ma żyraf, mini zoo zamknięte do 1 maja (niedziela), jakieś pretensje kobiety przy bramie, że dziecko, które ma bezpłatne wejście nie ma jednak jakiegoś biletu, wrrrr...
Poza tym jednak było całkiem przyjemnie, mi podobały się zażywające kąpieli niedźwiedzie, a syn był najbardziej zachwycony słoniem walącym w bramę o obiad i rybkami w akwariach, ale wolimy mimo wszystko krakowskie zoo. Teren łatwy do przejechania wózkiem, zdecydowanie polecam dla młodszych dzieci, bo trzeba poruszać się na sporej przestrzeni. Dla starszych dzieci na terenie jest coś w stylu parku linowego, dodatkowo płatne, zrezygnowaliśmy po rozmowie z matką, której córa - ok. 6 lat - właśnie tam brykała, ale podobno rok wcześniej skończyło się wielkim płaczem, mimo iż dziecko było już bardzo zwinne. Ale oprócz tego jest też niewielki plac zabaw, atrakcyjny zarówno dla młodszych jak i starszych dzieci no i naprawdę fajna dolina dinozaurów. Na terenie jest sporo punktów gastronomicznych, raczej fastfoodowych niż obiadowych, ale przy każdym niestety automaty. Wstęp 12 zł, ulgowy 6 zł, dzieci do 5 lat za darmo.

Relacja - dodatkowe informacje

+ Zalety

Miejsce na spędzenie całego dnia
Łatwo dostępne dla wózków
Kilka punktów gastronomicznych
Dodatkowe atrakcje w postaci dinozaurów i parku linowego

- Wady

Mini zoo czynne tylko w sezonie
Co chwilę można się nadziać na automaty
Przy drodze nie ma żadnych znaków na zoo

Wiek dziecka/i

prawie 3 lata

Data pobytu

maj 2011

Ina

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

S2Framework Debug Console

Database Queries (29)

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 = 89 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 = 190) 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 (190)

SELECT * FROM zcik5_jreviews_fieldoptions WHERE fieldid IN ( '16','22','29') AND value IN ( 'chorzow','ogrody-zoologiczne-i-akwaria','rok') 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 (190) 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 (190) 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 (45) )

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 = 190 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 = 190 AND main_media = 1 ORDER BY media_id ASC LIMIT 1

UPDATE zcik5_jreviews_media SET main_media = 0 WHERE listing_id = 190 and review_id = 0 and media_id != 3108

SELECT images FROM zcik5_content WHERE id = 190

SELECT path FROM zcik5_categories WHERE id IN (89)

SELECT ParentCategory.id AS `Category.cat_id`, ParentCategory.lft AS `Category.lft`, ParentCategory.title AS `Category.title`, IF(JreviewsCategory.page_title <> '',JreviewsCategory.page_title,ParentCategory.title) AS `Category.title_seo`, JreviewsCategory.title_override AS `Category.title_override`, ParentCategory.alias AS `Category.slug`, ParentCategory.description AS `Category.description`, ParentCategory.level AS `Category.level`, ParentCategory.published AS `Category.published`, ParentCategory.access AS `Category.access`, ParentCategory.params AS `Category.params`, ParentCategory.parent_id AS `Category.parent_id`, ParentCategory.metadesc AS `Category.metadesc`, ParentCategory.metakey AS `Category.metakey`, IF(ParentCategory.metadesc <> '' AND JreviewsCategory.desc_override =1,ParentCategory.metadesc,ParentCategory.description) AS `Category.description`, JreviewsCategory.criteriaid AS `ListingType.listing_type_id`, JreviewsCategory.tmpl AS `Category.tmpl`, JreviewsCategory.tmpl_suffix AS `Category.tmpl_suffix`, JreviewsCategory.dirid AS `Directory.dir_id`, Directory.slug AS `Directory.slug`, Directory.title AS `Directory.title`, Directory.description AS `Directory.description` FROM zcik5_categories AS ParentCategory INNER JOIN zcik5_jreviews_categories AS JreviewsCategory ON JreviewsCategory.id = ParentCategory.id AND JreviewsCategory.`option` = 'com_content' LEFT JOIN zcik5_jreviews_directories AS Directory ON JreviewsCategory.dirid = Directory.id WHERE ParentCategory.path IN ( 'polska','polska/woj-slaskie') ORDER BY ParentCategory.lft

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 = 190 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 (902,79)

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 (79) 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 (902,79)

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

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

CHORZÓW - ZOO

Opis atrakcji turystycznej

Photos

Mapa

Recenzje użytkowników

Relacja - dodatkowe informacje

Relacja - dodatkowe informacje

Spis treści

Spis atrakcji wg lokalizacji

S2Framework Debug Console

Database Queries (29)

Zaloguj się

Resetowanie hasła

Przypomnienie

CHORZÓW - ZOO

Opis atrakcji turystycznej

Photos

Mapa

Recenzje użytkowników

Relacja - dodatkowe informacje

Relacja - dodatkowe informacje

Spis treści

Spis atrakcji wg lokalizacji

S2Framework Debug Console

Database Queries (29)