| 40,12 → 40,12 |
|---|
| d'où GROUP BY id_observation HAVING count(id_observation) = 1, |
| ce qui ne produit plus que 51359 matches (soit 22734 dups) */ |
| /* |
| SELECT id_observation, nom_referentiel, nom_sel, nom_sel_nn, nom_ret, nom_ret_nn, nt, c.famille |
| SELECT id_observation, valid_ref, nom_sel, nom, nom_sel_nn, nom_ret, nom_ret_nn, nt, c.famille |
| FROM `BASEEDIT`.`cel_obs` c |
| INNER JOIN T_bis b |
| ON (b.num_nom = c.nom_sel_nn) |
| WHERE nom_referentiel IS NULL AND nom_sel_nn IS NOT NULL GROUP BY id_observation HAVING count(id_observation) = 1; |
| -- 51359, tous bdtfx... |
| -- 63941, tous bdtfx... |
| */ |
| |
| |
| 74,3 → 74,5 |
|---|
| | |
| |
| delimiter ; |
| |
| CALL majreferentiel; |