Something

SELECT files.uid, files.path, files.modified, files.sizeFROM filesLEFT OUTER JOIN downloads ON files.uid = downloads.fileidWHERE downloads.userid =1LIMIT 0 , 3000;