University of Pittsburgh-Johnstown

@procedure{ "id":"3","name":"Okullar as O", "property":["O.Logo Logo","O.Adi Adi","SC.SEOUrl SU"], "where":"O.Adi like N'University of Pittsburg%' and SC.LanguageID=1 and OT.OkulTurID=3", "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"} ], "orderby":[{"sort":"asc","property":"O.Adi"}] }@/procedure @forcode[3]{

@3.Adi

}[3]@/forcode

Meslek Yüksekokulu

@procedure{ "id":"4","name":"Okullar as O", "property":["O.Logo Logo","O.Adi Adi","SC.SEOUrl SU"], "where":"O.Adi like N'University of Pittsburg%' and SC.LanguageID=1 and OT.OkulTurID=4", "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"} ], "orderby":[{"sort":"asc","property":"O.Adi"}] }@/procedure @forcode[4]{

@4.Adi

}[4]@/forcode

Üniversite

@procedure{ "id":"5","name":"Okullar as O", "property":["O.Logo Logo","O.Adi Adi","SC.SEOUrl SU"], "where":"O.Adi like N'University of Pittsburg%' and SC.LanguageID=1 and OT.OkulTurID=5", "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"} ], "orderby":[{"sort":"asc","property":"O.Adi"}] }@/procedure @forcode[5]{

@5.Adi

}[5]@/forcode

Yüksekokul

@procedure{ "id":"6","name":"Okullar as O", "property":["O.Logo Logo","O.Adi Adi","SC.SEOUrl SU"], "where":"O.Adi like N'University of Pittsburg%' and SC.LanguageID=1 and OT.OkulTurID=6", "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"} ], "orderby":[{"sort":"asc","property":"O.Adi"}] }@/procedure @forcode[6]{

@6.Adi

}[6]@/forcode

Sponsorlu

Yakın Yurtlar

Yakın Üniversiteler

United States 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 = 883"}@/procedure @forcode[ilceler]{ @ilceler.Adi }[ilceler]@/forcode

Ü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.ST
@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