@procedure{"id":"seo", "name":"SEO as SP", "where":"SP.ID=3777 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','/tirebolu-yuvam-kiz-ogrenci-pansiyonu') = 0 then '' else ' - 1. Sayfa' end sayfa", "case when SC.Canonical='' then 'https://www.yurtlarevimiz.com/tirebolu-yuvam-kiz-ogrenci-pansiyonu' 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
@procedure{"id":"detay","name":"Yurtlar as M","limit":"1", "property":["M.FaaliyetDurumu FaaliyetDurumu","M.YouTubeVideoID YouTubeVideoID","M.Adi Adi","M.Aciklama Aciklama","M.Logo Logo","M.YatakSayisi YatakSayisi","M.CepTelefon CepTelefon","M.SabitTelefon SabitTelefon","replace(M.MailAdresleri,'@','ytev') MailAdresleri","M.Detay Detay","A.Adres Adres","A.XMap XMap","A.YMap YMap","M.Gorsel YGorsel","A.Gorsel Gorsel", "U.Adi UlkeAdi","lower(S.Adi) LSehirAdi","lower(I.Adi) LIlceAdi","S.ID SehirID","S.Adi SehirAdi","I.Adi IlceAdi","A.MapUrl MapUrl","M.WebSite WebSite","TYTSC.SEOUrl TYTSU"], "where":"M.Durumu = 1 and M.ID=@seo.YurtID", "relation":[ {"type":"join","name":"YurdunTuru as YT","on":"YT.YurtID=M.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=M.ID"}, {"type":"join","name":"TanimUlkeler as U","on":"U.ID=A.UlkeID"}, {"type":"join","name":"TanimSehirler as S","on":"S.ID=A.SehirID"}, {"type":"join","name":"TanimIlceler as I","on":"I.ID=A.IlceID"} ] }@/procedure @forcode[detay]{

@detay.Adi

  2. Tirebolu Yuvam Kız Öğrenci Pansiyonu
@detay.Adi

@detay.Adi @detay.YatakSayisi

@detay.Aciklama


@detay.CepTelefon   @detay.SabitTelefon
@detay.Adres @detay.IlceAdi - @detay.SehirAdi - @detay.UlkeAdi

Harita  Yakın Yurtlar
@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.YurtID=@seo.YurtID", "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
@detay.Detay
HizmetlerimizBina ÖzelliklerimizOda Özelliklerimiz
@procedure{"id":"hizmet","name":"TanimHizmetleri as B", "property":["case when YB.Aciklama = '' then ' '+ B.Adi +'' else '

'+ ' '+ B.Adi +'' +'
'+ YB.Aciklama+'

' end cnt"], "where":"YB.YurtID=@seo.YurtID", "orderby":[{"sort":"asc","property":"YB.Aciklama,B.Adi"}], "relation":[ {"type":"join","name":"YurtHizmetleri as YB","on":"YB.HizmetID=B.ID"}, {"type":"join","name":"SEO as S","on":"S.HizmetID=B.ID"}, {"type":"join","name":"SEOCeviri as SC","on":"SC.SEOID=S.ID"} ] }@/procedure @forcode[hizmet]{ @hizmet.cnt }[hizmet]@/forcode
@procedure{"id":"bina","name":"TanimBinaOzellikleri as B", "property":["case when YB.Aciklama = '' then ' '+ B.Adi +'' else '

'+ ' '+ B.Adi +'' +'
'+ YB.Aciklama+'

' end cnt"], "where":"YB.YurtID=@seo.YurtID", "orderby":[{"sort":"asc","property":"YB.Aciklama,B.Adi"}], "relation":[ {"type":"join","name":"YurtBinaOzellikleri as YB","on":"YB.BinaOzellikID=B.ID"}, {"type":"join","name":"SEO as S","on":"S.BinaOzellikID=B.ID"}, {"type":"join","name":"SEOCeviri as SC","on":"SC.SEOID=S.ID"} ] }@/procedure @forcode[bina]{ @bina.cnt }[bina]@/forcode
@procedure{"id":"oda","name":"TanimOdaOzellikleri as B", "property":["case when YB.Aciklama = '' then ' '+ B.Adi +'' else '

'+ ' '+ B.Adi +'' +'
'+ YB.Aciklama+'

' end cnt"], "where":"YB.YurtID=@seo.YurtID", "orderby":[{"sort":"asc","property":"YB.Aciklama,B.Adi"}], "relation":[ {"type":"join","name":"YurtOdaOzellikleri as YB","on":"YB.OdaOzellikID=B.ID"}, {"type":"join","name":"SEO as S","on":"S.OdaOzelliKID=B.ID"}, {"type":"join","name":"SEOCeviri as SC","on":"SC.SEOID=S.ID"} ] }@/procedure @forcode[oda]{ @oda.cnt }[oda]@/forcode
Galeri
Sponsorlu
Yakın Yurtlar
@detay.SehirAdi ili ilçeleri
@procedure{"id":"ilceler", "name":"TanimIlceler as I", "property":["lower(I.Adi) LAdi","I.Adi Adi"], "orderby":[{"sort":"asc","property":"I.Adi"}], "where":"I.SehirID = @detay.SehirID"}@/procedure @forcode[ilceler]{ @ilceler.Adi }[ilceler]@/forcode
Yakın Üniversiteler
Üyelerimizden
@procedure{"id":"yorum","name":"Yorumlar as Y","limit":"5", "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","SC.SEOUrl SU","SC.SEOTitle ST"], "where":"Y.Durumu = 1 and SC.LanguageID=1", "orderby":[{"sort":"desc","property":"Y.Tarih"}], "relation":[ {"type":"join","name":"Uyeler as U","on":"U.ID=Y.UyeID"}, {"type":"join","name":"SEO as S","on":"S.YurtID=Y.YurtID"}, {"type":"join","name":"SEOCeviri as SC","on":"SC.SEOID=S.ID"}, ] }@/procedure @forcode[yorum]{
@yorum.AdSoyad
@yorum.ST
@yorum.AdSoyad - @yorum.Tarih
@yorum.Yorum

}[yorum]@/forcode
}[detay]@/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