Code: Select all
delete from downloads where id not in (select max(id) from downloads group by downloadlink)Code: Select all
#1093 - You can't specify target table 'downloads' for update in FROM clauseModerator: General Moderators
Code: Select all
delete from downloads where id not in (select max(id) from downloads group by downloadlink)Code: Select all
#1093 - You can't specify target table 'downloads' for update in FROM clause