(mysqli):
select icr.* from tbl_iys_icerik as icr ,tbl_iys_sayfa_icerik_bagi as bag ,tbl_iys_kriter_data as krt
where ustgrup=0 and icr.ID=bag.icerikID and bag.sayfaID=10
and bag.sayfaID=krt.sayfaID and icr.ID=krt.icerikID and ( krt.masterID=1 )
and aktif=1
group by icr.ID