SELECT Count(*)
FROM   (SELECT `me`.`borrowernumber`,
               Max(`issues`.`timestamp`)               AS `currentissue`,
               Max(`old_issues`.`timestamp`)           AS `lastissue`,
               Sum(`accountlines`.`amountoutstanding`) AS `outstanding`
        FROM   `borrowers` `me`
               LEFT JOIN `issues` `issues`
                      ON `issues`.`borrowernumber` = `me`.`borrowernumber`
               LEFT JOIN `old_issues` `old_issues`
                      ON `old_issues`.`borrowernumber` = `me`.`borrowernumber`
               LEFT JOIN `accountlines` `accountlines`
                      ON `accountlines`.`borrowernumber` = `me`.`borrowernumber`
        WHERE  `me`.`borrowernumber` NOT IN (SELECT `me`.`borrowernumber`
                                             FROM   `borrowers` `me`
                                             WHERE  `guarantorid` != '0'
                                                     OR `guarantorid` IS NOT
                                                        NULL)
               AND `dateexpiry` < '2018-04-29 14:51:29'
               AND `lastseen` < '2017-05-24 14:51:29'
        GROUP  BY `me`.`borrowernumber`
        HAVING `currentissue` IS NULL
               AND `lastissue` < '2018-04-09 14:51:29'
               AND `outstanding` <= '0') `me`;