SELECT
p_model, p_title as p_titlang, p_title, p_descrip as p_descrip, p_sell, p_sellBy, p_listPrc, p_mapPrc,
prc_bustSite, prc_bustCart,
sp_price, v_id, v_name
, (MATCH (p_title) AGAINST ('+Stationary +Sneeze +Guard' IN BOOLEAN MODE) ) * p_relevance as relev
FROM products
JOIN pricing ON p_prc_id = prc_id
JOIN vendor ON prc_v_id = v_id
JOIN prod_cat ON pc_p_id = p_id JOIN category ON pc_c_id = c_id
LEFT JOIN ship_prod ON sp_p_id = p_id
LEFT JOIN media ON p_id = m_p_id AND m_type = 'Image'
WHERE
p_sell <> 0 and p_relevance >= 0
and c_left >= (SELECT c_left FROM category WHERE c_id = 6390) AND c_right <= (SELECT c_right FROM category WHERE c_id = 6390) order by relev desc, p_model LIMIT 1296, 24
Low Profile Breath Guard, single-sided, self-service, 46"W x 20-11/32"H, (for 3-well drop-in), hinged 1/4" thick tempered glass, 20"D 1/4" thick glass top shelf, 1/4" thick glass end panels, welded tubular upper frame with extruded aluminum supports, built in wiring chase, mount to stainless steel solid surface or millwork counter, NSF, made in USA
Low Profile Breath Guard, single-sided, self-service, 60"W x 20-11/32"H, (for 4-well drop-in), hinged 1/4" thick tempered glass, 20"D 1/4" thick glass top shelf, 1/4" thick glass end panels, welded tubular upper frame with extruded aluminum supports, built in wiring chase, mount to stainless steel solid surface or millwork counter, NSF, made in USA
Low Profile Breath Guard, single-sided, self-service, 74"W x 20-11/32"H, (for 5-well drop-in), hinged 1/4" thick tempered glass, 20"D 1/4" thick glass top shelf, 1/4" thick glass end panels, welded tubular upper frame with extruded aluminum supports, built in wiring chase, mount to stainless steel solid surface or millwork counter, NSF, made in USA
Low Profile Breath Guard, single-sided, self-service, 88"W x 20-11/32"H, (for 6-well drop-in), hinged 1/4" thick tempered glass, 20"D 1/4" thick glass top shelf, 1/4" thick glass end panels, welded tubular upper frame with extruded aluminum supports, built in wiring chase, mount to stainless steel solid surface or millwork counter, NSF, made in USA
Low Profile Breath Guard, single-sided, self-service, 33"W x 20-11/32"H, (for 2-well drop-in), hinged 1/4" thick tempered glass, 20"D 1/4" thick glass top shelf, 1/4" thick glass end panels, welded tubular upper frame with extruded aluminum supports, built in wiring chase, mount to stainless steel solid surface or millwork counter, NSF, made in USA
Español