aiiddqd/delete-commentmeta-without-comments.sql

Created October 29, 2018 10:39

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/aiiddqd/bf77160a0f956d2b39b775ae898f91d3.js"></script>
Save aiiddqd/bf77160a0f956d2b39b775ae898f91d3 to your computer and use it in GitHub Desktop.

Download ZIP

WordPress & SQL - delete commentmeta without comments

Raw

delete-commentmeta-without-comments.sql

-DELETE cm
-FROM wp_commentmeta as cm
-LEFT JOIN wp_comments as c ON c.comment_ID = cm.comment_id
-WHERE c.comment_ID is null

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment