Unisex Chef Pants

Unisex Chef Pants - Find the Largest selection of Chef Pants Available in Different Sizes and Colors

SMALLWARES
> Restaurant Apparel
> Chef Pants
> Unisex Chef Pants

VENDORS
	Chef Revival	(78)
	Mercer Culinary	(84)
	Royal Industries	(10)

PRICES
	$ 20 - $ 30	(43)
	$ 30 - $ 36	(46)
	$ 36 - $ 39	(38)
	$ 39 - $ 50	(45)

Search Results: 172 Products

Sort:

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 ('+Unisex +Chef +Pant' 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 = 4556) AND c_right <= (SELECT c_right FROM category WHERE c_id = 4556) order by relev desc, p_model LIMIT 168, 24