HOW-TO:Share libraries using MySQL: Wiki Edition
sql:
2019-10-22 22:46:02.196 T:123145339019264 DEBUG: RunQuery took 585 ms for 1 items query: SELECT * FROM tvshow_view WHERE watchedCount != 0 AND totalCount != watchedCount ORDER BY c00
2019-10-22 22:46:02.574 T:123145339019264 DEBUG: RunQuery took 137 ms for 6 items query: SELECT * FROM tvshow_view WHERE ((tvshow_view.watchedcount = 0)) AND ((tvshow_view.totalCount > 0))
2019-10-22 22:46:02.767 T:123145342238720 DEBUG: RunQuery took 188 ms for 99 items query: select * from episode_view WHERE ((episode_view.dateAdded > '2012-01-01')) AND ((episode_view.playCount IS NULL OR episode_view.playCount < 1
2019-10-22 22:46:12.237 T:123145347604480 DEBUG: RunQuery took 73 ms for 7 items query: SELECT * FROM tvshow_view WHERE totalCount IS NOT NULL AND totalCount > 0
There is some content in the tvshow section, but it isn't much.
Did you change the filter on the TV show listing to Unwatched or Watched, instead of All ?
Reply


Messages In This Thread
RE: HOW-TO:Share libraries using MySQL: Wiki Edition - by Klojum - 2019-10-23, 07:25
Logout Mark Read Team Forum Stats Members Help
HOW-TO:Share libraries using MySQL: Wiki Edition2