select distinct concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME, CHAR_A_SOUSTITRE from TMP_ARTICLE_SEARCH WHERE (CONCAT_COLLECTION like "1 %" || CONCAT_COLLECTION like "% 1" || CONCAT_COLLECTION like "1" || CONCAT_COLLECTION like "% 1 %" ) AND BE_A_ACTIVE="1" AND  BE_P_CONDIMENT="1" ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC<br>47<br><br>select distinct concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME, CHAR_A_SOUSTITRE from TMP_ARTICLE_SEARCH WHERE (CONCAT_COLLECTION like "1 %" || CONCAT_COLLECTION like "% 1" || CONCAT_COLLECTION like "1" || CONCAT_COLLECTION like "% 1 %" ) AND BE_A_ACTIVE="1" AND  BE_P_MELLIFERE="1" ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC<br>776<br><br>select distinct concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME, CHAR_A_SOUSTITRE from TMP_ARTICLE_SEARCH WHERE (CONCAT_COLLECTION like "1 %" || CONCAT_COLLECTION like "% 1" || CONCAT_COLLECTION like "1" || CONCAT_COLLECTION like "% 1 %" ) AND BE_A_ACTIVE="1" AND  BE_P_ODORANTE="1" ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC<br>525<br><br>select distinct concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME, CHAR_A_SOUSTITRE from TMP_ARTICLE_SEARCH WHERE (CONCAT_COLLECTION like "1 %" || CONCAT_COLLECTION like "% 1" || CONCAT_COLLECTION like "1" || CONCAT_COLLECTION like "% 1 %" ) AND BE_A_ACTIVE="1" AND  BE_P_MARITIME="1" ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC<br>902<br><br>select distinct concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME, CHAR_A_SOUSTITRE from TMP_ARTICLE_SEARCH WHERE (CONCAT_COLLECTION like "1 %" || CONCAT_COLLECTION like "% 1" || CONCAT_COLLECTION like "1" || CONCAT_COLLECTION like "% 1 %" ) AND BE_A_ACTIVE="1" AND  BE_P_FLEURCOUPE="1" ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC<br>1330<br><br>select distinct concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME, CHAR_A_SOUSTITRE from TMP_ARTICLE_SEARCH WHERE (CONCAT_COLLECTION like "1 %" || CONCAT_COLLECTION like "% 1" || CONCAT_COLLECTION like "1" || CONCAT_COLLECTION like "% 1 %" ) AND BE_A_ACTIVE="1" AND  BE_P_EPURATRICE="1" ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC<br>0<br><br>select distinct concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME, CHAR_A_SOUSTITRE from TMP_ARTICLE_SEARCH WHERE (CONCAT_COLLECTION like "1 %" || CONCAT_COLLECTION like "% 1" || CONCAT_COLLECTION like "1" || CONCAT_COLLECTION like "% 1 %" ) AND BE_A_ACTIVE="1" AND  BE_P_ISOLE="1" ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC<br>284<br><br>select distinct concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME, CHAR_A_SOUSTITRE from TMP_ARTICLE_SEARCH WHERE (CONCAT_COLLECTION like "1 %" || CONCAT_COLLECTION like "% 1" || CONCAT_COLLECTION like "1" || CONCAT_COLLECTION like "% 1 %" ) AND BE_A_ACTIVE="1" AND  BE_P_GARNITURE="1" ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC<br>1<br><br>select distinct concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME, CHAR_A_SOUSTITRE from TMP_ARTICLE_SEARCH WHERE (CONCAT_COLLECTION like "1 %" || CONCAT_COLLECTION like "% 1" || CONCAT_COLLECTION like "1" || CONCAT_COLLECTION like "% 1 %" ) AND BE_A_ACTIVE="1" AND  BE_P_PERSISTANT="1" ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC<br>866<br><br>select distinct concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME, CHAR_A_SOUSTITRE from TMP_ARTICLE_SEARCH WHERE (CONCAT_COLLECTION like "1 %" || CONCAT_COLLECTION like "% 1" || CONCAT_COLLECTION like "1" || CONCAT_COLLECTION like "% 1 %" ) AND BE_A_ACTIVE="1" AND  BE_P_ACIDE="1" ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC<br>168<br><br>select distinct concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME, CHAR_A_SOUSTITRE from TMP_ARTICLE_SEARCH WHERE (CONCAT_COLLECTION like "1 %" || CONCAT_COLLECTION like "% 1" || CONCAT_COLLECTION like "1" || CONCAT_COLLECTION like "% 1 %" ) AND BE_A_ACTIVE="1" AND  BE_P_CALCAIRE="1" ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC<br>1063<br><br>select distinct concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME, CHAR_A_SOUSTITRE from TMP_ARTICLE_SEARCH WHERE (CONCAT_COLLECTION like "1 %" || CONCAT_COLLECTION like "% 1" || CONCAT_COLLECTION like "1" || CONCAT_COLLECTION like "% 1 %" ) AND BE_A_ACTIVE="1" AND  BE_P_DRAINE="1" ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC<br>243<br><br>select distinct concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME, CHAR_A_SOUSTITRE from TMP_ARTICLE_SEARCH WHERE (CONCAT_COLLECTION like "1 %" || CONCAT_COLLECTION like "% 1" || CONCAT_COLLECTION like "1" || CONCAT_COLLECTION like "% 1 %" ) AND BE_A_ACTIVE="1" AND  BE_P_SEC="1" ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC<br>1515<br><br>select distinct concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME, CHAR_A_SOUSTITRE from TMP_ARTICLE_SEARCH WHERE (CONCAT_COLLECTION like "1 %" || CONCAT_COLLECTION like "% 1" || CONCAT_COLLECTION like "1" || CONCAT_COLLECTION like "% 1 %" ) AND BE_A_ACTIVE="1" AND  BE_P_FRAIS="1" ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC<br>1800<br><br>select distinct concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME, CHAR_A_SOUSTITRE from TMP_ARTICLE_SEARCH WHERE (CONCAT_COLLECTION like "1 %" || CONCAT_COLLECTION like "% 1" || CONCAT_COLLECTION like "1" || CONCAT_COLLECTION like "% 1 %" ) AND BE_A_ACTIVE="1" AND  BE_P_HUMIDE="1" ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC<br>340<br><br>select distinct concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME, CHAR_A_SOUSTITRE from TMP_ARTICLE_SEARCH 
WHERE (CONCAT_COLLECTION like "1 %" || CONCAT_COLLECTION like "% 1" || CONCAT_COLLECTION like "1" || CONCAT_COLLECTION like "% 1 %" ) 
AND BE_A_ACTIVE="1" AND  BE_P_PRIOFLEUR="3" ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC<br>46<br><br>