اين كوئري رو زدم جواب داد 


DELETE dle_tags.* FROM dle_tags

JOIN (

    SELECT tag FROM dle_tags GROUP BY tag HAVING COUNT(tag) = 1

) AS subq USING (tag)