Borrower added datewise with librarian
select b.cardnumber AS "Cardnumber", concat(b.surname, ', ', b.firstname) AS "Surname, Name", b.phone AS "Phone", b.email AS "Email", b.dateenrolled AS "Date of registered", b.dateexpiry AS "Date of expiry", concat(br.surname," ",br.firstname) as Librarian, if(b.dateexpiry>=curdate(),"Yes","No") as "Active status" from borrowers b left join action_logs a on a.object = b.borrowernumber and a.module = "MEMBERS" and a.action like "CREAT%" left join borrowers br on br.borrowernumber = a.user where b.dateenrolled between > and >