SELECT artlist.sku, artlist.prodname, artlist.artist, artlist.medium, artlist.price, artlist.qoh, artlist.catagory, artlist.subcatagory, artlist.originalprice, thumb FROM artlist WHERE Discontinued is null AND (medium = 'Comics') AND ((search LIKE '%' + 'Collectibles' +'%') OR (search LIKE '%' + 'DynamicForces' +'%') OR (search LIKE '%' + 'Lithographs' +'%') OR (search LIKE '%' + 'Prints' +'%') OR (search LIKE '%' + 'figurines' +'%')) ORDER BY Available DESC, qoh DESC, sort, price, catagory, subcatagory, artist, prodname


ImageCategory/SubcategoryTitleArtistMediumPrice
DC/Comic ArtSpectre issue No. 11Greg HildebrandtComics$15
Comic Art/AshAsh #5Joe QuesadaComics$15
Marvel/Signed Trade PaperbackX-Men 2099 Oasis Bookshelf EditionBrothers HildebrandtComics$20
Comic Art/Fantasy   Darkchylde SketchbookRandy QueenComics$7
Comic Art/Signed Comic Book   Coven Issue #5Ian ChurchillComics$7
Comic Art/Fantasy   Darkchylde - The Sketch Book - 1998Randy QueenComics$10
Comic Art/Comic Art   The Coven #1 - Fan Appreciation EditionIan ChurchillComics$13
Comic Art/Comic Art   Painkiller Jane vs The DarknessBrothers HildebrandtComics$15
Comic Art/Comic Art   The DarknessBrothers HildebrandtComics$15
Marvel/Signed Comic Book   WILD C.A.T.S/X-MEN #1Travis CharestComics$16
DC/Signed Comic Book   Swamp Thing: RootsJon MuthComics$18
DC/Superman   Superman - Action Comics #700 - The Fall of Metropolis!Denis RodierComics$18
DC/Comic Art   Batman & Batgirl - Thrillkiller `62Dan BreretonComics$19
Fantasy/Signed Comic Book   Xena & Joxer #1Ron LimComics$20
Marvel/Comic Art   Fantastic Four #1Alan DavisComics$20
Marvel/Fantasy   Uncanny X-Men #304John Romita, Jr.Comics$20
DC/Signed Comic Book   Superman #123Ron FrenzComics$23
DC/Signed Comic Book   JLA #16Howard PorterComics$24
Comic Art/Ash   Ash #4Joe QuesadaComics$25
Fantasy/Comic Art   X-Files Season One - SqueezeRoy ThomasComics$25
Marvel/Comic Art   X-Men vs Magneto #150Joe RubinsteinComics$25
DC/Signed Comic Book   Azrael / ASHJoe QuesadaComics$30
Marvel/Comic Art   X-Men #186 - LifeDeathBarry Windsor-SmithComics$30
Marvel/DC   Uncanny X-Men and the New Teen Titans #1Walter SimonsonComics$30
Star Wars/Signed Trade Paperback   Star Wars - Heir to the EmpireOliver VatineComics$30
DC/Signed Comic Book   Spawn / BatmanTodd McFarlaneComics$50
Marvel/Signed Comic Book   Weapon Zero Silver Surfer #1Mark SilvestriComics$50
DC/Signed Trade Paperback   The Flash Archives Volume 1Various ArtistsComics$75
Marvel/Comic Art   Uncanny X-Men #325 - Anniversary IssueJoe MadurieraComics$375