<NikolayGospodinov[m]> "Hello. Koha! I am trying to..." <- maybe something like:
SELECT
i.itemnumber,
r.invoiceid,
r.closedate
FROM
aqinvoices r
LEFT JOIN aqorders o ON r.invoiceid=o.invoiceid
LEFT JOIN aqorders_items x ON o.ordernumber=x.ordernumber
LEFT JOIN  items i ON x.itemnumber=i.itemnumber
WHERE r.closedate BETWEEN <<from|date>> AND <<to|date>>