SELECT files.uid, files.path, files.modified, files.size
FROM files
LEFT OUTER JOIN downloads ON files.uid = downloads.fileid
WHERE downloads.userid =1
LIMIT 0 , 3000;