The glazed Eve apple is a striking sculptural element indoors or out. Available in multiple color and size options, Eve is handcrafted of clay and organic pigments. Exterior Use Not Recommended in Temperatures Below Freezing.
H
14.5"
37 CM
Diam
18.5"
47 CM
Weight
27.5 lbs
12.5 kg
Color:
ANTHRACITE
SELECT p.ID as post_id, t.slug as product_color
FROM wp_posts p
LEFT JOIN wp_term_relationships tr ON p.ID = tr.object_id
LEFT JOIN wp_term_taxonomy tt ON tr.term_taxonomy_id = tt.term_taxonomy_id
LEFT JOIN wp_terms t ON t.term_id = tt.term_id
WHERE
tt.taxonomy = 'product_colors'
AND p.post_title = 'EVE LARGE' AND p.post_status = 'publish'