1/2 in. Crimp PEX Pull Stop Box
The Pull Stop box takes the hassle out of angle stop installation. The Pull Stop Box insets the angle stop into the wall for a clean, finished look and reduces installation time by up to 50 percent by eliminating the need to stub out. The decorative knob controls the flow of water to the supply line with a simple push/pull motion.
Model # 10585
: SELECT a.ID, CAST(b.meta_value AS SIGNED) as meta_value, a.post_title, b.post_id
FROM wp_vh5zacy6zs_posts a
LEFT JOIN wp_vh5zacy6zs_postmeta b ON a.ID = b.post_id
WHERE a.post_type = 'vendors'
AND a.post_status = 'publish'
AND b.meta_key = 'vendor_order'
ORDER BY meta_value ASC