| /trunk/doc/bdd/migration_bdd_herbiers_vers_coel.sql |
|---|
| 365,7 → 365,7 |
| ccac_truk_type, |
| ccac_ce_meta) |
| SELECT hi.ID_INDIC, ID, |
| CAST(GROUP_CONCAT(DISTINCT CASE ID_TYPE WHEN '1' THEN '2368' WHEN '2' THEN '2369' WHEN '3' THEN '2370' WHEN '4' THEN '2371' WHEN '5' THEN '2372' WHEN '6' THEN '2373' ELSE NULL END SEPARATOR ";") AS CHAR) AS TYPE, |
| CAST(GROUP_CONCAT(DISTINCT CASE ID_TYPE WHEN '1' THEN '2368' WHEN '2' THEN '2369' WHEN '3' THEN '2370' WHEN '4' THEN '2371' WHEN '5' THEN '2372' WHEN '6' THEN '2373' ELSE NULL END SEPARATOR ";;") AS CHAR) AS TYPE, |
| @idm := @idm+1 |
| FROM tb_herbiers.HERBIERS_INDIC AS hi LEFT JOIN tb_herbiers.HERBIERS_A_UN_TYPE AS haut ON (hi.ID_INDIC = haut.ID_INDIC) |
| WHERE ID IN (SELECT ccm_id_commentaire FROM tb_coel.coel_commentaire) |