OK, this is a little misleading as it will only work for images (i.e. not applicable for text files or pdf files) ~ if anyone can show me how to check for valid paths from sqlite, i would be stoked!
SELECT * FROM Multimediatable WHERE Thumbnail is null AND Mediafile like '%.jpg';