Kodi Community Forum

Kodi Community Forum > Support > General Support > OS independent / Other > MySQL Query
Full Version: MySQL Query
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

thaJack

2014-06-23, 19:54
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

2014-06-24, 19:04
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]
Kodi Community Forum > Support > General Support > OS independent / Other > MySQL Query