Problem series

Other queries that could be run:

Problems that can be found and fixed throught the online interface:

Editor fields with a * in them (I've been fixing a lot of them) <--- through the OI (Editing - Containing - *) - there are 1069 of them!

Pencil fields with '---' in them. <----- through the OI (Pencil - Containing - "---") - there are only 78 of them

Queries from the last data-dump:

Features of "Text story" or "(Text Story)" or "Text Article" or "(Text Article)":Features with Text in them

Type with "Feature" in it with Feature not having Text in it (to exclude the ones in the Text query): Type with Feature in it

Series with date problems at the series level: Series with Date Problems

Sequences with "Supereroi" as a genre: Pages with Supereroi as a genre

Sequences with "War" as a feature: Sequences with War as a Feature

Issues missing KeyDates: Missing KeyDates

Issues with KeyDates not in the XXXX.XX.XX format: Incorrectly Formatted Keydates

Issues missing PubDates: Missing PubDates (now separated by country)

Issues with missing page counts for the cover sequence: Missing Cover Page Counts

Issues with no cover price : Indexed comics with missing cover price

Issues with a , in the PubDate: Comma in the Pub Date

Funky Genres (up to C): Funky Genres up to C

Feature with "cover" (Mike says that he's fixed a bunch already so everyone might want to wait until the next data dump before we do anything about the comics found in this search) : Feature with Cover

Sequence 0 records that are set to story not cover (Mike says that he's fixed a bunch already): Cover sequence not set to Cover

Sequences with "Featur" in any of the creative fields (because Mike found "Humor Featurette" in the script and color fields of at least one index): Sequences with Feature in the creative fields (not many)

Sequences with 'Story' as part of the feature. Some of these are legit (does not include "war Story" since that is in a separate query): Sequences with Story in the feature (organized by feature)

Keydates with '00' as the month... for Jim: Keydates with 00 as the month

Sequences with a "?" as part of the page count: (don't bother with these until the next data dump...) Sequences with QuestionMark as part of the page count

Canadian comics with something in the reprint field: Canadian comics reprint fields

Queries that are for reference or to find problems

Listing of some of the 40000 Features in the last data dump: Features in Last Data Dump

Here is a list of problem series and what needs to be done. This is only for more major items, not series missing non-required items.

AC Comics

• Bolt Special #1 (Total page count is 1)
• Captain Paragon and the Sentinals of Justice #5 (needs story page count)
• Femforce Special: #1 (story page count)
• Further Adventures of Nyoka the Jungle Girl: 1, 2, 4
• Good Girl Comics #18 (last two sequences need counts)
• Gorgana's Ghoul Gallery: 1 and 2 need total page counts.
• Jesse James #1 (Last sequence needs page count)
• Jungle Girls: 1,8,15
• Nightveil (1984): 1,2,4,7 (All have cover counts of 1, that can't be right)
• Shade Special (Cover count is 1): 1
• Starmasters (Cover count is wrong): 1
• Thrilling Planet Tales (no cover count): nn

Archie Comics

• Red Circle/Archie Adventure series (1983)
• Most have incomplete credits, some missing page counts, missing types, missing sequences, sequences out of order, no genre, no synposis, char apps are odd, etc.
• Red Circle Sorcery 11
• Thunder Bunny 1

Better Comics

• Joe Yank (missing total page count) : 13

Bongo Comics

• Radioactive Man (1993): 1,88, 216, 412, 679, 1000

Charlton Comics

• Captain Atom (1965 series): 81, 82, 84, 86, 87 all need total page counts and sequences fixed up.
• World of Wheels: 23, 29

Dark Horse Comics

• Adam Warren Dirty Pair - Fatal but not Serious: #1, 2 - need cover page counts.
• Dark Horse Comics: 2-6,8,10-13,15-25 (need story page counts) - (MN - This two issues I fixed, the indexes were junk. Missing credits, bad story titles, etc. so watch for that also.) (Actually, all issues have story page counts except #11. Max)
• Deadline USA (Dark Horse) (1992 series) #2-6 (need story page counts)

DC Comics

• Amethyst (1985 series) : Need total page counts for the issues: 2-11,14 (Story page counts are there, just need total page counts)
• Animal Man (1988 series): Looks like someone guessed on total page counts. Need confirmation on: 27-37,39,40,42-47,50-52,55,62,64-66,68-74,78-83
• DC Special Series 25: Needs credits fixed to format and story sequences properly identified.
• Doom Patrol (1987 series): Need to check the total page counts. Some issue show 32 pages when they are really 36 pages. I fixed #72
• Falling in Love: 24, 28, 70, 89, 90, 93 (have stories with no page count)
• Fury of Firestorm (DC 1982 series) : Missing page counts, and also pay close attention to credits as some may not be correct: 3, 5-8,10-13, 15-20, 22-33, 35,36,38,39,41,42,46,49-53,55,57,59-63 and Annual #1-4 (Basically most of the series except the handful I fixed)
• House of Mystery: This is a real mess. All these are missing page counts and sequence types: 4, 10-16, 20, 22-41, 45-49, 51-62, 64-67, 69-86, 89, 92, 96, 101, 103, 105-106, 108-110, 112, 114-126, 128, 131, 138-142, 158, 160, 162, 191, 216, 217, 221, 233, 236, 243, 245, 248, 255, 259, 261, 270, 275, 285, 289
• Our Army at War: 1-4, 5-53, 66-113, 116, 118-139, 141-149, 153, 159, 162, 171, 173, 180, 195-201, 204-210, 212-214, 217, 219-228, 230, 233, 235, 237, 240, 242-248, 252-254, 260, 269, 275, 285 (missing total and story counts most issues)
• Red Tornado (mini): 1, 2, 4
• Robin (1991 series): 4
• Shadow of the Batman (5 issue reprint series): 1-5 are all missing total page counts and need some other cleanup
• Showcase: (Missing page counts) 1-3, 5, 15-21, 25-29, 31, 32, 41-44, 46, 47, 49-51, 53, 54, 57, 58, 62, 63, 65-67, 69-71, 73, 74, 75, 81, 82, 84, 85, 86, 88, 89, 90 other issues of showcase were missing seq types but these are the ones with missing page counts.
• Starman (1988 series - Missing total page counts) : 1-3, 5, 7-9, 27, 30, 32-35, 37-45
• Superman Annual (1960 series): 1,4,7,8 (need total page counts, some have a 1 in the cover count)
• Super Powers (1985 series): 3-6

Dell Comics

• Flash Gordon (1947) #2 (Needs total page count and other info)
• Looney Tunes (Dell) has issues with features listed, but no titles or page counts. These are pretty much at random, many issues having been fully indexed.
• Looney Tunes (dell 1955 series) Here are the issues that need major work. Did not check those currenty reserved to someone: 195, 201, 207, 208, 211, 212, 213, 216, 217, 218, 219, 222, 225, 229, 232, 235, 238, 243
• New Funnies (Del 1945 series): 92, 93, 97, 98, 100, 101, 104, 105, 106, 107, 108. 103 has page counts but no creator info entered.
• Four Color (Series II): Many Disney titles need type, genre, characters, synopsis added. Titles, page counts, features, and art and story credits are already there. However, activity pages may not be listed.
• Tom Corbett, Space Cadet - 7 needs total page counts (probably 36 pages)

Eclipse

• Air Fighters Classics: 1-6
• Axel Pressbutton: 1-6
• Aztec Ace: 2
• Bedlam: 1,2
• Clive Barker: The Life of Death: 1
• New DNAgents: 1, 3-17 (Need total page counts)

Fawcett

• Whiz Comics: Missing Total page counts. I only saw one issue that was missing page counts on other sequences, but it's mostly total counts: 2, 3 [3/40] , 3 [4/40] , 4-23, 25, 26, 28-60, 62-70, 72-77, 81-121, 123, 125-153, 155

First Comics

• Starslayer: 7-20, 22-34 - All need total page counts.

Fox Comics

• All-Famous Crime: Indexed issue has total page count as one.
• Famous Crimes: All indexed have total page count listed as one.
• Murder Incorporated: All indexed have total page count listed as one.

Image

• 1963: 2-6 - Missing total page count.
• Deathblow: 4-15 (Cover count is 2 which can't be right)
• Gen 13 Bootleg: 1,2,4-7,11-13,15,16 (same count for cover and story. Same info in both records also)
• Image Comics #0 : Needs total page count
• Pitt: 3-8 - Total page count is 36?. Needs confirmation.
• Spawn (missing total page counts); 1-7,10, 11, 13, 14, 16-20, 22-33, 40 (this one shows 35 pages.)

Malibu

• 'Breed II: #1 (cover 36 pages, story 40 pages. Something wrong);
• Dinosaur for Hire (1993 series): #1-12
• Man of War: 1,2,3,5 (need page counts)
• Strangers: 1-3,5,7-11 (Total page counts missing)

Marvel Comics

• Amazing Spider-Man (1962 series) : #120, 254-257, 260, 261, 293, 294, 296, (#300 has 40 page story and 36 total pages. That can't be right)
• A-Team: 2,3
• Battle (Stories missing page counts): 63
• Blood: A Tale (Epic) : 1-3 (some story sequences need page counts)
• Clandestine: 3, 5-9, 11 (Same info in the cover and story sequences. Cover is wrong)
• Conan the Barbarian: 10, 15, 134, 143-154, 175, 176, 241, 253-257, 260, 262, 264, 266-268, 275 (Need total page count)
• Dakota North: 3
• Excalibur: (These are all jacked up. Cover and Story sequence appear to have the same info. Cover is wrong): 42, 43, 45-49, 51-54, 57-59, 61-67, 89, 91, 95, 96, 108
• Incredible Hulk: (1962 series) #2
• Incredible Hulk: (1968 series) #102,104,106,111,114,120,121,123,126,131,135-137,142-145,158,187,301-303,305-310,323,327,379-382,385-389,391-394,397-407,409-415,419,420,424-434,436-438,440,442-447,449-453,464 (Some have same page count on cover and story, which isn't right. One had a total of 26 pages, it's probably wrong)
• Iron Man (1968 series): (Lots of early issues need sequence types set on the story records. Looks like it could be done without the issues themselves). Some issues need page counts: 155, 161-164, 167, 208, 211-217, 219-230, 234, 235, 238, 239, 251-253, 255-260, 262-274
• Marvel Tales (1966 series) 1-30-ish have incorrect total page counts (36 but they are larger); also need revision of artist credits for cover sequences
• Micronauts (1979 series): 1, 30, 46, 52-56, 58, 59
• Moon Knight (1980 series): 13, 25, 36, 38 (some missing total, some have same count for story and total, one has larger story count than total count)
• Morbius: 10, 12-18, 20-22, 24-26 (missing total page counts)
• New Warriors (1990 series): 1-13, 15, 18-22 (Total count and story count the same)
• Nova (1976 series): 25 (has a total page count of 1)
• Patsy Walker (1945 series): 20 (needs total page count, date and keydate) - shows as "unindexed" but is more complete than a lot of older indexes...
• Punisher War Journal (1988 series): Missing total and story page counts (This list does not include any already reserved or currently un-indexed): 2-4,8,10,11,14-16,20,22-24,34,36
• Saga of the Sub-Mariner: 1-12 (missing total page counts)
• Strange Tales (1987 series): Missing page counts on: 1-9, 11, 15-19
• Strange Tales of the Unusual: 6 (one story is missign page counts)
• Strikeforce Moritori : 1-8, 11-13, 15-25, 27-31 (need total page counts)

Novelty Press

• Target Comics (1940 series): Needsequences set, characters moved to character section, and colourists removed (they match the writers in every sequence!): 1,2,3,4,5,11,
• Also need total pages set: 6,7,8,9,12,13,14,15,16,18,19,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,37,38,39,40,41,42,43,44,46,47,48,49,50 need to check issues after 50

Pacific Comics

• (I've checked every indexed one, these all need page counts)
• Elric #1-6 (total page count)
• Jerry Iger's Famous Features #1 (Need cover count)
• Ms. Mystic #1,2 (total page count)
• Pathways to Fantasy #1 (total page count)
• Skateman #1 (total page count)
• Somerset Holmes #2-4 (total page count)
• Starslayer #2-6 (total page count)
• Sun Runners #1-3 (total page count)

Prize Comics

• Prize Comics #1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,32,33,34,35,36,37,38,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,66,68 (need total page count)

Tekno Comics / Big Entertainment

• Mr. Hero (1995 series) : 2-10 (Need total page count)

Topps Comics

• Dracula Vs. Zorro: 1 (need cover count)

Valiant

• Magic the Gathering -- Shadow Mage #1-4 (total page counts)
• Magnus Robot Fighter #55, 57, 59-64 (total page counts)
• Shadowman (1992): 15-18, 21, 23-25 unindexed, are still reserved by Derek Reinhart and have been forever.
• Solar Man of Atom: 49, 50, 53-57, 59, 60 (total page counts)
• Turok, Dinosaur Hunter: 15-36 (total page counts)
• X-O Manowar (1992): 61 (story page count)

Warren

• Creepy: #2,5-10,12-14,20,21,25-30, 32-34, 37-50, 53, 58-61, 65, 68, 98, 99, 102-104, 106, 109, 111, 119, 121, 124, 125, 127-131, 134-136, 138-140 (Early ones missing page counts on letters pages, middle ones need total page counts, later ones have a? in the page count.)

Ziff Davis

• G.I. Joe 1951 series
• Total page count 8-9
• Total page count, type and credits 12,15,15,18,19,20,25,26,27,28,30,31,37,39,40,41

Other Indy comics

• Hepcats (Double Diamond Press 1989 series) #7,11,12 all need total page counts
• Fight the Enemy (Tower): 1-3
• Mystery Men Comics: 1-5, 7-31 - Need seq types, char app cleanup, etc
• Fantastic Comics: 4-23 - Need seq types, char app cleanup, etc
• Murder (Renegade Press): 1-3
• Blazing Sixguns (IW Publishing): #12, 15 (Stories need page counts)
• Dream of Love (IW Publishing): 1 (stories need page counts)
• Foxhole (IW Publishing): 12, 17, 18 (Stories need page counts)
• Love and Marriage (IW Publishing) : 2 (stories need page counts)
• U.S. Paratroops (IW Publishing): 1 (two text stories need page counts)
• US. FIghting Air Force (IW Publishing): 1 (stories need page counts)

Old Queries that need to be checked against the next datadump to make sure they got done completely:

Sequences with "umoristico" as a genre (that aren't Italian): Sequences with Umoristico as a genre

Issues with "War" as a type: War as a Type ALL FIXED!!!! Saving for a double check in the next data dump.

Sequence type of "Fantasy": Sequence Type of Fantasy

Issues with "Romance" as a type: Romance as a Type

Sequences with "Romance" as a feature: Sequences with Romance as a Feature

Features of "War Story": Feature as War Story

Issues with CAN or CDN in the price (should be CAD): Issues with CAN or CDN in the price

Text in the genre field that has been brought up: 'superherosuper-hero', 'eroisuperhero' and I've seen 'Inside Cover'. Bad Superhero Genres