Back & Arms: Powder Coated Aluminum Wrapped in Polyolefin Fabric
W
23.5"
60 CM
D
22.75"
58 CM
H
30.25"
77 CM
SH
17.75"
45 CM
AH
26"
26 CM
OSH
19.75"
50 CM
Color:
Natural/Grey
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 = 'MOOD ARMCHAIR' AND p.post_status = 'publish'