| 301,7 → 301,8 |
|---|
| 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, |
| @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) |
| 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) |
| GROUP BY hi.ID_INDIC |
| ORDER BY hi.ID_INDIC ASC; |
| INSERT INTO tb_coel.coel_meta_historique_ligne |
| 309,7 → 310,8 |
|---|
| cmhl_date_modification, cmhl_notes, cmhl_ce_modifier_par, cmhl_ce_etat, cmhl_ip) |
| SELECT @idm_tmp := @idm_tmp+1, '102', hi.ID_INDIC, NULL, |
| FROM_UNIXTIME(MAJ_INDIC) , CONCAT('Ajout des types du commentaire #',hi.ID_INDIC,' de la table HERBIERS_A_UN_TYPE.'), IF(ID_INDICATEUR != '0', ID_INDICATEUR, '1'), '1', IF(ID_INDICATEUR != '0', NULL, '162.38.234.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) LEFT JOIN tb_herbiers.HERBIERS_INDIC_HISTORIQUE AS hih ON (hi.ID_INDIC = hih.ID_INDIC) |
| FROM tb_herbiers.HERBIERS_INDIC AS hi LEFT JOIN tb_herbiers.HERBIERS_A_UN_TYPE AS haut ON (hi.ID_INDIC = haut.ID_INDIC) LEFT JOIN tb_herbiers.HERBIERS_INDIC_HISTORIQUE AS hih ON (hi.ID_INDIC = hih.ID_INDIC) |
| WHERE ID IN (SELECT ccm_id_commentaire FROM tb_coel.coel_commentaire) |
| GROUP BY hi.ID_INDIC |
| ORDER BY hi.ID_INDIC ASC; |
| |