ajkis

/mnt/cloud/movies/#ALONE (2020)
/mnt/cloud/movies/#IMomSoHard Live (2019)
/mnt/cloud/movies/#realityhigh (2017)
/mnt/cloud/movies/'71 (2014)
/mnt/cloud/movies/'Til Death Do Us Part (2017)
/mnt/cloud/movies/(500) Days of Summer (2009)
/mnt/cloud/movies/(R)Evolutie (2021)
/mnt/cloud/movies/1 Mile To You (2017)
/mnt/cloud/movies/1 Night (2017)
/mnt/cloud/movies/1% (2017)

ajkis

#!/bin/bash
RadarrDB="/home/plex/.config/Radarr/nzbdrone.db"
Url="http://XXX.XXX.XXX.XXX:7878"
ApiKey="XXXX"

Counter=0
readarray -t MOVIES < <(sqlite3 "$RadarrDB" "SELECT id from Movies WHERE MovieFileId NOT IN (SELECT id FROM MovieFiles)")

echo "Deleting missing Movies where Year is older then X"
for movieid in "${MOVIES[@]}"