select 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 "1 %" || CONCAT_COULEUR_FEUILLE like "% 1" || CONCAT_COULEUR_FEUILLE like "1" || CONCAT_COULEUR_FEUILLE like "% 1 %") ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select 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 "1 %" || CONCAT_COULEUR_FEUILLE like "% 1" || CONCAT_COULEUR_FEUILLE like "1" || CONCAT_COULEUR_FEUILLE like "% 1 %") ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC  

159
select 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
(mysqli): select 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  

42
select 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
(mysqli): select 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  

42
select 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
(mysqli): select 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  

176
select 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
(mysqli): select 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  

4
select 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
(mysqli): select 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  

40
select 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
(mysqli): select 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  

66
select 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
(mysqli): select 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  

89
select 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
(mysqli): select 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  

1952
select 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
(mysqli): select 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  

18