{"body":"21567 $DBversion = '19.12.00.067';\n21568 if( CheckVersion( $DBversion ) ) {\n21569     # From: https://stackoverflow.com/questions/3311903/remove-duplicate-rows-in-mysql\n21570     $dbh->do(q|\n21571         DELETE a\n21572         FROM virtualshelfshares as a, virtualshelfshares as b\n21573         WHERE\n21574           a.id < b.id \n21575         AND\n21576           a.borrowernumber IS NOT NULL\n21577         AND\n21578           a.borrowernumber=b.borrowernumber\n21579         AND\n21580           a.shelfnumber=b.shelfnumber\n21581     |);\n21582 \n21583     NewVersion( $DBversion, 20754, \"Remove double accepted list shares\" );\n21584 }\n","name":"","extension":"txt","url":"https://www.irccloud.com/pastebin/5iHT6O4j","modified":1638532589,"id":"5iHT6O4j","size":634,"lines":18,"own_paste":false,"theme":"","date":1638532589}