- Moderator
- #1
Property shows the number of episodes in the series, season. But not those that have a local library and all. To be able to display: Episodes: 10 / 20. That is, 10 is in the local library, of the planned 20.
ie: 10 - Count of Local Episodes (local_episodes table), 20 - Count of Online Episodes (online_episodes table)
Like:
For 3 season of 259948 series - result 2 / 10
ie: 10 - Count of Local Episodes (local_episodes table), 20 - Count of Online Episodes (online_episodes table)
Like:
SQL:
select distinct seasonindex, count(episodeindex) from local_episodes where seriesid = 259948 group by seasonindex
Code:
SeasonIndex count(episodeindex)
2 10
3 2
SQL:
select distinct seasonindex, count(episodeindex) from online_episodes where seriesid = 259948 group by seasonindex
Code:
SeasonIndex count(episodeindex)
1 13
2 10
3 10