SELECT borrowers.cardnumber as `Numer karty`, borrowers.surname as Nazwisko, borrowers.firstname as ImiÄ™, borrowers.branchcode as `Biblioteka macierzysta` FROM statistics, items, borrowers
WHERE items.itemnumber = statistics.itemnumber
and DATE(statistics.datetime)=<<Data|date>>
and statistics.borrowernumber=borrowers.borrowernumber
and items.homebranch = <<Biblioteka|branches>>
and statistics.borrowernumber IS NOT NULL
GROUP BY DATE(statistics.datetime), statistics.borrowernumber
ORDER BY borrowers.surname ASC
