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; |