models/disappear.go
@@ -109,8 +109,7 @@ snapshot_count_summary AS s JOIN person AS p ON p.id = s.document_number WHERE s.STATUS = 'resident' AND p.id_card != "" p.id_card != "" AND TIMESTAMPDIFF( YEAR, STR_TO_DATE( CASE WHEN LENGTH( id_card ) = 18 THEN SUBSTRING( id_card, 7, 8 ) ELSE NULL END, '%Y%m%d' ),
