SELECT * FROM Items WHERE ParentID IN ( SELECT ID FROM Items ) AND StoreID = 2
ORDER BY ParentID, Name