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'