right now on ebay
Hi
PLEASE BE AWARE
When you click on links to ebay and make a purchase ToyMart may earn a commission.

ToyMart Price Guide

Condition Grading
Throughout the site all models are given a condition grading. The first letter applies to the model and the second to the box or packaging.
  • A+ = Mint
  • As new Condition
  • A = Excellent
  • Only the slightest faults
  • B = Very Good
  • Some signs of wear
  • C = Good
  • With obvious wear
  • D = Fair
  • Possibly parts missing
  • E = Poor
  • Restoration project only
  • NB = Loose
  • No box or packaging
Top Trumps dubreq/schmid) Regex error 'unmatched closing parenthesis at offset 38'
SELECT pg.*, pg.combinedPNS, pg.produced_from, m.man_id, m.man_name, m.man_use FROM price_guide AS pg, manufacturer AS m WHERE pg.Model REGEXP '([[[:blank:][:punct:]]|^)Top([[:blank:][:punct:]]|$)' AND pg.Model REGEXP '([[[:blank:][:punct:]]|^)Trumps([[:blank:][:punct:]]|$)' AND pg.Model REGEXP '([[[:blank:][:punct:]]|^)dubreq/schmid)([[:blank:][:punct:]]|$)' AND pg.Manufacturer = m.man_id AND m.man_status = 1 OR pg.Description REGEXP '([[[:blank:][:punct:]]|^)Top([[:blank:][:punct:]]|$)' AND pg.Description REGEXP '([[[:blank:][:punct:]]|^)Trumps([[:blank:][:punct:]]|$)' AND pg.Description REGEXP '([[[:blank:][:punct:]]|^)dubreq/schmid)([[:blank:][:punct:]]|$)' AND pg.Manufacturer = m.man_id AND m.man_status = 1 OR pg.P='Top' AND pg.Number REGEXP '([[[:blank:][:punct:]]|^)Trumps([[:blank:][:punct:]]|$)' AND pg.Number REGEXP '([[[:blank:][:punct:]]|^)dubreq/schmid)([[:blank:][:punct:]]|$)' AND pg.Manufacturer = m.man_id AND m.man_status = 1 OR pg.Colour REGEXP '([[[:blank:][:punct:]]|^)Top([[:blank:][:punct:]]|$)' AND pg.Colour REGEXP '([[[:blank:][:punct:]]|^)Trumps([[:blank:][:punct:]]|$)' AND pg.Colour REGEXP '([[[:blank:][:punct:]]|^)dubreq/schmid)([[:blank:][:punct:]]|$)' AND pg.Manufacturer = m.man_id AND m.man_status = 1 OR pg.Barcode REGEXP '([[[:blank:][:punct:]]|^)Top([[:blank:][:punct:]]|$)' AND pg.Barcode REGEXP '([[[:blank:][:punct:]]|^)Trumps([[:blank:][:punct:]]|$)' AND pg.Barcode REGEXP '([[[:blank:][:punct:]]|^)dubreq/schmid)([[:blank:][:punct:]]|$)' AND pg.Manufacturer = m.man_id AND m.man_status = 1 OR pg.combinedPNS = 'Top' AND pg.combinedPNS = 'Trumps' AND pg.combinedPNS = 'dubreq/schmid)' AND pg.Manufacturer = m.man_id AND m.man_status = 1 OR m.man_name REGEXP '([[[:blank:][:punct:]]|^)Top([[:blank:][:punct:]]|$)' AND m.man_name REGEXP '([[[:blank:][:punct:]]|^)Trumps([[:blank:][:punct:]]|$)' AND m.man_name REGEXP '([[[:blank:][:punct:]]|^)dubreq/schmid)([[:blank:][:punct:]]|$)' AND pg.Manufacturer = m.man_id AND m.man_status = 1 GROUP BY pg.ID ORDER BY m.man_name, pg.combinedPNS ASC, pg.produced_from