Akciók/árak

Árlistánk tartalmazza alkalmi jegyeinket és bérleteinket!

 

Szolárium

Álló és fekvőszoláriummal várjuk a barnulni vágyókat.

Kávézó

Eredeti olasz kávékülönlegességek, meghitt beszélgetésekhez, feltöltődéshez, reggeli ébredés után vagy csak azért mert finom! Frissen facsart narancs és grapefruit leveinkkel pótolhatod a vitamin raktáraid.

Közérzetjavítás

Az Eleven Ház közérzet javító szolgáltatásai: Masszázs, Mofetta, Magneter terápia, Sono terápia

Edzők bemutatása

Teremedzőink, személyi edzőink és a csoportos órák oktatói!

Képgaléria

Életképek az Eleven Házból!

Webshop

Hamarosan!

Iratkozzon fel ingyenes hírlevelünkre!

 

ÚJ SZÉCHENYI TERV
(default) 13 queries took 1 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Service`.`id`, `Service`.`parent_id`, `Service`.`name`, `Service`.`seo_url`, `Service`.`title`, `Service`.`meta_keywords`, `Service`.`meta_description`, `Service`.`topnav`, `Service`.`homebox`, `Service`.`homebox_text`, `Service`.`homebox_image`, `Service`.`offerbox_text`, `Service`.`offerbox_image`, `Service`.`content` FROM `elevenha_z`.`services` AS `Service` WHERE `Service`.`topnav` = '1'19190
2SELECT `Service`.`id`, `Service`.`parent_id`, `Service`.`name`, `Service`.`seo_url`, `Service`.`title`, `Service`.`meta_keywords`, `Service`.`meta_description`, `Service`.`topnav`, `Service`.`homebox`, `Service`.`homebox_text`, `Service`.`homebox_image`, `Service`.`offerbox_text`, `Service`.`offerbox_image`, `Service`.`content` FROM `elevenha_z`.`services` AS `Service` WHERE `Service`.`parent_id` is null880
3SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`seo_url`, `ProductCategory`.`title`, `ProductCategory`.`meta_keywords`, `ProductCategory`.`meta_description`, `ProductCategory`.`product_count` FROM `elevenha_z`.`product_categories` AS `ProductCategory` WHERE 1 = 1660
4SELECT `Product`.`id`, `Product`.`product_category_id`, `Product`.`name`, `Product`.`seo_url`, `Product`.`title`, `Product`.`meta_keywords`, `Product`.`meta_description`, `Product`.`image`, `Product`.`lead`, `Product`.`content`, `Product`.`price`, `Product`.`discount_price`, `Product`.`featured`, `Product`.`popular`, (IF(`Product`.`discount_price` is null, `Product`.`price`, `Product`.`discount_price`)) AS `Product__sell_price`, (IF(`Product`.`discount_price` is null, 0, `Product`.`price`)) AS `Product__list_price` FROM `elevenha_z`.`products` AS `Product` WHERE `Product`.`product_category_id` IN (1, 2, 3, 4, 5, 6)32320
5SELECT `Service`.`id`, `Service`.`parent_id`, `Service`.`name`, `Service`.`seo_url`, `Service`.`title`, `Service`.`meta_keywords`, `Service`.`meta_description`, `Service`.`topnav`, `Service`.`homebox`, `Service`.`homebox_text`, `Service`.`homebox_image`, `Service`.`offerbox_text`, `Service`.`offerbox_image`, `Service`.`content` FROM `elevenha_z`.`services` AS `Service` WHERE `Service`.`homebox` = '1' LIMIT 3331
6SELECT `SliderImage`.`id`, `SliderImage`.`title`, `SliderImage`.`lead`, `SliderImage`.`link`, `SliderImage`.`image`, `SliderImage`.`place`, `SliderImage`.`public_from`, `SliderImage`.`public_until`, `SliderImage`.`active` FROM `elevenha_z`.`slider_images` AS `SliderImage` WHERE `SliderImage`.`place` = 'top' AND `SliderImage`.`active` = '1' AND `SliderImage`.`image` <> ""550
7SELECT `SliderImage`.`id`, `SliderImage`.`title`, `SliderImage`.`lead`, `SliderImage`.`link`, `SliderImage`.`image`, `SliderImage`.`place`, `SliderImage`.`public_from`, `SliderImage`.`public_until`, `SliderImage`.`active` FROM `elevenha_z`.`slider_images` AS `SliderImage` WHERE `SliderImage`.`place` = 'bottom' AND `SliderImage`.`active` = '1' AND `SliderImage`.`image` <> "" ORDER BY `SliderImage`.`id` ASC15150
8SELECT `Content`.`content` FROM `elevenha_z`.`contents` AS `Content` WHERE `content_id` = 'akciok_arak_box' LIMIT 1110
9SELECT `Content`.`content` FROM `elevenha_z`.`contents` AS `Content` WHERE `content_id` = 'edzok_box' LIMIT 1110
10SELECT `Content`.`content` FROM `elevenha_z`.`contents` AS `Content` WHERE `content_id` = 'kepgaléria_box' LIMIT 1110
11SELECT `Content`.`content` FROM `elevenha_z`.`contents` AS `Content` WHERE `content_id` = 'webshop_box' LIMIT 1110
12SELECT `Article`.`id`, `Article`.`title`, `Article`.`seo_url`, `Article`.`lead`, `Article`.`body`, `Article`.`created` FROM `elevenha_z`.`articles` AS `Article` WHERE 1 = 1 ORDER BY `created` DESC LIMIT 10880
13SELECT * from settings as Setting WHERE id in (1,2)220