Delete wp_post_meta if users not exist by SQL

82
October 29, 2021, at 05:10 AM

I have huge unnecessary custom field data in my post. This post has been contain user id. I have already removed the users but this user id in our custom filed post. How can remove this. I need if user not exist it then remove the post meta.

 DELETE pm
    FROM wp_postmeta pm
    LEFT JOIN wp_posts wp ON wp.ID = pm.post_id
    WHERE NOT EXISTS (SELECT * FROM pm WHERE wp_users.id= pm.value)
READ ALSO
mysql in docker secure-file-priv problems

mysql in docker secure-file-priv problems

mysql in docker on windows with python, local

76
Can Jinja be used inside of a CSS file?

Can Jinja be used inside of a CSS file?

So I'm using Flask, Python, HTML, CSS, and jinja2 for a project and I wanna try to use jinja to make my website dynamic so I need to ask if it's possible to use jinja inside of my CSS file something like this:

84
Why am I unable to slide a Div onto the screen using jquery animate?

Why am I unable to slide a Div onto the screen using jquery animate?

I have a simple effect I am trying to achieve, but am doing something wrong

40
Recursive limit exceeded - Pyomo?

Recursive limit exceeded - Pyomo?

I'm a newcomer to Pyomo, trying to solve an LP that I've implemented

50