ignore placeholder deputies (#36632)

This commit is contained in:
Frédéric Péters 2019-10-03 16:00:27 +02:00
parent 4ddb26f6de
commit 82629738eb
1 changed files with 1 additions and 0 deletions

View File

@ -508,6 +508,7 @@ class SyncFromPcfDbView(BrowserView):
FROM t_pers, t_pershistoline, t_comppol, t_parl, t_arrond
WHERE t_pers.st = 'S_PARL' and
t_pers.prenom is not NULL and
t_pers.nom is not like '%% N %%' and
t_pers.id = t_pershistoline.pers and
t_pershistoline.description = t_comppol.id and
t_pershistoline.type = 'P_CMPL' and