The following items are on sale.1 Products Query = SELECT artlist.sku, artlist.prodname, artlist.artist, artlist.medium, artlist.price, artlist.qoh, artlist.catagory, artlist.subcatagory, artlist.sort, artlist.thumb FROM artlist WHERE originalprice<>0 ORDER BY sort, price, artist, catagory, subcatagory, prodname
37 products were found in the following 7 mediums:
3D Art (7)   Books (7)   Paintings - Acrylic (5)   Paintings - Oil (5)   Portfolios (1)   Prints (11)   Sweatshirts (1)  

ImageCategory/SubcategoryTitleArtistMediumPrice
Illustrated Books/HardcoverThe Bremen Town MusiciansJoe BoddyBooks$10
Illustrated Books/HardcoverPollyannaJudy MastrangeloBooks$10
Illustrated Books/HardcoverGhost StoriesWalt SturrockBooks$10
Classics/Hardcover-LinenGhosts - A Classic CollectionWalt SturrockBooks$15
Illustrated Books/Hardcover-LinenRobin HoodGreg HildebrandtBooks$25
Illustrated Books/HardcoverPinocchioGreg HildebrandtBooks$30
Classics/PoeEdgar Allan Poe: The Man That Was Used UpGreg HildebrandtBooks$75
Tolkien/Lord of the RingsHildebrandt / Tolkien Screen SaverBrothers HildebrandtPortfolios$10
Tolkien/Lord of the RingsGandalf Visits BilboBrothers HildebrandtPrints$10
Tolkien/Lord of the RingsLothlorienBrothers HildebrandtPrints$10
Fantasy/PrintsThe Dragon SlayerBrothers HildebrandtPrints$20
Tolkien/Lord of the RingsFellowship PrintBrothers HildebrandtPrints$25
Tolkien/Lord of the RingsThe Siege PrintBrothers HildebrandtPrints$25
Tolkien/Lord of the RingsRing of the Elf QueenGreg HildebrandtPrints$35
Tolkien/Lord of the RingsSiege of Minas Tirith 2Brothers HildebrandtPrints$40
Tolkien/Lord of the RingsThe Return of GandalfBrothers HildebrandtPrints$40
Tolkien/Lord of the RingsThe Siege of Minas Tirith II printBrothers HildebrandtPrints$40
Tolkien/Lord of the RingsGift of the Elf QueenGreg HildebrandtPrints$40
Tolkien/Lord of the Rings   The Unexpected Party PrintBrothers HildebrandtPrints$150
Clothing/TolkienSmaug white sweatshirtBrothers HildebrandtSweatshirts$15
Puzzles/Fantasy   Castle Puzzle - 1000 pcsBrothers Hildebrandt3D Art$10
Puzzles/Product Art   BLACK CAULDRON 1,000 Piece PuzzleGreg Hildebrandt3D Art$15
Puzzles/Product Art   MERLINGreg Hildebrandt3D Art$15
Puzzles/Product Art   THOR 500 Piece PuzzleGreg Hildebrandt3D Art$15
Dolls and Figurines/Fantasy   Pillar of StrengthBrothers Hildebrandt3D Art$45
Dolls and Figurines/Fantasy   Revenge of MadfuryBrothers Hildebrandt3D Art$45
Dolls and Figurines/Fantasy   Ocean's TreasureBrothers Hildebrandt3D Art$50
Comic Art/Comic Book CoverInfernoTom SmithPaintings - Acrylic$225
Magic The Gathering/MirrodinSoul NovaKeith GarlettsPaintings - Acrylic$425
Magic The Gathering/7th EditionBroodhatch NantukoKeith GarlettsPaintings - Acrylic$600
Fantasy/Gallery PieceGolden DragonMark RomanoskiPaintings - Acrylic$1400
Entertainment/WrestlingThe RockMark RomanoskiPaintings - Acrylic$2500
Marvel/X MENPyroLou HarrisonPaintings - Oil$350
Marvel/Comic ArtBullseyeMark RomanoskiPaintings - Oil$600
Comic Art/Comic Book CoverBlack Widow Comic CoverMark RomanoskiPaintings - Oil$1300
Marvel/Comic ArtThor Vs Surt`s MinionsLou HarrisonPaintings - Oil$1800
Marvel/Comic ArtThor vs Sea CreatureLou HarrisonPaintings - Oil$2500