Elérhetőségeink

Keresse kollégáinkat bizalommal

Értékesítés

Ozibiusz Roland - értékesítési vezető
Telefon: 37/544-443, mobil: 70/323-0945
Email: ozibiusz.roland@premiumautohaz.hu

 

Czibolya Krisztián - értékesítő
Telefon: 37/544-444, mobil: 70/881-2603
Email: czibolya.krisztian@premiumautohaz.hu

Vevőszolgálat:

Víg Tamás - munkafelvevő
Telefon: 37/544-452, mobil: 70/617-7962
Email: vig.tamas@premiumautohaz.hu

 Kovács Krisztián - karosszéria műhely
és kárrendezési központ vezető
Telefon: 37/544-457, mobil: 70/204-6352
Email: kovacs.krisztian@premiumautohaz.hu

 Pénzügy, számlázás:

Pető Kármen - pénzügyi ügyintéző
Telefon: 37/544-447
Email: peto.karmen@premiumautohaz.hu

 Alkatrész értékesítés, raktár: 

Horváth Tibor - értékesítési- és raktárvezető
Telefon: 37/544-459, mobil: 70/881-2602
Email: horvath.tibor@premiumautohaz.hu


 Tóth Péter - alkatrész értékesítő
Telefon: 37/544-459, mobil: 70/323-0944
Email: toth.peter@premiumautohaz.hu

 

Írjon nekünk

Cégadatok

Prémium Autóház Kft.
Cím: 3000 Hatvan, Ring Kálmán u. 3.
Telefon: 37/544-440, Fax: 37/544-450, Email: info@hyundai60.hu
GPS koordináták: N47.6669076 E19.6424421

Nyitvatartás:

Hétfő - Péntek: 8.00 - 17.00
Szombat: Zárva

Map cannot be displayed!
array(1) { [0]=> string(0) "" }
(default) 25 queries took 15 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:56:14'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` = 'pv7i191t9od52a2j48l20qote4' LIMIT 1001
3SELECT COUNT(*) AS `count` FROM `hyundai60_hu`.`studio_onlines` AS `Online` WHERE `Online`.`user_id` = 'pv7i191t9od52a2j48l20qote4'110
4SELECT COUNT(*) AS `count` FROM `hyundai60_hu`.`studio_onlines` AS `Online` WHERE `Online`.`user_id` = 'pv7i191t9od52a2j48l20qote4'110
5INSERT INTO `hyundai60_hu`.`studio_onlines` (`session`, `user_id`, `group_id`, `last_seen`, `ip`, `url`, `created`) VALUES ('pv7i191t9od52a2j48l20qote4', 'pv7i191t9od52a2j48l20qote4', 0, '2018-05-23 06:56:14', '23.20.7.34', '/hu/kapcsolat', '2018-05-23 06:56:14')1114
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 `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 `Content`.`id`, `Content`.`user_id`, `Content`.`seourl`, `Content`.`title`, `Content`.`bodypre`, `Content`.`body`, `Content`.`script`, `Content`.`link`, `Content`.`picture`, `Content`.`publicity`, `Content`.`publicity_date`, `Content`.`cached_in_element`, `Content`.`activatemenu`, `Content`.`menuorder`, `Content`.`parent_id`, `Content`.`type`, `Content`.`visited`, `Content`.`lft`, `Content`.`rght`, `Content`.`active`, `Content`.`deleted`, `Content`.`deleted_date`, `Content`.`created`, `Content`.`modified`, (`I18n__title`.`content`) AS `Content__i18n_title`, (`I18n__body`.`content`) AS `Content__i18n_body`, (`I18n__bodypre`.`content`) AS `Content__i18n_bodypre`, (`I18n__seourl`.`content`) AS `Content__i18n_seourl`, (`I18n__link`.`content`) AS `Content__i18n_link`, `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`, `ParentContent`.`id`, `ParentContent`.`user_id`, `ParentContent`.`seourl`, `ParentContent`.`title`, `ParentContent`.`bodypre`, `ParentContent`.`body`, `ParentContent`.`script`, `ParentContent`.`link`, `ParentContent`.`picture`, `ParentContent`.`publicity`, `ParentContent`.`publicity_date`, `ParentContent`.`cached_in_element`, `ParentContent`.`activatemenu`, `ParentContent`.`menuorder`, `ParentContent`.`parent_id`, `ParentContent`.`type`, `ParentContent`.`visited`, `ParentContent`.`lft`, `ParentContent`.`rght`, `ParentContent`.`active`, `ParentContent`.`deleted`, `ParentContent`.`deleted_date`, `ParentContent`.`created`, `ParentContent`.`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`, `Redirect`.`id`, `Redirect`.`related_model_name`, `Redirect`.`related_model_id`, `Redirect`.`urlfrom`, `Redirect`.`urlto`, `Redirect`.`code`, `Redirect`.`deleted`, `Redirect`.`created`, `Redirect`.`modified` FROM `hyundai60_hu`.`studio_contents` AS `Content` INNER JOIN `hyundai60_hu`.`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') INNER JOIN `hyundai60_hu`.`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') INNER JOIN `hyundai60_hu`.`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') INNER JOIN `hyundai60_hu`.`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') INNER JOIN `hyundai60_hu`.`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') LEFT JOIN `hyundai60_hu`.`studio_users` AS `User` ON (`Content`.`user_id` = `User`.`id`) LEFT JOIN `hyundai60_hu`.`studio_contents` AS `ParentContent` ON (`Content`.`parent_id` = `ParentContent`.`id` AND `ParentContent`.`active` = 1) LEFT JOIN `hyundai60_hu`.`studio_seos` AS `Seo` ON (`Seo`.`related_model_id` = `Content`.`id` AND `Seo`.`related_model_name` = 'Content' AND `Seo`.`locale` = 'hun') LEFT JOIN `hyundai60_hu`.`studio_redirects` AS `Redirect` ON (`Redirect`.`related_model_id` = `Content`.`id` AND `Redirect`.`related_model_name` = 'Content') WHERE `Content`.`id` = 7 AND `Content`.`deleted` != 1 LIMIT 1110
9SELECT `ChildContent`.`id`, `ChildContent`.`user_id`, `ChildContent`.`seourl`, `ChildContent`.`title`, `ChildContent`.`bodypre`, `ChildContent`.`body`, `ChildContent`.`script`, `ChildContent`.`link`, `ChildContent`.`picture`, `ChildContent`.`publicity`, `ChildContent`.`publicity_date`, `ChildContent`.`cached_in_element`, `ChildContent`.`activatemenu`, `ChildContent`.`menuorder`, `ChildContent`.`parent_id`, `ChildContent`.`type`, `ChildContent`.`visited`, `ChildContent`.`lft`, `ChildContent`.`rght`, `ChildContent`.`active`, `ChildContent`.`deleted`, `ChildContent`.`deleted_date`, `ChildContent`.`created`, `ChildContent`.`modified` FROM `hyundai60_hu`.`studio_contents` AS `ChildContent` WHERE `ChildContent`.`parent_id` = (7)000
10SELECT `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`, `ContentGalleryGallery`.`gallery_gallery_id`, `ContentGalleryGallery`.`content_id` FROM `hyundai60_hu`.`studio_gallery_galleries` AS `GalleryGallery` JOIN `hyundai60_hu`.`studio_content_gallery_galleries` AS `ContentGalleryGallery` ON (`ContentGalleryGallery`.`content_id` = 7 AND `ContentGalleryGallery`.`gallery_gallery_id` = `GalleryGallery`.`id`)000
11SELECT `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` = 7 AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tag`.`deleted` = 0 AND `Tagged`.`model` = 'Content'000
12SELECT `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
13SELECT `Content`.`id`, `Content`.`user_id`, `Content`.`seourl`, `Content`.`title`, `Content`.`bodypre`, `Content`.`body`, `Content`.`script`, `Content`.`link`, `Content`.`picture`, `Content`.`publicity`, `Content`.`publicity_date`, `Content`.`cached_in_element`, `Content`.`activatemenu`, `Content`.`menuorder`, `Content`.`parent_id`, `Content`.`type`, `Content`.`visited`, `Content`.`lft`, `Content`.`rght`, `Content`.`active`, `Content`.`deleted`, `Content`.`deleted_date`, `Content`.`created`, `Content`.`modified`, (`I18n__title`.`content`) AS `Content__i18n_title`, (`I18n__body`.`content`) AS `Content__i18n_body`, (`I18n__bodypre`.`content`) AS `Content__i18n_bodypre`, (`I18n__seourl`.`content`) AS `Content__i18n_seourl`, (`I18n__link`.`content`) AS `Content__i18n_link`, `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`, `ParentContent`.`id`, `ParentContent`.`user_id`, `ParentContent`.`seourl`, `ParentContent`.`title`, `ParentContent`.`bodypre`, `ParentContent`.`body`, `ParentContent`.`script`, `ParentContent`.`link`, `ParentContent`.`picture`, `ParentContent`.`publicity`, `ParentContent`.`publicity_date`, `ParentContent`.`cached_in_element`, `ParentContent`.`activatemenu`, `ParentContent`.`menuorder`, `ParentContent`.`parent_id`, `ParentContent`.`type`, `ParentContent`.`visited`, `ParentContent`.`lft`, `ParentContent`.`rght`, `ParentContent`.`active`, `ParentContent`.`deleted`, `ParentContent`.`deleted_date`, `ParentContent`.`created`, `ParentContent`.`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`, `Redirect`.`id`, `Redirect`.`related_model_name`, `Redirect`.`related_model_id`, `Redirect`.`urlfrom`, `Redirect`.`urlto`, `Redirect`.`code`, `Redirect`.`deleted`, `Redirect`.`created`, `Redirect`.`modified` FROM `hyundai60_hu`.`studio_contents` AS `Content` INNER JOIN `hyundai60_hu`.`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') INNER JOIN `hyundai60_hu`.`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') INNER JOIN `hyundai60_hu`.`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') INNER JOIN `hyundai60_hu`.`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') INNER JOIN `hyundai60_hu`.`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') LEFT JOIN `hyundai60_hu`.`studio_users` AS `User` ON (`Content`.`user_id` = `User`.`id`) LEFT JOIN `hyundai60_hu`.`studio_contents` AS `ParentContent` ON (`Content`.`parent_id` = `ParentContent`.`id` AND `ParentContent`.`active` = 1) LEFT JOIN `hyundai60_hu`.`studio_seos` AS `Seo` ON (`Seo`.`related_model_id` = `Content`.`id` AND `Seo`.`related_model_name` = 'Content' AND `Seo`.`locale` = 'hun') LEFT JOIN `hyundai60_hu`.`studio_redirects` AS `Redirect` ON (`Redirect`.`related_model_id` = `Content`.`id` AND `Redirect`.`related_model_name` = 'Content') WHERE `Content`.`id` = 28 AND `Content`.`deleted` != 1 LIMIT 1110
14SELECT `ChildContent`.`id`, `ChildContent`.`user_id`, `ChildContent`.`seourl`, `ChildContent`.`title`, `ChildContent`.`bodypre`, `ChildContent`.`body`, `ChildContent`.`script`, `ChildContent`.`link`, `ChildContent`.`picture`, `ChildContent`.`publicity`, `ChildContent`.`publicity_date`, `ChildContent`.`cached_in_element`, `ChildContent`.`activatemenu`, `ChildContent`.`menuorder`, `ChildContent`.`parent_id`, `ChildContent`.`type`, `ChildContent`.`visited`, `ChildContent`.`lft`, `ChildContent`.`rght`, `ChildContent`.`active`, `ChildContent`.`deleted`, `ChildContent`.`deleted_date`, `ChildContent`.`created`, `ChildContent`.`modified` FROM `hyundai60_hu`.`studio_contents` AS `ChildContent` WHERE `ChildContent`.`parent_id` = (28)000
15SELECT `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`, `ContentGalleryGallery`.`gallery_gallery_id`, `ContentGalleryGallery`.`content_id` FROM `hyundai60_hu`.`studio_gallery_galleries` AS `GalleryGallery` JOIN `hyundai60_hu`.`studio_content_gallery_galleries` AS `ContentGalleryGallery` ON (`ContentGalleryGallery`.`content_id` = 28 AND `ContentGalleryGallery`.`gallery_gallery_id` = `GalleryGallery`.`id`)000
16SELECT `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` = 28 AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tag`.`deleted` = 0 AND `Tagged`.`model` = 'Content'000
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 `Content`.`id`, `Content`.`user_id`, `Content`.`seourl`, `Content`.`title`, `Content`.`bodypre`, `Content`.`body`, `Content`.`script`, `Content`.`link`, `Content`.`picture`, `Content`.`publicity`, `Content`.`publicity_date`, `Content`.`cached_in_element`, `Content`.`activatemenu`, `Content`.`menuorder`, `Content`.`parent_id`, `Content`.`type`, `Content`.`visited`, `Content`.`lft`, `Content`.`rght`, `Content`.`active`, `Content`.`deleted`, `Content`.`deleted_date`, `Content`.`created`, `Content`.`modified`, (`I18n__title`.`content`) AS `Content__i18n_title`, (`I18n__body`.`content`) AS `Content__i18n_body`, (`I18n__bodypre`.`content`) AS `Content__i18n_bodypre`, (`I18n__seourl`.`content`) AS `Content__i18n_seourl`, (`I18n__link`.`content`) AS `Content__i18n_link`, `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`, `ParentContent`.`id`, `ParentContent`.`user_id`, `ParentContent`.`seourl`, `ParentContent`.`title`, `ParentContent`.`bodypre`, `ParentContent`.`body`, `ParentContent`.`script`, `ParentContent`.`link`, `ParentContent`.`picture`, `ParentContent`.`publicity`, `ParentContent`.`publicity_date`, `ParentContent`.`cached_in_element`, `ParentContent`.`activatemenu`, `ParentContent`.`menuorder`, `ParentContent`.`parent_id`, `ParentContent`.`type`, `ParentContent`.`visited`, `ParentContent`.`lft`, `ParentContent`.`rght`, `ParentContent`.`active`, `ParentContent`.`deleted`, `ParentContent`.`deleted_date`, `ParentContent`.`created`, `ParentContent`.`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`, `Redirect`.`id`, `Redirect`.`related_model_name`, `Redirect`.`related_model_id`, `Redirect`.`urlfrom`, `Redirect`.`urlto`, `Redirect`.`code`, `Redirect`.`deleted`, `Redirect`.`created`, `Redirect`.`modified` FROM `hyundai60_hu`.`studio_contents` AS `Content` INNER JOIN `hyundai60_hu`.`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') INNER JOIN `hyundai60_hu`.`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') INNER JOIN `hyundai60_hu`.`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') INNER JOIN `hyundai60_hu`.`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') INNER JOIN `hyundai60_hu`.`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') LEFT JOIN `hyundai60_hu`.`studio_users` AS `User` ON (`Content`.`user_id` = `User`.`id`) LEFT JOIN `hyundai60_hu`.`studio_contents` AS `ParentContent` ON (`Content`.`parent_id` = `ParentContent`.`id` AND `ParentContent`.`active` = 1) LEFT JOIN `hyundai60_hu`.`studio_seos` AS `Seo` ON (`Seo`.`related_model_id` = `Content`.`id` AND `Seo`.`related_model_name` = 'Content' AND `Seo`.`locale` = 'hun') LEFT JOIN `hyundai60_hu`.`studio_redirects` AS `Redirect` ON (`Redirect`.`related_model_id` = `Content`.`id` AND `Redirect`.`related_model_name` = 'Content') WHERE `Content`.`id` = 29 AND `Content`.`deleted` != 1 LIMIT 1110
19SELECT `ChildContent`.`id`, `ChildContent`.`user_id`, `ChildContent`.`seourl`, `ChildContent`.`title`, `ChildContent`.`bodypre`, `ChildContent`.`body`, `ChildContent`.`script`, `ChildContent`.`link`, `ChildContent`.`picture`, `ChildContent`.`publicity`, `ChildContent`.`publicity_date`, `ChildContent`.`cached_in_element`, `ChildContent`.`activatemenu`, `ChildContent`.`menuorder`, `ChildContent`.`parent_id`, `ChildContent`.`type`, `ChildContent`.`visited`, `ChildContent`.`lft`, `ChildContent`.`rght`, `ChildContent`.`active`, `ChildContent`.`deleted`, `ChildContent`.`deleted_date`, `ChildContent`.`created`, `ChildContent`.`modified` FROM `hyundai60_hu`.`studio_contents` AS `ChildContent` WHERE `ChildContent`.`parent_id` = (29)000
20SELECT `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`, `ContentGalleryGallery`.`gallery_gallery_id`, `ContentGalleryGallery`.`content_id` FROM `hyundai60_hu`.`studio_gallery_galleries` AS `GalleryGallery` JOIN `hyundai60_hu`.`studio_content_gallery_galleries` AS `ContentGalleryGallery` ON (`ContentGalleryGallery`.`content_id` = 29 AND `ContentGalleryGallery`.`gallery_gallery_id` = `GalleryGallery`.`id`)000
21SELECT `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` = 29 AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tag`.`deleted` = 0 AND `Tagged`.`model` = 'Content'000
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
24SELECT `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
25SELECT `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