@procedure{"id":"seo", "name":"SEO as SP", "where":"SP.ID=6475 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 SC.Canonical='' then 'https://www.yurtlarevimiz.com/ulkeler/gl19 3ef' 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":"ulke", "name":"TanimUlkeler as U", "property":["U.ID ID","U.Adi Adi","lower(U.Adi) LAdi"], "orderby":[{"sort":"asc","property":"U.Adi"}],"where":"U.Adi like '%gl19 3ef%'"}@/procedure @forcode[ulke]{ @ulke.Adi yurtlar | Yurtlar, Oteller, Pansiyonlar, Öğrenci Evleri

@ulke.Adi yurtlar

@ulke.Adi yurtlar

@ulke.Adi şehirleri aşağıda listelenmiştir. Şehir adlarına tıklayarak ilçelerini ve en iyi yurtlarını görüntüleyebilirsiniz.

@procedure{"id":"sehir", "name":"TanimSehirler as S", "property":["S.ID ID","S.Adi Adi","lower(S.Adi) LAdi"], "orderby":[{"sort":"asc","property":"S.Adi"}], "where":"S.UlkeID = @ulke.ID"}@/procedure @forcode[sehir]{

@sehir.Adi

}[sehir]@/forcode
Sponsorlu
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
}[ulke]@/forcode }[seo]@/forcode