select count(*) from library_t l1 left join library_scrap_t l2 on l1.lb_code = l2.lc_lb_code and l2.lc_user = '' where l1.lb_deleted_at is null and lb_show = 'Y'