@procedure{"id":"seo", "name":"SEO as SP", "where":"SC.SEOUrl=N'responsive-tasarim-nedir' and SC.LanguageID=1", "property":["case when '2'='0' then SC.SEOTitle else SC.SEOTitle +' '+ ST.Title end ST","SC.SEOTitle SEOTitle","case when SC.Canonical='' then 'https://www.usetechs.com/blog/responsive-tasarim-nedir' else SC.Canonical end Canonical","SC.SEODescription SD", "SC.SEOKeywords SK","SP.Gorsel SG","SP.ID ID", "SP.MenuID MenuID","SP.HizmetID HizmetID","SP.HaberID HaberID","SP.BlogID BlogID"], "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]{ @seo.ST | usetechs.com @procedure{ "id":"detay","name":"Blog as H", "property":["H.Gorsel Gorsel","HC.Baslik BS","HC.Detay DT","H.Tarih Tarih","lower(LTRIM(HC.Tags)) Tags","SC.SEOUrl SU"], "where":"HC.Durumu=1 and HC.LanguageID=1 and SC.LanguageID=1 and H.ID = @seo.BlogID", "relation":[ {"type":"join","name":"BlogCeviri as HC","on":"HC.BlogID=H.ID"}, {"type":"join","name":"SEO as S","on":"S.BlogID=H.ID"}, {"type":"join","name":"SEOCeviri as SC","on":"SC.SEOID=S.ID"} ], "orderby":[{"sort":"asc","property":"H.Tarih"}] }@/procedure @forcode[detay]{

@detay.BS

@procedure{ "id":"oncblog","name":"Blog as H", "property":["H.Gorsel Gorsel","HC.Baslik TBaslik","substring(HC.Baslik,0,30)+'...' BS","SUBSTRING(HC.Aciklama,0,100) + '...' AC","SC.SEOUrl SU"],"limit":"1", "where":"HC.Durumu=1 and HC.LanguageID=1 and SC.LanguageID=1 and H.ID <@seo.BlogID", "relation":[ {"type":"join","name":"BlogCeviri as HC","on":"HC.BlogID=H.ID"}, {"type":"join","name":"SEO as S","on":"S.BlogID=H.ID"}, {"type":"join","name":"SEOCeviri as SC","on":"SC.SEOID=S.ID"} ], "orderby":[{"sort":"desc","property":"H.Tarih"}] }@/procedure @forcode[oncblog]{ @oncblog.TBaslik

@oncblog.BS

@oncblog.AC

}[oncblog]@/forcode

@detay.BS

@seo.SD

@detay.DT
@procedure{"id":"video","name":"BlogVideolari as BV","property":["BV.Video Video"],"where":"BV.BlogID=@seo.BlogID and BV.Durumu=1"}@/procedure @forcode[video]{ }[video]@/forcode

@detay.Tarih

@detay.Tags


@procedure{"id":"yorum","name":"Yorumlar as Y", "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"], "where":"Y.Durumu = 1 and Y.BlogID=@seo.BlogID", "orderby":[{"sort":"desc","property":"Y.Tarih"}], "relation":[{"type":"join","name":"Uyeler as U","on":"U.ID=Y.UyeID"}] }@/procedure @forcode[yorum]{
@yorum.AdSoyad
@yorum.AdSoyad - @yorum.Tarih

@yorum.Yorum

}[yorum]@/forcode
@procedure{ "id":"sncblog","name":"Blog as H", "property":["H.Gorsel Gorsel","HC.Baslik TBaslik","substring(HC.Baslik,0,30)+'...' BS","SUBSTRING(HC.Aciklama,0,100) + '...' AC","SC.SEOUrl SU"],"limit":"1", "where":"HC.Durumu=1 and HC.LanguageID=1 and SC.LanguageID=1 and H.ID > @seo.BlogID", "relation":[ {"type":"join","name":"BlogCeviri as HC","on":"HC.BlogID=H.ID"}, {"type":"join","name":"SEO as S","on":"S.BlogID=H.ID"}, {"type":"join","name":"SEOCeviri as SC","on":"SC.SEOID=S.ID"} ], "orderby":[{"sort":"asc","property":"H.Tarih"}] }@/procedure @forcode[sncblog]{ @sncblog.TBaslik

@sncblog.BS

@sncblog.AC

}[sncblog]@/forcode
}[detay]@/forcode
@procedure{ "id":"blog","name":"Blog as H", "property":["H.Gorsel Gorsel","HC.Baslik TBaslik","substring(HC.Baslik,0,30)+'...' BS","SUBSTRING(HC.Aciklama,0,100) + '...' AC","SC.SEOUrl SU"], "where":"HC.Durumu=1 and HC.LanguageID=1 and SC.LanguageID=1", "relation":[ {"type":"join","name":"BlogCeviri as HC","on":"HC.BlogID=H.ID"}, {"type":"join","name":"SEO as S","on":"S.BlogID=H.ID"}, {"type":"join","name":"SEOCeviri as SC","on":"SC.SEOID=S.ID"} ], "orderby":[{"sort":"desc","property":"H.Tarih"}] }@/procedure @forcode[blog]{ }[blog]@/forcode
}[seo]@/forcode