Select a.felanca, b.felanca from

maclar as a
inner join takimlar as b on a.takim1id = b.id
inner join takimlar as c on a.takim2id = c.id
inner join stadlar as d on d.id = a.stadid