Woocommerce price vs regular price fix

update wp1_postmeta pm
 join (
     select id, pmd.post_title, pmd.pm_price, pm_regular_price from vProductMetaData pmd
     join vProducts vp on vp.wp_post_id = pmd.id
      where coalesce(pmd.pm_price,0 ) <> coalesce (pmd.pm_regular_price,0)
      and product_type = 'simple'
      ) t on t.id = pm.post_id
 set pm.meta_value = pm_price
 where pm.meta_key = '_regular_price';