Frame: Aluminum with JANUScoat™ with Onset JANUSwood Arms. Seat & Back: Aluminum Slats with JANUScoat. Stacks to 4.
W
27.5"
70 CM
D
28.75"
73 CM
H
41.25"
105 CM
SH
15"
38 CM
AH
21.75"
55 CM
Color:
Admiral
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 = 'DUO RECLINING LOUNGE CHAIR' AND p.post_status = 'publish'
