Таблица _assets - Joomla 3.x: Общие вопросы

SELECT *
FROM jos_content
WHERE `id` = '16989'

DELETE 
FROM jos_contentitem_tag_map
WHERE `type_alias` = 'com_content.article' AND `content_item_id` = 16989

SELECT `core_content_id`
FROM `jos_ucm_content`
WHERE `core_content_item_id` = 1 AND `core_type_alias` = 'com_content.article'

SELECT `type_id`
FROM `jos_content_types`
WHERE `type_alias` = 'com_content.article'

DELETE 
FROM `jos_ucm_history`
WHERE `ucm_item_id` = 16989 AND `ucm_type_id` = 1

SELECT `id`
FROM `jos_assets`
WHERE `name` = 'com_content.article.16989'

SELECT *
FROM jos_assets
WHERE `id` = '17569'

LOCK TABLES `jos_assets` WRITE

SELECT id, parent_id, level, lft, rgt
FROM jos_assets
WHERE id = 17569 LIMIT 1

DELETE 
FROM jos_assets
WHERE lft BETWEEN 30127 AND 30128

UPDATE jos_assets
SET lft = lft - 2
WHERE lft > 30128

UPDATE jos_assets
SET rgt = rgt - 2
WHERE rgt > 30128

UNLOCK TABLES

DELETE 
FROM jos_content
WHERE `id` = '16989'

SELECT id FROM jos_jcomments 
 WHERE object_group = 'com_content'
 AND object_id IN (0)

DELETE FROM jos_jcomments_objects  WHERE object_group = 'com_content' AND object_id = '0'

DELETE 
FROM `jos_jcomments_subscriptions`
WHERE `object_id` = 16989 AND `object_group` = 'com_content'