SELECT count(*) as ct FROM tbl_book AS T1 LEFT JOIN tbl_book_author AS T2 ON T1.book_id = T2.book_id LEFT JOIN tbl_author AS T3 ON T3.author_id = T2.author_id WHERE T3.STATUS = 'ACTIVE' AND T3.author_id = :author_id