UPDATE wp_posts AS P
LEFT JOIN wp_postmeta AS Latitude
ON Latitude.meta_key='lv_listing_lat' AND P.ID=Latitude.post_id
LEFT JOIN wp_postmeta AS Longtitude
ON Longtitude.meta_key='lv_listing_lng' AND P.ID=Longtitude.post_id
SET P.post_status='trash'

WHERE P.post_type='lv_listing' 
    AND Latitude.meta_value... //duplicate clause
    AND Latitude.meta_value .... //duplicate clause

please help me! many thanks

this data from WordPress database

Read more here: How to update with join table and duplicate value


If you know the solution of this issue, please leave us a reply in Comment section, to update the question.

Wordpress related questions and answers: