DELETE FROM wikis_details
WHERE wiki_id in
(SELECT wiki_id
FROM wikis_details
GROUP BY wiki_id
HAVING count(wiki_id)>1)