jungle52
2005-08-06, 05:34
is it possible to sort the actors view by the number of movies they are in?
using sqlite, i can check this with the sql statement:
select stractor, count (*) as "movies"
from actorlinkmovie join actors on actorlinkmovie.idactor=actors.idactor
group by stractor
order by "movies" desc
but i'd like to be able to do this within xbmc.
using sqlite, i can check this with the sql statement:
select stractor, count (*) as "movies"
from actorlinkmovie join actors on actorlinkmovie.idactor=actors.idactor
group by stractor
order by "movies" desc
but i'd like to be able to do this within xbmc.