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 = 'Pencils - BW') AND (catagory = 'Fantasy') AND ((search LIKE '%' + 'atlantis' +'%')) ORDER BY Available DESC, qoh DESC, sort, price, catagory, subcatagory, artist, prodname


ImageCategory/SubcategoryTitleArtistMediumPrice
Fantasy/AtlantisAtlantis- Character SketchGreg HildebrandtPencils - BW$150
Fantasy/AtlantisAtlantis Calandar Cover SketchBrothers HildebrandtPencils - BW$350
Fantasy/AtlantisShadows Of AtlantisGreg HildebrandtPencils - BW$350
Fantasy/AtlantisTwo Shadows of AtlantisGreg HildebrandtPencils - BW$450
Fantasy/AtlantisAtlantis - To The DeathGreg HildebrandtPencils - BW$500
Fantasy/AtlantisAtlantis AttackGreg HildebrandtPencils - BW$500
Fantasy/AtlantisAtlantis RevengeGreg HildebrandtPencils - BW$500
Fantasy/AtlantisAtlantis White BeastGreg HildebrandtPencils - BW$750
Fantasy/AtlantisAtlantis Bee CreatureGreg HildebrandtPencils - BW$800
Fantasy/AtlantisAtlantis - The HeroesGreg HildebrandtPencils - BW$850
Fantasy/AtlantisAtlantis On The HorizonGreg HildebrandtPencils - BW$1000
Fantasy/AtlantisAtlantis The Attack #2Greg HildebrandtPencils - BW$1500
Fantasy/AtlantisAtlantis- The Great Sky TelescopeGreg HildebrandtPencils - BW$1800
Fantasy/AtlantisAtlantis White Beast #2Greg HildebrandtPencils - BW$1800
Fantasy/AtlantisAtlantis - The Quest #2Greg HildebrandtPencils - BW$2000
Fantasy/AtlantisAtlantis Sea BattleGreg HildebrandtPencils - BW$2000
Fantasy/AtlantisAtlantis Lost ContinentGreg HildebrandtPencils - BW$5000
Fantasy/Atlantis   Atlantis Concept LayoutBrothers HildebrandtPencils - BW$150
Fantasy/Atlantis   NivickBrothers HildebrandtPencils - BW$200
Fantasy/Atlantis   Atlantis - The QuestGreg HildebrandtPencils - BW$325
Fantasy/Atlantis   Atlantis Preliminary LayoutBrothers HildebrandtPencils - BW$400
Fantasy/Atlantis   Atlantis - The SeerGreg HildebrandtPencils - BW$400
Fantasy/Atlantis   Atlantis Prelminary Cover LayoutBrothers HildebrandtPencils - BW$550
Fantasy/Atlantis   Atlantis Black MenaceGreg HildebrandtPencils - BW$1200
Fantasy/AtlantisAtlantis concept sketchGreg HildebrandtPencils - BW$4000