We've got 124WP_Query Object ( [query] => Array ( [product_cat] => ofertas-especiales-en ) [query_vars] => Array ( [product_cat] => ofertas-especiales-en [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_key] => [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 ( [0] => 105841 [1] => 105837 [2] => 105834 [3] => 105831 [4] => 105755 [5] => 105576 [6] => 105573 [7] => 105570 [8] => 105567 [9] => 105531 [10] => 105528 [11] => 105525 [12] => 105522 [13] => 105114 [14] => 105108 [15] => 105101 [16] => 105098 [17] => 105094 [18] => 105093 [19] => 105089 [20] => 105074 [21] => 105071 [22] => 105068 [23] => 105065 [24] => 105062 [25] => 105059 [26] => 105054 [27] => 105051 [28] => 105046 [29] => 105042 [30] => 104257 [31] => 104251 [32] => 104248 [33] => 104245 [34] => 104242 [35] => 104239 [36] => 104233 [37] => 104230 [38] => 104227 [39] => 104224 [40] => 104221 [41] => 104218 [42] => 104209 [43] => 98792 [44] => 98789 [45] => 98546 [46] => 98534 [47] => 98385 [48] => 98380 [49] => 98358 [50] => 98355 [51] => 89291 [52] => 82386 [53] => 82350 ) [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 ( ) [meta_query] => Array ( ) [orderby] => menu_order title [order] => ASC [tax_query] => Array ( [relation] => AND [0] => Array ( [taxonomy] => product_visibility [field] => term_taxonomy_id [terms] => Array ( [0] => 7 ) [operator] => NOT IN ) ) [wc_query] => product_query [posts_per_page] => 16 [parsed_rml_folder] => 0 [ignore_sticky_posts] => [suppress_filters] => [cache_results] => 1 [update_post_term_cache] => 1 [update_menu_item_cache] => [lazy_load_term_meta] => 1 [update_post_meta_cache] => 1 [post_type] => [nopaging] => [comments_per_page] => 50 [no_found_rows] => [taxonomy] => product_cat [term] => ofertas-especiales-en [use_rml_folder] => ) [tax_query] => WP_Tax_Query Object ( [queries] => Array ( [relation] => AND [0] => Array ( [taxonomy] => product_visibility [terms] => Array ( [0] => 7 ) [field] => term_taxonomy_id [operator] => NOT IN [include_children] => 1 ) [1] => Array ( [taxonomy] => product_cat [terms] => Array ( [0] => ofertas-especiales-en ) [field] => slug [operator] => IN [include_children] => 1 ) ) [relation] => AND [table_aliases:protected] => Array ( [0] => ess_term_relationships ) [queried_terms] => Array ( [product_cat] => Array ( [terms] => Array ( [0] => ofertas-especiales-en ) [field] => slug ) ) [primary_table] => ess_posts [primary_id_column] => ID ) [meta_query] => WP_Meta_Query Object ( [queries] => Array ( ) [relation] => [meta_table] => [meta_id_column] => [primary_table] => [primary_id_column] => [table_aliases:protected] => Array ( ) [clauses:protected] => Array ( ) [has_or_relation:protected] => ) [date_query] => [queried_object] => WP_Term Object ( [term_id] => 377 [name] => Special sales [slug] => ofertas-especiales-en [term_group] => 0 [term_taxonomy_id] => 377 [taxonomy] => product_cat [description] => [parent] => 0 [count] => 124 [filter] => raw ) [queried_object_id] => 377 [request] => SELECT SQL_CALC_FOUND_ROWS ess_posts.ID FROM ess_posts LEFT JOIN ess_term_relationships ON (ess_posts.ID = ess_term_relationships.object_id) LEFT JOIN ess_icl_translations wpml_translations ON ess_posts.ID = wpml_translations.element_id AND wpml_translations.element_type = CONCAT('post_', ess_posts.post_type) WHERE 1=1 AND ess_posts.ID NOT IN (105841,105837,105834,105831,105755,105576,105573,105570,105567,105531,105528,105525,105522,105114,105108,105101,105098,105094,105093,105089,105074,105071,105068,105065,105062,105059,105054,105051,105046,105042,104257,104251,104248,104245,104242,104239,104233,104230,104227,104224,104221,104218,104209,98792,98789,98546,98534,98385,98380,98358,98355,89291,82386,82350) AND ( ess_posts.ID NOT IN ( SELECT object_id FROM ess_term_relationships WHERE term_taxonomy_id IN (7) ) AND ess_term_relationships.term_taxonomy_id IN (377,622,623,624,625,214,618,616,615,617) ) AND ((ess_posts.post_type = 'product' AND (ess_posts.post_status = 'publish' OR ess_posts.post_status = 'acf-disabled'))) AND ( ( ( wpml_translations.language_code = 'en' OR ( wpml_translations.language_code = 'es' AND ess_posts.post_type IN ( 'product','product_variation' ) AND ( ( ( SELECT COUNT(element_id) FROM ess_icl_translations WHERE trid = wpml_translations.trid AND language_code = 'en' ) = 0 ) OR ( ( SELECT COUNT(element_id) FROM ess_icl_translations t2 JOIN ess_posts p ON p.id = t2.element_id WHERE t2.trid = wpml_translations.trid AND t2.language_code = 'en' AND ( p.post_status = 'publish' OR p.post_status = 'private' OR ( p.post_type='attachment' AND p.post_status = 'inherit' ) ) ) = 0 ) ) ) ) AND ess_posts.post_type IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','product','product_variation','wpcf7_contact_form','woo_mb_template','mc4wp-form' ) ) OR ess_posts.post_type NOT IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','product','product_variation','wpcf7_contact_form','woo_mb_template','mc4wp-form' ) ) GROUP BY ess_posts.ID ORDER BY ess_posts.menu_order ASC, ess_posts.post_title ASC LIMIT 0, 16 [posts] => Array ( [0] => WP_Post Object ( [ID] => 23825 [post_author] => 14 [post_date] => 2021-01-11 13:19:34 [post_date_gmt] => 2021-01-11 13:19:35 [post_content] => [post_title] => Silk foulard ASK138C [post_excerpt] => Silk printed foulard. Size: 180×100 cm. Composition: 100% silk. Hand made. Washing instructions Hand wash maximum 30º. Iron maximum 110º. No tumble dry. Don’t bleach. [post_status] => publish [comment_status] => open [ping_status] => closed [post_password] => [post_name] => silk-foulard-ask138c [to_ping] => [pinged] => [post_modified] => 2023-07-13 15:06:22 [post_modified_gmt] => 2023-07-13 15:06:22 [post_content_filtered] => [post_parent] => 0 [guid] => https://enconstruccion.net/colores/?post_type=product&p=23825 [menu_order] => 428 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [1] => WP_Post Object ( [ID] => 23020 [post_author] => 14 [post_date] => 2021-01-04 13:06:05 [post_date_gmt] => 2021-01-04 13:06:06 [post_content] => [post_title] => Silk foulard ASK123C [post_excerpt] => Silk printed foulard. Size: 180×100 cm. Composition: 100% silk. Hand made. Washing instructions Hand wash maximum 30º. Iron maximum 110º. No tumble dry. Don’t bleach. [post_status] => publish [comment_status] => open [ping_status] => closed [post_password] => [post_name] => silk-foulard-ask123c [to_ping] => [pinged] => [post_modified] => 2023-09-13 10:40:51 [post_modified_gmt] => 2023-09-13 10:40:51 [post_content_filtered] => [post_parent] => 0 [guid] => https://enconstruccion.net/colores/?post_type=product&p=23020 [menu_order] => 494 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [2] => WP_Post Object ( [ID] => 21595 [post_author] => 14 [post_date] => 2020-12-23 15:44:55 [post_date_gmt] => 2020-12-23 15:44:56 [post_content] => [post_title] => Silk foulard ASK92C [post_excerpt] => Silk printed foulard. Size: 180×100 cm. Composition: 100% silk. Hand made. Washing instructions Hand wash maximum 30º. Iron maximum 110º. No tumble dry. Don’t bleach. [post_status] => publish [comment_status] => open [ping_status] => closed [post_password] => [post_name] => silk-foulard-ask92c [to_ping] => [pinged] => [post_modified] => 2023-10-17 16:11:06 [post_modified_gmt] => 2023-10-17 16:11:06 [post_content_filtered] => [post_parent] => 0 [guid] => https://enconstruccion.net/colores/?post_type=product&p=21595 [menu_order] => 557 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [3] => WP_Post Object ( [ID] => 40522 [post_author] => 14 [post_date] => 2021-02-01 15:08:31 [post_date_gmt] => 2021-02-01 15:08:33 [post_content] => [post_title] => Double silk foulard ASK87CD [post_excerpt] => Double silk and viscose foulard. Size: 180×50 cm printed silk + 180x50 cm plain viscose. Composition: 100% silk + 100% viscose. Hand made. Washing instructions Hand wash maximum 30º. Iron maximum 110º. No tumble dry. Don’t bleach. [post_status] => publish [comment_status] => open [ping_status] => closed [post_password] => [post_name] => double-silk-foulard-ask87cd [to_ping] => [pinged] => [post_modified] => 2023-07-10 14:21:23 [post_modified_gmt] => 2023-07-10 14:21:23 [post_content_filtered] => [post_parent] => 0 [guid] => https://enconstruccion.net/colores/?post_type=product&p=40522 [menu_order] => 567 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [4] => WP_Post Object ( [ID] => 19492 [post_author] => 14 [post_date] => 2020-12-22 13:36:24 [post_date_gmt] => 2020-12-22 13:36:24 [post_content] => [post_title] => Silk foulard ASK13C [post_excerpt] => Silk printed foulard. Size: 180×100 cm. Composition: 100% silk. Hand made. Washing instructions Hand wash maximum 30º. Iron maximum 110º. No tumble dry. Don’t bleach. [post_status] => publish [comment_status] => open [ping_status] => closed [post_password] => [post_name] => silk-foulard-ask13c [to_ping] => [pinged] => [post_modified] => 2022-10-02 21:39:53 [post_modified_gmt] => 2022-10-02 21:39:53 [post_content_filtered] => [post_parent] => 0 [guid] => https://enconstruccion.net/colores/?post_type=product&p=19492 [menu_order] => 731 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [5] => WP_Post Object ( [ID] => 26507 [post_author] => 14 [post_date] => 2021-01-14 12:37:23 [post_date_gmt] => 2021-01-14 12:37:24 [post_content] => [post_title] => Silk foulard ATU383C [post_excerpt] => Silk printed foulard. Size: 180×100 cm. Composition: 100% silk. Hand made. Washing instructions Hand wash maximum 30º. Iron maximum 110º. No tumble dry. Don’t bleach. [post_status] => publish [comment_status] => open [ping_status] => closed [post_password] => [post_name] => silk-foulard-atu383c [to_ping] => [pinged] => [post_modified] => 2023-11-15 17:31:19 [post_modified_gmt] => 2023-11-15 17:31:19 [post_content_filtered] => [post_parent] => 0 [guid] => https://enconstruccion.net/colores/?post_type=product&p=26507 [menu_order] => 770 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [6] => WP_Post Object ( [ID] => 26543 [post_author] => 14 [post_date] => 2021-01-14 12:37:36 [post_date_gmt] => 2021-01-14 12:37:37 [post_content] => [post_title] => Silk foulard ATU376C [post_excerpt] => Silk printed foulard. Size: 180×100 cm. Composition: 100% silk. Hand made. Washing instructions Hand wash maximum 30º. Iron maximum 110º. No tumble dry. Don’t bleach. [post_status] => publish [comment_status] => open [ping_status] => closed [post_password] => [post_name] => silk-foulard-atu376c [to_ping] => [pinged] => [post_modified] => 2023-10-19 09:41:09 [post_modified_gmt] => 2023-10-19 09:41:09 [post_content_filtered] => [post_parent] => 0 [guid] => https://enconstruccion.net/colores/?post_type=product&p=26543 [menu_order] => 785 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [7] => WP_Post Object ( [ID] => 42400 [post_author] => 14 [post_date] => 2021-02-02 14:54:50 [post_date_gmt] => 2021-02-02 14:54:53 [post_content] => [post_title] => Double silk foulard ATU376CDA [post_excerpt] => Double silk and viscose foulard. Size: 180×50 cm printed silk + 180x50 cm plain viscose. Composition: 100% silk + 100% viscose. Hand made. Washing instructions Hand wash maximum 30º. Iron maximum 110º. No tumble dry. Don’t bleach. [post_status] => publish [comment_status] => open [ping_status] => closed [post_password] => [post_name] => double-silk-foulard-atu376cda [to_ping] => [pinged] => [post_modified] => 2023-10-24 11:39:07 [post_modified_gmt] => 2023-10-24 11:39:07 [post_content_filtered] => [post_parent] => 0 [guid] => https://enconstruccion.net/colores/?post_type=product&p=42400 [menu_order] => 786 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [8] => WP_Post Object ( [ID] => 42462 [post_author] => 14 [post_date] => 2021-02-02 15:12:45 [post_date_gmt] => 2021-02-02 15:12:47 [post_content] => [post_title] => Double silk foulard ATU375CBDA [post_excerpt] => Double silk and viscose foulard. Size: 180×50 cm printed silk + 180x50 cm plain viscose. Composition: 100% silk + 100% viscose. Hand made. Washing instructions Hand wash maximum 30º. Iron maximum 110º. No tumble dry. Don’t bleach. [post_status] => publish [comment_status] => open [ping_status] => closed [post_password] => [post_name] => double-silk-foulard-atu375cbda [to_ping] => [pinged] => [post_modified] => 2023-06-09 10:42:51 [post_modified_gmt] => 2023-06-09 10:42:51 [post_content_filtered] => [post_parent] => 0 [guid] => https://enconstruccion.net/colores/?post_type=product&p=42462 [menu_order] => 789 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [9] => WP_Post Object ( [ID] => 42494 [post_author] => 14 [post_date] => 2021-02-02 15:18:18 [post_date_gmt] => 2021-02-02 15:18:20 [post_content] => [post_title] => Double silk foulard ATU372CD [post_excerpt] => Double silk and viscose foulard. Size: 180×50 cm printed silk + 180x50 cm plain viscose. Composition: 100% silk + 100% viscose. Hand made. Washing instructions Hand wash maximum 30º. Iron maximum 110º. No tumble dry. Don’t bleach. [post_status] => publish [comment_status] => open [ping_status] => closed [post_password] => [post_name] => double-silk-foulard-atu372cd [to_ping] => [pinged] => [post_modified] => 2023-10-17 16:13:29 [post_modified_gmt] => 2023-10-17 16:13:29 [post_content_filtered] => [post_parent] => 0 [guid] => https://enconstruccion.net/colores/?post_type=product&p=42494 [menu_order] => 792 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [10] => WP_Post Object ( [ID] => 42658 [post_author] => 14 [post_date] => 2021-02-02 15:43:30 [post_date_gmt] => 2021-02-02 15:43:32 [post_content] => [post_title] => Double silk foulard ATU362CD [post_excerpt] => Double silk and viscose foulard. Size: 180×50 cm printed silk + 180x50 cm plain viscose. Composition: 100% silk + 100% viscose. Hand made. Washing instructions Hand wash maximum 30º. Iron maximum 110º. No tumble dry. Don’t bleach. [post_status] => publish [comment_status] => open [ping_status] => closed [post_password] => [post_name] => double-silk-foulard-atu362cd [to_ping] => [pinged] => [post_modified] => 2023-10-19 11:58:10 [post_modified_gmt] => 2023-10-19 11:58:10 [post_content_filtered] => [post_parent] => 0 [guid] => https://enconstruccion.net/colores/?post_type=product&p=42658 [menu_order] => 804 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [11] => WP_Post Object ( [ID] => 42694 [post_author] => 14 [post_date] => 2021-02-02 15:49:02 [post_date_gmt] => 2021-02-02 15:49:04 [post_content] => [post_title] => Double silk foulard ATU361CD [post_excerpt] => Double silk and viscose foulard. Size: 180×50 cm printed silk + 180x50 cm plain viscose. Composition: 100% silk + 100% viscose. Hand made. Washing instructions Hand wash maximum 30º. Iron maximum 110º. No tumble dry. Don’t bleach. [post_status] => publish [comment_status] => open [ping_status] => closed [post_password] => [post_name] => double-silk-foulard-atu361cd [to_ping] => [pinged] => [post_modified] => 2023-10-18 16:25:40 [post_modified_gmt] => 2023-10-18 16:25:40 [post_content_filtered] => [post_parent] => 0 [guid] => https://enconstruccion.net/colores/?post_type=product&p=42694 [menu_order] => 807 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [12] => WP_Post Object ( [ID] => 26897 [post_author] => 14 [post_date] => 2021-01-14 13:58:44 [post_date_gmt] => 2021-01-14 13:58:45 [post_content] => [post_title] => Silk foulard ATU360C [post_excerpt] => Silk printed foulard. Size: 180×100 cm. Composition: 100% silk. Hand made. Washing instructions Hand wash maximum 30º. Iron maximum 110º. No tumble dry. Don’t bleach. [post_status] => publish [comment_status] => open [ping_status] => closed [post_password] => [post_name] => silk-foulard-atu360c [to_ping] => [pinged] => [post_modified] => 2023-10-19 09:47:36 [post_modified_gmt] => 2023-10-19 09:47:36 [post_content_filtered] => [post_parent] => 0 [guid] => https://enconstruccion.net/colores/?post_type=product&p=26897 [menu_order] => 811 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [13] => WP_Post Object ( [ID] => 27644 [post_author] => 14 [post_date] => 2021-01-15 09:43:25 [post_date_gmt] => 2021-01-15 09:43:26 [post_content] => [post_title] => Silk foulard ATU310C [post_excerpt] => Silk printed foulard. Size: 180×100 cm. Composition: 100% silk. Hand made. Washing instructions Hand wash maximum 30º. Iron maximum 110º. No tumble dry. Don’t bleach. [post_status] => publish [comment_status] => open [ping_status] => closed [post_password] => [post_name] => silk-foulard-atu310c [to_ping] => [pinged] => [post_modified] => 2023-08-21 15:14:16 [post_modified_gmt] => 2023-08-21 15:14:16 [post_content_filtered] => [post_parent] => 0 [guid] => https://enconstruccion.net/colores/?post_type=product&p=27644 [menu_order] => 842 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [14] => WP_Post Object ( [ID] => 27922 [post_author] => 14 [post_date] => 2021-01-15 10:35:28 [post_date_gmt] => 2021-01-15 10:35:29 [post_content] => [post_title] => Silk foulard ATU301C [post_excerpt] => Silk printed foulard. Size: 180×100 cm. Composition: 100% silk. Hand made. Washing instructions Hand wash maximum 30º. Iron maximum 110º. No tumble dry. Don’t bleach. [post_status] => publish [comment_status] => open [ping_status] => closed [post_password] => [post_name] => silk-foulard-atu301c [to_ping] => [pinged] => [post_modified] => 2023-10-19 09:49:32 [post_modified_gmt] => 2023-10-19 09:49:32 [post_content_filtered] => [post_parent] => 0 [guid] => https://enconstruccion.net/colores/?post_type=product&p=27922 [menu_order] => 855 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [15] => WP_Post Object ( [ID] => 28218 [post_author] => 14 [post_date] => 2021-01-15 11:33:33 [post_date_gmt] => 2021-01-15 11:33:34 [post_content] => [post_title] => Silk foulard ATU226C [post_excerpt] => Silk pleated foulard. Size: 180×100 cm. Composition: 100% silk. Hand made. Washing instructions Hand wash maximum 30º. Iron maximum 110º. No tumble dry. Don’t bleach. [post_status] => publish [comment_status] => open [ping_status] => closed [post_password] => [post_name] => silk-foulard-atu226c [to_ping] => [pinged] => [post_modified] => 2023-07-11 10:09:34 [post_modified_gmt] => 2023-07-11 10:09:34 [post_content_filtered] => [post_parent] => 0 [guid] => https://enconstruccion.net/colores/?post_type=product&p=28218 [menu_order] => 861 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) ) [post_count] => 16 [current_post] => -1 [in_the_loop] => [post] => WP_Post Object ( [ID] => 23825 [post_author] => 14 [post_date] => 2021-01-11 13:19:34 [post_date_gmt] => 2021-01-11 13:19:35 [post_content] => [post_title] => Silk foulard ASK138C [post_excerpt] => Silk printed foulard. Size: 180×100 cm. Composition: 100% silk. Hand made. Washing instructions Hand wash maximum 30º. Iron maximum 110º. No tumble dry. Don’t bleach. [post_status] => publish [comment_status] => open [ping_status] => closed [post_password] => [post_name] => silk-foulard-ask138c [to_ping] => [pinged] => [post_modified] => 2023-07-13 15:06:22 [post_modified_gmt] => 2023-07-13 15:06:22 [post_content_filtered] => [post_parent] => 0 [guid] => https://enconstruccion.net/colores/?post_type=product&p=23825 [menu_order] => 428 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [comment_count] => 0 [current_comment] => -1 [found_posts] => 124 [max_num_pages] => 8 [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] => da607c1fb6ed0027b4a5bfb8ddd54b52 [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 ) ) products for you

Cart

Log in

Create an Account
Back to Top