Title: mvtilborg's Replies | WordPress.org

---

# mvtilborg

  [  ](https://wordpress.org/support/users/mvtilborg/)

 *   [Profile](https://wordpress.org/support/users/mvtilborg/)
 *   [Topics Started](https://wordpress.org/support/users/mvtilborg/topics/)
 *   [Replies Created](https://wordpress.org/support/users/mvtilborg/replies/)
 *   [Reviews Written](https://wordpress.org/support/users/mvtilborg/reviews/)
 *   [Topics Replied To](https://wordpress.org/support/users/mvtilborg/replied-to/)
 *   [Engagements](https://wordpress.org/support/users/mvtilborg/engagements/)
 *   [Favorites](https://wordpress.org/support/users/mvtilborg/favorites/)

 Search replies:

## Forum Replies Created

Viewing 2 replies - 1 through 2 (of 2 total)

 *   Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
   
   In reply to: [How to delete all posts with a given meta value](https://wordpress.org/support/topic/how-to-delete-all-posts-with-a-given-meta-value/)
 *  Thread Starter [mvtilborg](https://wordpress.org/support/users/mvtilborg/)
 * (@mvtilborg)
 * [14 years, 6 months ago](https://wordpress.org/support/topic/how-to-delete-all-posts-with-a-given-meta-value/#post-2403850)
 * Got this now, but does not do anything, what is wrong? Any help is highly appreciated.
 *     ```
       global $wpdb;
       	// delete all posts WHERE meta_value = $aid;
       	$wpdb->query("DELETE wp
       		FROM $wpdb->posts wp
       		LEFT JOIN $wpdb->postmeta pm ON pm.post_id = wp.ID
       		WHERE mp.meta_key = 'product_aid' AND mp.meta_value = '". $aid ."'");
       	// delete not used meta
       	$wpdb->query("DELETE pm
       		FROM $wpdb->postmeta pm
       		LEFT JOIN $wpdb->posts wp ON wp.ID = pm.post_id
       		WHERE wp.ID IS NULL");
       ```
   
 *   Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
   
   In reply to: [How to get post id on certain meta data values](https://wordpress.org/support/topic/how-to-get-post-id-on-certain-meta-data-values/)
 *  Thread Starter [mvtilborg](https://wordpress.org/support/users/mvtilborg/)
 * (@mvtilborg)
 * [14 years, 6 months ago](https://wordpress.org/support/topic/how-to-get-post-id-on-certain-meta-data-values/#post-2395046)
 * Figured it out myself
 *     ```
       global $wpdb;
       		$querystr = "SELECT post_id, count(post_id)
       			FROM $wpdb->postmeta
       			WHERE
       				(meta_key = 'product_aid' AND meta_value = '". $aid ."') OR
       				(meta_key = 'product_id' AND meta_value = '". (string)$item->productID ."')
       			GROUP BY post_id
       			HAVING count(post_id) = 2;
       		";
       		$postid = $wpdb->get_var($wpdb->prepare($querystr));
       ```
   

Viewing 2 replies - 1 through 2 (of 2 total)