# Pastebin 5iHT6O4j 21567 $DBversion = '19.12.00.067'; 21568 if( CheckVersion( $DBversion ) ) { 21569 # From: https://stackoverflow.com/questions/3311903/remove-duplicate-rows-in-mysql 21570 $dbh->do(q| 21571 DELETE a 21572 FROM virtualshelfshares as a, virtualshelfshares as b 21573 WHERE 21574 a.id < b.id 21575 AND 21576 a.borrowernumber IS NOT NULL 21577 AND 21578 a.borrowernumber=b.borrowernumber 21579 AND 21580 a.shelfnumber=b.shelfnumber 21581 |); 21582 21583 NewVersion( $DBversion, 20754, "Remove double accepted list shares" ); 21584 }