| Line 299... |
Line 299... |
| 299 |
ccac_truk_type,
|
299 |
ccac_truk_type,
|
| 300 |
ccac_ce_meta)
|
300 |
ccac_ce_meta)
|
| 301 |
SELECT hi.ID_INDIC, ID,
|
301 |
SELECT hi.ID_INDIC, ID,
|
| 302 |
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,
|
302 |
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,
|
| 303 |
@idm := @idm+1
|
303 |
@idm := @idm+1
|
| 304 |
FROM tb_herbiers.HERBIERS_INDIC AS hi LEFT JOIN tb_herbiers.HERBIERS_A_UN_TYPE AS haut ON (hi.ID_INDIC = haut.ID_INDIC)
|
304 |
FROM tb_herbiers.HERBIERS_INDIC AS hi LEFT JOIN tb_herbiers.HERBIERS_A_UN_TYPE AS haut ON (hi.ID_INDIC = haut.ID_INDIC)
|
| - |
|
305 |
WHERE ID IN (SELECT ccm_id_commentaire FROM tb_coel.coel_commentaire)
|
| 305 |
GROUP BY hi.ID_INDIC
|
306 |
GROUP BY hi.ID_INDIC
|
| 306 |
ORDER BY hi.ID_INDIC ASC;
|
307 |
ORDER BY hi.ID_INDIC ASC;
|
| 307 |
INSERT INTO tb_coel.coel_meta_historique_ligne
|
308 |
INSERT INTO tb_coel.coel_meta_historique_ligne
|
| 308 |
(cmhl_id_historique_ligne, cmhl_ce_table, cmhl_cle_ligne, cmhl_enregistrement,
|
309 |
(cmhl_id_historique_ligne, cmhl_ce_table, cmhl_cle_ligne, cmhl_enregistrement,
|
| 309 |
cmhl_date_modification, cmhl_notes, cmhl_ce_modifier_par, cmhl_ce_etat, cmhl_ip)
|
310 |
cmhl_date_modification, cmhl_notes, cmhl_ce_modifier_par, cmhl_ce_etat, cmhl_ip)
|
| 310 |
SELECT @idm_tmp := @idm_tmp+1, '102', hi.ID_INDIC, NULL,
|
311 |
SELECT @idm_tmp := @idm_tmp+1, '102', hi.ID_INDIC, NULL,
|
| 311 |
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')
|
312 |
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')
|
| 312 |
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)
|
313 |
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)
|
| - |
|
314 |
WHERE ID IN (SELECT ccm_id_commentaire FROM tb_coel.coel_commentaire)
|
| 313 |
GROUP BY hi.ID_INDIC
|
315 |
GROUP BY hi.ID_INDIC
|
| 314 |
ORDER BY hi.ID_INDIC ASC;
|
316 |
ORDER BY hi.ID_INDIC ASC;
|
| Line 315... |
Line 317... |
| 315 |
|
317 |
|
| 316 |
#------------------------------------------------------------------------------------------------------------------------
|
318 |
#------------------------------------------------------------------------------------------------------------------------
|