Kaitlyn

SELECT c1.Id AS Id1, c2.Id AS Id2, c1.Title AS Title1, c2.Title As Title2, c1.ItemCount As ItemCount1, c2.ItemCount as ItemCount2FROM categories AS c1LEFT JOIN categories AS c2 ON c2.ParentId = c1.IdWHERE c1.ParentId = 0ORDER BY Title1 ASC, Title2 ASC