Hyundai 350

Ismertető

Új Hyundai H350 már  készletről nettó 5.466.000 + ÁFA-tól

A H350 különösen megbízható és gazdaságos munkaeszköz, amely új mércét állít a kényelem terén, modern formavilágot kínál, ráadásul a rugalmas platform révén különféle felépítményekkel elérhető, a zárt áruszállítótól a platós teherautón át az utasszállító buszig.

KÜLSŐ

A KIEMELKEDŐ, MODERN FORMATERVEZÉS MINTAPÉLDÁNYA

A könnyű haszonjárművek szegmensében új mércét állító H350 markáns külső formavilágával a Hyundai modellektől megszokott praktikumot és kifinomult stílust nyújtja.
 
BELSŐ

FEJLETT ERGONÓMIA ÉS VEZETŐKÖZPONTÚ GAZDASÁGOSSÁG

A vezetőcentrikus H350 hű maradt a Hyundai biztonságot, könnyed használhatóságot és egyszerűséget szorgalmazó, alapvető formai irányelveihez. A tágas utasfülke, a remek kilátás és a kiemelkedő, személyautós komfort az utasok kedvencévé teszi.
 
TELJESÍTMÉNY

KATEGÓRIAELSŐ TELJESÍTMÉNY, OPTIMÁLIS ÜZEMANYAG-FOGYASZTÁS

A Hyundai 2.5 CRDi dízelmotorjával, hatfokozatú kézi sebességválttóval felszerelt, hátsókerék-hajtású H350 optimális vezethetőséget kínál, minden helyzetben takarékosabban és biztonságosabban üzemeltethető.
 
BIZTONSÁG

NAGY SZILÁRDSÁGÚ VÁZSZERKEZET, KIFINOMULT BIZTONSÁGI RENDSZEREK

A H350 élvonalbeli biztonsági rendszereit fejlett vezérlő elektronika, érzékelők és szabályzók szolglják ki, automatikusan felismerik a potenciális vészhelyzeteket, és segítik a vezetőt az ütközés elkerülésében.

Galéria

array(1) { [0]=> string(0) "" }
(default) 23 queries took 42 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Online`.`user_id` FROM `hyundai60_hu`.`studio_onlines` AS `Online` LEFT JOIN `hyundai60_hu`.`studio_users` AS `User` ON (`Online`.`user_id` = `User`.`id`) LEFT JOIN `hyundai60_hu`.`studio_groups` AS `Group` ON (`Online`.`group_id` = `Group`.`id`) WHERE `last_seen` <= '2018-05-23 05:53:09'220
2DELETE `Online` FROM `hyundai60_hu`.`studio_onlines` AS `Online` WHERE `Online`.`user_id` IN ('gel3uoh06scce63test19l6ki7', 'u9om70ne3a9baca68tjsekob11')2235
3SELECT `Online`.`session`, `Online`.`user_id`, `Online`.`group_id`, `Online`.`last_seen`, `Online`.`url`, `Online`.`ip`, `Online`.`created`, `User`.`id`, `User`.`group_id`, `User`.`username`, `User`.`email`, `User`.`password`, `User`.`fullname`, `User`.`firstname`, `User`.`lastname`, `User`.`avatar`, `User`.`content_count`, `User`.`facebook_id`, `User`.`google_id`, `User`.`active`, `User`.`activation_code`, `User`.`password_reset`, `User`.`lastseen`, `User`.`deleted`, `User`.`deleted_date`, `User`.`created`, `User`.`modified`, `Group`.`id`, `Group`.`name`, `Group`.`created`, `Group`.`modified` FROM `hyundai60_hu`.`studio_onlines` AS `Online` LEFT JOIN `hyundai60_hu`.`studio_users` AS `User` ON (`Online`.`user_id` = `User`.`id`) LEFT JOIN `hyundai60_hu`.`studio_groups` AS `Group` ON (`Online`.`group_id` = `Group`.`id`) WHERE `Online`.`user_id` = 'pp661k646sqfnodscmeapobus6' LIMIT 1000
4SELECT COUNT(*) AS `count` FROM `hyundai60_hu`.`studio_onlines` AS `Online` WHERE `Online`.`user_id` = 'pp661k646sqfnodscmeapobus6'110
5SELECT COUNT(*) AS `count` FROM `hyundai60_hu`.`studio_onlines` AS `Online` WHERE `Online`.`user_id` = 'pp661k646sqfnodscmeapobus6'110
6INSERT INTO `hyundai60_hu`.`studio_onlines` (`session`, `user_id`, `group_id`, `last_seen`, `ip`, `url`, `created`) VALUES ('pp661k646sqfnodscmeapobus6', 'pp661k646sqfnodscmeapobus6', 0, '2018-05-23 06:53:09', '23.20.7.34', '/hu/hyundai-350', '2018-05-23 06:53:09')112
7SELECT `SiteConfig`.`key`, (`I18n__value`.`content`) AS `SiteConfig__i18n_value` FROM `hyundai60_hu`.`studio_site_configs` AS `SiteConfig` INNER JOIN `hyundai60_hu`.`studio_site_config_i18ns` AS `I18n__value` ON (`SiteConfig`.`id` = `I18n__value`.`foreign_key` AND `I18n__value`.`model` = 'SiteConfig' AND `I18n__value`.`field` = 'value' AND `I18n__value`.`locale` = 'hun') WHERE `active` = 1 AND `SiteConfig`.`deleted` != 1770
8SELECT `Page`.`id`, `Page`.`slider_id`, `Page`.`parent_id`, `Page`.`title`, `Page`.`description`, `Page`.`seourl`, `Page`.`picture`, `Page`.`pageorder`, `Page`.`columns`, `Page`.`rows`, `Page`.`notinmenu`, `Page`.`activatemenu`, `Page`.`cached_in_element`, `Page`.`lft`, `Page`.`rght`, `Page`.`active`, `Page`.`deleted`, `Page`.`deleted_date`, `Page`.`created`, `Page`.`modified`, `Page`.`link`, (`I18n__title`.`content`) AS `Page__i18n_title`, (`I18n__seourl`.`content`) AS `Page__i18n_seourl`, (`I18n__description`.`content`) AS `Page__i18n_description`, `ParentPage`.`id`, `ParentPage`.`slider_id`, `ParentPage`.`parent_id`, `ParentPage`.`title`, `ParentPage`.`description`, `ParentPage`.`seourl`, `ParentPage`.`picture`, `ParentPage`.`pageorder`, `ParentPage`.`columns`, `ParentPage`.`rows`, `ParentPage`.`notinmenu`, `ParentPage`.`activatemenu`, `ParentPage`.`cached_in_element`, `ParentPage`.`lft`, `ParentPage`.`rght`, `ParentPage`.`active`, `ParentPage`.`deleted`, `ParentPage`.`deleted_date`, `ParentPage`.`created`, `ParentPage`.`modified`, `ParentPage`.`link`, `Slider`.`id`, `Slider`.`title`, `Slider`.`slider_image_count`, `Slider`.`active`, `Slider`.`deleted`, `Slider`.`deleted_date`, `Slider`.`created`, `Slider`.`modified`, `Seo`.`id`, `Seo`.`related_model_id`, `Seo`.`related_model_name`, `Seo`.`title`, `Seo`.`description`, `Seo`.`keywords`, `Seo`.`slug`, `Seo`.`locale`, `Seo`.`created`, `Seo`.`modified` FROM `hyundai60_hu`.`studio_pages` AS `Page` INNER JOIN `hyundai60_hu`.`studio_page_i18ns` AS `I18n__title` ON (`Page`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Page' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'hun') INNER JOIN `hyundai60_hu`.`studio_page_i18ns` AS `I18n__seourl` ON (`Page`.`id` = `I18n__seourl`.`foreign_key` AND `I18n__seourl`.`model` = 'Page' AND `I18n__seourl`.`field` = 'seourl' AND `I18n__seourl`.`locale` = 'hun') INNER JOIN `hyundai60_hu`.`studio_page_i18ns` AS `I18n__description` ON (`Page`.`id` = `I18n__description`.`foreign_key` AND `I18n__description`.`model` = 'Page' AND `I18n__description`.`field` = 'description' AND `I18n__description`.`locale` = 'hun') LEFT JOIN `hyundai60_hu`.`studio_pages` AS `ParentPage` ON (`Page`.`parent_id` = `ParentPage`.`id`) LEFT JOIN `hyundai60_hu`.`studio_sliders` AS `Slider` ON (`Page`.`slider_id` = `Slider`.`id`) LEFT JOIN `hyundai60_hu`.`studio_seos` AS `Seo` ON (`Seo`.`related_model_id` = `Page`.`id` AND `Seo`.`related_model_name` = 'Page' AND `Seo`.`locale` = 'hun') WHERE `I18n__seourl`.`content` = 'hyundai-350' AND `Page`.`active` = 1 AND `Page`.`deleted` != 1 LIMIT 1111
9SELECT `ChildPage`.`id`, `ChildPage`.`slider_id`, `ChildPage`.`parent_id`, `ChildPage`.`title`, `ChildPage`.`description`, `ChildPage`.`seourl`, `ChildPage`.`picture`, `ChildPage`.`pageorder`, `ChildPage`.`columns`, `ChildPage`.`rows`, `ChildPage`.`notinmenu`, `ChildPage`.`activatemenu`, `ChildPage`.`cached_in_element`, `ChildPage`.`lft`, `ChildPage`.`rght`, `ChildPage`.`active`, `ChildPage`.`deleted`, `ChildPage`.`deleted_date`, `ChildPage`.`created`, `ChildPage`.`modified`, `ChildPage`.`link` FROM `hyundai60_hu`.`studio_pages` AS `ChildPage` WHERE deleted=0 AND `ChildPage`.`parent_id` = (22)000
10 SELECT Pagesbox.*, `I18n__title`.`content` as `I18n__title` FROM `studio_pagesboxes` AS `Pagesbox` LEFT JOIN `studio_pagesbox_i18ns` AS `I18n__title` ON (`Pagesbox`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = "Pagesbox" AND `I18n__title`.`field` = "title" AND `I18n__title`.`locale` = "hun") WHERE `Pagesbox`.`page_id`="22" and `Pagesbox`.`deleted`="0" ORDER BY `Pagesbox`.`row` ASC, `Pagesbox`.`order` ASC330
11SELECT `Pagesboxlink`.`id`, `Pagesboxlink`.`page_id`, `Pagesboxlink`.`pagesbox_id`, `Pagesboxlink`.`linked_modul`, `Pagesboxlink`.`linked_id` FROM `hyundai60_hu`.`studio_pagesboxlinks` AS `Pagesboxlink` WHERE `Pagesboxlink`.`page_id` = (22)330
12 SELECT PagesboxlinkContent.*, Content.id, Content.title, Content.seourl, Content.script, Content.bodypre, Content.body, Content.picture, Content.link, Content.type, Content.publicity_date, Content.created, `I18n__title`.`content` as `I18n__title`, `I18n__bodypre`.`content` as `I18n__bodypre`, `I18n__body`.`content` as `I18n__body`, `I18n__seourl`.`content` as `I18n__seourl`, `I18n__link`.`content` as `I18n__link` FROM `studio_pagesboxlinks` AS `PagesboxlinkContent` LEFT JOIN `studio_contents` AS `Content` ON (`PagesboxlinkContent`.`linked_id` = `Content`.`id` AND `PagesboxlinkContent`.`linked_modul` = "Content") LEFT JOIN `studio_content_i18ns` AS `I18n__title` ON (`Content`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = "Content" AND `I18n__title`.`field` = "title" AND `I18n__title`.`locale` = "hun") LEFT JOIN `studio_content_i18ns` AS `I18n__bodypre` ON (`Content`.`id` = `I18n__bodypre`.`foreign_key` AND `I18n__bodypre`.`model` = "Content" AND `I18n__bodypre`.`field` = "bodypre" AND `I18n__bodypre`.`locale` = "hun") LEFT JOIN `studio_content_i18ns` AS `I18n__body` ON (`Content`.`id` = `I18n__body`.`foreign_key` AND `I18n__body`.`model` = "Content" AND `I18n__body`.`field` = "body" AND `I18n__body`.`locale` = "hun") LEFT JOIN `studio_content_i18ns` AS `I18n__seourl` ON (`Content`.`id` = `I18n__seourl`.`foreign_key` AND `I18n__seourl`.`model` = "Content" AND `I18n__seourl`.`field` = "seourl" AND `I18n__seourl`.`locale` = "hun") LEFT JOIN `studio_content_i18ns` AS `I18n__link` ON (`Content`.`id` = `I18n__link`.`foreign_key` AND `I18n__link`.`model` = "Content" AND `I18n__link`.`field` = "link" AND `I18n__link`.`locale` = "hun") WHERE `PagesboxlinkContent`.`page_id`="22" and `Content`.`active`="1" and `Content`.`deleted`="0" ORDER BY Content.publicity_date, Content.created DESC221
13SELECT `Tag`.`id`, `Tag`.`identifier`, `Tag`.`name`, `Tag`.`keyname`, `Tag`.`occurrence`, `Tag`.`post_occurrence`, `Tag`.`weight`, `Tag`.`deleted`, `Tag`.`created`, `Tag`.`modified`, `Tagged`.`id`, `Tagged`.`foreign_key`, `Tagged`.`tag_id`, `Tagged`.`model`, `Tagged`.`language`, `Tagged`.`times_tagged`, `Tagged`.`created`, `Tagged`.`modified` FROM `hyundai60_hu`.`studio_tags` AS `Tag` JOIN `hyundai60_hu`.`studio_tagged` AS `Tagged` ON (`Tagged`.`foreign_key` = 22 AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tag`.`deleted` = 0 AND `Tagged`.`model` = 'Page'000
14SELECT `SiteConfig`.`key`, (`I18n__value`.`content`) AS `SiteConfig__i18n_value` FROM `hyundai60_hu`.`studio_site_configs` AS `SiteConfig` INNER JOIN `hyundai60_hu`.`studio_site_config_i18ns` AS `I18n__value` ON (`SiteConfig`.`id` = `I18n__value`.`foreign_key` AND `I18n__value`.`model` = 'SiteConfig' AND `I18n__value`.`field` = 'value' AND `I18n__value`.`locale` = 'hun') WHERE `active` = 1 AND `SiteConfig`.`deleted` != 1770
15SELECT `SliderImage`.`id`, `SliderImage`.`slider_id`, `SliderImage`.`image`, `SliderImage`.`title`, `SliderImage`.`description`, `SliderImage`.`url`, `SliderImage`.`ordered`, `SliderImage`.`active`, `SliderImage`.`deleted`, `SliderImage`.`deleted_date`, `SliderImage`.`created`, `SliderImage`.`modified`, (`I18n__title`.`content`) AS `SliderImage__i18n_title`, (`I18n__description`.`content`) AS `SliderImage__i18n_description`, (`I18n__url`.`content`) AS `SliderImage__i18n_url`, `Slider`.`id`, `Slider`.`title`, `Slider`.`slider_image_count`, `Slider`.`active`, `Slider`.`deleted`, `Slider`.`deleted_date`, `Slider`.`created`, `Slider`.`modified` FROM `hyundai60_hu`.`studio_slider_images` AS `SliderImage` INNER JOIN `hyundai60_hu`.`studio_slider_image_i18ns` AS `I18n__title` ON (`SliderImage`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'SliderImage' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'hun') INNER JOIN `hyundai60_hu`.`studio_slider_image_i18ns` AS `I18n__description` ON (`SliderImage`.`id` = `I18n__description`.`foreign_key` AND `I18n__description`.`model` = 'SliderImage' AND `I18n__description`.`field` = 'description' AND `I18n__description`.`locale` = 'hun') INNER JOIN `hyundai60_hu`.`studio_slider_image_i18ns` AS `I18n__url` ON (`SliderImage`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'SliderImage' AND `I18n__url`.`field` = 'url' AND `I18n__url`.`locale` = 'hun') LEFT JOIN `hyundai60_hu`.`studio_sliders` AS `Slider` ON (`SliderImage`.`slider_id` = `Slider`.`id`) WHERE `SliderImage`.`slider_id` = 4 AND `SliderImage`.`active` = 1 AND `SliderImage`.`deleted` != 1 ORDER BY `SliderImage`.`ordered` asc LIMIT 20111
16SELECT COUNT(DISTINCT(`SliderImage`.`id`)) AS count FROM `hyundai60_hu`.`studio_slider_images` AS `SliderImage` INNER JOIN `hyundai60_hu`.`studio_slider_image_i18ns` AS `SliderImageI18n` ON (`SliderImage`.`id` = `SliderImageI18n`.`foreign_key` AND `SliderImageI18n`.`model` = 'SliderImage' AND `SliderImageI18n`.`locale` = 'hun') LEFT JOIN `hyundai60_hu`.`studio_sliders` AS `Slider` ON (`SliderImage`.`slider_id` = `Slider`.`id`) WHERE `SliderImage`.`slider_id` = 4 AND `SliderImage`.`active` = 1 AND `SliderImage`.`deleted` != 1110
17SELECT `SiteConfig`.`key`, (`I18n__value`.`content`) AS `SiteConfig__i18n_value` FROM `hyundai60_hu`.`studio_site_configs` AS `SiteConfig` INNER JOIN `hyundai60_hu`.`studio_site_config_i18ns` AS `I18n__value` ON (`SiteConfig`.`id` = `I18n__value`.`foreign_key` AND `I18n__value`.`model` = 'SiteConfig' AND `I18n__value`.`field` = 'value' AND `I18n__value`.`locale` = 'hun') WHERE `active` = 1 AND `SiteConfig`.`deleted` != 1770
18SELECT `GalleryImage`.`id`, `GalleryImage`.`gallery_id`, `GalleryImage`.`image`, `GalleryImage`.`originalname`, `GalleryImage`.`size`, `GalleryImage`.`width`, `GalleryImage`.`height`, `GalleryImage`.`title`, `GalleryImage`.`description`, `GalleryImage`.`main`, `GalleryImage`.`ordered`, `GalleryImage`.`active`, `GalleryImage`.`deleted`, `GalleryImage`.`deleted_date`, `GalleryImage`.`created`, `GalleryImage`.`modified`, (`I18n__title`.`content`) AS `GalleryImage__i18n_title`, (`I18n__description`.`content`) AS `GalleryImage__i18n_description`, `GalleryGallery`.`id`, `GalleryGallery`.`title`, `GalleryGallery`.`seourl`, `GalleryGallery`.`picture`, `GalleryGallery`.`description`, `GalleryGallery`.`user_id`, `GalleryGallery`.`parent_id`, `GalleryGallery`.`lft`, `GalleryGallery`.`rght`, `GalleryGallery`.`active`, `GalleryGallery`.`ordered`, `GalleryGallery`.`gallery_image_count`, `GalleryGallery`.`deleted`, `GalleryGallery`.`deleted_date`, `GalleryGallery`.`created`, `GalleryGallery`.`modified` FROM `hyundai60_hu`.`studio_gallery_images` AS `GalleryImage` INNER JOIN `hyundai60_hu`.`studio_gallery_image_i18ns` AS `I18n__title` ON (`GalleryImage`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'GalleryImage' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'hun') INNER JOIN `hyundai60_hu`.`studio_gallery_image_i18ns` AS `I18n__description` ON (`GalleryImage`.`id` = `I18n__description`.`foreign_key` AND `I18n__description`.`model` = 'GalleryImage' AND `I18n__description`.`field` = 'description' AND `I18n__description`.`locale` = 'hun') LEFT JOIN `hyundai60_hu`.`studio_gallery_galleries` AS `GalleryGallery` ON (`GalleryImage`.`gallery_id` = `GalleryGallery`.`id`) WHERE `GalleryImage`.`gallery_id` = 6 AND `GalleryImage`.`active` = 1 AND `GalleryImage`.`deleted` != 1 ORDER BY `GalleryImage`.`ordered` asc LIMIT 21551
19SELECT COUNT(DISTINCT(`GalleryImage`.`id`)) AS count FROM `hyundai60_hu`.`studio_gallery_images` AS `GalleryImage` INNER JOIN `hyundai60_hu`.`studio_gallery_image_i18ns` AS `GalleryImageI18n` ON (`GalleryImage`.`id` = `GalleryImageI18n`.`foreign_key` AND `GalleryImageI18n`.`model` = 'GalleryImage' AND `GalleryImageI18n`.`locale` = 'hun') LEFT JOIN `hyundai60_hu`.`studio_gallery_galleries` AS `GalleryGallery` ON (`GalleryImage`.`gallery_id` = `GalleryGallery`.`id`) WHERE `GalleryImage`.`gallery_id` = 6 AND `GalleryImage`.`active` = 1 AND `GalleryImage`.`deleted` != 1111
20SELECT `SiteConfig`.`key`, (`I18n__value`.`content`) AS `SiteConfig__i18n_value` FROM `hyundai60_hu`.`studio_site_configs` AS `SiteConfig` INNER JOIN `hyundai60_hu`.`studio_site_config_i18ns` AS `I18n__value` ON (`SiteConfig`.`id` = `I18n__value`.`foreign_key` AND `I18n__value`.`model` = 'SiteConfig' AND `I18n__value`.`field` = 'value' AND `I18n__value`.`locale` = 'hun') WHERE `active` = 1 AND `SiteConfig`.`deleted` != 1770
21SELECT `Page`.`lft`, `Page`.`rght`, `Page`.`activatemenu`, `Page`.`pageorder`, `Page`.`parent_id`, `ParentSeourl`.`content` AS `parent_seourl`, (`I18n__title`.`content`) AS `Page__i18n_title`, (`I18n__seourl`.`content`) AS `Page__i18n_seourl`, `Page`.`id` FROM `hyundai60_hu`.`studio_pages` AS `Page` LEFT JOIN `hyundai60_hu`.`studio_page_i18ns` AS `ParentTitle` ON (`ParentTitle`.`foreign_key` = `Page`.`parent_id` AND `ParentTitle`.`locale` = 'hun' AND `ParentTitle`.`field` = 'title') LEFT JOIN `hyundai60_hu`.`studio_page_i18ns` AS `ParentSeourl` ON (`ParentSeourl`.`foreign_key` = `Page`.`parent_id` AND `ParentSeourl`.`locale` = 'hun' AND `ParentSeourl`.`field` = 'seourl') INNER JOIN `hyundai60_hu`.`studio_page_i18ns` AS `I18n__title` ON (`Page`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Page' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'hun') INNER JOIN `hyundai60_hu`.`studio_page_i18ns` AS `I18n__seourl` ON (`Page`.`id` = `I18n__seourl`.`foreign_key` AND `I18n__seourl`.`model` = 'Page' AND `I18n__seourl`.`field` = 'seourl' AND `I18n__seourl`.`locale` = 'hun') LEFT JOIN `hyundai60_hu`.`studio_pages` AS `ParentPage` ON (`Page`.`parent_id` = `ParentPage`.`id`) LEFT JOIN `hyundai60_hu`.`studio_sliders` AS `Slider` ON (`Page`.`slider_id` = `Slider`.`id`) LEFT JOIN `hyundai60_hu`.`studio_seos` AS `Seo` ON (`Seo`.`related_model_id` = `Page`.`id` AND `Seo`.`related_model_name` = 'Page' AND `Seo`.`locale` = 'hun') WHERE `Page`.`deleted` != 1 AND `Page`.`notinmenu` = 0 AND `Page`.`active` = 1 ORDER BY `lft` ASC18180
22SELECT `SiteConfig`.`key`, (`I18n__value`.`content`) AS `SiteConfig__i18n_value` FROM `hyundai60_hu`.`studio_site_configs` AS `SiteConfig` INNER JOIN `hyundai60_hu`.`studio_site_config_i18ns` AS `I18n__value` ON (`SiteConfig`.`id` = `I18n__value`.`foreign_key` AND `I18n__value`.`model` = 'SiteConfig' AND `I18n__value`.`field` = 'value' AND `I18n__value`.`locale` = 'hun') WHERE `active` = 1 AND `SiteConfig`.`deleted` != 1770
23SELECT `Page`.`lft`, `Page`.`rght`, `Page`.`activatemenu`, `Page`.`pageorder`, `Page`.`parent_id`, `ParentSeourl`.`content` AS `parent_seourl`, (`I18n__title`.`content`) AS `Page__i18n_title`, (`I18n__seourl`.`content`) AS `Page__i18n_seourl`, `Page`.`id` FROM `hyundai60_hu`.`studio_pages` AS `Page` LEFT JOIN `hyundai60_hu`.`studio_page_i18ns` AS `ParentTitle` ON (`ParentTitle`.`foreign_key` = `Page`.`parent_id` AND `ParentTitle`.`locale` = 'hun' AND `ParentTitle`.`field` = 'title') LEFT JOIN `hyundai60_hu`.`studio_page_i18ns` AS `ParentSeourl` ON (`ParentSeourl`.`foreign_key` = `Page`.`parent_id` AND `ParentSeourl`.`locale` = 'hun' AND `ParentSeourl`.`field` = 'seourl') INNER JOIN `hyundai60_hu`.`studio_page_i18ns` AS `I18n__title` ON (`Page`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Page' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'hun') INNER JOIN `hyundai60_hu`.`studio_page_i18ns` AS `I18n__seourl` ON (`Page`.`id` = `I18n__seourl`.`foreign_key` AND `I18n__seourl`.`model` = 'Page' AND `I18n__seourl`.`field` = 'seourl' AND `I18n__seourl`.`locale` = 'hun') LEFT JOIN `hyundai60_hu`.`studio_pages` AS `ParentPage` ON (`Page`.`parent_id` = `ParentPage`.`id`) LEFT JOIN `hyundai60_hu`.`studio_sliders` AS `Slider` ON (`Page`.`slider_id` = `Slider`.`id`) LEFT JOIN `hyundai60_hu`.`studio_seos` AS `Seo` ON (`Seo`.`related_model_id` = `Page`.`id` AND `Seo`.`related_model_name` = 'Page' AND `Seo`.`locale` = 'hun') WHERE `Page`.`deleted` != 1 AND `Page`.`notinmenu` = 0 AND `Page`.`active` = 1 ORDER BY `lft` ASC18180