Reply to thread

Message

<blockquote data-quote="Lehmden" data-source="post: 1123470" data-attributes="member: 109222">Hi.I've easily done both in MP2-Edit with a SQL Query, but I'm not sure if this is possible in a MP2 Skin...Here is the query I'm using for Seasons:&nbsp;'SELECT SEASON FROM M_SERIESITEM WHERE SERIESNAME = &quot;SeriesName&quot; ;' (You can also use TVDB-ID instead of SeriesName, but at the Time I do this query it's possible that some episodes did not have propper filled TVDB-ID filed. DId not know if this is fixed by the patch Realkane has done to the series MDE lately, as I didn't noticed this issue after applying the fix.Then you need to make the result unique as it will deliver an season entry for every episode in the DB. Playcount is a bit more tricky as you need to &quot;INNER JOIN&quot; tables for this query.'SELECT PLAYCOUNT FROM M_MEDIAITEM INNER JOIN M_SERIESITEM ON M_MEDIAITEM.MEDIA_ITEM_ID = M_SERIESITEM.MEDIA_ITEM_ID Where M_SERIESITEM.SERIESNAME = &quot;SeriesName&quot; ;'Did not know if this helps.</blockquote>

[QUOTE="Lehmden, post: 1123470, member: 109222"] Hi. I've easily done both in MP2-Edit with a SQL Query, but I'm not sure if this is possible in a MP2 Skin... Here is the query I'm using for Seasons: 'SELECT SEASON FROM M_SERIESITEM WHERE SERIESNAME = "SeriesName" ;' (You can also use TVDB-ID instead of SeriesName, but at the Time I do this query it's possible that some episodes did not have propper filled TVDB-ID filed. DId not know if this is fixed by the patch Realkane has done to the series MDE lately, as I didn't noticed this issue after applying the fix. Then you need to make the result unique as it will deliver an season entry for every episode in the DB. Playcount is a bit more tricky as you need to "INNER JOIN" tables for this query. 'SELECT PLAYCOUNT FROM M_MEDIAITEM INNER JOIN M_SERIESITEM ON M_MEDIAITEM.MEDIA_ITEM_ID = M_SERIESITEM.MEDIA_ITEM_ID Where M_SERIESITEM.SERIESNAME = "SeriesName" ;' Did not know if this helps. [/QUOTE]

Verification