if you have simple SQL knowledge you can go to db.view and use this query
Code: Select all
SELECT * from statistic_user, media_file where statistic_user.media_file_id = media_file.id and username = 'admin'
Code: Select all
SELECT * from statistic_user, media_file where statistic_user.media_file_id = media_file.id and username = 'guest' and played < '2013-03-13 01:25'
best regards