Meie Salongid: Eesti
WP_Query Object ( [query] => Array ( [post_type] => stores [post_status] => publish [posts_per_page] => -1 [meta_key] => position [orderby] => meta_value [order] => ASC [suppress_filters] => [tax_query] => Array ( [relation] => AND [0] => Array ( [taxonomy] => store-country [field] => term_id [terms] => Array ( [0] => 82 ) ) [1] => Array ( [taxonomy] => store-type [field] => term_id [terms] => Array ( [0] => 92 ) ) ) ) [query_vars] => Array ( [post_type] => stores [post_status] => publish [posts_per_page] => -1 [meta_key] => position [orderby] => meta_value [order] => ASC [suppress_filters] => [tax_query] => Array ( [relation] => AND [0] => Array ( [taxonomy] => store-country [field] => term_id [terms] => Array ( [0] => 82 ) ) [1] => Array ( [taxonomy] => store-type [field] => term_id [terms] => Array ( [0] => 92 ) ) ) [error] => [m] => [p] => 0 [post_parent] => [subpost] => [subpost_id] => [attachment] => [attachment_id] => 0 [name] => [pagename] => [page_id] => 0 [second] => [minute] => [hour] => [day] => 0 [monthnum] => 0 [year] => 0 [w] => 0 [category_name] => [tag] => [cat] => [tag_id] => [author] => [author_name] => [feed] => [tb] => [paged] => 0 [meta_value] => [preview] => [s] => [sentence] => [title] => [fields] => [menu_order] => [embed] => [category__in] => Array ( ) [category__not_in] => Array ( ) [category__and] => Array ( ) [post__in] => Array ( ) [post__not_in] => Array ( ) [post_name__in] => Array ( ) [tag__in] => Array ( ) [tag__not_in] => Array ( ) [tag__and] => Array ( ) [tag_slug__in] => Array ( ) [tag_slug__and] => Array ( ) [post_parent__in] => Array ( ) [post_parent__not_in] => Array ( ) [author__in] => Array ( ) [author__not_in] => Array ( ) [search_columns] => Array ( ) [meta_query] => Array ( ) [ignore_sticky_posts] => [cache_results] => 1 [update_post_term_cache] => 1 [update_menu_item_cache] => [lazy_load_term_meta] => 1 [update_post_meta_cache] => 1 [nopaging] => 1 [comments_per_page] => 50 [no_found_rows] => [taxonomy] => store-country [term_id] => 82 ) [tax_query] => WP_Tax_Query Object ( [queries] => Array ( [relation] => AND [0] => Array ( [taxonomy] => store-country [terms] => Array ( [0] => 82 ) [field] => term_id [operator] => IN [include_children] => 1 ) [1] => Array ( [taxonomy] => store-type [terms] => Array ( [0] => 92 ) [field] => term_id [operator] => IN [include_children] => 1 ) ) [relation] => AND [table_aliases:protected] => Array ( [0] => wp_term_relationships [1] => tt1 ) [queried_terms] => Array ( [store-country] => Array ( [terms] => Array ( [0] => 82 ) [field] => term_id ) [store-type] => Array ( [terms] => Array ( [0] => 92 ) [field] => term_id ) ) [primary_table] => wp_posts [primary_id_column] => ID ) [meta_query] => WP_Meta_Query Object ( [queries] => Array ( [0] => Array ( [key] => position ) [relation] => OR ) [relation] => AND [meta_table] => wp_postmeta [meta_id_column] => post_id [primary_table] => wp_posts [primary_id_column] => ID [table_aliases:protected] => Array ( [0] => wp_postmeta ) [clauses:protected] => Array ( [wp_postmeta] => Array ( [key] => position [compare] => = [compare_key] => = [alias] => wp_postmeta [cast] => CHAR ) ) [has_or_relation:protected] => ) [date_query] => [queried_object] => WP_Term Object ( [term_id] => 86 [name] => Norge [slug] => norge-sv [term_group] => 0 [term_taxonomy_id] => 86 [taxonomy] => store-country [description] => [parent] => 0 [count] => 0 [filter] => raw [term_order] => 0 ) [queried_object_id] => 86 [request] => SELECT wp_posts.* FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_term_relationships AS tt1 ON (wp_posts.ID = tt1.object_id) INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) JOIN wp_icl_translations wpml_translations ON wp_posts.ID = wpml_translations.element_id AND wpml_translations.element_type = CONCAT('post_', wp_posts.post_type) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (86,14) AND tt1.term_taxonomy_id IN (94,21) ) AND ( wp_postmeta.meta_key = 'position' ) AND wp_posts.post_type = 'stores' AND ((wp_posts.post_status = 'publish')) AND ( ( ( wpml_translations.language_code = 'sv' OR ( wpml_translations.language_code = 'et' AND wp_posts.post_type IN ( 'stores','products','inspiration' ) AND ( ( ( SELECT COUNT(element_id) FROM wp_icl_translations WHERE trid = wpml_translations.trid AND language_code = 'sv' ) = 0 ) OR ( ( SELECT COUNT(element_id) FROM wp_icl_translations t2 JOIN wp_posts p ON p.id = t2.element_id WHERE t2.trid = wpml_translations.trid AND t2.language_code = 'sv' AND ( p.post_status = 'publish' OR p.post_status = 'private' OR ( p.post_type='attachment' AND p.post_status = 'inherit' ) ) ) = 0 ) ) ) ) AND wp_posts.post_type IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','stores','products','design','inspiration','cookielawinfo' ) ) OR wp_posts.post_type NOT IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','stores','products','design','inspiration','cookielawinfo' ) ) GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order, wp_postmeta.meta_value ASC [posts] => Array ( [0] => WP_Post Object ( [ID] => 454 [post_author] => 1 [post_date] => 2021-11-08 17:19:49 [post_date_gmt] => 2021-11-08 15:19:49 [post_content] => [post_title] => BEKKESTUA KJØKKENSTUDIO, Bekkestua, Gamle Ringeriksvei 32 [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => bekkestua-kjokkenstudio-as [to_ping] => [pinged] => [post_modified] => 2023-04-27 12:46:46 [post_modified_gmt] => 2023-04-27 09:46:46 [post_content_filtered] => [post_parent] => 0 [guid] => https://arens.ee/?post_type=stores&p=454 [menu_order] => 6 [post_type] => stores [post_mime_type] => [comment_count] => 0 [filter] => raw ) [1] => WP_Post Object ( [ID] => 8416 [post_author] => 2 [post_date] => 2022-05-11 14:16:42 [post_date_gmt] => 2022-05-11 11:16:42 [post_content] => [post_title] => LIGNUM AS, Kolbotn, Skiveien 42 [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => lignum-as-kolbotn-skiveien-42 [to_ping] => [pinged] => [post_modified] => 2023-10-03 17:08:17 [post_modified_gmt] => 2023-10-03 14:08:17 [post_content_filtered] => [post_parent] => 0 [guid] => https://arens.ee/?post_type=stores&p=8416 [menu_order] => 7 [post_type] => stores [post_mime_type] => [comment_count] => 0 [filter] => raw ) ) [post_count] => 2 [current_post] => -1 [before_loop] => 1 [in_the_loop] => [post] => WP_Post Object ( [ID] => 454 [post_author] => 1 [post_date] => 2021-11-08 17:19:49 [post_date_gmt] => 2021-11-08 15:19:49 [post_content] => [post_title] => BEKKESTUA KJØKKENSTUDIO, Bekkestua, Gamle Ringeriksvei 32 [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => bekkestua-kjokkenstudio-as [to_ping] => [pinged] => [post_modified] => 2023-04-27 12:46:46 [post_modified_gmt] => 2023-04-27 09:46:46 [post_content_filtered] => [post_parent] => 0 [guid] => https://arens.ee/?post_type=stores&p=454 [menu_order] => 6 [post_type] => stores [post_mime_type] => [comment_count] => 0 [filter] => raw ) [comment_count] => 0 [current_comment] => -1 [found_posts] => 2 [max_num_pages] => 0 [max_num_comment_pages] => 0 [is_single] => [is_preview] => [is_page] => [is_archive] => 1 [is_date] => [is_year] => [is_month] => [is_day] => [is_time] => [is_author] => [is_category] => [is_tag] => [is_tax] => 1 [is_search] => [is_feed] => [is_comment_feed] => [is_trackback] => [is_home] => [is_privacy_policy] => [is_404] => [is_embed] => [is_paged] => [is_admin] => [is_attachment] => [is_singular] => [is_robots] => [is_favicon] => [is_posts_page] => [is_post_type_archive] => [query_vars_hash:WP_Query:private] => 625b74b2d95539a92c7a0228945fe3f9 [query_vars_changed:WP_Query:private] => 1 [thumbnails_cached] => [allow_query_attachment_by_filename:protected] => [stopwords:WP_Query:private] => [compat_fields:WP_Query:private] => Array ( [0] => query_vars_hash [1] => query_vars_changed ) [compat_methods:WP_Query:private] => Array ( [0] => init_query_flags [1] => parse_tax_query ) )

Affärer av Arens

  • Tallinn Pärnu mnt 139 e/2
  • Tallinn Mustamäe tee 3a
  • Tartu Fortuuna 1b
Tallinn, Pärnu mnt 139 e/2
E-R: 10:00-18:00
L: 10:00-14:00
Stella-Maria
Salongi sekretär
Kai Asu
Disainer
Piia Perm
Disainer
Marili Rooba
Disainer
Gunilla Kõiv
Disainer
Merike Hirvoja
Disainer
Tallinn, Mustamäe tee 3a
E-R: 10:00-18:00
L: 10:00-14:00
Kristel Soome
Logistik
Larissa Frosch
Disainer
Marcello Liinar
Disainer
Merje Mäng
Disainer
Eveli Kuusik
Disainer
Tartu, Fortuuna 1b
E-R: 10:00-18:00
L: 10:00-14:00
Mari-Liis Sellis
Salongi sekretär
Epp Avila
Disainer
Jane Mändre
Disainer
Kaido Ohno
Disainer
Siim Laine
Disainer