radarr-remove-all-wanted.sh

#!/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[@]}"
do
            Counter=$(($Counter +1 ))
            echo "Processing: $(sqlite3 "$RadarrDB" "SELECT id, title, Year from Movies WHERE id = '$movieid'")"
            curl {$Url}/api/movie/$movieid -X DELETE -H "X-Api-Key: $ApiKey"
done
echo "Processed $Counter movies"
exit

wrong echo
echo "Deleting missing Movies where Year is older then X"

right one
echo "Deleting all wanted & missing movies"