BBB Accredited Business / Click To Verify
English French German Italian Spanish Japanese
Search Here  
Call Us At 1-888-BLUE-HEN
Items: 0   Total: $0.00
Location >> Home » Blue Hen Office Furniture » All Products
Search Manufacturers
Brands / Categories
View all manufacturers and their respective categories
Search For Furniture
Price Between:
Search in:
What's New? more
Ultimo Executive Mid Back
Ultimo Executive Mid Back
 More Products
Bestselling Products
Special Offers
New Products
All Products
A sampling of our product line, please inquiry with us if you cannot locate it below..
1054 - Unknown column 'p.products_id' in 'on clause'

select s.specials_new_products_price, p.products_id, p.products_model, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, p.products_date_added from products p , categories c, products_to_categories p2c left join products_description pd on p.products_id = pd.products_id and pd.language_id = '1' left join specials s on p.products_id = s.products_id where p.products_id = p2c.products_id and c.categories_id = p2c.categories_id and products_status = '1' order by pd.products_name


Product Image Product Name Model Price