Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DELETE FROM ttrss_entries
- WHERE id IN
- (
- WITH
- req_titles AS
- (
- SELECT
- id,
- MD5(title) md5title
- FROM
- ttrss_entries
- ),
- req_doublons AS
- (
- SELECT md5title,MIN(ID) minid FROM req_titles
- GROUP BY md5title
- HAVING COUNT(md5title)>1
- )
- SELECT id FROM req_titles
- WHERE md5title IN
- (
- SELECT md5title FROM req_doublons
- )
- EXCEPT
- SELECT minid FROM req_doublons
- );
Add Comment
Please, Sign In to add comment