@procedure{"id":"seo", "name":"SEO as SP", "where":"SP.ID=1444 and SC.LanguageID=1", "property":[ "case when '1'='0' then SC.SEOTitle else SC.SEOTitle +' '+ ST.Title end ST","SC.SEOTitle SEOTitle", "case when CHARINDEX('_1','/ozel-bogazici-yuksek-ogrenim-erkek-ogrenci-yurdu-4-sisli-sube') = 0 then '' else ' - 1. Sayfa' end sayfa", "case when SC.Canonical='' then 'https://www.yurtlarevimiz.com/ozel-bogazici-yuksek-ogrenim-erkek-ogrenci-yurdu-4-sisli-sube' else SC.Canonical end Canonical", "SC.SEODescription SD", "SC.SEOKeywords SK","SP.Gorsel SG", "SP.MenuID MenuID","SP.YurtID YurtID","SP. YurtTurID YurtTurID","SP.BinaOzellikID BinaOzellikID","SP.OdaOzellikID OdaOzellikID","SP.HizmetID HizmetID","SP.HaberID HaberID","SP.OkulTurID OkulTurID","SP.OkulID OkulID","SP.PaketID PaketID","SC.ID CeviriID"], "relation":[ {"type":"join","name":"SEOCeviri as SC","on":"SC.SEOID = SP.ID"}, {"type":"join","name":"SiteProperties as ST","on":"ST.LanguageID = 1"} ] }@/procedure @forcode[seo]{
'+ ' '+ B.Adi +'' +'
'+ YB.Aciklama+'
'+ ' '+ B.Adi +'' +'
'+ YB.Aciklama+'
'+ ' '+ B.Adi +'' +'
'+ YB.Aciklama+'