CHILDREN

SELECT * FROM category, grup, product WHERE category.category_id=32 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