관리-도구

편집 파일: TopDownloadsUploads_upload.sql

SELECT t.session_rid as "session_rid", t.rid as "transfer_rid", cast(avg(speed) as bigint) as "averageSpeed", path as "path", file_name as "name", url as "url", cast(transfer_size as bigint) as "size" FROM transfers t, sessions s where s.rid = t.session_rid and DIRECTION = ? and t.start_time >= ? and t.start_time <= ? /*START_USERNAMES*/and user_name in (%usernames%)/*END_USERNAMES*/ group by t.session_rid, t.rid, path,file_name,url,transfer_size order by 1 desc limit ?