| vmcTilePawPrints table with only good tile detections only and defaults | 
|  This view removes matches where there are pawprint detections but not a tile detection  | 
  
SELECT *
FROM vmcTilePawPrints
WHERE tlSeqNum>0
UNION
SELECT *
FROM vmcTilePawPrints
WHERE tileSetSeqNum<0
The details of the table defined by this view are available here.