select distinct concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH where  BE_A_ACTIVE="1" 
AND (CONCAT_COLLECTION like "1 %" || CONCAT_COLLECTION like "% 1" || CONCAT_COLLECTION like "1" || CONCAT_COLLECTION like "% 1 %" ) 
AND (CONCAT_COULEUR_FEUILLE like "2 %" || CONCAT_COULEUR_FEUILLE like "% 2" || CONCAT_COULEUR_FEUILLE like "2" || CONCAT_COULEUR_FEUILLE like "% 2 %") ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC <br>37<br>select distinct concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH where  BE_A_ACTIVE="1" 
AND (CONCAT_COLLECTION like "1 %" || CONCAT_COLLECTION like "% 1" || CONCAT_COLLECTION like "1" || CONCAT_COLLECTION like "% 1 %" ) 
AND (CONCAT_COULEUR_FEUILLE like "3 %" || CONCAT_COULEUR_FEUILLE like "% 3" || CONCAT_COULEUR_FEUILLE like "3" || CONCAT_COULEUR_FEUILLE like "% 3 %") ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC <br>43<br>select distinct concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH where  BE_A_ACTIVE="1" 
AND (CONCAT_COLLECTION like "1 %" || CONCAT_COLLECTION like "% 1" || CONCAT_COLLECTION like "1" || CONCAT_COLLECTION like "% 1 %" ) 
AND (CONCAT_COULEUR_FEUILLE like "4 %" || CONCAT_COULEUR_FEUILLE like "% 4" || CONCAT_COULEUR_FEUILLE like "4" || CONCAT_COULEUR_FEUILLE like "% 4 %") ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC <br>172<br>select distinct concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH where  BE_A_ACTIVE="1" 
AND (CONCAT_COLLECTION like "1 %" || CONCAT_COLLECTION like "% 1" || CONCAT_COLLECTION like "1" || CONCAT_COLLECTION like "% 1 %" ) 
AND (CONCAT_COULEUR_FEUILLE like "5 %" || CONCAT_COULEUR_FEUILLE like "% 5" || CONCAT_COULEUR_FEUILLE like "5" || CONCAT_COULEUR_FEUILLE like "% 5 %") ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC <br>3<br>select distinct concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH where  BE_A_ACTIVE="1" 
AND (CONCAT_COLLECTION like "1 %" || CONCAT_COLLECTION like "% 1" || CONCAT_COLLECTION like "1" || CONCAT_COLLECTION like "% 1 %" ) 
AND (CONCAT_COULEUR_FEUILLE like "6 %" || CONCAT_COULEUR_FEUILLE like "% 6" || CONCAT_COULEUR_FEUILLE like "6" || CONCAT_COULEUR_FEUILLE like "% 6 %") ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC <br>41<br>select distinct concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH where  BE_A_ACTIVE="1" 
AND (CONCAT_COLLECTION like "1 %" || CONCAT_COLLECTION like "% 1" || CONCAT_COLLECTION like "1" || CONCAT_COLLECTION like "% 1 %" ) 
AND (CONCAT_COULEUR_FEUILLE like "7 %" || CONCAT_COULEUR_FEUILLE like "% 7" || CONCAT_COULEUR_FEUILLE like "7" || CONCAT_COULEUR_FEUILLE like "% 7 %") ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC <br>70<br>select distinct concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH where  BE_A_ACTIVE="1" 
AND (CONCAT_COLLECTION like "1 %" || CONCAT_COLLECTION like "% 1" || CONCAT_COLLECTION like "1" || CONCAT_COLLECTION like "% 1 %" ) 
AND (CONCAT_COULEUR_FEUILLE like "8 %" || CONCAT_COULEUR_FEUILLE like "% 8" || CONCAT_COULEUR_FEUILLE like "8" || CONCAT_COULEUR_FEUILLE like "% 8 %") ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC <br>90<br>select distinct concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH where  BE_A_ACTIVE="1" 
AND (CONCAT_COLLECTION like "1 %" || CONCAT_COLLECTION like "% 1" || CONCAT_COLLECTION like "1" || CONCAT_COLLECTION like "% 1 %" ) 
AND (CONCAT_COULEUR_FEUILLE like "9 %" || CONCAT_COULEUR_FEUILLE like "% 9" || CONCAT_COULEUR_FEUILLE like "9" || CONCAT_COULEUR_FEUILLE like "% 9 %") ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC <br>1915<br>select distinct concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH where  BE_A_ACTIVE="1" 
AND (CONCAT_COLLECTION like "1 %" || CONCAT_COLLECTION like "% 1" || CONCAT_COLLECTION like "1" || CONCAT_COLLECTION like "% 1 %" ) 
AND (CONCAT_COULEUR_FEUILLE like "10 %" || CONCAT_COULEUR_FEUILLE like "% 10" || CONCAT_COULEUR_FEUILLE like "10" || CONCAT_COULEUR_FEUILLE like "% 10 %") ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC <br>17<br>