Les produits Amédée sont issus de notre sélection de chênes Français et Américains. Notre technique de chauffe du bois est optimisée pour révéler les arômes que vous rercherchez tout en assurant une qualité constante aux produits.
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 (13)
) AND ((wp_posts.post_type = 'product' AND (wp_posts.post_status = 'publish'))) AND ( ( ( wpml_translations.language_code = 'fr' 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
