If you wanted to omit mounted disk images you could amend the first temp table query to

JOIN

on

block_devices

and not include any results where

label = 'disk image'