ISFDB talk:Page Count Clean Up

First 500 identified thus:

select p.pub_id , p.pub_isbn
from pubs p
where p.pub_pages is NULL
and p.pub_isbn is not null
and length(p.pub_isbn) = 13
order by 2

This is to keep it to a manageable number, there are several thousand ISBN-10s. BLongley 11:05, 27 June 2012 (UTC)

Added Revised search to exclude '#', ebooks and audio books.

select p.pub_id , p.pub_isbn
from pubs p
where p.pub_pages is NULL
and p.pub_isbn is not null
and p.pub_isbn not like '#%'
and p.pub_ptype != 'ebook'
and p.pub_ptype not like 'audio%'
and length(p.pub_isbn) = 13
order by 2

BLongley 12:03, 28 June 2012 (UTC)