Lots of CDs have silent tracks and lots of them are one of a short list of lengths (sample counts)
How should the WHERE's be amended to exclude those in a [given list of sample counts]?
I don't think you have access to sample counts but you do have access to attributes like length_seconds, bitrate and filesize so you could use a combination of those, but the best way I've found to identify silent tracks is to look for missing replaygain_track_gain (assuming you calculate that of course).
select path,
album,
"album artist",
artist,
title,
md5,
length_seconds,
bitrate,
filesize,
replaygain_track_peak,
replaygain_track_gain
from Playlist
where playlist_index = active_playlist()
and replaygain_track_gain is null
If you wanted to exclude these from the dedupe process just change the where clause to:
WHERE md5 is not null and replaygain_track_gain is not null