Query DB for most recent vids added?

[mozztoff]

Is there a query that i can run from db.view that would basically give me say a list of the top 50 most recent vids I have added? I'm not looking for audio from the list, but rather just a list of any video format that has been added most recently? I appreciate any help

running 4.6 (build 2583) on win 08 r2

[hakko]

I'd say no, because 4.6 doesn't store file information in the db, it's kept in a (very inefficient) structure in memory that you can't really query. Should be possible in 4.7 though.

[mozztoff]

I'd say no, because 4.6 doesn't store file information in the db, it's kept in a (very inefficient) structure in memory that you can't really query. Should be possible in 4.7 though.

Thanks.. ill look into more in the next release