@procedure{ "id":"7","name":"Okullar as O", "property":["O.Logo Logo","O.Adi Adi","SC.SEOUrl SU"], "where":"A.SehirID=3 and A.IlceID=94 and SC.LanguageID=1 and OT.OkulTurID=7", "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"} , {"type":"join","name":"Adresler as A","on":"A.OkulID=O.ID"}], "orderby":[{"sort":"asc","property":"O.Adi"}] }@/procedure @forcode[7]{
@procedure{ "id":"11","name":"Okullar as O", "property":["O.Logo Logo","O.Adi Adi","SC.SEOUrl SU"], "where":"A.SehirID=3 and A.IlceID=94 and SC.LanguageID=1 and OT.OkulTurID=11", "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"} , {"type":"join","name":"Adresler as A","on":"A.OkulID=O.ID"}], "orderby":[{"sort":"asc","property":"O.Adi"}] }@/procedure @forcode[11]{
@procedure{ "id":"9","name":"Okullar as O", "property":["O.Logo Logo","O.Adi Adi","SC.SEOUrl SU"], "where":"A.SehirID=3 and A.IlceID=94 and SC.LanguageID=1 and OT.OkulTurID=9", "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"} , {"type":"join","name":"Adresler as A","on":"A.OkulID=O.ID"}], "orderby":[{"sort":"asc","property":"O.Adi"}] }@/procedure @forcode[9]{
@procedure{ "id":"10","name":"Okullar as O", "property":["O.Logo Logo","O.Adi Adi","SC.SEOUrl SU"], "where":"A.SehirID=3 and A.IlceID=94 and SC.LanguageID=1 and OT.OkulTurID=10", "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"} , {"type":"join","name":"Adresler as A","on":"A.OkulID=O.ID"}], "orderby":[{"sort":"asc","property":"O.Adi"}] }@/procedure @forcode[10]{
@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]{