Advertisement
Guest User

Find epsiodes dupes in Kodi17

a guest
May 4th, 2017
311
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.25 KB | None | 0 0
  1. SELECT y.idShow,y.c12,y.c13,
  2.  y.strFileName
  3. FROM episode_view Y
  4. INNER JOIN (
  5. SELECT
  6.  c12,c13,idShow, COUNT(*) AS CountOf
  7. FROM episode_view
  8. GROUP BY idShow,c12,c13
  9. HAVING COUNT(*)>1
  10. ) dt ON y.c12=dt.c12 AND y.c13=dt.c13 AND y.idShow=dt.idShow;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement