@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 = 49", "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

@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 = 532", "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

@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 = 899", "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

@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 = 965", "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

@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 = 977", "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

@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 = 1044", "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

@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 = 1071", "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

@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 = 1084", "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

@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 = 1208", "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

@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 = 1220", "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

@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 = 1282", "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

@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 = 1292", "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

@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 = 1333", "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

@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 = 1408", "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

@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 = 1458", "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

@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 = 1466", "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

@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 = 1520", "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

@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 = 1529", "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

@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 = 1554", "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

@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 = 1685", "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

@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 = 1695", "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

@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 = 1712", "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