Missing PubDates: Difference between revisions

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,

Missing PubDates: Difference between revisions

Revision as of 00:06, 26 March 2014

Contents

Australia

Canada

Germany

Italy

Sweden

USA

Navigation menu

Missing PubDates: Difference between revisions

Revision as of 00:06, 26 March 2014

Australia

Canada

Germany

Italy

Sweden

USA

Navigation menu

Search