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