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
International Shipping Now AvailableContact us
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
Global Black Leather Concorde Executive 24 Hour High Back Chair
Global Black Leather Concorde Executive 24 Hour High Back Chair
 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.manufacturers_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, m.manufacturers_name from products p , categories c, products_to_categories p2c left join manufacturers m on p.manufacturers_id = m.manufacturers_id 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 Manufacturer Price