file

SELECT
f.filename,
f.path,
u.username AS file_owner,
g.groupname AS group_owner,
datetime(f.atime,'unixepoch') AS file_last_access_time,
datetime(f.mtime,'unixepoch') AS file_last_modified_time,
datetime(f.ctime,'unixepoch') AS file_last_status_change_time,
datetime(f.btime,'unixepoch') AS file_created_time,
ROUND((f.size * 10e-7),4) AS size_megabytes
FROM file f
LEFT JOIN users u ON f.uid = u.uid
LEFT JOIN groups g ON f.gid = g.gid
WHERE ((f.directory like "/home/%%/.local/share/JetBrains/%/")
 OR (f.directory like "C:\users\%\AppData\%\JetBrains\%\Plugins\") 
 OR (f.directory like "/Users/%/Library/Application Support/JetBrains/%/plugins/")) 
 AND (
     (filename not like "%.xml") AND (filename not like "%.json") AND
     (filename not like "%.etag")
 );