Query to remove orphaned taxonomy terms from a WordPress DB

gistfile1.sql

-- Replace %s with table prefix
DELETE tr 
FROM %s_term_relationships tr 
INNER JOIN %s_term_taxonomy tt 
ON (tr.term_taxonomy_id = tt.term_taxonomy_id) 
WHERE tt.taxonomy != 'link_category' 
AND tr.object_id NOT IN (SELECT ID FROM %s_posts);