FINAL SALE ROBES AND TOWELS FOR SALE

Many inexpensive robes, bathrobes and towel options are offered as Final Sale. Available in variety of colors and sizes.

SELECT * FROM category, grup, product WHERE category.category_id=34 and category.display='Y' and category.category_id=grup.category_id and grup.display='Y' and grup.grup_id=product.grup_id and product.display='Y' ORDER BY grup.order_no, grup.grup, product.order_no