133.723 rows total and i wanna keep 77.646

i wanna delete the custom amount according to the query u see above but i tried to run a count for the remaining rows it also take a lot to do :S

i am really confused on the best solution for this...

please help me how ever you can

my main problem is i got 10 tables with 133k from what i wanna keep 77k from each so this will take ages unless i find a solution or u guys tell me one