Hi
Privacy, Security and Affiliates
Affiliate Links:
When you click on links to various merchants on this site and make a purchase, this can result in this site earning a commission. Affiliate programs and affiliations include, but are not limited to, the eBay Partner Network.
Personal Data:
Personal data submitted to ToyMart by registered users is held on our secure server with all passwords being highly encrypted. Your data will never be passed to third parties and only used by ToyMart where required to conduct our business such as fulfilling orders etc.
Any data retained by ToyMart is available on the My ToyMart settings page and can be edited or destroyed by the owner at any time.
Our checkout payment system is handled securely by PayPal. ToyMart does not collect, hold or have access to any card payment details.
When you click on links to various merchants on this site and make a purchase, this can result in this site earning a commission. Affiliate programs and affiliations include, but are not limited to, the eBay Partner Network.
Personal Data:
Personal data submitted to ToyMart by registered users is held on our secure server with all passwords being highly encrypted. Your data will never be passed to third parties and only used by ToyMart where required to conduct our business such as fulfilling orders etc.
Any data retained by ToyMart is available on the My ToyMart settings page and can be edited or destroyed by the owner at any time.
Our checkout payment system is handled securely by PayPal. ToyMart does not collect, hold or have access to any card payment details.
X
PLEASE BE AWARE
When you click on links to ebay and make a purchase ToyMart may earn a commission.
When you click on links to ebay and make a purchase ToyMart may earn a commission.
ToyMart Price Guide
Find Rare Toys
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
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