Difference between revisions of "ISFDB:Data Consistency/Serial Mismatches"

From ISFDB
Jump to navigation Jump to search
(Moved the Serial Mismatches section to this page)
 
 
(7 intermediate revisions by one other user not shown)
Line 1: Line 1:
 +
2010-01-05:
 +
 +
 
{| border="1" cellpadding="2" style="border-collapse:collapse; text-align:left"
 
{| border="1" cellpadding="2" style="border-collapse:collapse; text-align:left"
 
! Title
 
! Title
Line 7: Line 10:
  
 
|-
 
|-
−
|[http://www.isfdb.org/cgi-bin/title.cgi?193239 Balance and Power (Part 1)]
+
|[http://www.isfdb.org/cgi-bin/title.cgi?112736 . . . And Call Me Conrad (Part 1 of 2)]
 +
|SERIAL
 +
|[http://www.isfdb.org/cgi-bin/pl.cgi?286653 Power & Light]
 +
|COLLECTION
 +
|
 +
|-
 +
|[http://www.isfdb.org/cgi-bin/title.cgi?112737 . . . And Call Me Conrad (Part 2 of 2)]
 +
|SERIAL
 +
|[http://www.isfdb.org/cgi-bin/pl.cgi?286653 Power & Light]
 +
|COLLECTION
 +
|
 +
|-
 +
|[http://www.isfdb.org/cgi-bin/title.cgi?851008 An Invisible War (Part 1 of 2)]
 +
|SERIAL
 +
|[http://www.isfdb.org/cgi-bin/pl.cgi?255089 Grantville Gazette II]
 +
|ANTHOLOGY
 +
|
 +
|-
 +
|[http://www.isfdb.org/cgi-bin/title.cgi?851008 An Invisible War (Part 1 of 2)]
 +
|SERIAL
 +
|[http://www.isfdb.org/cgi-bin/pl.cgi?282180 Grantville Gazette II]
 +
|ANTHOLOGY
 +
|
 +
|-
 +
|[http://www.isfdb.org/cgi-bin/title.cgi?851431 An Invisible War (Part 2 of 2)]
 +
|SERIAL
 +
|[http://www.isfdb.org/cgi-bin/pl.cgi?255170 Grantville Gazette III]
 +
|ANTHOLOGY
 +
|
 +
|-
 +
|[http://www.isfdb.org/cgi-bin/title.cgi?966782 At the Cliff's Edge]
 
|SERIAL
 
|SERIAL
−
|[http://www.isfdb.org/cgi-bin/pl.cgi?3603 Bardic Voices One]
+
|[http://www.isfdb.org/cgi-bin/pl.cgi?280955 Grantville Gazette IX]
 
|ANTHOLOGY
 
|ANTHOLOGY
 
|
 
|
Line 25: Line 58:
 
|
 
|
 
|-
 
|-
−
|[http://www.isfdb.org/cgi-bin/title.cgi?114358 From Snow Crash: Chapter 1 (Excerpt)]
+
|[http://www.isfdb.org/cgi-bin/title.cgi?966783 Butterflies In The Kremlin, Episode 2: A 'Merican in Moscow]
 +
|SERIAL
 +
|[http://www.isfdb.org/cgi-bin/pl.cgi?280955 Grantville Gazette IX]
 +
|ANTHOLOGY
 +
|
 +
|-
 +
|[http://www.isfdb.org/cgi-bin/title.cgi?852659 Butterflies in the Kremlin, Part 1: A Russian Noble]
 +
|SERIAL
 +
|[http://www.isfdb.org/cgi-bin/pl.cgi?255473 Grantville Gazette VIII]
 +
|ANTHOLOGY
 +
|
 +
|-
 +
|[http://www.isfdb.org/cgi-bin/title.cgi?966805 Butterflies in the Kremlin, Part 3: Boris, Natasha . . . But Where's Bullwinkle]
 
|SERIAL
 
|SERIAL
−
|[http://www.isfdb.org/cgi-bin/pl.cgi?26485 Postmodern American Fiction]
+
|[http://www.isfdb.org/cgi-bin/pl.cgi?280956 Grantville Gazette X]
 
|ANTHOLOGY
 
|ANTHOLOGY
 
|
 
|
 
|-
 
|-
−
|[http://www.isfdb.org/cgi-bin/title.cgi?114368 From The Crying of Lot 49 (Excerpt)]
+
|[http://www.isfdb.org/cgi-bin/title.cgi?974518 Butterflies in the Kremlin, Part Four]
 
|SERIAL
 
|SERIAL
−
|[http://www.isfdb.org/cgi-bin/pl.cgi?26485 Postmodern American Fiction]
+
|[http://www.isfdb.org/cgi-bin/pl.cgi?282259 Grantville Gazette XI]
 
|ANTHOLOGY
 
|ANTHOLOGY
 
|
 
|
 
|-
 
|-
−
|[http://www.isfdb.org/cgi-bin/title.cgi?114365 From White Noise: Chapter 17 (Excerpt)]
+
|[http://www.isfdb.org/cgi-bin/title.cgi?851467 Dr. Phil's Aeolian Transformers]
 
|SERIAL
 
|SERIAL
−
|[http://www.isfdb.org/cgi-bin/pl.cgi?26485 Postmodern American Fiction]
+
|[http://www.isfdb.org/cgi-bin/pl.cgi?255173 Grantville Gazette VI]
 
|ANTHOLOGY
 
|ANTHOLOGY
 
|
 
|
 
|-
 
|-
−
|[http://www.isfdb.org/cgi-bin/title.cgi?114367 From White Noise: Chapter 7 (Excerpt)]
+
|[http://www.isfdb.org/cgi-bin/title.cgi?851466 Dr. Phil's Amazing Lightning Crystal]
 
|SERIAL
 
|SERIAL
−
|[http://www.isfdb.org/cgi-bin/pl.cgi?26485 Postmodern American Fiction]
+
|[http://www.isfdb.org/cgi-bin/pl.cgi?255173 Grantville Gazette VI]
 
|ANTHOLOGY
 
|ANTHOLOGY
 
|
 
|
 
|-
 
|-
−
|[http://www.isfdb.org/cgi-bin/title.cgi?114366 From White Noise: Chapter 9 (Excerpt)]
+
|[http://www.isfdb.org/cgi-bin/title.cgi?113551 Earth, the Marauder (Part 3 of 3)]
 
|SERIAL
 
|SERIAL
−
|[http://www.isfdb.org/cgi-bin/pl.cgi?26485 Postmodern American Fiction]
+
|[http://www.isfdb.org/cgi-bin/pl.cgi?302523 Astounding Stories of Super-Science, September 1930]
 +
|ANTHOLOGY
 +
|
 +
|-
 +
|[http://www.isfdb.org/cgi-bin/title.cgi?851886 Essen Steel, Part 1: Crucibellus]
 +
|SERIAL
 +
|[http://www.isfdb.org/cgi-bin/pl.cgi?255327 Grantville Gazette VII]
 +
|ANTHOLOGY
 +
|
 +
|-
 +
|[http://www.isfdb.org/cgi-bin/title.cgi?851003 Euterpe, Episode 1]
 +
|SERIAL
 +
|[http://www.isfdb.org/cgi-bin/pl.cgi?81782 Grantville Gazette II]
 +
|ANTHOLOGY
 +
|
 +
|-
 +
|[http://www.isfdb.org/cgi-bin/title.cgi?851003 Euterpe, Episode 1]
 +
|SERIAL
 +
|[http://www.isfdb.org/cgi-bin/pl.cgi?255089 Grantville Gazette II]
 +
|ANTHOLOGY
 +
|
 +
|-
 +
|[http://www.isfdb.org/cgi-bin/title.cgi?851003 Euterpe, Episode 1]
 +
|SERIAL
 +
|[http://www.isfdb.org/cgi-bin/pl.cgi?282180 Grantville Gazette II]
 +
|ANTHOLOGY
 +
|
 +
|-
 +
|[http://www.isfdb.org/cgi-bin/title.cgi?851430 Euterpe, Episode 2]
 +
|SERIAL
 +
|[http://www.isfdb.org/cgi-bin/pl.cgi?255170 Grantville Gazette III]
 +
|ANTHOLOGY
 +
|
 +
|-
 +
|[http://www.isfdb.org/cgi-bin/title.cgi?851430 Euterpe, Episode 2]
 +
|SERIAL
 +
|[http://www.isfdb.org/cgi-bin/pl.cgi?280804 Grantville Gazette III]
 +
|ANTHOLOGY
 +
|
 +
|-
 +
|[http://www.isfdb.org/cgi-bin/title.cgi?851447 Euterpe, Episode 3]
 +
|SERIAL
 +
|[http://www.isfdb.org/cgi-bin/pl.cgi?255171 Grantville Gazette V]
 +
|ANTHOLOGY
 +
|
 +
|-
 +
|[http://www.isfdb.org/cgi-bin/title.cgi?966803 Franconia! Part 1]
 +
|SERIAL
 +
|[http://www.isfdb.org/cgi-bin/pl.cgi?280956 Grantville Gazette X]
 
|ANTHOLOGY
 
|ANTHOLOGY
 
|
 
|
Line 63: Line 156:
 
|[http://www.isfdb.org/cgi-bin/title.cgi?63959 Iron (Part 2 of 2)]
 
|[http://www.isfdb.org/cgi-bin/title.cgi?63959 Iron (Part 2 of 2)]
 
|SERIAL
 
|SERIAL
−
|[http://www.isfdb.org/cgi-bin/pl.cgi?18167 Inconstant Star]
+
|[http://www.isfdb.org/cgi-bin/pl.cgi?23713 New Destinies, Volume I/Spring 1987]
 +
|ANTHOLOGY
 +
|
 +
|-
 +
|[http://www.isfdb.org/cgi-bin/title.cgi?113552 Jetta of the Lowlands (Part 1 of 3)]
 +
|SERIAL
 +
|[http://www.isfdb.org/cgi-bin/pl.cgi?302523 Astounding Stories of Super-Science, September 1930]
 +
|ANTHOLOGY
 +
|
 +
|-
 +
|[http://www.isfdb.org/cgi-bin/title.cgi?21191 Murder in Space (Complete Novel)]
 +
|SERIAL
 +
|[http://www.isfdb.org/cgi-bin/pl.cgi?222153 Murder in Space]
 +
|NOVEL
 +
|
 +
|-
 +
|[http://www.isfdb.org/cgi-bin/title.cgi?955135 Mutants in Action (Complete Novel)]
 +
|SERIAL
 +
|[http://www.isfdb.org/cgi-bin/pl.cgi?267071 The Vega Sector]
 +
|ANTHOLOGY
 +
|
 +
|-
 +
|[http://www.isfdb.org/cgi-bin/title.cgi?16997 My Heart Leaps Up (Part 1 of 5)]
 +
|SERIAL
 +
|[http://www.isfdb.org/cgi-bin/pl.cgi?23216 My Heart Leaps Up, Chapters 1 & 2]
 +
|CHAPTERBOOK
 +
|
 +
|-
 +
|[http://www.isfdb.org/cgi-bin/title.cgi?16997 My Heart Leaps Up (Part 1 of 5)]
 +
|SERIAL
 +
|[http://www.isfdb.org/cgi-bin/pl.cgi?295072 My Heart Leaps Up, Chapters 1 & 2]
 +
|CHAPTERBOOK
 +
|
 +
|-
 +
|[http://www.isfdb.org/cgi-bin/title.cgi?886264 My Heart Leaps Up (Part 2 of 5)]
 +
|SERIAL
 +
|[http://www.isfdb.org/cgi-bin/pl.cgi?264121 My Heart Leaps Up, Chapters 3 & 4]
 +
|CHAPTERBOOK
 +
|
 +
|-
 +
|[http://www.isfdb.org/cgi-bin/title.cgi?886264 My Heart Leaps Up (Part 2 of 5)]
 +
|SERIAL
 +
|[http://www.isfdb.org/cgi-bin/pl.cgi?295073 My Heart Leaps Up, Chapters 3 & 4]
 +
|CHAPTERBOOK
 +
|
 +
|-
 +
|[http://www.isfdb.org/cgi-bin/title.cgi?886265 My Heart Leaps Up (Part 3 of 5)]
 +
|SERIAL
 +
|[http://www.isfdb.org/cgi-bin/pl.cgi?264122 My Heart Leaps Up, Chapters 5 & 6]
 +
|CHAPTERBOOK
 +
|
 +
|-
 +
|[http://www.isfdb.org/cgi-bin/title.cgi?886265 My Heart Leaps Up (Part 3 of 5)]
 +
|SERIAL
 +
|[http://www.isfdb.org/cgi-bin/pl.cgi?295074 My Heart Leaps Up, Chapters 5 & 6]
 +
|CHAPTERBOOK
 +
|
 +
|-
 +
|[http://www.isfdb.org/cgi-bin/title.cgi?886267 My Heart Leaps Up (Part 4 of 5)]
 +
|SERIAL
 +
|[http://www.isfdb.org/cgi-bin/pl.cgi?264124 My Heart Leaps Up, Chapters 7 & 8]
 +
|CHAPTERBOOK
 +
|
 +
|-
 +
|[http://www.isfdb.org/cgi-bin/title.cgi?886267 My Heart Leaps Up (Part 4 of 5)]
 +
|SERIAL
 +
|[http://www.isfdb.org/cgi-bin/pl.cgi?295075 My Heart Leaps Up, Chapters 7 & 8]
 +
|CHAPTERBOOK
 +
|
 +
|-
 +
|[http://www.isfdb.org/cgi-bin/title.cgi?16996 My Heart Leaps Up (Part 5 of 5)]
 +
|SERIAL
 +
|[http://www.isfdb.org/cgi-bin/pl.cgi?23217 My Heart Leaps Up, Chapters 9 & 10]
 +
|CHAPTERBOOK
 +
|
 +
|-
 +
|[http://www.isfdb.org/cgi-bin/title.cgi?16996 My Heart Leaps Up (Part 5 of 5)]
 +
|SERIAL
 +
|[http://www.isfdb.org/cgi-bin/pl.cgi?295076 My Heart Leaps Up, Chapters 9 & 10]
 +
|CHAPTERBOOK
 +
|
 +
|-
 +
|[http://www.isfdb.org/cgi-bin/title.cgi?955134 Space Battle in the Vega Sector (Complete Novel)]
 +
|SERIAL
 +
|[http://www.isfdb.org/cgi-bin/pl.cgi?267071 The Vega Sector]
 +
|ANTHOLOGY
 +
|
 +
|-
 +
|[http://www.isfdb.org/cgi-bin/title.cgi?974517 Stretching Out, Part One: Second Starts]
 +
|SERIAL
 +
|[http://www.isfdb.org/cgi-bin/pl.cgi?282259 Grantville Gazette XI]
 +
|ANTHOLOGY
 +
|
 +
|-
 +
|[http://www.isfdb.org/cgi-bin/title.cgi?851446 Suite For Four Hands]
 +
|SERIAL
 +
|[http://www.isfdb.org/cgi-bin/pl.cgi?255171 Grantville Gazette V]
 +
|ANTHOLOGY
 +
|
 +
|-
 +
|[http://www.isfdb.org/cgi-bin/title.cgi?114334 The Blue Monkeys (Part 1 of 3)]
 +
|SERIAL
 +
|[http://www.isfdb.org/cgi-bin/pl.cgi?29740 SF Reprise 3]
 +
|ANTHOLOGY
 +
|
 +
|-
 +
|[http://www.isfdb.org/cgi-bin/title.cgi?114335 The Blue Monkeys (Part 2 of 3)]
 +
|SERIAL
 +
|[http://www.isfdb.org/cgi-bin/pl.cgi?29740 SF Reprise 3]
 +
|ANTHOLOGY
 +
|
 +
|-
 +
|[http://www.isfdb.org/cgi-bin/title.cgi?114336 The Blue Monkeys (Part 3 of 3)]
 +
|SERIAL
 +
|[http://www.isfdb.org/cgi-bin/pl.cgi?29740 SF Reprise 3]
 +
|ANTHOLOGY
 +
|
 +
|-
 +
|[http://www.isfdb.org/cgi-bin/title.cgi?963455 The Captive (Part 1 of 2)]
 +
|SERIAL
 +
|[http://www.isfdb.org/cgi-bin/pl.cgi?259304 The Secret Circle: The Initiation and The Captive Part 1]
 +
|OMNIBUS
 +
|
 +
|-
 +
|[http://www.isfdb.org/cgi-bin/title.cgi?963453 The Captive (Part 2 of 2)]
 +
|SERIAL
 +
|[http://www.isfdb.org/cgi-bin/pl.cgi?273575 The Secret Circle: The Captive Part II and The Power]
 +
|OMNIBUS
 +
|
 +
|-
 +
|[http://www.isfdb.org/cgi-bin/title.cgi?120930 The Challenge from Beyond (Part 1 of 5)]
 +
|SERIAL
 +
|[http://www.isfdb.org/cgi-bin/pl.cgi?17311 Horrors Unknown]
 +
|ANTHOLOGY
 +
|
 +
|-
 +
|[http://www.isfdb.org/cgi-bin/title.cgi?120930 The Challenge from Beyond (Part 1 of 5)]
 +
|SERIAL
 +
|[http://www.isfdb.org/cgi-bin/pl.cgi?23383 Nameless Cults: The Cthulhu Mythos Fiction of Robert E. Howard]
 
|COLLECTION
 
|COLLECTION
 
|
 
|
 
|-
 
|-
−
|[http://www.isfdb.org/cgi-bin/title.cgi?63959 Iron (Part 2 of 2)]
+
|[http://www.isfdb.org/cgi-bin/title.cgi?120930 The Challenge from Beyond (Part 1 of 5)]
 
|SERIAL
 
|SERIAL
−
|[http://www.isfdb.org/cgi-bin/pl.cgi?23713 New Destinies, Volume I/Spring 1987]
+
|[http://www.isfdb.org/cgi-bin/pl.cgi?71558 Seekers of Dreams: Masterpieces of Fantasy]
 
|ANTHOLOGY
 
|ANTHOLOGY
 
|
 
|
 
|-
 
|-
−
|[http://www.isfdb.org/cgi-bin/title.cgi?63959 Iron (Part 2 of 2)]
+
|[http://www.isfdb.org/cgi-bin/title.cgi?120930 The Challenge from Beyond (Part 1 of 5)]
 
|SERIAL
 
|SERIAL
−
|[http://www.isfdb.org/cgi-bin/pl.cgi?43839 The Man-Kzin Wars]
+
|[http://www.isfdb.org/cgi-bin/pl.cgi?301157 Horrors Unknown]
 
|ANTHOLOGY
 
|ANTHOLOGY
 
|
 
|
 
|-
 
|-
−
|[http://www.isfdb.org/cgi-bin/title.cgi?114361 Journal from Ellipsia (Excerpt)]
+
|[http://www.isfdb.org/cgi-bin/title.cgi?133172 The Challenge from Beyond (Part 2 of 5)]
 
|SERIAL
 
|SERIAL
−
|[http://www.isfdb.org/cgi-bin/pl.cgi?29731 SF 12]
+
|[http://www.isfdb.org/cgi-bin/pl.cgi?17311 Horrors Unknown]
 
|ANTHOLOGY
 
|ANTHOLOGY
−
|FIXED
+
|
 +
|-
 +
|[http://www.isfdb.org/cgi-bin/title.cgi?133172 The Challenge from Beyond (Part 2 of 5)]
 +
|SERIAL
 +
|[http://www.isfdb.org/cgi-bin/pl.cgi?23383 Nameless Cults: The Cthulhu Mythos Fiction of Robert E. Howard]
 +
|COLLECTION
 +
|
 
|-
 
|-
−
|[http://www.isfdb.org/cgi-bin/title.cgi?114361 Journal from Ellipsia (Excerpt)]
+
|[http://www.isfdb.org/cgi-bin/title.cgi?133172 The Challenge from Beyond (Part 2 of 5)]
 
|SERIAL
 
|SERIAL
−
|[http://www.isfdb.org/cgi-bin/pl.cgi?189201 SF 12]
+
|[http://www.isfdb.org/cgi-bin/pl.cgi?71558 Seekers of Dreams: Masterpieces of Fantasy]
 
|ANTHOLOGY
 
|ANTHOLOGY
−
|FIXED
+
|
 
|-
 
|-
−
|[http://www.isfdb.org/cgi-bin/title.cgi?114364 Sleipnir (Excerpt)]
+
|[http://www.isfdb.org/cgi-bin/title.cgi?133172 The Challenge from Beyond (Part 2 of 5)]
 
|SERIAL
 
|SERIAL
−
|[http://www.isfdb.org/cgi-bin/pl.cgi?29190 Science Fiction Writer's Market Place and Sourcebook]
+
|[http://www.isfdb.org/cgi-bin/pl.cgi?301157 Horrors Unknown]
−
|NOVEL
+
|ANTHOLOGY
−
|FIXED
+
|
 
|-
 
|-
−
|[http://www.isfdb.org/cgi-bin/title.cgi?114360 Stand on Zanzibar (Excerpt)]
+
|[http://www.isfdb.org/cgi-bin/title.cgi?120928 The Challenge from Beyond (Part 3 of 5)]
 
|SERIAL
 
|SERIAL
−
|[http://www.isfdb.org/cgi-bin/pl.cgi?46280 The Road to Science Fiction 3: From Heinlein to Here]
+
|[http://www.isfdb.org/cgi-bin/pl.cgi?17311 Horrors Unknown]
 
|ANTHOLOGY
 
|ANTHOLOGY
−
|FIXED
+
|
 
|-
 
|-
−
|[http://www.isfdb.org/cgi-bin/title.cgi?114360 Stand on Zanzibar (Excerpt)]
+
|[http://www.isfdb.org/cgi-bin/title.cgi?120928 The Challenge from Beyond (Part 3 of 5)]
 
|SERIAL
 
|SERIAL
−
|[http://www.isfdb.org/cgi-bin/pl.cgi?163141 The Road to Science Fiction 3: From Heinlein to Here]
+
|[http://www.isfdb.org/cgi-bin/pl.cgi?23383 Nameless Cults: The Cthulhu Mythos Fiction of Robert E. Howard]
 +
|COLLECTION
 +
|
 +
|-
 +
|[http://www.isfdb.org/cgi-bin/title.cgi?120928 The Challenge from Beyond (Part 3 of 5)]
 +
|SERIAL
 +
|[http://www.isfdb.org/cgi-bin/pl.cgi?71558 Seekers of Dreams: Masterpieces of Fantasy]
 
|ANTHOLOGY
 
|ANTHOLOGY
−
|FIXED
+
|
 
|-
 
|-
−
|[http://www.isfdb.org/cgi-bin/title.cgi?686929 The Bridge of Light]
+
|[http://www.isfdb.org/cgi-bin/title.cgi?120928 The Challenge from Beyond (Part 3 of 5)]
 
|SERIAL
 
|SERIAL
−
|[http://www.isfdb.org/cgi-bin/pl.cgi?36543 The Bridge of Light]
+
|[http://www.isfdb.org/cgi-bin/pl.cgi?301157 Horrors Unknown]
−
|NOVEL
+
|ANTHOLOGY
−
|FIXED
+
|
 
|-
 
|-
−
|[http://www.isfdb.org/cgi-bin/title.cgi?41467 The Dragon Masters (Complete Novel)]
+
|[http://www.isfdb.org/cgi-bin/title.cgi?120927 The Challenge from Beyond (Part 4 of 5)]
 
|SERIAL
 
|SERIAL
−
|[http://www.isfdb.org/cgi-bin/pl.cgi?33349 Stories from the Hugo Winners, Volume 2]
+
|[http://www.isfdb.org/cgi-bin/pl.cgi?17311 Horrors Unknown]
 
|ANTHOLOGY
 
|ANTHOLOGY
 
|
 
|
 
|-
 
|-
−
|[http://www.isfdb.org/cgi-bin/title.cgi?41467 The Dragon Masters (Complete Novel)]
+
|[http://www.isfdb.org/cgi-bin/title.cgi?120927 The Challenge from Beyond (Part 4 of 5)]
 +
|SERIAL
 +
|[http://www.isfdb.org/cgi-bin/pl.cgi?23383 Nameless Cults: The Cthulhu Mythos Fiction of Robert E. Howard]
 +
|COLLECTION
 +
|
 +
|-
 +
|[http://www.isfdb.org/cgi-bin/title.cgi?120927 The Challenge from Beyond (Part 4 of 5)]
 
|SERIAL
 
|SERIAL
−
|[http://www.isfdb.org/cgi-bin/pl.cgi?41815 The Hugo Winners, Volume 2]
+
|[http://www.isfdb.org/cgi-bin/pl.cgi?71558 Seekers of Dreams: Masterpieces of Fantasy]
 
|ANTHOLOGY
 
|ANTHOLOGY
 
|
 
|
 
|-
 
|-
−
|[http://www.isfdb.org/cgi-bin/title.cgi?41467 The Dragon Masters (Complete Novel)]
+
|[http://www.isfdb.org/cgi-bin/title.cgi?120927 The Challenge from Beyond (Part 4 of 5)]
 
|SERIAL
 
|SERIAL
−
|[http://www.isfdb.org/cgi-bin/pl.cgi?41819 The Hugo Winners Volume One 1962-1967]
+
|[http://www.isfdb.org/cgi-bin/pl.cgi?301157 Horrors Unknown]
 
|ANTHOLOGY
 
|ANTHOLOGY
 
|
 
|
 
|-
 
|-
−
|[http://www.isfdb.org/cgi-bin/title.cgi?41467 The Dragon Masters (Complete Novel)]
+
|[http://www.isfdb.org/cgi-bin/title.cgi?120926 The Challenge from Beyond (Part 5 of 5)]
 
|SERIAL
 
|SERIAL
−
|[http://www.isfdb.org/cgi-bin/pl.cgi?41821 The Hugo Winners, Volumes One and Two]
+
|[http://www.isfdb.org/cgi-bin/pl.cgi?17311 Horrors Unknown]
 
|ANTHOLOGY
 
|ANTHOLOGY
 
|
 
|
 
|-
 
|-
−
|[http://www.isfdb.org/cgi-bin/title.cgi?41467 The Dragon Masters (Complete Novel)]
+
|[http://www.isfdb.org/cgi-bin/title.cgi?120926 The Challenge from Beyond (Part 5 of 5)]
 
|SERIAL
 
|SERIAL
−
|[http://www.isfdb.org/cgi-bin/pl.cgi?89319 The Jack Vance Treasury]
+
|[http://www.isfdb.org/cgi-bin/pl.cgi?23383 Nameless Cults: The Cthulhu Mythos Fiction of Robert E. Howard]
 
|COLLECTION
 
|COLLECTION
 
|
 
|
 
|-
 
|-
−
|[http://www.isfdb.org/cgi-bin/title.cgi?41467 The Dragon Masters (Complete Novel)]
+
|[http://www.isfdb.org/cgi-bin/title.cgi?120926 The Challenge from Beyond (Part 5 of 5)]
 
|SERIAL
 
|SERIAL
−
|[http://www.isfdb.org/cgi-bin/pl.cgi?155251 The Hugo Winners Volume One 1962-1967]
+
|[http://www.isfdb.org/cgi-bin/pl.cgi?71558 Seekers of Dreams: Masterpieces of Fantasy]
 
|ANTHOLOGY
 
|ANTHOLOGY
 
|
 
|
 
|-
 
|-
−
|[http://www.isfdb.org/cgi-bin/title.cgi?113322 The Eye of the Heron (Complete Novel)]
+
|[http://www.isfdb.org/cgi-bin/title.cgi?120926 The Challenge from Beyond (Part 5 of 5)]
 
|SERIAL
 
|SERIAL
−
|[http://www.isfdb.org/cgi-bin/pl.cgi?22208 Millennial Women]
+
|[http://www.isfdb.org/cgi-bin/pl.cgi?301157 Horrors Unknown]
 
|ANTHOLOGY
 
|ANTHOLOGY
−
|FIXED
+
|
 
|-
 
|-
−
|[http://www.isfdb.org/cgi-bin/title.cgi?114359 The Left Hand of Darkness (Excerpt)]
+
|[http://www.isfdb.org/cgi-bin/title.cgi?851465 The Doctor Gribbleflotz Chronicles, Part 1: Calling Dr. Phil]
 
|SERIAL
 
|SERIAL
−
|[http://www.isfdb.org/cgi-bin/pl.cgi?46280 The Road to Science Fiction 3: From Heinlein to Here]
+
|[http://www.isfdb.org/cgi-bin/pl.cgi?255173 Grantville Gazette VI]
 
|ANTHOLOGY
 
|ANTHOLOGY
−
|FIXED
+
|
 
|-
 
|-
−
|[http://www.isfdb.org/cgi-bin/title.cgi?114359 The Left Hand of Darkness (Excerpt)]
+
|[http://www.isfdb.org/cgi-bin/title.cgi?852657 The Doctor Gribbleflotz Chronicles, Part 3: Doctor Phil's Distraction]
 
|SERIAL
 
|SERIAL
−
|[http://www.isfdb.org/cgi-bin/pl.cgi?163141 The Road to Science Fiction 3: From Heinlein to Here]
+
|[http://www.isfdb.org/cgi-bin/pl.cgi?255473 Grantville Gazette VIII]
 
|ANTHOLOGY
 
|ANTHOLOGY
−
|FIXED
+
|
 
|-
 
|-
−
|[http://www.isfdb.org/cgi-bin/title.cgi?692621 The Mad Lands - Part 1: Death Wish]
+
|[http://www.isfdb.org/cgi-bin/title.cgi?966804 The Doctor Phil Chronicles: Doctor Phil's Family]
 
|SERIAL
 
|SERIAL
−
|[http://www.isfdb.org/cgi-bin/pl.cgi?72966 Adventure]
+
|[http://www.isfdb.org/cgi-bin/pl.cgi?280956 Grantville Gazette X]
 
|ANTHOLOGY
 
|ANTHOLOGY
 
|
 
|
 
|-
 
|-
−
|[http://www.isfdb.org/cgi-bin/title.cgi?572109 The Man on the Meteor - Part 3 (chapters 5-7)]
+
|[http://www.isfdb.org/cgi-bin/title.cgi?851884 The Dr. Gribbleflotz Chronicles, Part 2: Dr. Phil's Amazing Essence Of Fire Tablets]
 
|SERIAL
 
|SERIAL
−
|[http://www.isfdb.org/cgi-bin/pl.cgi?188729 Conflict Center: Naator]
+
|[http://www.isfdb.org/cgi-bin/pl.cgi?255327 Grantville Gazette VII]
−
|NOVEL
+
|ANTHOLOGY
 
|
 
|
 
|-
 
|-
−
|[http://www.isfdb.org/cgi-bin/title.cgi?178801 The Pillars of the Earth Part 1 of 3]
+
|[http://www.isfdb.org/cgi-bin/title.cgi?966781 The Essen Chronicles, Part 3: Trip to Paris]
 
|SERIAL
 
|SERIAL
−
|[http://www.isfdb.org/cgi-bin/pl.cgi?79927 The Pillars of the Earth Part 1 of 3]
+
|[http://www.isfdb.org/cgi-bin/pl.cgi?280955 Grantville Gazette IX]
−
|NOVEL
+
|ANTHOLOGY
 
|
 
|
 
|-
 
|-
−
|[http://www.isfdb.org/cgi-bin/title.cgi?178800 The Pillars of the Earth Part 2 of 3]
+
|[http://www.isfdb.org/cgi-bin/title.cgi?852658 The Essen Steel Chronicles, Part 2: Louis de Geer]
 
|SERIAL
 
|SERIAL
−
|[http://www.isfdb.org/cgi-bin/pl.cgi?79926 The Pillars of the Earth Part 2 of 3]
+
|[http://www.isfdb.org/cgi-bin/pl.cgi?255473 Grantville Gazette VIII]
−
|NOVEL
+
|ANTHOLOGY
 
|
 
|
 
|-
 
|-
−
|[http://www.isfdb.org/cgi-bin/title.cgi?178804 The Pillars of the Earth Part 3 of 3]
+
|[http://www.isfdb.org/cgi-bin/title.cgi?193318 The Impossible Smile (Part 1 of 2)]
 
|SERIAL
 
|SERIAL
−
|[http://www.isfdb.org/cgi-bin/pl.cgi?79930 The Pillars of the Earth Part 3 of 3]
+
|[http://www.isfdb.org/cgi-bin/pl.cgi?29743 SF Reprise 6]
−
|NOVEL
+
|ANTHOLOGY
 
|
 
|
 
|-
 
|-
−
|[http://www.isfdb.org/cgi-bin/title.cgi?113774 The Sleeper and the Seer (Excerpt from King of the World's Edge)]
+
|[http://www.isfdb.org/cgi-bin/title.cgi?193319 The Impossible Smile (Part 2 of 2)]
 
|SERIAL
 
|SERIAL
−
|[http://www.isfdb.org/cgi-bin/pl.cgi?44077 The Merlin Chronicles]
+
|[http://www.isfdb.org/cgi-bin/pl.cgi?29743 SF Reprise 6]
 
|ANTHOLOGY
 
|ANTHOLOGY
 
|
 
|
 
|-
 
|-
−
|[http://www.isfdb.org/cgi-bin/title.cgi?113774 The Sleeper and the Seer (Excerpt from King of the World's Edge)]
+
|[http://www.isfdb.org/cgi-bin/title.cgi?1059924 The Omega Egg (Part 1 of 17): Conversation with an Admiral]
 +
|SERIAL
 +
|[http://www.isfdb.org/cgi-bin/pl.cgi?302697 The Omega Egg (Part 1 of 17)]
 +
|CHAPTERBOOK
 +
|
 +
|-
 +
|[http://www.isfdb.org/cgi-bin/title.cgi?1059905 The Omega Egg (Part 10 of 17): Holes in the Universe]
 
|SERIAL
 
|SERIAL
−
|[http://www.isfdb.org/cgi-bin/pl.cgi?44078 The Merlin Chronicles]
+
|[http://www.isfdb.org/cgi-bin/pl.cgi?302688 The Omega Egg (Part 10 of 17)]
−
|ANTHOLOGY
+
|CHAPTERBOOK
 +
|
 +
|-
 +
|[http://www.isfdb.org/cgi-bin/title.cgi?1059903 The Omega Egg (Part 11 of 17): Choosing Sides]
 +
|SERIAL
 +
|[http://www.isfdb.org/cgi-bin/pl.cgi?302687 The Omega Egg (Part 11 of 17)]
 +
|CHAPTERBOOK
 +
|
 +
|-
 +
|[http://www.isfdb.org/cgi-bin/title.cgi?1059901 The Omega Egg (Part 12 of 17): Picking a God's Nose]
 +
|SERIAL
 +
|[http://www.isfdb.org/cgi-bin/pl.cgi?302686 The Omega Egg (Part 12 of 17)]
 +
|CHAPTERBOOK
 +
|
 +
|-
 +
|[http://www.isfdb.org/cgi-bin/title.cgi?1059899 The Omega Egg (Part 13 of 17): The Search for Bob]
 +
|SERIAL
 +
|[http://www.isfdb.org/cgi-bin/pl.cgi?302685 The Omega Egg (Part 13 of 17)]
 +
|CHAPTERBOOK
 +
|
 +
|-
 +
|[http://www.isfdb.org/cgi-bin/title.cgi?1059897 The Omega Egg (Part 14 of 17): The End of Some Things, the Beginning of Others]
 +
|SERIAL
 +
|[http://www.isfdb.org/cgi-bin/pl.cgi?302684 The Omega Egg (Part 14 of 17)]
 +
|CHAPTERBOOK
 +
|
 +
|-
 +
|[http://www.isfdb.org/cgi-bin/title.cgi?1059895 The Omega Egg (Part 15 of 17): Mr. Spencer's Blues]
 +
|SERIAL
 +
|[http://www.isfdb.org/cgi-bin/pl.cgi?302683 The Omega Egg (Part 15 of 17)]
 +
|CHAPTERBOOK
 +
|
 +
|-
 +
|[http://www.isfdb.org/cgi-bin/title.cgi?1059297 The Omega Egg (Part 16 of 17): Conversation With His Future Self]
 +
|SERIAL
 +
|[http://www.isfdb.org/cgi-bin/pl.cgi?302642 The Omega Egg (Part 16 of 17)]
 +
|CHAPTERBOOK
 +
|
 +
|-
 +
|[http://www.isfdb.org/cgi-bin/title.cgi?1059295 The Omega Egg (Part 17 of 17): For Whom the Bellflower Tolls]
 +
|SERIAL
 +
|[http://www.isfdb.org/cgi-bin/pl.cgi?302641 The Omega Egg (Part 17 of 17)]
 +
|CHAPTERBOOK
 +
|
 +
|-
 +
|[http://www.isfdb.org/cgi-bin/title.cgi?1059922 The Omega Egg (Part 2 of 17): Conversation with a Dragon]
 +
|SERIAL
 +
|[http://www.isfdb.org/cgi-bin/pl.cgi?302696 The Omega Egg (Part 2 of 17)]
 +
|CHAPTERBOOK
 +
|
 +
|-
 +
|[http://www.isfdb.org/cgi-bin/title.cgi?1059920 The Omega Egg (Part 3 of 17): Dreams and Nightmares]
 +
|SERIAL
 +
|[http://www.isfdb.org/cgi-bin/pl.cgi?302695 The Omega Egg (Part 3 of 17)]
 +
|CHAPTERBOOK
 +
|
 +
|-
 +
|[http://www.isfdb.org/cgi-bin/title.cgi?1059918 The Omega Egg (Part 4 of 17): Smoke and Mirrors]
 +
|SERIAL
 +
|[http://www.isfdb.org/cgi-bin/pl.cgi?302694 The Omega Egg (Part 4 of 17)]
 +
|CHAPTERBOOK
 +
|
 +
|-
 +
|[http://www.isfdb.org/cgi-bin/title.cgi?1059916 The Omega Egg (Part 5 of 17): The Egg and the Dragon]
 +
|SERIAL
 +
|[http://www.isfdb.org/cgi-bin/pl.cgi?302693 The Omega Egg (Part 5 of 17)]
 +
|CHAPTERBOOK
 
|
 
|
 
|-
 
|-
−
|[http://www.isfdb.org/cgi-bin/title.cgi?555277 Untitled: Visible Light (part 1 of 7)]
+
|[http://www.isfdb.org/cgi-bin/title.cgi?1059914 The Omega Egg (Part 6 of 17): The Da Vinci Code]
 
|SERIAL
 
|SERIAL
−
|[http://www.isfdb.org/cgi-bin/pl.cgi?7522 The Collected Short Fiction of C. J. Cherryh]
+
|[http://www.isfdb.org/cgi-bin/pl.cgi?302692 The Omega Egg (Part 6 of 17)]
−
|COLLECTION
+
|CHAPTERBOOK
 
|
 
|
 
|-
 
|-
−
|[http://www.isfdb.org/cgi-bin/title.cgi?555277 Untitled: Visible Light (part 1 of 7)]
+
|[http://www.isfdb.org/cgi-bin/title.cgi?1059912 The Omega Egg (Part 7 of 17): Your Own Private Gulag]
 
|SERIAL
 
|SERIAL
−
|[http://www.isfdb.org/cgi-bin/pl.cgi?185157 The Collected Short Fiction of C. J. Cherryh]
+
|[http://www.isfdb.org/cgi-bin/pl.cgi?302691 The Omega Egg (Part 7 of 17)]
−
|COLLECTION
+
|CHAPTERBOOK
 
|
 
|
 
|-
 
|-
−
|[http://www.isfdb.org/cgi-bin/title.cgi?555285 Untitled: Visible Light (part 2 of 7)]
+
|[http://www.isfdb.org/cgi-bin/title.cgi?1059909 The Omega Egg (Part 8 of 17): Altar Ego]
 
|SERIAL
 
|SERIAL
−
|[http://www.isfdb.org/cgi-bin/pl.cgi?7522 The Collected Short Fiction of C. J. Cherryh]
+
|[http://www.isfdb.org/cgi-bin/pl.cgi?302690 The Omega Egg (Part 8 of 17)]
−
|COLLECTION
+
|CHAPTERBOOK
 
|
 
|
 
|-
 
|-
−
|[http://www.isfdb.org/cgi-bin/title.cgi?555285 Untitled: Visible Light (part 2 of 7)]
+
|[http://www.isfdb.org/cgi-bin/title.cgi?1059907 The Omega Egg (Part 9 of 17): Falling]
 
|SERIAL
 
|SERIAL
−
|[http://www.isfdb.org/cgi-bin/pl.cgi?185157 The Collected Short Fiction of C. J. Cherryh]
+
|[http://www.isfdb.org/cgi-bin/pl.cgi?302689 The Omega Egg (Part 9 of 17)]
−
|COLLECTION
+
|CHAPTERBOOK
 
|
 
|
 
|-
 
|-
−
|[http://www.isfdb.org/cgi-bin/title.cgi?555293 Untitled: Visible Light (part 3 of 7)]
+
|[http://www.isfdb.org/cgi-bin/title.cgi?178801 The Pillars of the Earth (Part 1 of 3)]
 
|SERIAL
 
|SERIAL
−
|[http://www.isfdb.org/cgi-bin/pl.cgi?7522 The Collected Short Fiction of C. J. Cherryh]
+
|[http://www.isfdb.org/cgi-bin/pl.cgi?79927 The Pillars of the Earth (Part 1 of 3)]
−
|COLLECTION
+
|NOVEL
 
|
 
|
 
|-
 
|-
−
|[http://www.isfdb.org/cgi-bin/title.cgi?555293 Untitled: Visible Light (part 3 of 7)]
+
|[http://www.isfdb.org/cgi-bin/title.cgi?178800 The Pillars of the Earth (Part 2 of 3)]
 
|SERIAL
 
|SERIAL
−
|[http://www.isfdb.org/cgi-bin/pl.cgi?185157 The Collected Short Fiction of C. J. Cherryh]
+
|[http://www.isfdb.org/cgi-bin/pl.cgi?79926 The Pillars of the Earth (Part 2 of 3)]
−
|COLLECTION
+
|NOVEL
 
|
 
|
 
|-
 
|-
−
|[http://www.isfdb.org/cgi-bin/title.cgi?555301 Untitled: Visible Light (part 4 of 7)]
+
|[http://www.isfdb.org/cgi-bin/title.cgi?178804 The Pillars of the Earth (Part 3 of 3)]
 
|SERIAL
 
|SERIAL
−
|[http://www.isfdb.org/cgi-bin/pl.cgi?7522 The Collected Short Fiction of C. J. Cherryh]
+
|[http://www.isfdb.org/cgi-bin/pl.cgi?79930 The Pillars of the Earth (Part 3 of 3)]
−
|COLLECTION
+
|NOVEL
 
|
 
|
 
|-
 
|-
−
|[http://www.isfdb.org/cgi-bin/title.cgi?555301 Untitled: Visible Light (part 4 of 7)]
+
|[http://www.isfdb.org/cgi-bin/title.cgi?741389 The Plant (Part 1 of ?)]
 
|SERIAL
 
|SERIAL
−
|[http://www.isfdb.org/cgi-bin/pl.cgi?185157 The Collected Short Fiction of C. J. Cherryh]
+
|[http://www.isfdb.org/cgi-bin/pl.cgi?232185 The Plant]
−
|COLLECTION
+
|CHAPTERBOOK
 
|
 
|
 
|-
 
|-
−
|[http://www.isfdb.org/cgi-bin/title.cgi?555309 Untitled: Visible Light (part 5 of 7)]
+
|[http://www.isfdb.org/cgi-bin/title.cgi?532365 The Power of Y (Part 1 of 2)]
 
|SERIAL
 
|SERIAL
−
|[http://www.isfdb.org/cgi-bin/pl.cgi?7522 The Collected Short Fiction of C. J. Cherryh]
+
|[http://www.isfdb.org/cgi-bin/pl.cgi?29739 SF Reprise 2]
−
|COLLECTION
+
|ANTHOLOGY
 
|
 
|
 
|-
 
|-
−
|[http://www.isfdb.org/cgi-bin/title.cgi?555309 Untitled: Visible Light (part 5 of 7)]
+
|[http://www.isfdb.org/cgi-bin/title.cgi?532401 The Power of Y (Part 2 of 2)]
 
|SERIAL
 
|SERIAL
−
|[http://www.isfdb.org/cgi-bin/pl.cgi?185157 The Collected Short Fiction of C. J. Cherryh]
+
|[http://www.isfdb.org/cgi-bin/pl.cgi?29739 SF Reprise 2]
−
|COLLECTION
+
|ANTHOLOGY
 
|
 
|
 
|-
 
|-
−
|[http://www.isfdb.org/cgi-bin/title.cgi?555317 Untitled: Visible Light (part 6 of 7)]
+
|[http://www.isfdb.org/cgi-bin/title.cgi?532265 The Shores of Death (Part 1 of 2)]
 
|SERIAL
 
|SERIAL
−
|[http://www.isfdb.org/cgi-bin/pl.cgi?7522 The Collected Short Fiction of C. J. Cherryh]
+
|[http://www.isfdb.org/cgi-bin/pl.cgi?29738 SF Reprise 1]
−
|COLLECTION
+
|ANTHOLOGY
 
|
 
|
 
|-
 
|-
−
|[http://www.isfdb.org/cgi-bin/title.cgi?555317 Untitled: Visible Light (part 6 of 7)]
+
|[http://www.isfdb.org/cgi-bin/title.cgi?532305 The Shores of Death (Part 2 of 2)]
 
|SERIAL
 
|SERIAL
−
|[http://www.isfdb.org/cgi-bin/pl.cgi?185157 The Collected Short Fiction of C. J. Cherryh]
+
|[http://www.isfdb.org/cgi-bin/pl.cgi?29738 SF Reprise 1]
−
|COLLECTION
+
|ANTHOLOGY
 
|
 
|
 
|-
 
|-
−
|[http://www.isfdb.org/cgi-bin/title.cgi?555325 Untitled: Visible Light (part 7 of 7)]
+
|[http://www.isfdb.org/cgi-bin/title.cgi?964309 The Werewolf of Rutherford Grange (Part 1 of 2)]
 
|SERIAL
 
|SERIAL
−
|[http://www.isfdb.org/cgi-bin/pl.cgi?7522 The Collected Short Fiction of C. J. Cherryh]
+
|[http://www.isfdb.org/cgi-bin/pl.cgi?74314 Tales of the Shadowmen 1: The Modern Babylon]
−
|COLLECTION
+
|ANTHOLOGY
 
|
 
|
 
|-
 
|-
−
|[http://www.isfdb.org/cgi-bin/title.cgi?555325 Untitled: Visible Light (part 7 of 7)]
+
|[http://www.isfdb.org/cgi-bin/title.cgi?964330 The Werewolf of Rutherford Grange (Part 2 of 2)]
 
|SERIAL
 
|SERIAL
−
|[http://www.isfdb.org/cgi-bin/pl.cgi?185157 The Collected Short Fiction of C. J. Cherryh]
+
|[http://www.isfdb.org/cgi-bin/pl.cgi?280271 Tales of the Shadowmen 2: Gentlemen of the Night]
−
|COLLECTION
+
|ANTHOLOGY
 
|
 
|
 
|}
 
|}
−
 
−
 
−
:: Some of these don't look like problems. "New Destinies" IS (well, WAS) a magazine, but to allow for the multiple printings, we've had to class it as "Anthology". No consistency problem there really. [[User:BLongley|BLongley]] 15:50, 18 Sep 2007 (CDT)
 
−
:: Using "Serial" to group several pieces within the same book looks wrong though - abuse "Series" for that, I'd say, unless they really are reprints of magazine entries. [[User:BLongley|BLongley]] 15:50, 18 Sep 2007 (CDT)
 
−
:: "(Excerpt)" looks wrong too, unless they're numbered excerpts leading to a whole work. [[User:BLongley|BLongley]] 15:50, 18 Sep 2007 (CDT)
 
−
:: "(Complete Novel)" is a known problem: I know that's what it says in many magazines, but reprints of the exact same work don't cut the mustard by today's standards. Create "Novella/Novellette" Variants of the magazine entries before inclusion in works where they're considered Short-Fiction maybe? Or make the "(Complete Novel)" titles variants of what we'd call them now? [[User:BLongley|BLongley]] 15:50, 18 Sep 2007 (CDT)
 
−
:: I'm not sure where this is going, but I'd sort this lot by title. "Journal from Ellipsia" still confuses me with double-entries here. [[User:BLongley|BLongley]] 15:50, 18 Sep 2007 (CDT)
 
−
 
−
:::Posting the Python code here as per Bill's request:
 
−
 
−
<pre>
 
−
# initialize the variables that will keep track of different type mismatches
 
−
bad_title = 0
 
−
bad_pub = 0
 
−
bad_xref = 0
 
−
mismatches = {}
 
−
exceptions = {}
 
−
# import the MySQLdb module that will allow Python to access MySQL
 
−
import MySQLdb
 
−
# establish a connection to MySQL and call it 'db'
 
−
db = MySQLdb.connect('localhost', username, password, 'ISFDB')
 
−
# create a cursor for the pub-content table
 
−
xref_cursor = db.cursor()
 
−
# create a cursor for the title table
 
−
title_cursor = db.cursor()
 
−
# create a cursor for the pubs table
 
−
pubs_cursor = db.cursor()
 
−
# initialize the list that will hold xref information
 
−
xref = []
 
−
# initialize the dictionary that will hold title information
 
−
titles = {}
 
−
# initialize the dictionary that will hold publication information
 
−
pubs = {}
 
−
# retrieve all rows in the pub_content (cross-reference) table
 
−
response = xref_cursor.execute("select * from pub_content;")
 
−
i = 0
 
−
while 1:
 
−
    #retrieve one row of pub_content data
 
−
    row = xref_cursor.fetchone()
 
−
    #break out of the loop when we finish the last retrieved row
 
−
    if row == None:
 
−
      break
 
−
    i = i +1
 
−
    if i % 25000 == 0:
 
−
        print "Imported ",i," cross-reference records"
 
−
    #xref_id = int(row[0])
 
−
    if type(row[1]) is not long:
 
−
        bad_xref = bad_xref + 1
 
−
        #print type(title_id)
 
−
        continue
 
−
    title_id = int(row[1])
 
−
    if type(row[2]) is not long:
 
−
        bad_xref = bad_xref + 1
 
−
        #print pub_id
 
−
        continue
 
−
    pub_id = int(row[2])
 
−
    xref.append([title_id,pub_id])
 
−
print "Retrieved ",len(xref)," cross-reference records"
 
−
 
−
# now retrieve all rows in the titles table
 
−
response = title_cursor.execute("select title_id,title_ttype,title_title from titles;")
 
−
i = 0
 
−
while 1:
 
−
    #retrieve one row of titles data
 
−
    row = title_cursor.fetchone()
 
−
    #break out of the loop when we finish the last retrieved row
 
−
    if row == None:
 
−
      break
 
−
    i = i +1
 
−
    if i % 25000 == 0:
 
−
        print "Imported ",i," title records"
 
−
    title_id = int(row[0])
 
−
    titles[title_id] = row[1]
 
−
       
 
−
# now retrieve all rows in the pubs table
 
−
response = pubs_cursor.execute("select pub_id,pub_ctype,pub_title from pubs;")
 
−
i = 0
 
−
while 1:
 
−
    #retrieve one row of titles data
 
−
    row = pubs_cursor.fetchone()
 
−
    #break out of the loop when we finish the last retrieved row
 
−
    if row == None:
 
−
      break
 
−
    i = i +1
 
−
    if i % 25000 == 0:
 
−
        print "Imported ",i," publications records"
 
−
    pub_id = int(row[0])
 
−
    pubs[pub_id] = row[1]
 
−
 
−
#iterate over the xref list and compare title/publication type
 
−
i = 0
 
−
for index in range(len(xref)):
 
−
    i = i + 1
 
−
    if i % 25000 == 0:
 
−
        print "Analyzed ",i," cross-reference records"
 
−
    xref_record = xref[index]
 
−
    title_id = xref_record[0]
 
−
    pub_id = xref_record[1]
 
−
    title_type = titles.get(title_id , "bad key")
 
−
    pub_type = pubs.get(pub_id , "bad key")
 
−
    if (title_type == "bad key"):
 
−
        bad_xref = bad_xref + 1
 
−
        continue
 
−
    if (pub_type == "bad key"):
 
−
        bad_xref = bad_xref + 1
 
−
        continue
 
−
    if (title_type == "CHAPTERBOOK"):
 
−
        mismatches["chapterbooks"] = mismatches.get("chapterbooks" , 0) + 1
 
−
        continue
 
−
    if pub_type == title_type:
 
−
        continue
 
−
    if (pub_type == "None") or (pub_type == ""):
 
−
        mismatches["missing publication type"] = mismatches.get("missing publication type" , 0) + 1
 
−
        continue
 
−
    if (title_type == "ESSAY") or (title_type == "REVIEW") or (title_type == "COVERART") or (title_type == "INTERIORART") or (title_type == "BACKCOVERART") or (title_type == "INTERVIEW"):
 
−
        continue
 
−
    if title_type == "OMNIBUS":
 
−
        if pub_type != "OMNIBUS":
 
−
            mismatches["omnibuses"] = mismatches.get("omnibuses" , 0) + 1
 
−
        continue
 
−
    if (title_type == "ANTHOLOGY") and (pub_type != "ANTHOLOGY"):
 
−
        mismatches["anthologies"] = mismatches.get("anthologies" , 0) + 1
 
−
        continue
 
−
    if (title_type == "EDITOR"):
 
−
        if (pub_type != "MAGAZINE") and (pub_type != "FANZINE") :
 
−
            mismatches["editor records"] = mismatches.get("editor records" , 0) + 1
 
−
        continue
 
−
    if (title_type == "SERIAL"):
 
−
        if (pub_type != "MAGAZINE") and (pub_type != "FANZINE") :
 
−
            mismatches["serials"] = mismatches.get("serials" , 0) + 1
 
−
            exceptions["serials", (title_id , pub_id)] = ""
 
−
        continue
 
−
    if (title_type == "COLLECTION") and (pub_type != "COLLECTION"):
 
−
        mismatches["collections"] = mismatches.get("collections" , 0) + 1
 
−
        continue
 
−
    if (title_type == "NOVEL"):
 
−
        if pub_type == "NOVEL":
 
−
            continue
 
−
        if pub_type == "OMNIBUS":
 
−
            continue
 
−
        if (pub_type == "MAGAZINE") or (pub_type == "FANZINE"):
 
−
            mismatches["novel/magazines"] = mismatches.get("novel/magazines" , 0) + 1
 
−
            continue
 
−
        mismatches["novels (other)"] = mismatches.get("novels (other)" , 0) + 1
 
−
        continue
 
−
    if (title_type == "SHORTFICTION"):
 
−
        if (pub_type == "NONFICTION") or (pub_type == "NOVEL"):
 
−
            mismatches["short fiction"] = mismatches.get("short fiction" , 0) + 1
 
−
        continue
 
−
    if (title_type == "POEM"):
 
−
        if (pub_type == "NONFICTION"):
 
−
            mismatches["poems"] = mismatches.get("poems" , 0) + 1
 
−
        continue
 
−
    if (title_type == "NONFICTION"):
 
−
        if (pub_type != "NONFICTION"):
 
−
            mismatches["nonfiction"] = mismatches.get("nonfiction" , 0) + 1
 
−
        continue
 
−
    if (title_type == "NONGENRE"):
 
−
        if (pub_type != "NOVEL"):
 
−
            mismatches["nongenre"] = mismatches.get("nongenre" , 0) + 1
 
−
        continue
 
−
    mismatches["uncategorized"] = mismatches.get("uncategorized" , 0) + 1
 
−
    #print title_data[0][1],title_type," vs. ",pub_data[0][1],pub_type
 
−
 
−
print "Bad title records: ",bad_title
 
−
print "Bad publication records: ",bad_pub
 
−
print "Bad cross-references: ",bad_xref
 
−
for key in exceptions:
 
−
    title_id = key[1][0]
 
−
    pub_id = key[1][1]
 
−
    response = title_cursor.execute("select title_ttype,title_title from titles where title_id = "+str(title_id)+";")
 
−
    row1 = title_cursor.fetchall()
 
−
    response = pubs_cursor.execute("select pub_ctype,pub_title,pub_tag from pubs where pub_id = "+str(pub_id)+";")
 
−
    row2 = pubs_cursor.fetchall()
 
−
    print "|-"
 
−
    print "|[http://www.isfdb.org/cgi-bin/title.cgi?"+str(title_id)+" "+str(row1[0][1])+"]"
 
−
    print "|"+str(row1[0][0])
 
−
    print "|[http://www.isfdb.org/cgi-bin/pl.cgi?"+str(row2[0][2])+" "+str(row2[0][1])+"]"
 
−
    print "|"+str(row2[0][0])
 
−
 
−
for key in mismatches:
 
−
    print "Mismatched",key,":",mismatches.get(key , 0)
 
−
 
−
db.close()
 
−
</pre>
 
−
:::[[User:Ahasuerus|Ahasuerus]] 23:45, 18 Sep 2007 (CDT)
 
−
 
−
:Some of the title appear to be correct. The titles have appeared in serial form in collections and anthologys first, but may not have been published as complete novels. So there listing as a serial maybe correct, they just have not been published in the usual magazine form.[[User:Kraang|Kraang]] 06:12, 20 Sep 2007 (CDT)
 
−
 
−
::The point about sorting by title is well taken, I will add it next when I have a moment. I will also add a Status column, where we could enter "FIXED" as we update the data. [[User:Ahasuerus|Ahasuerus]] 23:44, 19 Sep 2007 (CDT)
 
−
 
−
:::The table has been resorted by title and a "Fixed?" column has been added. However, my attempts to teach myself Python turned out to be more painful than expected (something to do with old dogs and new tricks), so I ended up converting the MySQL database to a more familiar format and parsing it using vintage 1960s technologies. I'll attack other type mismatches shortly. [[User:Ahasuerus|Ahasuerus]] 23:27, 29 Sep 2007 (CDT)
 

Latest revision as of 15:41, 4 August 2012

2010-01-05:


Title Title Type Publication Publication Type Fixed?
. . . And Call Me Conrad (Part 1 of 2) SERIAL Power & Light COLLECTION
. . . And Call Me Conrad (Part 2 of 2) SERIAL Power & Light COLLECTION
An Invisible War (Part 1 of 2) SERIAL Grantville Gazette II ANTHOLOGY
An Invisible War (Part 1 of 2) SERIAL Grantville Gazette II ANTHOLOGY
An Invisible War (Part 2 of 2) SERIAL Grantville Gazette III ANTHOLOGY
At the Cliff's Edge SERIAL Grantville Gazette IX ANTHOLOGY
Briar Patch (Part 1 of 2) SERIAL New Destinies VII, Spring 1989 ANTHOLOGY
Briar Patch (Part 2 of 2) SERIAL New Destinies, Volume VIII / Fall 1989 ANTHOLOGY
Butterflies In The Kremlin, Episode 2: A 'Merican in Moscow SERIAL Grantville Gazette IX ANTHOLOGY
Butterflies in the Kremlin, Part 1: A Russian Noble SERIAL Grantville Gazette VIII ANTHOLOGY
Butterflies in the Kremlin, Part 3: Boris, Natasha . . . But Where's Bullwinkle SERIAL Grantville Gazette X ANTHOLOGY
Butterflies in the Kremlin, Part Four SERIAL Grantville Gazette XI ANTHOLOGY
Dr. Phil's Aeolian Transformers SERIAL Grantville Gazette VI ANTHOLOGY
Dr. Phil's Amazing Lightning Crystal SERIAL Grantville Gazette VI ANTHOLOGY
Earth, the Marauder (Part 3 of 3) SERIAL Astounding Stories of Super-Science, September 1930 ANTHOLOGY
Essen Steel, Part 1: Crucibellus SERIAL Grantville Gazette VII ANTHOLOGY
Euterpe, Episode 1 SERIAL Grantville Gazette II ANTHOLOGY
Euterpe, Episode 1 SERIAL Grantville Gazette II ANTHOLOGY
Euterpe, Episode 1 SERIAL Grantville Gazette II ANTHOLOGY
Euterpe, Episode 2 SERIAL Grantville Gazette III ANTHOLOGY
Euterpe, Episode 2 SERIAL Grantville Gazette III ANTHOLOGY
Euterpe, Episode 3 SERIAL Grantville Gazette V ANTHOLOGY
Franconia! Part 1 SERIAL Grantville Gazette X ANTHOLOGY
Iron (Part 1 of 2) SERIAL Far Frontiers, Volume VII/ Winter 1986 ANTHOLOGY
Iron (Part 2 of 2) SERIAL New Destinies, Volume I/Spring 1987 ANTHOLOGY
Jetta of the Lowlands (Part 1 of 3) SERIAL Astounding Stories of Super-Science, September 1930 ANTHOLOGY
Murder in Space (Complete Novel) SERIAL Murder in Space NOVEL
Mutants in Action (Complete Novel) SERIAL The Vega Sector ANTHOLOGY
My Heart Leaps Up (Part 1 of 5) SERIAL My Heart Leaps Up, Chapters 1 & 2 CHAPTERBOOK
My Heart Leaps Up (Part 1 of 5) SERIAL My Heart Leaps Up, Chapters 1 & 2 CHAPTERBOOK
My Heart Leaps Up (Part 2 of 5) SERIAL My Heart Leaps Up, Chapters 3 & 4 CHAPTERBOOK
My Heart Leaps Up (Part 2 of 5) SERIAL My Heart Leaps Up, Chapters 3 & 4 CHAPTERBOOK
My Heart Leaps Up (Part 3 of 5) SERIAL My Heart Leaps Up, Chapters 5 & 6 CHAPTERBOOK
My Heart Leaps Up (Part 3 of 5) SERIAL My Heart Leaps Up, Chapters 5 & 6 CHAPTERBOOK
My Heart Leaps Up (Part 4 of 5) SERIAL My Heart Leaps Up, Chapters 7 & 8 CHAPTERBOOK
My Heart Leaps Up (Part 4 of 5) SERIAL My Heart Leaps Up, Chapters 7 & 8 CHAPTERBOOK
My Heart Leaps Up (Part 5 of 5) SERIAL My Heart Leaps Up, Chapters 9 & 10 CHAPTERBOOK
My Heart Leaps Up (Part 5 of 5) SERIAL My Heart Leaps Up, Chapters 9 & 10 CHAPTERBOOK
Space Battle in the Vega Sector (Complete Novel) SERIAL The Vega Sector ANTHOLOGY
Stretching Out, Part One: Second Starts SERIAL Grantville Gazette XI ANTHOLOGY
Suite For Four Hands SERIAL Grantville Gazette V ANTHOLOGY
The Blue Monkeys (Part 1 of 3) SERIAL SF Reprise 3 ANTHOLOGY
The Blue Monkeys (Part 2 of 3) SERIAL SF Reprise 3 ANTHOLOGY
The Blue Monkeys (Part 3 of 3) SERIAL SF Reprise 3 ANTHOLOGY
The Captive (Part 1 of 2) SERIAL The Secret Circle: The Initiation and The Captive Part 1 OMNIBUS
The Captive (Part 2 of 2) SERIAL The Secret Circle: The Captive Part II and The Power OMNIBUS
The Challenge from Beyond (Part 1 of 5) SERIAL Horrors Unknown ANTHOLOGY
The Challenge from Beyond (Part 1 of 5) SERIAL Nameless Cults: The Cthulhu Mythos Fiction of Robert E. Howard COLLECTION
The Challenge from Beyond (Part 1 of 5) SERIAL Seekers of Dreams: Masterpieces of Fantasy ANTHOLOGY
The Challenge from Beyond (Part 1 of 5) SERIAL Horrors Unknown ANTHOLOGY
The Challenge from Beyond (Part 2 of 5) SERIAL Horrors Unknown ANTHOLOGY
The Challenge from Beyond (Part 2 of 5) SERIAL Nameless Cults: The Cthulhu Mythos Fiction of Robert E. Howard COLLECTION
The Challenge from Beyond (Part 2 of 5) SERIAL Seekers of Dreams: Masterpieces of Fantasy ANTHOLOGY
The Challenge from Beyond (Part 2 of 5) SERIAL Horrors Unknown ANTHOLOGY
The Challenge from Beyond (Part 3 of 5) SERIAL Horrors Unknown ANTHOLOGY
The Challenge from Beyond (Part 3 of 5) SERIAL Nameless Cults: The Cthulhu Mythos Fiction of Robert E. Howard COLLECTION
The Challenge from Beyond (Part 3 of 5) SERIAL Seekers of Dreams: Masterpieces of Fantasy ANTHOLOGY
The Challenge from Beyond (Part 3 of 5) SERIAL Horrors Unknown ANTHOLOGY
The Challenge from Beyond (Part 4 of 5) SERIAL Horrors Unknown ANTHOLOGY
The Challenge from Beyond (Part 4 of 5) SERIAL Nameless Cults: The Cthulhu Mythos Fiction of Robert E. Howard COLLECTION
The Challenge from Beyond (Part 4 of 5) SERIAL Seekers of Dreams: Masterpieces of Fantasy ANTHOLOGY
The Challenge from Beyond (Part 4 of 5) SERIAL Horrors Unknown ANTHOLOGY
The Challenge from Beyond (Part 5 of 5) SERIAL Horrors Unknown ANTHOLOGY
The Challenge from Beyond (Part 5 of 5) SERIAL Nameless Cults: The Cthulhu Mythos Fiction of Robert E. Howard COLLECTION
The Challenge from Beyond (Part 5 of 5) SERIAL Seekers of Dreams: Masterpieces of Fantasy ANTHOLOGY
The Challenge from Beyond (Part 5 of 5) SERIAL Horrors Unknown ANTHOLOGY
The Doctor Gribbleflotz Chronicles, Part 1: Calling Dr. Phil SERIAL Grantville Gazette VI ANTHOLOGY
The Doctor Gribbleflotz Chronicles, Part 3: Doctor Phil's Distraction SERIAL Grantville Gazette VIII ANTHOLOGY
The Doctor Phil Chronicles: Doctor Phil's Family SERIAL Grantville Gazette X ANTHOLOGY
The Dr. Gribbleflotz Chronicles, Part 2: Dr. Phil's Amazing Essence Of Fire Tablets SERIAL Grantville Gazette VII ANTHOLOGY
The Essen Chronicles, Part 3: Trip to Paris SERIAL Grantville Gazette IX ANTHOLOGY
The Essen Steel Chronicles, Part 2: Louis de Geer SERIAL Grantville Gazette VIII ANTHOLOGY
The Impossible Smile (Part 1 of 2) SERIAL SF Reprise 6 ANTHOLOGY
The Impossible Smile (Part 2 of 2) SERIAL SF Reprise 6 ANTHOLOGY
The Omega Egg (Part 1 of 17): Conversation with an Admiral SERIAL The Omega Egg (Part 1 of 17) CHAPTERBOOK
The Omega Egg (Part 10 of 17): Holes in the Universe SERIAL The Omega Egg (Part 10 of 17) CHAPTERBOOK
The Omega Egg (Part 11 of 17): Choosing Sides SERIAL The Omega Egg (Part 11 of 17) CHAPTERBOOK
The Omega Egg (Part 12 of 17): Picking a God's Nose SERIAL The Omega Egg (Part 12 of 17) CHAPTERBOOK
The Omega Egg (Part 13 of 17): The Search for Bob SERIAL The Omega Egg (Part 13 of 17) CHAPTERBOOK
The Omega Egg (Part 14 of 17): The End of Some Things, the Beginning of Others SERIAL The Omega Egg (Part 14 of 17) CHAPTERBOOK
The Omega Egg (Part 15 of 17): Mr. Spencer's Blues SERIAL The Omega Egg (Part 15 of 17) CHAPTERBOOK
The Omega Egg (Part 16 of 17): Conversation With His Future Self SERIAL The Omega Egg (Part 16 of 17) CHAPTERBOOK
The Omega Egg (Part 17 of 17): For Whom the Bellflower Tolls SERIAL The Omega Egg (Part 17 of 17) CHAPTERBOOK
The Omega Egg (Part 2 of 17): Conversation with a Dragon SERIAL The Omega Egg (Part 2 of 17) CHAPTERBOOK
The Omega Egg (Part 3 of 17): Dreams and Nightmares SERIAL The Omega Egg (Part 3 of 17) CHAPTERBOOK
The Omega Egg (Part 4 of 17): Smoke and Mirrors SERIAL The Omega Egg (Part 4 of 17) CHAPTERBOOK
The Omega Egg (Part 5 of 17): The Egg and the Dragon SERIAL The Omega Egg (Part 5 of 17) CHAPTERBOOK
The Omega Egg (Part 6 of 17): The Da Vinci Code SERIAL The Omega Egg (Part 6 of 17) CHAPTERBOOK
The Omega Egg (Part 7 of 17): Your Own Private Gulag SERIAL The Omega Egg (Part 7 of 17) CHAPTERBOOK
The Omega Egg (Part 8 of 17): Altar Ego SERIAL The Omega Egg (Part 8 of 17) CHAPTERBOOK
The Omega Egg (Part 9 of 17): Falling SERIAL The Omega Egg (Part 9 of 17) CHAPTERBOOK
The Pillars of the Earth (Part 1 of 3) SERIAL The Pillars of the Earth (Part 1 of 3) NOVEL
The Pillars of the Earth (Part 2 of 3) SERIAL The Pillars of the Earth (Part 2 of 3) NOVEL
The Pillars of the Earth (Part 3 of 3) SERIAL The Pillars of the Earth (Part 3 of 3) NOVEL
The Plant (Part 1 of ?) SERIAL The Plant CHAPTERBOOK
The Power of Y (Part 1 of 2) SERIAL SF Reprise 2 ANTHOLOGY
The Power of Y (Part 2 of 2) SERIAL SF Reprise 2 ANTHOLOGY
The Shores of Death (Part 1 of 2) SERIAL SF Reprise 1 ANTHOLOGY
The Shores of Death (Part 2 of 2) SERIAL SF Reprise 1 ANTHOLOGY
The Werewolf of Rutherford Grange (Part 1 of 2) SERIAL Tales of the Shadowmen 1: The Modern Babylon ANTHOLOGY
The Werewolf of Rutherford Grange (Part 2 of 2) SERIAL Tales of the Shadowmen 2: Gentlemen of the Night ANTHOLOGY
Retrieved from "https://isfdb.org/wiki/index.php?title=ISFDB:Data_Consistency/Serial_Mismatches&oldid=281799"