SELECT DISTINCT shipping_date, item_name, username, url FROM (SELECT A.shipping_date, A.item_name, G.username, G.url FROM cs_product A JOIN cs_product_creator_map D ON D.product = A.product JOIN cs_user_creator_map E ON E.creator = D.creator JOIN cs_user G ON G.user = E.user WHERE A.shipping_date > '2008-12-09' AND G.url = 'jon-plante' UNION SELECT A.shipping_date, A.item_name, G.username, G.url FROM cs_product A JOIN cs_user G WHERE A.shipping_date > '2008-12-09' AND G.url = 'jon-plante' AND (A.item_name LIKE '%Jughead%' OR A.item_name LIKE '%Acme%' OR A.item_name LIKE '%modern masters%' OR A.item_name LIKE '%Star Trek%' OR A.item_name LIKE '%futurama%')) union_table ORDER BY shipping_date DESC, item_nameComicScout Pull Lists For Jon Plante Pull Lists From ComicScout.com http://comicscout.com/pull-list/jon-plante/ 2009 comicscout.com 08 10 12 14 16 18 20 Jon Plante's Pull List For January 7, 2009 FANTASTIC FOUR WORLDS GREATEST PREM<br />FANTASTIC FOUR WORLDS GREATEST PREM DM ED<br />HELLBOY WILD HUNT #2 (OF 8)<br />JUSTICE VOL 03<br />MIRRORS EDGE #3 (OF 6)<br />SECRET INVASION<br />SECRET INVASION WAR OF KINGS ONE SHOT<br />STAR TREK TMP SPOCK & KIRK AF 2-PACK<br />TRINITY #32<br />VIXEN RETURN OF THE LION #4 (OF 5)<br />X-MEN NOIR #1 (OF 4) 2ND PTG CALERO VAR<br />X-MEN NOIR #2 (OF 4) http://comicscout.com/pull-list/jon-plante/2009-01-07/ http://comicscout.com/pull-list/jon-plante/2009-01-07/ Wed, 07 Jan 2009 00:00:00 -0800 Jon Plante's Pull List For January 2, 2009 ALIENS OMNIBUS VOL 06<br />AVENGERS INVADERS #7 (OF 12)<br />BATMAN #684<br />ESSENTIAL PUNISHER VOL 03<br />FANTASTIC FOUR #562<br />FINAL CRISIS SECRET FILES #1<br />FUTURAMA AF SERIES 5<br />FUTURAMA FUTURE IS TODAY TIN SIGN<br />FUTURAMA WHEN WORKING TIN SIGN<br />FUTURAMA WORK WHILE BENT TIN SIGN<br />JUSTICE SOCIETY OF AMERICA #22<br />MARVEL ADVENTURES FANTASTIC FOUR #43<br />SUPERMAN #683 NEW KRYPTON<br />TRINITY #31<br />ULTIMATE HULK ANNUAL #1<br />WAR THAT TIME FORGOT #8 (OF 12)<br />WOLVERINE #70<br />YOUNG X-MEN #9 MD http://comicscout.com/pull-list/jon-plante/2009-01-02/ http://comicscout.com/pull-list/jon-plante/2009-01-02/ Fri, 02 Jan 2009 00:00:00 -0800 Jon Plante's Pull List For December 24, 2008 BATMAN #683<br />DARK TOWER TREACHERY #4 (OF 6)<br />DARKNESS #73 LUCAS CVR A<br />DARKNESS #73 SEJIC CVR B<br />FLASH #247<br />HULK #9<br />HULK #9 SANTA HULK VAR<br />MARVEL ADVENTURES SUPER HEROES #6<br />PATSY WALKER HELLCAT #4 (OF 5)<br />REIGN IN HELL #6 (OF 8)<br />SECRET INVASION REQUIEM #1 DKR<br />STAR TREK MAGAZINE #15 NEWSSTAND ED<br />STAR TREK MAGAZINE #15 PX ED<br />TRINITY #30<br />ULTIMATE SPIDER-MAN #129<br />ULTIMATES 3 PREM WHO KILLED SCARLET WITCH<br />ULTIMATES 3 PREM WHO KILLED SCARLET WITCH B & W DM VAR<br />ULTIMATES 3 PREM WHO KILLED SCARLET WITCH DM ED<br />X-MEN COMPLETE ONSLAUGHT EPIC BOOK 04 http://comicscout.com/pull-list/jon-plante/2008-12-24/ http://comicscout.com/pull-list/jon-plante/2008-12-24/ Wed, 24 Dec 2008 00:00:00 -0800 Jon Plante's Pull List For December 17, 2008 BIRDS OF PREY #125<br />CONAN THE CIMMERIAN #6<br />DARK REIGN NEW NATION<br />DARKNESS COMPENDIUM LTD ED VOL 01<br />DCU HOLIDAY SPECIAL 2008<br />DEAD OF NIGHT DEVIL SLAYER #4 (OF 4)<br />DEADPOOL #5<br />FABLES #79<br />JUGHEADS DOUBLE DIGEST #146<br />MADMAN ATOMIC COMICS #12<br />MIGHTY AVENGERS #20 DKR<br />MIGHTY AVENGERS PREM VOL 03 SECRET INVASION BOOK 01<br />SECRET WARS OMNIBUS<br />SECRET WARS OMNIBUS DM ED<br />SPIDER-MAN VOL 02 BRAND NEW DAY<br />STAR TREK LAST GENERATION #2<br />STAR TREK MOVIES IN MOTION T/C BOX<br />SUPERGIRL #36 NEW KRYPTON<br />SUPERMAN PAST AND FUTURE<br />TRINITY #29<br />UNCANNY X-MEN #505 MD<br />WHAT IF NEWER FANTASTIC FOUR<br />WITCHBLADE COMPENDIUM VOL 01 LTD ED<br />WOLVERINE ORIGINS VOL 05 DEADPOOL<br />X-MEN KINGBREAKER #1 (OF 4) http://comicscout.com/pull-list/jon-plante/2008-12-17/ http://comicscout.com/pull-list/jon-plante/2008-12-17/ Wed, 17 Dec 2008 00:00:00 -0800 Jon Plante's Pull List For December 10, 2008 100 BULLETS #98<br />ACTION COMICS #872 NEW KRYPTON<br />ASTONISHING X-MEN GHOST BOXES #2 (OF 2)<br />AVENGERS PREM FIRST TO LAST<br />AVENGERS PREM FIRST TO LAST DM ED<br />BATMAN JOKERS ASYLUM<br />BPRD WAR ON FROGS #2<br />CAPTAIN AMERICA CHOSEN<br />CAPTAIN BRITAIN AND MI 13 #8<br />DARKNESS BUTCHER (ONE SHOT) TC STORE EXCL VAR SGN<br />FINAL CRISIS #5 (OF 7)<br />JSA VOL 03 THY KINGDOM COME PART 2<br />MARVEL APES #0<br />MIRRORS EDGE #2 (OF 6)<br />SECRET INVASION DARK REIGN<br />STAR TREK MOVIES IN MOTION COLLECTORS ALBUM<br />TRINITY #28<br />WATCHMEN #1 NEW PTG<br />WHAT IF CAPTAIN AMERICA FALLEN SON<br />WITCHBLADE #118 SDCC EXCL VAR<br />WONDERFUL WIZARD OF OZ #1 (OF 8) http://comicscout.com/pull-list/jon-plante/2008-12-10/ http://comicscout.com/pull-list/jon-plante/2008-12-10/ Wed, 10 Dec 2008 00:00:00 -0800