@procedure{"id":"seo", "name":"SEO as SP", "where":"SP.ID=1241 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('_44','/yangin-uyari-sistemi-olan-yurtlar_44') = 0 then '' else ' - 44. Sayfa' end sayfa", "case when SC.Canonical='' then 'https://www.yurtlarevimiz.com/yangin-uyari-sistemi-olan-yurtlar_44' 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
Meetlys, öğrenciler için kariyer, bilgi, sosyalleşme, zaman yönetimi
Yurtlar Üniversiteler Harita Ücretsiz İlan Ver

@seo.ST

  2. Yangın Uyarı Sistemi Olan Yurtlar
    3. @equals{"id":"s2","value1":"1","value2":"2"}@/equals @if[s2]{
  3. Yangın Uyarı Sistemi Olan Yurtlar
  4. @url[2].seotitle
    5. }[s2]@/if @else[s2]{}[s2]@/else @equals{"id":"s3","value1":"1","value2":"3"}@/equals @if[s3]{
  5. Yangın Uyarı Sistemi Olan Yurtlar
  6. @url[2].seotitle
  7. @url[3].seotitle
    8. }[s3]@/if @else[s3]{}[s3]@/else @equals{"id":"s4","value1":"1","value2":"4"}@/equals @if[s4]{
  8. Yangın Uyarı Sistemi Olan Yurtlar
  9. @url[2].seotitle
  10. @url[3].seotitle
  11. @url[4].seotitle
    12. }[s4]@/if @else[s4]{}[s4]@/else @equals{"id":"s5","value1":"1","value2":"5"}@/equals @if[s5]{
  12. Yangın Uyarı Sistemi Olan Yurtlar
  13. @url[2].seotitle
  14. @url[3].seotitle
  15. @url[4].seotitle
  16. @url[5].seotitle
    17. }[s5]@/if @else[s5]{}[s5]@/else

@seo.ST

@seo.SD

@procedure{ "id":"yurt","name":"Yurtlar as Y", "property":["Y.Gorsel Gorsel","Y.Adi YurtAdi","substring(Y.Adi,0,30)+'...' Adi","SUBSTRING(Y.Aciklama,0,100) + '...' Aciklama","SC.SEOUrl SU","TYT.Adi YurtTurAdi","TYTSC.SEOUrl TYTSU","Se.Adi SehirAdi","I.Adi IlceAdi","lower(Se.Adi) LSehirAdi","lower(I.Adi) LIlceAdi"], "where":"Y.Durumu=1 and SC.LanguageID=1 and YBO.BinaOzellikID=@seo.BinaOzellikID ", "relation":[ {"type":"join","name":"SEO as S","on":"S.YurtID=Y.ID"}, {"type":"join","name":"SEOCeviri as SC","on":"SC.SEOID=S.ID"}, {"type":"join","name":"YurdunTuru as YT","on":"YT.YurtID=Y.ID"}, {"type":"join","name":"TanimYurtTurleri as TYT","on":"TYT.ID=YT.YurtTurID"}, {"type":"join","name":"SEO as TYTS","on":"TYTS.YurtTurID=YT.YurtTurID"}, {"type":"join","name":"SEOCeviri as TYTSC","on":"TYTSC.SEOID=TYTS.ID"}, {"type":"join","name":"Adresler as A","on":"A.YurtID=Y.ID"}, {"type":"join","name":"TanimSehirler as Se","on":"Se.ID=A.SehirID"}, {"type":"join","name":"TanimIlceler as I","on":"I.ID=A.IlceID"}, {"type":"join","name":"YurtBinaOzellikleri as YBO","on":"YBO.YurtID=Y.ID"} ],"orderby":[{"sort":"asc","property":"Se.Adi"},{"sort":"asc","property":"I.Adi"},{"sort":"desc","property":"NEWID()"}], "limit":"12", "next":"44" }@/procedure @forcode[yurt]{
@yurt.Adi

@yurt.Adi

@yurt.IlceAdi- @yurt.SehirAdi
@yurt.YurtTurAdi
}[yurt]@/forcode

Aradığınızı bulamadınız mı?

Aramanızı formu doldurarak bize iletebilirsiniz, uzmanlarımız tarafından en kısa sürede tarafınıza dönüş sağlanacaktır.

/ Yasal İzinler
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
i
}[seo]@/forcode