SELECT b.date_due_for_return,
b.users_user_id,
b.date_issued,
b.date_returned,
CONCAT(u.first_name, ' ', u.last_name) AS user_full_name
FROM Books_out_on_loan AS b
LEFT JOIN users AS u ON u.user_id = b.Users_user_id
WHERE b.date_issued + 10 < CURDATE() AND b.date_returned IS NULL;