select 'sayfalar' as tabloislem,linkaktif,cat,altmenu,id,baslik,url,title,aktif,menu,siralama, (select ';/;/'+s3.baslik+'##'+s3.url from sayfalar as s3 where s3.aktif=1 and s3.cat=s2.id and not s3.cat=1 order by siralama asc for xml path('')) as altsayfa from sayfalar as s2 where s2.aktif=1 and s2.menu=1 union select 'kategoriler' as tabloislem,1,cat,altmenu,id,baslik,url,title,aktif,menu,siralama, (select ';/;/'+k3.baslik+'##'+k3.url from kategoriler as k3 where k3.aktif=1 and k3.menu=1 and k3.cat=k2.id order by k3.siralama asc for xml path('')) as altsayfa from kategoriler as k2 where k2.aktif=1 and k2.menu=1 order by siralama asc