SELECT P.ID,P.Name,P.ImagePath,P.URL,C.Name as Category,C.ID as CatID FROM Partners P LEFT JOIN Categories C on C.ID = P.CatID ORDER BY C.RankOrder, C.Name, P.RankOrder, P.Name Champaign County Tent

Our Corporate Partners