select * from online_product join images on images.Image_Product_Id=online_product.Online_Product_Id join products on products.Online_Product_Id=online_product.Online_Product_Id join product_cat on products.Product_Cat_Id=product_cat.Product_Cat_Id where Online_Product_Section='0' and Product_Cat_Desc='Clearance' order by products.Product_Cat_Id Asc