SQL Query to remove uncategorised category from categorised articles

remove-uncategorised-from-categorised-posts.sql

DELETE
FROM `{PREFIX}_term_relationships`
WHERE `term_taxonomy_id` = 1 AND `object_id` IN
( SELECT * FROM 
(
SELECT object_id
FROM `{PREFIX}_term_relationships`
WHERE `term_taxonomy_id`
IN ( SELECT `term_taxonomy_id`
FROM `{PREFIX}_term_taxonomy`
WHERE `taxonomy` = 'category' )
GROUP BY `object_id`
HAVING ( COUNT( `object_id` ) > 1 )
)
AS X
)