Miva - Master Product From Variant Product Code - Cacher Snippet

2/5/2015 - 1:17 AM

Miva - Master Product From Variant Product Code

Miva - Master Product From Variant Product Code

miva-master-product-from-variant-product-code.sql

SELECT p.* FROM s01_Products vp INNER JOIN s01_ProductVariantParts vpvp ON vp.id = vpvp.part_id INNER JOIN s01_Products p ON p.id = vpvp.product_id WHERE vp.code = 'VARIANT_PRODUCT_CODE'