-- @query thumbnails_count_default
-- @db media 11.0
SELECT COUNT(*) AS cnt FROM media_properties
WHERE takenDateTime IS NOT NULL AND takenDateTime != ''
  AND isTombstoned = 0
