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)

First batch completed

I finished that batch. No particular rush for the next batch though, I was taking a break from assigning languages to books from International publishers known to Wikipedia. I'm at least half-way through that project, and am going to go back to it for a bit. I may also deal with these B & N identifiers being stuck in the ISBN field.

Along the way, I've been adding other data I found in the OCLC records that we didn't have included, then "WorldCat/OCLC Verifying" those books. For those publications where there is no OCLC record should I mark them as "N/A"? It seems there might be some value in doing so, but on the other hand it's always possible that WorldCat would add a record for such books at a later time. Chavey 15:54, 29 June 2012 (UTC)

I'd be reluctant to mark as "N/A": just because some of the details may be found under another OCLC record that doesn't use the same ISBN (I've seen people link to the relevant OCLC record where an ISBN link isn't enough). But I'm not an OCLC expert by any means. BLongley 19:31, 29 June 2012 (UTC)

Since OCLC records are the results of cataloging entries at member libraries, it is always possible for a library to acquire and add a record to Worldcat for any publication at any time, so I would be reluctant to mark a pub N/A on the Worldcat row. A note 'No matching OCLC record found as of <date>' could be added if you like, but even that I would only do after searching on both title and ISBN, at least. Some OCLC records fail to list the ISBN at all, and some list variant ISBNs (for library bindings, often). -DES ^Talk 02:35, 13 July 2012 (UTC)