SELECT ime,prezime, mejl_adresa, datum_uzimanja, knjige.naziv, izdavaci.naziv
FROM pozajmice JOIN clanovi
ON (pozajmice.broj_clanske_karte = clanovi.broj_clanske_karte)
JOIN primerci
ON (primerci.inventarski_broj = pozajmice.inventarski_broj)
JOIN knjige ON (primerci.id_knjige = knjige.id_knjige)
JOIN izdavaci ON (knjige.id_izdavaca = izdavaci.id)
WHERE datum_vracanja IS NULL
U0VMRUNUIGltZSxwcmV6aW1lLCBtZWpsX2FkcmVzYSwgZGF0dW1fdXppbWFuamEsIGtuamlnZS5uYXppdiwgaXpkYXZhY2kubmF6aXYKRlJPTSBwb3pham1pY2UgSk9JTiBjbGFub3ZpCk9OIChwb3pham1pY2UuYnJval9jbGFuc2tlX2thcnRlID0gY2xhbm92aS5icm9qX2NsYW5za2Vfa2FydGUpCkpPSU4gcHJpbWVyY2kgCk9OIChwcmltZXJjaS5pbnZlbnRhcnNraV9icm9qID0gcG96YWptaWNlLmludmVudGFyc2tpX2Jyb2opCkpPSU4ga25qaWdlIE9OIChwcmltZXJjaS5pZF9rbmppZ2UgPSBrbmppZ2UuaWRfa25qaWdlKQpKT0lOIGl6ZGF2YWNpIE9OIChrbmppZ2UuaWRfaXpkYXZhY2EgPSBpemRhdmFjaS5pZCkKV0hFUkUgZGF0dW1fdnJhY2FuamEgSVMgTlVMTAo=