Turmas em turmas_moodle sendo duplicados
Em homologação,
select * from turmas_moodle where codmoodle like '4300160%' limit 20;
+-------+-------------------+---------+------------+------------+------+
| id | codmoodle | codpes | dataini | datafim | tipo |
+-------+-------------------+---------+------------+------------+------+
| 1253 | 4300160.2.2024101 | 3298395 | 2024-02-26 | 2024-07-02 | GR |
| 15551 | 4300160.2.2024101 | 0 | 2024-02-26 | 2024-07-02 | GR |
| 1254 | 4300160.2.2024102 | 3298395 | 2024-02-26 | 2024-07-02 | GR |
| 15552 | 4300160.2.2024102 | 0 | 2024-02-26 | 2024-07-02 | GR |
| 1255 | 4300160.2.2024142 | 155469 | 2024-02-26 | 2024-07-02 | GR |
| 15553 | 4300160.2.2024142 | 0 | 2024-02-26 | 2024-07-02 | GR |
| 1256 | 4300160.2.2024147 | 155469 | 2024-02-26 | 2024-07-02 | GR |
| 15554 | 4300160.2.2024147 | 0 | 2024-02-26 | 2024-07-02 | GR |
| 1257 | 4300160.2.2024148 | 155469 | 2024-02-26 | 2024-07-02 | GR |
| 15555 | 4300160.2.2024148 | 0 | 2024-02-26 | 2024-07-02 | GR |
+-------+-------------------+---------+------------+------------+------+
Temos que descobrir donde vem esses linhas com codpes = 0. O query está correto? Problema no código?