steveosoule
2/5/2015 - 1:17 AM

Miva - Master Product From Variant Product Code

Miva - Master Product From Variant Product Code

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'