A few lines of SQL I used to clean up a Scriblio site. It’s probably useless to anybody but me. I’m not suggesting anybody else use this code, as it will result in changed or deleted data.
Update the post author for catalog records (identified because they have a specific post meta entry):
UPDATE wp_8_postmeta JOIN wp_8_posts ON wp_8_posts.ID = wp_8_postmeta.post_id SET post_author = 15 WHERE meta_key = 'scrib_meditor_content'
Get the categories attached to every catalog record (except the “catalog” category):
SELECT tr.object_id , tr.term_taxonomy_id FROM wp_8_term_relationships tr JOIN wp_8_posts p ON p.ID = tr.object_id WHERE tr.term_taxonomy_id IN ( SELECT term_taxonomy_id FROM wp_8_term_taxonomy WHERE taxonomy = "category" AND term_id != 30 ) AND post_author = 15 ORDER BY tr.object_id , tr.term_taxonomy_id
Using the above list of object ids and term taxonomy ids, build a series of queries like the following to delete them:
DELETE FROM wp_8_term_relationships WHERE object_id = 12275 AND term_taxonomy_id = 271872 ;
Insert a catalog category relationship for all catalog records:
INSERT INTO wp_8_term_relationships SELECT p.ID , '271871' , '0' FROM wp_8_posts p LEFT JOIN wp_8_term_relationships tr ON p.ID = tr.object_id AND tr.term_taxonomy_id = 271871 WHERE post_author = 15 AND tr.term_taxonomy_id IS NULL