Subversion Repositories eFlore/Applications.coel

Rev

Rev 962 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 962 Rev 984
Line 363... Line 363...
363 
INSERT INTO tb_coel.coel_collection_a_commentaire
 363 
INSERT INTO tb_coel.coel_collection_a_commentaire
364 
	(ccac_id_collection, ccac_id_commentaire,
364 
	(ccac_id_collection, ccac_id_commentaire,
365 
	ccac_truk_type,
365 
	ccac_truk_type,
366 
	ccac_ce_meta)
 366 
	ccac_ce_meta)
367 
	SELECT hi.ID_INDIC, ID,
367 
	SELECT hi.ID_INDIC, ID,
368 
		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,
 368 
		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,
369 
		@idm := @idm+1
369 
		@idm := @idm+1
370 
	FROM tb_herbiers.HERBIERS_INDIC AS hi LEFT JOIN tb_herbiers.HERBIERS_A_UN_TYPE AS haut ON (hi.ID_INDIC = haut.ID_INDIC)
 370 
	FROM tb_herbiers.HERBIERS_INDIC AS hi LEFT JOIN tb_herbiers.HERBIERS_A_UN_TYPE AS haut ON (hi.ID_INDIC = haut.ID_INDIC)
371 
	WHERE ID IN (SELECT ccm_id_commentaire FROM tb_coel.coel_commentaire)
 371 
	WHERE ID IN (SELECT ccm_id_commentaire FROM tb_coel.coel_commentaire)
372 
	GROUP BY hi.ID_INDIC
372 
	GROUP BY hi.ID_INDIC
373 
	ORDER BY hi.ID_INDIC ASC;
 373 
	ORDER BY hi.ID_INDIC ASC;