[_Andy_]

Hello

I have a question about the library stats. For testing purpose i use 2 different skins. The stats in the skins shows 182 tvshows and 12664 episodes.

If i go direct into the MySQL library and execute

Code:

SELECT count(idEpisode) FROM `myvideos89`.`episode`;

i get as result 12577 episodes.

Why the difference?
What i'm missing?

[k4sh1n]

Any duplicates:

Code:

select count(field1,field2)
from table
where the combination of field1, field2 occurs multiple times

Maybe do a clean library and re-SQL count

[_Andy_]

Hello.

Thx for your help but if duplicates are the problem i would expect more counts in the database than in the skin. The skins show more episodes that i have in the database.

That is what is bugging me.

I have some doubles because some Anime Spiderman shows are not recognized correct but i guess that would result in more counts in the database than in the skins.