SELECT product_metadata.*, product.id AS product_id, sum(product.stock) AS stock FROM product_metadata INNER JOIN tree ON tree.id = product_metadata.tree_id INNER JOIN _rel_product_metadata rpm ON rpm.product_metadata_id = product_metadata.id INNER JOIN product ON rpm.product_id = product.id WHERE ( product.parent_id = 529 or (product.id = 529 and product.stock >= 1) ) AND product.online = 1 AND ( product_metadata.tree_id = 972 ) GROUP by product_metadata.id ORDER BY product_metadata.prio, product.parent_id, tree.depth, tree.prio, product.prio T-Shirts
Zoelen
T-Shirts
shirrt black
shirrt black achter

WIPEOUT® BLACK UNISEX T-SHIRT

€ 17,50

Rocking BLACK T-Shirt!! Mooie kwaliteit en een uniek WipeOut Patroon! Een echte musthaves! Laat iedereen zien YOU DID IT offf... GOING TO DO IT!

Maat:
Aantal:
XXL
978