That query also was not written to avoid symlink loop issues caused by Time Machine backups and you would need to add their exclusion to the

NOT IN

statement of the

mounted_volumes

temp table output.