@procedure{"id":"seo", "name":"SEO as SP", "where":"SP.ID=1626 and SC.LanguageID=1", "property":["case when '2'='0' then lower(SC.SEOTitle) else lower(SC.SEOTitle) +' '+ ST.Title end ST","SC.SEOTitle SEOTitle", "case when CHARINDEX('_1','/kiz-ogrenci-evi/bingöl_1') = 0 then '' else ' - 1. Sayfa' end sayfa", "case when SC.Canonical='' then 'https://www.yurtlarevimiz.com/kiz-ogrenci-evi/bingöl_1' else SC.Canonical end Canonical","SC.SEODescription SD", "SC.SEOKeywords SK", "SP.MenuID MenuID","SP.YurtID YurtID","SP. YurtTurID YurtTurID"], "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]{ @procedure{"id":"sehir", "name":"TanimSehirler as S", "property":["S.ID ID","lower(S.Adi) LAdi","S.Adi Adi"], "where":"S.Adi like '%bingöl%'"}@/procedure @forcode[sehir]{ @sehir.Adi ilinde bulunan @seo.ST @seo.sayfa | Yurtlar, Oteller, Pansiyonlar, Öğrenci Evleri
Yurtlar Üniversiteler Harita Ücretsiz İlan Ver

@sehir.Adi İlinde bulunan @seo.ST

  2. Kız Öğrenci Evi
  3. @sehir.Adi

@sehir.Adi İlinde bulunan @seo.ST

Değerli velilerimiz ve öğrencilerimiz için oluşturduğumuz @sehir.Adi ilinde bulunan en iyi öğrenci yurtları aşağıda listelenmiştir.


Yurdunuzu Ekleyin
@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.SehirID=@sehir.ID", "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
@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 Se.ID = @sehir.ID", "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"} ],"orderby":[{"sort":"asc","property":"I.Adi"},{"sort":"desc","property":"NEWID()"}],"limit":"12", "next":"1" }@/procedure @forcode[yurt]{
@yurt.Adi

@yurt.Adi

@yurt.IlceAdi- @yurt.SehirAdi
@yurt.YurtTurAdi
}[yurt]@/forcode
Sponsorlu
@sehir.Adi 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 = @sehir.ID"}@/procedure @forcode[ilceler]{ @ilceler.Adi }[ilceler]@/forcode
@sehir.Adi İli Üniversiteleri
Ü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
}[sehir]@/forcode }[seo]@/forcode