Find duplicate episodes in Kodi database

query.sql

select
	tvshow.c00 show,
	episode.c12 s,
	episode.c13 e,
	episode.c00 title,
	count(*) num,
	group_concat(path.strPath || files.strFilename) locations
from files
join episode on episode.idFile = files.idFile
join path on files.idPath = path.idPath
join tvshow on episode.idShow = tvshow.idShow
group by episode.idShow, s, e having num > 1;