clean revisions

clean-revisions.sql

DELETE field_revision_body
FROM field_revision_body

LEFT JOIN field_data_body
ON field_data_body.revision_id = field_revision_body.revision_id

WHERE field_data_body.entity_id IS NULL;

-- optimize:
OPTIMIZE TABLE field_revision_body;


-- overview:

SELECT 
field_data_body.entity_id AS data_id,
field_data_body.revision_id AS data_vid,
field_revision_body.entity_id AS revision_id,
field_revision_body.revision_id AS revision_vid

FROM field_revision_body

LEFT JOIN field_data_body
ON field_data_body.revision_id = field_revision_body.revision_id

WHERE field_data_body.entity_id IS NULL;