Difference between revisions of "ISFDB talk:Page Count Clean Up"

From ISFDB
Jump to navigation Jump to search
(New page: 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 ...)
 
Line 9: Line 9:
  
 
This is to keep it to a manageable number, there are several thousand ISBN-10s. [[User:BLongley|BLongley]] 11:05, 27 June 2012 (UTC)
 
This is to keep it to a manageable number, there are several thousand ISBN-10s. [[User:BLongley|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
 +
 +
[[User:BLongley|BLongley]] 12:03, 28 June 2012 (UTC)

Revision as of 08:03, 28 June 2012

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)

Retrieved from "https://isfdb.org/wiki/index.php?title=ISFDB_talk:Page_Count_Clean_Up&oldid=277056"