SELECT * FROM urun 
INNER JOIN siparis ON (urun.urunid = siparis.urunid) 
INNER JOIN odeme ON (urun.urunid = odeme.urunid)
INNER JOIN kullanici ON (odeme.userid = kullanici.userid)
WHERE odeme.userid = 5 AND odeme.durum = 'beklemede'