select distinct concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH where BE_A_ACTIVE="1" AND CONCAT_ENVIRONNEMENT like "1 %" || CONCAT_ENVIRONNEMENT like "% 1" || CONCAT_ENVIRONNEMENT like "1" || CONCAT_ENVIRONNEMENT like "% 1 %" ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
0
select distinct concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH where BE_A_ACTIVE="1" AND CONCAT_ENVIRONNEMENT like "2 %" || CONCAT_ENVIRONNEMENT like "% 2" || CONCAT_ENVIRONNEMENT like "2" || CONCAT_ENVIRONNEMENT like "% 2 %" ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
0
select distinct concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH where BE_A_ACTIVE="1" AND CONCAT_ENVIRONNEMENT like "3 %" || CONCAT_ENVIRONNEMENT like "% 3" || CONCAT_ENVIRONNEMENT like "3" || CONCAT_ENVIRONNEMENT like "% 3 %" ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
0
select distinct concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH where BE_A_ACTIVE="1" AND CONCAT_ENVIRONNEMENT like "4 %" || CONCAT_ENVIRONNEMENT like "% 4" || CONCAT_ENVIRONNEMENT like "4" || CONCAT_ENVIRONNEMENT like "% 4 %" ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
0
select distinct concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH where BE_A_ACTIVE="1" AND CONCAT_ENVIRONNEMENT like "5 %" || CONCAT_ENVIRONNEMENT like "% 5" || CONCAT_ENVIRONNEMENT like "5" || CONCAT_ENVIRONNEMENT like "% 5 %" ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
0
select distinct concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH where BE_A_ACTIVE="1" AND CONCAT_ENVIRONNEMENT like "6 %" || CONCAT_ENVIRONNEMENT like "% 6" || CONCAT_ENVIRONNEMENT like "6" || CONCAT_ENVIRONNEMENT like "% 6 %" ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
0
select distinct concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH where BE_A_ACTIVE="1" AND CONCAT_ENVIRONNEMENT like "7 %" || CONCAT_ENVIRONNEMENT like "% 7" || CONCAT_ENVIRONNEMENT like "7" || CONCAT_ENVIRONNEMENT like "% 7 %" ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
0
select distinct concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH where BE_A_ACTIVE="1" AND CONCAT_ENVIRONNEMENT like "8 %" || CONCAT_ENVIRONNEMENT like "% 8" || CONCAT_ENVIRONNEMENT like "8" || CONCAT_ENVIRONNEMENT like "% 8 %" ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
0
select distinct concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH where BE_A_ACTIVE="1" AND CONCAT_ENVIRONNEMENT like "9 %" || CONCAT_ENVIRONNEMENT like "% 9" || CONCAT_ENVIRONNEMENT like "9" || CONCAT_ENVIRONNEMENT like "% 9 %" ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
0
select distinct concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH where BE_A_ACTIVE="1" AND CONCAT_ENVIRONNEMENT like "10 %" || CONCAT_ENVIRONNEMENT like "% 10" || CONCAT_ENVIRONNEMENT like "10" || CONCAT_ENVIRONNEMENT like "% 10 %" ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
0
select distinct concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH where BE_A_ACTIVE="1" AND CONCAT_ENVIRONNEMENT like "11 %" || CONCAT_ENVIRONNEMENT like "% 11" || CONCAT_ENVIRONNEMENT like "11" || CONCAT_ENVIRONNEMENT like "% 11 %" ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
0
select distinct concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH where BE_A_ACTIVE="1" AND CONCAT_ENVIRONNEMENT like "12 %" || CONCAT_ENVIRONNEMENT like "% 12" || CONCAT_ENVIRONNEMENT like "12" || CONCAT_ENVIRONNEMENT like "% 12 %" ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
0
select distinct concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH where BE_A_ACTIVE="1" AND CONCAT_ENVIRONNEMENT like "13 %" || CONCAT_ENVIRONNEMENT like "% 13" || CONCAT_ENVIRONNEMENT like "13" || CONCAT_ENVIRONNEMENT like "% 13 %" ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
0
select distinct concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH where BE_A_ACTIVE="1" AND CONCAT_ENVIRONNEMENT like "14 %" || CONCAT_ENVIRONNEMENT like "% 14" || CONCAT_ENVIRONNEMENT like "14" || CONCAT_ENVIRONNEMENT like "% 14 %" ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
0
select distinct concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH where BE_A_ACTIVE="1" AND CONCAT_ENVIRONNEMENT like "15 %" || CONCAT_ENVIRONNEMENT like "% 15" || CONCAT_ENVIRONNEMENT like "15" || CONCAT_ENVIRONNEMENT like "% 15 %" ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
0
select distinct concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH where BE_A_ACTIVE="1" AND CONCAT_ENVIRONNEMENT like "16 %" || CONCAT_ENVIRONNEMENT like "% 16" || CONCAT_ENVIRONNEMENT like "16" || CONCAT_ENVIRONNEMENT like "% 16 %" ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
0
select distinct concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH where BE_A_ACTIVE="1" AND CONCAT_ENVIRONNEMENT like "17 %" || CONCAT_ENVIRONNEMENT like "% 17" || CONCAT_ENVIRONNEMENT like "17" || CONCAT_ENVIRONNEMENT like "% 17 %" ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
0
select distinct concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH where BE_A_ACTIVE="1" AND CONCAT_ENVIRONNEMENT like "18 %" || CONCAT_ENVIRONNEMENT like "% 18" || CONCAT_ENVIRONNEMENT like "18" || CONCAT_ENVIRONNEMENT like "% 18 %" ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
0
select distinct concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH where BE_A_ACTIVE="1" AND CONCAT_ENVIRONNEMENT like "19 %" || CONCAT_ENVIRONNEMENT like "% 19" || CONCAT_ENVIRONNEMENT like "19" || CONCAT_ENVIRONNEMENT like "% 19 %" ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
0
select distinct concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH where BE_A_ACTIVE="1" AND CONCAT_ENVIRONNEMENT like "20 %" || CONCAT_ENVIRONNEMENT like "% 20" || CONCAT_ENVIRONNEMENT like "20" || CONCAT_ENVIRONNEMENT like "% 20 %" ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
0
select distinct concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH where BE_A_ACTIVE="1" AND CONCAT_ENVIRONNEMENT like "21 %" || CONCAT_ENVIRONNEMENT like "% 21" || CONCAT_ENVIRONNEMENT like "21" || CONCAT_ENVIRONNEMENT like "% 21 %" ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
0
select distinct concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH where BE_A_ACTIVE="1" AND CONCAT_ENVIRONNEMENT like "22 %" || CONCAT_ENVIRONNEMENT like "% 22" || CONCAT_ENVIRONNEMENT like "22" || CONCAT_ENVIRONNEMENT like "% 22 %" ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
0
select distinct concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH where BE_A_ACTIVE="1" AND CONCAT_ENVIRONNEMENT like "23 %" || CONCAT_ENVIRONNEMENT like "% 23" || CONCAT_ENVIRONNEMENT like "23" || CONCAT_ENVIRONNEMENT like "% 23 %" ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
0
select distinct concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH where BE_A_ACTIVE="1" AND CONCAT_ENVIRONNEMENT like "24 %" || CONCAT_ENVIRONNEMENT like "% 24" || CONCAT_ENVIRONNEMENT like "24" || CONCAT_ENVIRONNEMENT like "% 24 %" ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
0
select distinct concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH where BE_A_ACTIVE="1" AND CONCAT_ENVIRONNEMENT like "25 %" || CONCAT_ENVIRONNEMENT like "% 25" || CONCAT_ENVIRONNEMENT like "25" || CONCAT_ENVIRONNEMENT like "% 25 %" ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
0
select distinct concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH where BE_A_ACTIVE="1" AND CONCAT_ENVIRONNEMENT like "26 %" || CONCAT_ENVIRONNEMENT like "% 26" || CONCAT_ENVIRONNEMENT like "26" || CONCAT_ENVIRONNEMENT like "% 26 %" ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
0
select distinct concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH where BE_A_ACTIVE="1" AND CONCAT_ENVIRONNEMENT like "27 %" || CONCAT_ENVIRONNEMENT like "% 27" || CONCAT_ENVIRONNEMENT like "27" || CONCAT_ENVIRONNEMENT like "% 27 %" ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
0
select distinct concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH where BE_A_ACTIVE="1" AND CONCAT_ENVIRONNEMENT like "28 %" || CONCAT_ENVIRONNEMENT like "% 28" || CONCAT_ENVIRONNEMENT like "28" || CONCAT_ENVIRONNEMENT like "% 28 %" ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
0
select distinct concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH where BE_A_ACTIVE="1" AND CONCAT_ENVIRONNEMENT like "29 %" || CONCAT_ENVIRONNEMENT like "% 29" || CONCAT_ENVIRONNEMENT like "29" || CONCAT_ENVIRONNEMENT like "% 29 %" ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
0
select distinct concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH where BE_A_ACTIVE="1" AND CONCAT_ENVIRONNEMENT like "30 %" || CONCAT_ENVIRONNEMENT like "% 30" || CONCAT_ENVIRONNEMENT like "30" || CONCAT_ENVIRONNEMENT like "% 30 %" ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
0
select distinct concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH where BE_A_ACTIVE="1" AND CONCAT_ENVIRONNEMENT like "31 %" || CONCAT_ENVIRONNEMENT like "% 31" || CONCAT_ENVIRONNEMENT like "31" || CONCAT_ENVIRONNEMENT like "% 31 %" ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
0