{"version":"1.0","provider_name":"","provider_url":"https:\/\/magali-colas.fr\/astuces-wordpress","author_name":"Lyanna","author_url":"https:\/\/magali-colas.fr\/astuces-wordpress\/author\/jesuisadmin\/","title":"Comment all\u00e9ger et optimiser sa base de donn\u00e9es WordPress ?","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"PCTG2XwDqv\"><a href=\"https:\/\/magali-colas.fr\/astuces-wordpress\/optimiser-bdd-wordpress\/\">Comment all\u00e9ger et optimiser sa base de donn\u00e9es WordPress&nbsp;?<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/magali-colas.fr\/astuces-wordpress\/optimiser-bdd-wordpress\/embed\/#?secret=PCTG2XwDqv\" width=\"600\" height=\"338\" title=\"\u00ab\u00a0Comment all\u00e9ger et optimiser sa base de donn\u00e9es WordPress&nbsp;?\u00a0\u00bb &#8212; \" data-secret=\"PCTG2XwDqv\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" class=\"wp-embedded-content\"><\/iframe><script type=\"text\/javascript\">\n\/* <![CDATA[ *\/\n\/*! This file is auto-generated *\/\n!function(d,l){\"use strict\";l.querySelector&&d.addEventListener&&\"undefined\"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!\/[^a-zA-Z0-9]\/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret=\"'+t.secret+'\"]'),o=l.querySelectorAll('blockquote[data-secret=\"'+t.secret+'\"]'),c=new RegExp(\"^https?:$\",\"i\"),i=0;i<o.length;i++)o[i].style.display=\"none\";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute(\"style\"),\"height\"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):\"link\"===t.message&&(r=new URL(s.getAttribute(\"src\")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener(\"message\",d.wp.receiveEmbedMessage,!1),l.addEventListener(\"DOMContentLoaded\",function(){for(var e,t,s=l.querySelectorAll(\"iframe.wp-embedded-content\"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute(\"data-secret\"))||(t=Math.random().toString(36).substring(2,12),e.src+=\"#?secret=\"+t,e.setAttribute(\"data-secret\",t)),e.contentWindow.postMessage({message:\"ready\",secret:t},\"*\")},!1)))}(window,document);\n\/\/# sourceURL=https:\/\/magali-colas.fr\/astuces-wordpress\/wp-includes\/js\/wp-embed.min.js\n\/* ]]> *\/\n<\/script>\n","thumbnail_url":"https:\/\/magali-colas.fr\/astuces-wordpress\/wp-content\/uploads\/2020\/09\/requete_sql.jpg","thumbnail_width":960,"thumbnail_height":525,"description":"Supprimer les r\u00e9visions de post DELETE FROM wp_posts WHERE post_type = \"revision\"; Supprimer les commentaires spam DELETE FROM wp_comments WHERE comment_approved = '0'; Supprimer les posts en corbeille Voici la requ\u00eate SQL qui permet de supprimer les articles pr\u00e9sents en corbeille. Vous pouvez modifier la requ\u00eate en fonction des status (brouillon etc). DELETE FROM wp_posts [&hellip;]"}