Series double in MySQL database

Dear all,

At first, I’m sorry if this is posted in the wrong thread…
Second, I LOVE Kodi/XMBC, been using it for a little over 5 years now!

But, due to my own stupidity, I ran into a problem.
First some small infra-topology:
– cheapo nas (Hostname: NSA325, ip 192.168.0.191) – MySQL server + hosts all my video’s
– HTPC (Win10 + Kodi17)

I moved not that long ago, and broke my HTPC on the way to my new house.
Reinstalled it, installed Kodi onthere, copied over my advancedsettings.xml BUT I FORGOT MY SOURCES.XML :'( :'(
So had to add them manually.
I used to be setup as “smb://NSA325/Series/”, but due to not paying enough attention, I added “smb://192.168.0.191/Series”

=> result, some of my series got scanned a second time, and written to the MySQL database a second time…
Very annoying, as every episode is listed twice, once with the correct path, once with the incorrect path

I know the basics of SQL commands, relations etc etc etc, but my knowledge does not go far enough to correctly fix my own mistake..

So I would like to ask some help from you guys. What would be the correct approach to drop the duplicate?

Thanks A LOT!

Screenshots that might explain better what I’m experiencing: