+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: General Support (https://forum.kodi.tv/forumdisplay.php?fid=111)
+---- Forum: OS independent / Other (https://forum.kodi.tv/forumdisplay.php?fid=228)
+---- Thread: Number of Movies are different in "Kodi GUI View" and "SQL select". (/showthread.php?tid=366297)
Number of Movies are different in "Kodi GUI View" and "SQL select". - kirbyzhou - 2022-01-03
In KODI GUI, I can see there are 872 movies in my collection.
But when I open the underly database, I can see 971 movies;
mysql> select count(*) from movie \G
*************************** 1. row ***************************
count(*): 981
1 row in set (0.00 sec)
Why they are different?
RE: Number of Movies are different in "Kodi GUI View" and "SQL select". - Karellen - 2022-01-03
Maybe you have Music Videos or Concerts that are displayed in the Music Videos tab, not the Movies tab.
RE: Number of Movies are different in "Kodi GUI View" and "SQL select". - Klojum - 2022-01-03
(2022-01-03, 04:07)kirbyzhou Wrote: Why they are different?
How many movie sets are there in your movie collection, assuming that display option is enabled.
That SQL query does not deal with movie sets, so it would display the total number of movies.
RE: Number of Movies are different in "Kodi GUI View" and "SQL select". - DaVu - 2022-01-03
(2022-01-03, 04:07)kirbyzhou Wrote: In KODI GUI, I can see there are 872 movies in my collection.
But when I open the underly database, I can see 971 movies;
Jepp...as @Klojum said. Most likely due to grouping movies in sets.