I’ve always thought unseen would make a great checkbox on the browse page (like TV-episodes, but make it ‘Unseen Only’) instead of a radio button.

 

That way, you can list out by New, Wishlist, ABC, etc.

 

Thoughts?

 


From: Jdrien Rag [mailto:jdrien@gmail.com]
Sent: Friday, May 22, 2009 1:01 PM
To: videodb-devel@lists.sourceforge.net
Subject: [videodb-devel] unseen movies

 

Hi,

Would it be possible to add a "unseen" box in the search menu? (as in
the explore menu)

What should I add to this to select only the unseen movies?
SELECT filename, filesize, diskid, rating
FROM videodb_videodata
ORDER BY rating

Thanks :-)

--
Félix


You can do this :
SELECT filename, filesize, diskid, rating
FROM videodb_videodata
WHERE id NOT IN
(
 SELECT video_id
 FROM videodb_userseen
)
ORDER BY rating