-- cet exemple supprime les 1000 premiers CTP de type "commande" dont la meta "boutique" vaut "14513"
CREATE TEMPORARY TABLE akn_temp_table (post INT);
INSERT INTO akn_temp_table SELECT ID FROM wp_posts WHERE post_type="commande" AND ID IN (SELECT post_id FROM wp_postmeta WHERE meta_key="boutique" AND meta_value="14513") ORDER BY ID ASC LIMIT 0,1000;
DELETE FROM wp_posts WHERE ID IN (SELECT post FROM akn_temp_table);
DELETE FROM wp_posts WHERE post_parent IN (SELECT post FROM akn_temp_table);
DELETE FROM wp_postmeta WHERE post_id IN (SELECT post FROM akn_temp_table);
DELETE FROM wp_term_relationships WHERE object_id IN (SELECT post FROM akn_temp_table);
DELETE FROM wp_comments WHERE comment_post_id IN (SELECT post FROM akn_temp_table);
DELETE FROM wp_commentmeta WHERE comment_id NOT IN (SELECT comment_ID FROM wp_comments);