delete from {wp_abj404_lookup}
where lkup_value in (
    select * from (
	    SELECT DISTINCT lkup_value 
	    FROM {wp_abj404_lookup} 
	    group by lkup_value 
	    having count(lkup_value) > 1
    ) a
)