Frame: Aluminum with JANUScoat™. Seat & Back: Handwoven JANUSfiber®.
W
28.25"
72 CM
H
37.5"
95 CM
L
77.5"
197 CM
SH
12.5"
32 CM
AH
19.75"
50 CM
OSH
14"
35 CM
Weight
49.8 lbs
22.6 kg
Color:
Limestone
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 = 'CORTINO CHAISE LOUNGE WITH ARMS' AND p.post_status = 'publish'