• SELECT wp_posts.* FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_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 (4) ) AND ((wp_posts.post_type = 'product' AND (wp_posts.post_status = 'publish'))) AND ( ( ( wpml_translations.language_code = 'en' OR 0 ) AND wp_posts.post_type IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','wpcf7_contact_form','product','zigzag','otherproducts','qa','homereviews' ) ) OR wp_posts.post_type NOT IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','wpcf7_contact_form','product','zigzag','otherproducts','qa','homereviews' ) ) GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order ASC
  • Pure

    French Oak

    More details
  • Fruité

    French Oak

    More details