SELECT ProdCategID, ISNULL(ProdCategDesc, ProdCategDesc) as ProdCategDesc, ProdCategImageURL, ProdCategCondition
FROM os_ProdCateg
WHERE ProdCategParentID =1072 ORDER BY ProdCategOrder, ProdCategDesc