Skip to content

Instantly share code, notes, and snippets.

@stilografico

stilografico/gist:ab61371f0623653fea9224dc849fe4c3

Created March 26, 2018 09:15
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save stilografico/ab61371f0623653fea9224dc849fe4c3 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save stilografico/ab61371f0623653fea9224dc849fe4c3 to your computer and use it in GitHub Desktop.
Download ZIP
GRAVITY FORMS CLEANUP Delete orphan entries from rg_lead_detail_long
Raw
gistfile1.txt
/*GRAVITY FORMS CLEANUP*/
Delete orphan entries from rg_lead_detail_long
SELECT * FROM wp_rg_lead_detail_long
LEFT JOIN wp_rg_lead_detail ON (wp_rg_lead_detail_long.lead_detail_id = wp_rg_lead_detail.lead_id)
WHERE (wp_rg_lead_detail.lead_id IS NULL)
DELETE wp_rg_lead_detail_long FROM wp_rg_lead_detail_long
LEFT JOIN wp_rg_lead_detail ON (wp_rg_lead_detail_long.lead_detail_id = wp_rg_lead_detail.lead_id)
WHERE (wp_rg_lead_detail.lead_id IS NULL)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment