Missing PubDates

From GCD
Jump to: navigation, search

Back to Special Projects

Halo Jones (1987 series) #6

Halo Jones (1987 series) #7

Halo Jones (1987 series) #9

Halo Jones (1987 series) #10

Halo Jones (1987 series) #12

Hulk album (1979 series) #[5 Presentalbum]

Incorruptible (2009 series) #13 [Cover A]

Intimate Confessions (1951 series) #5

Invincible Iron Man Annual (2010 series) #1

Jeremiah (1988 series) #10 - Bumerang

Judomaster (1978 series) #1

King Comics (1936 series) #33

Knockout (1939 series) #558

Kwaziu (2008 series) #2

The Li'l Depressed Boy (2011 series) #1

El Libertador (2000 series) #[nn]

Lieutenant Blueberry (1991 series) #1 - The Iron Horse

Lieutenant Blueberry (1991 series) #2 - Steelfingers

Lill-Allers julbok (1972 series) #[nn]

Locke & Key (2008 series) #5

Loner (1990 series) #6

Love Diary (1958 series) #30

Love Illustrated (1951 series) #43

Mad's Al Jaffee Spews Out Snappy Answers to Stupid Questions (1968 series) #T4987

Maverick Western Library (1971 ? series) #3

Millie the Model (1945 series) #42

newuniversal (2006 series) #2

Northguard: The ManDes Conclusion (1989 series) #2

Overkill (1992 series) #1

Overkill (1992 series) #3

Overkill (1992 series) #4

Overkill (1992 series) #5

Overkill (1992 series) #6

Parasiten (2002 series) #3

The Phantom: Generations (2009 series) #5

Pk Paperinik New Adventures (1996 series) #49 - #50

Prime (1995 series) #7

Retief: Grime and Punishment (1991 series) #1

Return of the Super Pimps (2005 series) #4

Romantic Love (1949 series) #4

Romantic Love (1958 series) #8

Romantic Love (1958 series) #10

Sagan om ringen (1979 series) #1

Secrets of the Unknown (1962 series) #132

Sheriff Klassiker (1964 series) #944

Silhouette Western (1956 ? series) #20

Sinister Tales (1964 series) #209

Six Degrees (1995 series) #1

Six Degrees (1995 series) #2

Six Degrees (1995 series) #3

Six Degrees (1995 series) #4

Six Degrees (1995 series) #5

Spawn (1992 series) #169

Spider-Island: Deadly Hands of Kung Fu (2011 series) #1

Spøk og Spenning (1950 series) #6/1950

Spøk og Spenning (1950 series) #7/1950

Spøk og Spenning (1950 series) #8/1950

Spøk og Spenning (1950 series) #10/1950

Spøk og Spenning (1950 series) #12/1950

Spøk og Spenning (1950 series) #1/1951

Spøk og Spenning (1950 series) #2/1951

Spøk og Spenning (1950 series) #3/1951

Spøk og Spenning (1950 series) #4/1951

Spøk og Spenning (1950 series) #5/1951

Spøk og Spenning (1950 series) #6/1951

Spøk og Spenning (1950 series) #7/1951

Spøk og Spenning (1950 series) #8/1951

Spøk og Spenning (1950 series) #9/1951

Spøk og Spenning (1950 series) #10/1951

Spøk og Spenning (1950 series) #11/1951

Spøk og Spenning (1950 series) #12/1951

Spøk og Spenning (1950 series) #1/1952

Spøk og Spenning (1950 series) #2/1952

Spøk og Spenning (1950 series) #3/1952

Spøk og Spenning (1950 series) #4/1952

Spøk og Spenning (1950 series) #5/1952

Spøk og Spenning (1950 series) #6/1952

Spøk og Spenning (1950 series) #13/1952

Spøk og Spenning (1950 series) #14/1952

Spøk og Spenning (1950 series) #15/1952

Spøk og Spenning (1950 series) #16/1952

Spøk og Spenning (1950 series) #1-2/1953

Spøk og Spenning (1950 series) #5-6/1953

Spøk og Spenning (1950 series) #7-8/1953

Spøk og Spenning (1950 series) #9-10/1953

Spøk og Spenning (1950 series) #13-14/1953

Spøk og Spenning (1950 series) #15-16/1953

Spøk og Spenning (1950 series) #21-22/1953

Spøk og Spenning (1950 series) #27-28/1953

Spøk og Spenning (1950 series) #35-36/1953

Spøk og Spenning (1950 series) #41-42/1953

Spøk og Spenning (1950 series) #43-44/1953

Spøk og Spenning (1950 series) #45-46/1953

Spøk og Spenning (1950 series) #49-50/1953

Spøk og Spenning (1950 series) #4/1954

Spøk og Spenning (1950 series) #6/1954

Spøk og Spenning (1950 series) #7/1954

Spøk og Spenning (1950 series) #9/1954

Spøk og Spenning (1950 series) #10/1954

Spøk og Spenning (1950 series) #12/1954

Spøk og Spenning (1950 series) #13/1954

Spøk og Spenning (1950 series) #14/1954

Spøk og Spenning (1950 series) #15/1954

Spøk og Spenning (1950 series) #16/1954

Spøk og Spenning (1950 series) #17/1954

Spøk og Spenning (1950 series) #18/1954

Stjärnornas krig (1983 series) #4/1984

Studio Epix (1987 series) #4

Sun (1952 series) #184

Sun (1952 series) #199

Super Adventure Comic (1960 series) #49

Super Adventure Comic (1960 series) #57

Super Adventure Comic (1960 series) #61

Super Adventure Comic (1960 series) #66

Super Adventure Comic (1960 series) #68

Super Adventure Comic (1960 series) #69

Super Comics (1968 series) #3

Super Comics (1968 series) #4

Super Comics (1968 series) #5

Super Comics (1968 series) #6

Super Comics (1968 series) #7

Super Comics (1968 series) #8

Super Comics (1968 series) #9

Super Comics (1968 series) #10

Super Comics (1968 series) #11

Super Comics (1968 series) #12

Super Comics (1968 series) #13

Super Comics (1968 series) #14

Super Comics (1968 series) #15

Super Comics (1968 series) #16

Super Comics (1968 series) #17

Super Comics (1968 series) #18

Super Comics (1968 series) #19

Super Comics (1968 series) #20

Super Comics (1968 series) #21

Super Comics (1968 series) #22

Super Comics (1968 series) #23

Super Comics (1968 series) #24

Super Comics (1968 series) #25

Super Comics (1968 series) #26

Super Comics (1968 series) #27

Super Comics (1968 series) #28

Super Comics (1968 series) #29

Super Goof (1980 series) #68

Svenska serier (1987 series) #5/1989

They Called Me A Flirt (1951 series) #[nn]

Thriller (1991 series) #6/1992

Top Comics Die Grüne Laterne (1970 series) #114

Top Comics Die Grüne Laterne (1970 series) #115

Top Comics Wassermann (1970 series) #112

Le Trésor de la Jeunesse (1951 ? series) #8 - Les As du Sport

Uncanny Tales (1963 series) #59

Uncanny Tales (1963 series) #63

The Walking Dead (2004 series) #3 - Safety Behind Bars

The Walking Dead (2004 series) #4 - The Heart's Desire

The Walking Dead (2004 series) #5 - The Best Defense

War Stories (1975 ? series) #6

Web of Mystery (1951 series) #3

Web of Mystery (1951 series) #5

Western Outlaws (1954 series) #8

Worst from MAD (1958 series) #2

Young Hearts In Love (1963 series) #18

Young Marvelman (1954 series) #347

Zona 84 (1984 series) #58

Zona 84 (1984 series) #81


SELECT s.councode, s.bk_name, i.issue, i.key_date, i.pub_date
FROM issues i
INNER JOIN series s ON i.seriesID = s.id
WHERE i.indexstatus =3
AND i.pub_date =
ORDER BY s.councode, s.bk_name, i.issue

Country Code, Series Name, Issue Number, KeyDate (if it's there), Missing Published Date

councode,bk_name,issue,key_date,pub_date

Australia

  • au,Tip Top Comic Monthly,90,1973.00.90,

Canada

  • CA,Frontline Combat,2,, - no key date

Germany

  • de,Die Leidenschaft des Herrn Lührs,nn,2001.09.01,
  • de,Parasiten,3,2003.03.25,

Italy

  • it,Alan Ford,367,2000.01.10,
  • it,Alan Ford,368,2000.02.10,
  • it,Alan Ford,369,2000.03.10,
  • it,Alan Ford,370,2000.04.10,
  • it,Alan Ford,371,2000.05.10,
  • it,Alan Ford,372,2000.06.10,
  • it,Alan Ford,373,2000.07.10,
  • it,Alan Ford,374,2000.08.10,
  • it,Alan Ford,375,2000.09.10,
  • it,Alan Ford,376,2000.10.10,
  • it,Alan Ford,377,2000.11.10,
  • it,Alan Ford,378,2000.12.10,
  • it,Alan Ford,379,2001.01.10,

Sweden

  • se,Lucky Lukes äventyr,54,1986.00.54,
  • se,När himlen föll ned,1,1998.01.10,
  • se,När himlen föll ned,2,1998.01.20,
  • se,Skaparens folk,[nn],, - no key date

USA

  • us,Apache,1,1958.00.10,
  • us,Avenger, The,9,1958.00.20,
  • us,Billy And Buggy Bear,1,1958.00.01,
  • us,Billy And Buggy Bear,10,1958.00.10,
  • us,Billy And Buggy Bear,7,1958.00.07,
  • us,Birth Caul, The,nn,, - no key date
  • us,Brain,14,1963.00.20,
  • us,Brain,18,1963.00.30,
  • us,Buccaneer,1,1958.00.01,
  • us,Buccaneer,8,1958.00.08,
  • us,Cowboys 'N' Injuns,10,1958.00.10,
  • us,Cowboys 'N' Injuns,7,1958.00.07,
  • us,Danger Is Our Business,9,1958.00.09,
  • us,Doctor Fu Manchu,1,1958.00.01,
  • us,Dogface Dooley,1,1958.00.01,
  • us,Dream Of Love,1,1958.00.01,
  • us,Dream Of Love,2,1958.00.02,
  • us,Dream Of Love,8,1958.00.08,
  • us,Dynamic Adventures,9,1958.00.09,
  • us,Dynamic Comics,1,1958.00.01,
  • us,Eerie,1,1958.00.01,
  • us,Eerie,8,1958.00.08,
  • us,Eerie,9,1958.00.09,
  • us,Fantastic Tales,1,1958.00.01,
  • us,Frontier Romances,1,1958.00.01,
  • us,Frontier Romances,9,1958.00.09,
  • us,Gladstone Comics Album,15,1989.03.02,
  • us,Gladstone Comics Album,27,1990.06.02,
  • us,Gladstone Comics Album Special Giant,1,1989.19.01,
  • us,Great Action Comics,1,1958.00.01,
  • us,Great Action Comics,8,1958.00.08,
  • us,Great Action Comics,9,1958.00.09,
  • us,Great Western,1,1958.00.01,
  • us,Great Western,2,1958.00.02,
  • us,Great Western,8,1958.00.08,
  • us,Great Western,9,1958.00.09,
  • us,H.P. Lovecraft's Cthulhu,3,, - no key date
  • us,Hollywood Secrets Of Romance,9,1958.00.09,
  • us,Indian Braves,1,1958.00.01,
  • us,Indians Of The Wild West,9,1958.00.09,
  • us,Intimate Confessions,18,1958.00.10,
  • us,Jet Power,1,1958.00.01,
  • us,Jungle Comics,9,1958.00.09,
  • us,Ka'a'nga,1,1958.00.01,
  • us,Ka'a'nga,8,1958.00.08,
  • us,Kat Karson,1,1958.00.01,
  • us,Leo The Lion,1,1958.00.01,
  • us,Little Spunky,1,1958.00.01,
  • us,Love and Marriage,11,1958.00.11,
  • us,Love and Marriage,17,1963.00.17,
  • us,Love and Marriage,2,1958.00.02,
  • us,Love and Marriage,8,1958.00.08,
  • us,Malu In The Land Of Adventure,1,1958.00.01,
  • us,Man O' Mars,1,1958.00.01,
  • us,Marmaduke Monk,1,1958.00.11,
  • us,Marmaduke Monk,14,1958.00.14,
  • us,Mighty Atom And The Pixies,1,1958.00.01,
  • us,Mitch Byrd Presents,1,0000.00.01,
  • us,Mitch Byrd Presents,3,0000.00.03,
  • us,Muggsy Mouse,1,1958.00.01,
  • us,Muggy-Doo, Boy Cat,16,1958.00.16,
  • us,My Secret Marriage,9,1958.00.09,
  • us,Northguard: The ManDes Conclusion,2,1990.00.10,
  • us,Pee Wee Pixies,1,1958.00.01,
  • us,Pee Wee Pixies,10,1958.00.10,
  • us,Pee Wee Pixies,8,1958.00.08,
  • us,Pinky The Egghead,1,1958.00.01,
  • us,Planet Comics,8,1958.00.08,
  • us,Purple Claw,8,1958.00.08,
  • us,Realistic Romances,1,1958.00.01,
  • us,Realistic Romances,8,1958.00.08,
  • us,Realistic Romances,9,1958.00.09,
  • us,Red Mask,1,1958.00.01,
  • us,Red Mask,2,1958.00.02,
  • us,Red Mask,8,1958.00.08,
  • us,Robin Hood,1,1958.00.01,
  • us,Robin Hood,2,1958.00.02,
  • us,Robin Hood,9,1963.00.09,
  • us,Sambu Gassho,[nn],, - no key date
  • us,Sharpy Fox,14,1958.00.14,
  • us,Sharpy Fox,2,1958.00.02,
  • us,Sheena, Queen Of The Jungle,9,1958.00.09,
  • us,Silver Kid Western,1,1958.00.01,
  • us,Silver Kid Western,2,1958.00.02,
  • us,Soldier and Marine Comics,14,, - no key date
  • us,Space Comics,8,1958.00.08,
  • us,Space Detective,1,1958.00.01,
  • us,Space Detective,8,1958.00.08,
  • us,Space Mysteries,1,1958.00.01,
  • us,Space Mysteries,9,1958.00.09,
  • us,Speedy Rabbit,14,1958.00.01,
  • us,Star Feature Comics,9,1958.00.09,
  • us,Strange Mysteries,9,1958.00.09,
  • us,Strange Planets,1,1958.00.01,
  • us,Strange Planets,10,1958.00.10,
  • us,Strange Planets,11,1958.00.11,
  • us,Strange Planets,9,1958.00.09,
  • us,Strange Worlds,5,1958.00.05,
  • us,Sunny, America's Sweetheart,8,1958.00.08,
  • us,Super Brat,3,1958.00.03,
  • us,Super Brat,7,1958.00.07,
  • us,Teen-Age Talk,9,1958.00.09,
  • us,Tell It To the Marines,1,1958.00.01,
  • us,Tell It To the Marines,16,1958.00.16,
  • us,Tell It To the Marines,9,1958.00.09,
  • us,Three Rascals,10,1958.00.10,
  • us,Tippy Terry,1,1958.00.01,
  • us,Tom-Tom The Jungle Boy,1,1958.00.01,
  • us,Tom-Tom The Jungle Boy,2,1958.00.02,
  • us,Tom-Tom The Jungle Boy,8,1958.00.08,
  • us,Top Adventure Comics,1,1958.00.01,
  • us,Top Adventure Comics,2,1958.00.02,
  • us,Top Detective Comics,9,1958.00.09,
  • us,Top Jungle Comics,1,1958.00.01,
  • us,Torchy,16,1958.00.16,
  • us,U.S. Paratroops,1,1958.00.01,
  • us,U.S. Paratroops,8,1958.00.08,
  • us,Wacky Woodpecker,10,1958.00.10,
  • us,Wambi,8,1958.00.08,
  • us,Western Action,7,1958.00.07,
  • us,Whip Wilson,1,1958.00.01,
  • us,Wild Bill Hickok,1,1958.00.01,
  • us,Wild Western Roundup,1,1958.00.01,
  • us,Zero Hunters,1,0000.00.01,
  • us,Zero Hunters,2,0000.00.02,
  • us,Zero Hunters,3,0000.00.03,
  • us,Zero Hunters,4,0000.00.04,
  • us,Ziggy Pig,7,1958.00.07,