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
47

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
776

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
525

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
902

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
1330

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
0

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
284

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
1

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
866

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
168

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
1063

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
243

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
1515

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
1800

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
340

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
46