[Solidify]

OK. But that suggestion (manually removing that movie from the set) was suggested at the beginning of this thread. I was asking if there is any development on this issue (i.e.: a way to have XMBC automatically remove the single films as collections/sets).

[Martijn]

OK. But that suggestion (manually removing that movie from the set) was suggested at the beginning of this thread. I was asking if there is any development on this issue (i.e.: a way to have XMBC automatically remove the single films as collections/sets).

no

[Solidify]

I there a way to create a smart playlist from scratch (as a sub menu to the movies menu) to do this?

[Ned Scott]

I don't believe so

[flskydiver]

Regarding Expert Option to "Hide movie sets with only one title in library from Sets List", i.e. If a movie is scraped to be part of a set but it is the sole representative of that set in a user's library ... DO NOT display the movie/set in the sets list. Or perhaps something like "restrict Sets list to movie sets having two or more titles in the current library" ...

+1 to this idea.

+(n+1)

+1

Aaand +1 More.

@uNiversal
the following SQL statement will remove all sets that have only one movie.

Code:

update movie set idset=null where idmovie in (select idmovie from (select count(*) as n,idmovie, idset from movie group by idset) where n=1)

Thanks dragonflight, that's exactly what i wanted although i had to add an alias to the derived table for it to run in HeidiSQL

Code:

update movie set idset=null where idmovie in (select idmovie from (select count(*) as n,idmovie, idset from movie group by idset) sub where n=1)

Where does one insert this code?