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
Unidentified Diecast) Regex error 'unmatched closing parenthesis at offset 32'
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:]]|^)Diecast)([[:blank:][:punct:]]|$)' AND pg.Manufacturer = m.man_id AND m.man_status = 1 AND m.man_name LIKE '%Unidentified%' OR pg.Description REGEXP '([[[:blank:][:punct:]]|^)Diecast)([[:blank:][:punct:]]|$)' AND pg.Manufacturer = m.man_id AND m.man_status = 1 AND m.man_name LIKE '%Unidentified%' OR pg.Number REGEXP '([[[:blank:][:punct:]]|^)Diecast)([[:blank:][:punct:]]|$)' AND pg.Manufacturer = m.man_id AND m.man_status = 1 AND m.man_name LIKE '%Unidentified%' OR pg.Colour REGEXP '([[[:blank:][:punct:]]|^)Diecast)([[:blank:][:punct:]]|$)' AND pg.Manufacturer = m.man_id AND m.man_status = 1 AND m.man_name LIKE '%Unidentified%' OR pg.Barcode REGEXP '([[[:blank:][:punct:]]|^)Diecast)([[:blank:][:punct:]]|$)' AND pg.Manufacturer = m.man_id AND m.man_status = 1 AND m.man_name LIKE '%Unidentified%' OR pg.combinedPNS = 'Diecast)' AND pg.Manufacturer = m.man_id AND m.man_status = 1 AND m.man_name LIKE '%Unidentified%' OR m.man_name REGEXP '([[[:blank:][:punct:]]|^)Diecast)([[:blank:][:punct:]]|$)' AND pg.Manufacturer = m.man_id AND m.man_status = 1 AND m.man_name LIKE '%Unidentified%' GROUP BY pg.ID ORDER BY m.man_name, pg.combinedPNS ASC, pg.produced_from