HYUNDAI ELANTRA

Ismertető

Vadonatúj Hyundai Elantra modellek már 4.699.000 Ft-tól!
Különleges ajánlatainkkal várjuk a Hyundai Hatvan Márkakereskedésben!     
Raktárkészleten lévő modelljeinkről érdeklődjön márkakereskedésünkben!

KÜLÖNLEGES ÉS MODERN
Nincs hozzá fogható a kategóriában. Az Elantra modern, prémium vonzereje tökéletesen illeszkedik a modell kiemelkedő teljesítményéhez.


KÜLSŐ

ELLENÁLLHATATLAN MAGABIZTOSSÁG

A vadonatúj Elantra merész megjelenéséből, széles kiállásából, kifinomult profiljából csak úgy sugárzik a magabiztosság.


BELSŐ

TESTRE SZABOTT KOMFORT

Az Elantra ergonomikus és ösztönös kialakítású belső tere a sofőr testének meghosszabbításaként kezelhető, élvonalbeli technológiákkal elégíti ki a modern elvárásokat.


KÉNYELEM

TÖKÉLETES KÉNYELEM ÉS PRAKTIKUM

Kényelem, irányíthatóság, stílus: a vezetőközpontú technológiai megoldások különleges vezetési élményről gondoskodnak.

BIZTONSÁG

MINDIG ÜGYELÜNK ÖNRE

Az Elantra összesen hét, stratégiai pontokon beépített légzsákkal gondoskodik utasainak optimális védelméről.

 

A részletekért kattintson ide!

Galéria

array(1) { [0]=> string(0) "" }
(default) 22 queries took 39 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:51:53'000
2SELECT `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` = '4mtja4sjboqf6c053pbcvhj8j4' LIMIT 1000
3SELECT COUNT(*) AS `count` FROM `hyundai60_hu`.`studio_onlines` AS `Online` WHERE `Online`.`user_id` = '4mtja4sjboqf6c053pbcvhj8j4'110
4SELECT COUNT(*) AS `count` FROM `hyundai60_hu`.`studio_onlines` AS `Online` WHERE `Online`.`user_id` = '4mtja4sjboqf6c053pbcvhj8j4'110
5INSERT INTO `hyundai60_hu`.`studio_onlines` (`session`, `user_id`, `group_id`, `last_seen`, `ip`, `url`, `created`) VALUES ('4mtja4sjboqf6c053pbcvhj8j4', '4mtja4sjboqf6c053pbcvhj8j4', 0, '2018-05-23 06:51:53', '23.20.7.34', '/hu/hyundai-elantra', '2018-05-23 06:51:53')1134
6SELECT `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
7SELECT `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-elantra' AND `Page`.`active` = 1 AND `Page`.`deleted` != 1 LIMIT 1111
8SELECT `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` = (25)000
9 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`="25" and `Pagesbox`.`deleted`="0" ORDER BY `Pagesbox`.`row` ASC, `Pagesbox`.`order` ASC330
10SELECT `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` = (25)330
11 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`="25" and `Content`.`active`="1" and `Content`.`deleted`="0" ORDER BY Content.publicity_date, Content.created DESC221
12SELECT `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` = 25 AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tag`.`deleted` = 0 AND `Tagged`.`model` = 'Page'000
13SELECT `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
14SELECT `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` = 6 AND `SliderImage`.`active` = 1 AND `SliderImage`.`deleted` != 1 ORDER BY `SliderImage`.`ordered` asc LIMIT 20221
15SELECT 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` = 6 AND `SliderImage`.`active` = 1 AND `SliderImage`.`deleted` != 1110
16SELECT `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
17SELECT `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` = 8 AND `GalleryImage`.`active` = 1 AND `GalleryImage`.`deleted` != 1 ORDER BY `GalleryImage`.`ordered` asc LIMIT 21441
18SELECT 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` = 8 AND `GalleryImage`.`active` = 1 AND `GalleryImage`.`deleted` != 1111
19SELECT `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
20SELECT `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
21SELECT `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
22SELECT `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