[thaJack]

Hoping someone can help me with a query...

My XBMC setup uses MySQL for its database backend. I'm looking to write a query that will give me a list of television shows in which all episodes have been marked as watched.

Anyone know MySQL enough to help? Thanks in advance!

[thaJack]

I was able to solve it with the following query:

Code:

SELECT DISTINCT myvideos75.episodeview.strTitle
  FROM myvideos75.episodeview
WHERE myvideos75.episodeview.strTitle NOT IN
      (SELECT myvideos75.episodeview.strTitle
         FROM myvideos75.episodeview
        WHERE myvideos75.episodeview.playCount IS NULL
      )
ORDER BY strTitle ASC
;
[/code]