SELECT b.id, a.urun_adi, b.marka_adi, a.cikti, b.durum, a.marka_id FROM _urun As a
INNER JOIN _marka As b ON a.marka_id like Concat(Concat('%-', b.id), '-%')
WHERE a.cikti = 1 And b.durum = 1
GROUP BY b.id
ORDER BY b.marka_adi