Missing PubDates: Difference between revisions
Jump to navigation
Jump to search
CArchivist (talk | contribs) No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
[[Special Projects|Back to Special Projects]] | [[Special Projects|Back to Special Projects]] | ||
SELECT s.councode, s.bk_name, i.issue, i.key_date, i.pub_date<br> | SELECT s.councode, s.bk_name, i.issue, i.key_date, i.pub_date<br> | ||
Revision as of 08:42, 25 March 2020
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
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,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,