".htmlentities($msg["nettoyage_clean_relations_cat"], ENT_QUOTES, $charset)."
";
pmb_mysql_query("delete from notices_custom_values where notices_custom_champ not in (select idchamp from notices_custom)");
$affected = pmb_mysql_affected_rows();
pmb_mysql_query("delete from expl_custom_values where expl_custom_champ not in (select idchamp from expl_custom)");
$affected += pmb_mysql_affected_rows();
pmb_mysql_query("DELETE empr_custom_values FROM empr_custom_values LEFT JOIN empr ON id_empr=empr_custom_origine WHERE id_empr IS NULL ");
$affected += pmb_mysql_affected_rows();
pmb_mysql_query("delete from empr_custom_values where empr_custom_champ not in (select idchamp from empr_custom)");
$affected += pmb_mysql_affected_rows();
pmb_mysql_query("delete from notices_custom_dates where notices_custom_champ not in (select idchamp from notices_custom)");
$affected += pmb_mysql_affected_rows();
pmb_mysql_query("delete from expl_custom_dates where expl_custom_champ not in (select idchamp from expl_custom)");
$affected += pmb_mysql_affected_rows();
pmb_mysql_query("DELETE empr_custom_dates FROM empr_custom_dates LEFT JOIN empr ON id_empr=empr_custom_origine WHERE id_empr IS NULL ");
$affected += pmb_mysql_affected_rows();
pmb_mysql_query("delete from empr_custom_dates where empr_custom_champ not in (select idchamp from empr_custom)");
$affected += pmb_mysql_affected_rows();
pmb_mysql_query("DELETE from tu_custom_values where tu_custom_origine not in (select tu_id from titres_uniformes)");
$affected += pmb_mysql_affected_rows();
pmb_mysql_query("DELETE from author_custom_values where author_custom_origine not in (select author_id from authors)");
$affected += pmb_mysql_affected_rows();
pmb_mysql_query("DELETE from categ_custom_values where categ_custom_origine not in (select id_noeud from noeuds)");
$affected += pmb_mysql_affected_rows();
pmb_mysql_query("DELETE from collection_custom_values where collection_custom_origine not in (select collection_id from collections)");
$affected += pmb_mysql_affected_rows();
pmb_mysql_query("DELETE from indexint_custom_values where indexint_custom_origine not in (select indexint_id from indexint)");
$affected += pmb_mysql_affected_rows();
pmb_mysql_query("DELETE from publisher_custom_values where publisher_custom_origine not in (select ed_id from publishers)");
$affected += pmb_mysql_affected_rows();
pmb_mysql_query("DELETE from serie_custom_values where serie_custom_origine not in (select serie_id from series)");
$affected += pmb_mysql_affected_rows();
pmb_mysql_query("DELETE from subcollection_custom_values where subcollection_custom_origine not in (select sub_coll_id from sub_collections)");
$affected += pmb_mysql_affected_rows();
pmb_mysql_query("DELETE from skos_custom_values where skos_custom_origine not in (select uri_id from onto_uri)");
$affected += pmb_mysql_affected_rows();
pmb_mysql_query("DELETE from tu_custom_dates where tu_custom_origine not in (select tu_id from titres_uniformes)");
$affected += pmb_mysql_affected_rows();
pmb_mysql_query("DELETE from author_custom_dates where author_custom_origine not in (select author_id from authors)");
$affected += pmb_mysql_affected_rows();
pmb_mysql_query("DELETE from categ_custom_dates where categ_custom_origine not in (select id_noeud from noeuds)");
$affected += pmb_mysql_affected_rows();
pmb_mysql_query("DELETE from collection_custom_dates where collection_custom_origine not in (select collection_id from collections)");
$affected += pmb_mysql_affected_rows();
pmb_mysql_query("DELETE from indexint_custom_dates where indexint_custom_origine not in (select indexint_id from indexint)");
$affected += pmb_mysql_affected_rows();
pmb_mysql_query("DELETE from publisher_custom_dates where publisher_custom_origine not in (select ed_id from publishers)");
$affected += pmb_mysql_affected_rows();
pmb_mysql_query("DELETE from serie_custom_dates where serie_custom_origine not in (select serie_id from series)");
$affected += pmb_mysql_affected_rows();
pmb_mysql_query("DELETE from subcollection_custom_dates where subcollection_custom_origine not in (select sub_coll_id from sub_collections)");
$affected += pmb_mysql_affected_rows();
pmb_mysql_query("DELETE from skos_custom_dates where skos_custom_origine not in (select uri_id from onto_uri)");
$affected += pmb_mysql_affected_rows();
pmb_mysql_query("delete cms_articles_descriptors from cms_articles_descriptors left join noeuds on num_noeud=id_noeud where id_noeud is null");
$affected += pmb_mysql_affected_rows();
pmb_mysql_query("delete cms_sections_descriptors from cms_sections_descriptors left join noeuds on num_noeud=id_noeud where id_noeud is null");
$affected += pmb_mysql_affected_rows();
$v_state .= "
![](".get_url_icon()
".htmlentities($msg["nettoyage_suppr_relations"], ENT_QUOTES, $charset)." : ";
$v_state .= $affected." ".htmlentities($msg["nettoyage_res_suppr_relations_cat"], ENT_QUOTES, $charset);
// mise à jour de l'affichage de la jauge
print netbase::get_display_final_progress();
print netbase::get_process_state_form($v_state, $spec, '', '3');