@procedure{"id":"seo", "name":"SEO as SP", "where":"SP.ID=1436 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('_946','/fakulteler_946') = 0 then '' else ' - 946. Sayfa' end sayfa", "case when SC.Canonical='' then 'https://www.yurtlarevimiz.com/fakulteler_946' 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]{ @seo.ST @seo.sayfa | Yurtlar, Oteller, Pansiyonlar, Öğrenci Evleri
Yurtlar Üniversiteler Harita Ücretsiz İlan Ver

@seo.ST

  2. Fakültelerle öğrenci yurtları
@procedure{"id":"okul", "name":"Okullar as O", "property":["O.Logo Logo","O.Adi Adi","TOT.Adi OkulTurAdi","SC.SEOUrl SU","TOTSC.SEOUrl TOTSU"], "where":"SC.LanguageID=1 and OT.OkulTurID=@seo.OkulTurID", "relation":[ {"type":"join","name":"SEO as S","on":"S.OkulID=O.ID"}, {"type":"join","name":"SEOCeviri as SC","on":"SC.SEOID=S.ID"}, {"type":"join","name":"OkulunTuru as OT","on":"OT.OkulID=O.ID"}, {"type":"join","name":"TanimOkulTurleri as TOT","on":"TOT.ID=OT.OkulTurID"}, {"type":"join","name":"SEO as TOTS","on":"TOTS.OkulTurID=OT.OkulTurID"}, {"type":"join","name":"SEOCeviri as TOTSC","on":"TOTSC.SEOID=TOTS.ID"} ], "orderby":[{"sort":"asc","property":"O.Adi"}], "limit":"12", "next":"946" }@/procedure @forcode[okul]{
@okul.Adi

@okul.Adi

@okul.OkulTurAdi
}[okul]@/forcode
@procedure{"id":"yorum","name":"Yorumlar as Y", "property":["Y.Yorum Yorum","U.AdSoyad AdSoyad","case when U.Gorsel is null then 'user-1.png' else U.Gorsel end Gorsel","Y.Tarih Tarih"], "where":"Y.Durumu = 1 and Y.SeoCeviriID=@seo.CeviriID", "orderby":[{"sort":"desc","property":"Y.Tarih"}], "relation":[{"type":"join","name":"Uyeler as U","on":"U.ID=Y.UyeID"}] }@/procedure @forcode[yorum]{
@yorum.AdSoyad
@yorum.AdSoyad - @yorum.Tarih
@yorum.Yorum
}[yorum]@/forcode
OKUL

@procedure{"id":"ftrOkulTur","name":"TanimOkulTurleri as B", "property":["B.ID ID","B.Adi Adi","SC.SEOUrl SU"], "orderby":[{"sort":"asc","property":"B.Adi"}], "relation":[ {"type":"join","name":"SEO as S","on":"S.OkulTurID=B.ID"}, {"type":"join","name":"SEOCeviri as SC","on":"SC.SEOID=S.ID"} ] }@/procedure @forcode[ftrOkulTur]{ @ftrOkulTur.Adi }[ftrOkulTur]@/forcode
YURT TÜRLERİ

@procedure{"id":"footmenuTur","name":"TanimYurtTurleri as B", "property":["B.ID ID","B.Adi Adi","SC.SEOUrl SU"], "orderby":[{"sort":"asc","property":"B.Adi"}], "relation":[ {"type":"join","name":"SEO as S","on":"S.YurtTurID=B.ID"}, {"type":"join","name":"SEOCeviri as SC","on":"SC.SEOID=S.ID"} ] }@/procedure @forcode[footmenuTur]{ @footmenuTur.Adi }[footmenuTur]@/forcode
KATEGORİLER

@procedure{"id":"FootMenu", "name":"Menus as M", "orderby":[{"sort":"asc","property":"MC.Sira"}], "property":["M.ID ID","MC.Adi Adi","SC.SEOUrl SU"], "where":"SC.LanguageID=1 and MC.LanguageID=1 and MU.TopMenuID=1 and MC.Durumu = 1 and MC.MenudeGozuksunmu=1", "relation":[{"type":"join","name":"MenuCeviri as MC","on":"MC.MenuID=M.ID"}, {"type":"join","name":"MenuTop as MU","on":"MU.MenuID=M.ID"}, {"type":"join","name":"SEO as S","on":"S.MenuID=M.ID"}, {"type":"join","name":"SEOCeviri as SC","on":"SC.SEOID=S.ID"}]}@/procedure @forcode[FootMenu]{ @FootMenu.Adi @procedure{"id":"@FootMenu.ID", "name":"Menus as M", "orderby":[{"sort":"asc","property":"MC.Sira"}], "property":["MC.Adi Adi","SC.SEOUrl SU","MC.Gorsel Gorsel"], "where":"SC.LanguageID=1 and MC.LanguageID=1 and MC.Durumu = 1 and MC.MenudeGozuksunmu=1 and MU.TopMenuID = @FootMenu.ID", "relation":[{"type":"join","name":"MenuCeviri as MC","on":"MC.MenuID=M.ID"}, {"type":"join","name":"MenuTop as MU","on":"MU.MenuID=M.ID"}, {"type":"join","name":"SEO as S","on":"S.MenuID=M.ID"}, {"type":"join","name":"SEOCeviri as SC","on":"SC.SEOID=S.ID"}]}@/procedure @forcode[@FootMenu.ID]{ -@@FootMenu.ID.Adi }[@FootMenu.ID]@/forcode }[FootMenu]@/forcode
BİZDEN HABERDAR OLUN


ABONE OL
© 2021 yurtlarevimiz.com
}[seo]@/forcode