Sonuçlar

SELECT * FROM ( SELECT DergiID,TitleTR,MakaleID,Hit,Indirme,Aktif FROM makaleler ORDER BY MakaleID DESC) s WHERE s.Aktif=1 AND s.MakaleID!=0 AND ( s.Yazarlar LIKE '%Cihat ABAOĞLU%')