@procedure{ "id":"4","name":"Okullar as O", "property":["O.Logo Logo","O.Adi Adi","SC.SEOUrl SU"], "where":"O.Adi like N'Flinders University%' 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]{
@procedure{ "id":"5","name":"Okullar as O", "property":["O.Logo Logo","O.Adi Adi","SC.SEOUrl SU"], "where":"O.Adi like N'Flinders University%' 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]{
@procedure{ "id":"6","name":"Okullar as O", "property":["O.Logo Logo","O.Adi Adi","SC.SEOUrl SU"], "where":"O.Adi like N'Flinders University%' 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]{
@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]{