Форумы / National / Russian / Тех. поддержка / Как удалить теги?

DELETE sed_tag_references FROM sed_tag_references LEFT JOIN sed_pages ON sed_tag_references.tag_item = sed_pages.page_id WHERE sed_tag_references.tag_area = 'pages' AND sed_pages.page_id IS NULL;

DELETE FROM sed_tags WHERE 0 = (SELECT COUNT(*) FROM sed_tag_references WHERE sed_tag_references.tag = sed_tags.tag);