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 <hr>
(mysqli): select  concat(CHAR_P_GENRE,&quot; &quot;, CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH where  BE_A_ACTIVE=&quot;1&quot; 
AND (CONCAT_COLLECTION like &quot;1 %&quot; || CONCAT_COLLECTION like &quot;% 1&quot; || CONCAT_COLLECTION like &quot;1&quot; || CONCAT_COLLECTION like &quot;% 1 %&quot; ) 
AND (CONCAT_COULEUR_FEUILLE like &quot;1 %&quot; || CONCAT_COULEUR_FEUILLE like &quot;% 1&quot; || CONCAT_COULEUR_FEUILLE like &quot;1&quot; || CONCAT_COULEUR_FEUILLE like &quot;% 1 %&quot;) 
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC  &nbsp; 
<hr>
<br>159<br>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 <hr>
(mysqli): select  concat(CHAR_P_GENRE,&quot; &quot;, CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH where  BE_A_ACTIVE=&quot;1&quot; 
AND (CONCAT_COLLECTION like &quot;1 %&quot; || CONCAT_COLLECTION like &quot;% 1&quot; || CONCAT_COLLECTION like &quot;1&quot; || CONCAT_COLLECTION like &quot;% 1 %&quot; ) 
AND (CONCAT_COULEUR_FEUILLE like &quot;2 %&quot; || CONCAT_COULEUR_FEUILLE like &quot;% 2&quot; || CONCAT_COULEUR_FEUILLE like &quot;2&quot; || CONCAT_COULEUR_FEUILLE like &quot;% 2 %&quot;) 
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC  &nbsp; 
<hr>
<br>42<br>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 <hr>
(mysqli): select  concat(CHAR_P_GENRE,&quot; &quot;, CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH where  BE_A_ACTIVE=&quot;1&quot; 
AND (CONCAT_COLLECTION like &quot;1 %&quot; || CONCAT_COLLECTION like &quot;% 1&quot; || CONCAT_COLLECTION like &quot;1&quot; || CONCAT_COLLECTION like &quot;% 1 %&quot; ) 
AND (CONCAT_COULEUR_FEUILLE like &quot;3 %&quot; || CONCAT_COULEUR_FEUILLE like &quot;% 3&quot; || CONCAT_COULEUR_FEUILLE like &quot;3&quot; || CONCAT_COULEUR_FEUILLE like &quot;% 3 %&quot;) 
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC  &nbsp; 
<hr>
<br>42<br>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 <hr>
(mysqli): select  concat(CHAR_P_GENRE,&quot; &quot;, CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH where  BE_A_ACTIVE=&quot;1&quot; 
AND (CONCAT_COLLECTION like &quot;1 %&quot; || CONCAT_COLLECTION like &quot;% 1&quot; || CONCAT_COLLECTION like &quot;1&quot; || CONCAT_COLLECTION like &quot;% 1 %&quot; ) 
AND (CONCAT_COULEUR_FEUILLE like &quot;4 %&quot; || CONCAT_COULEUR_FEUILLE like &quot;% 4&quot; || CONCAT_COULEUR_FEUILLE like &quot;4&quot; || CONCAT_COULEUR_FEUILLE like &quot;% 4 %&quot;) 
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC  &nbsp; 
<hr>
<br>176<br>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 <hr>
(mysqli): select  concat(CHAR_P_GENRE,&quot; &quot;, CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH where  BE_A_ACTIVE=&quot;1&quot; 
AND (CONCAT_COLLECTION like &quot;1 %&quot; || CONCAT_COLLECTION like &quot;% 1&quot; || CONCAT_COLLECTION like &quot;1&quot; || CONCAT_COLLECTION like &quot;% 1 %&quot; ) 
AND (CONCAT_COULEUR_FEUILLE like &quot;5 %&quot; || CONCAT_COULEUR_FEUILLE like &quot;% 5&quot; || CONCAT_COULEUR_FEUILLE like &quot;5&quot; || CONCAT_COULEUR_FEUILLE like &quot;% 5 %&quot;) 
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC  &nbsp; 
<hr>
<br>4<br>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 <hr>
(mysqli): select  concat(CHAR_P_GENRE,&quot; &quot;, CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH where  BE_A_ACTIVE=&quot;1&quot; 
AND (CONCAT_COLLECTION like &quot;1 %&quot; || CONCAT_COLLECTION like &quot;% 1&quot; || CONCAT_COLLECTION like &quot;1&quot; || CONCAT_COLLECTION like &quot;% 1 %&quot; ) 
AND (CONCAT_COULEUR_FEUILLE like &quot;6 %&quot; || CONCAT_COULEUR_FEUILLE like &quot;% 6&quot; || CONCAT_COULEUR_FEUILLE like &quot;6&quot; || CONCAT_COULEUR_FEUILLE like &quot;% 6 %&quot;) 
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC  &nbsp; 
<hr>
<br>40<br>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 <hr>
(mysqli): select  concat(CHAR_P_GENRE,&quot; &quot;, CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH where  BE_A_ACTIVE=&quot;1&quot; 
AND (CONCAT_COLLECTION like &quot;1 %&quot; || CONCAT_COLLECTION like &quot;% 1&quot; || CONCAT_COLLECTION like &quot;1&quot; || CONCAT_COLLECTION like &quot;% 1 %&quot; ) 
AND (CONCAT_COULEUR_FEUILLE like &quot;7 %&quot; || CONCAT_COULEUR_FEUILLE like &quot;% 7&quot; || CONCAT_COULEUR_FEUILLE like &quot;7&quot; || CONCAT_COULEUR_FEUILLE like &quot;% 7 %&quot;) 
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC  &nbsp; 
<hr>
<br>66<br>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 <hr>
(mysqli): select  concat(CHAR_P_GENRE,&quot; &quot;, CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH where  BE_A_ACTIVE=&quot;1&quot; 
AND (CONCAT_COLLECTION like &quot;1 %&quot; || CONCAT_COLLECTION like &quot;% 1&quot; || CONCAT_COLLECTION like &quot;1&quot; || CONCAT_COLLECTION like &quot;% 1 %&quot; ) 
AND (CONCAT_COULEUR_FEUILLE like &quot;8 %&quot; || CONCAT_COULEUR_FEUILLE like &quot;% 8&quot; || CONCAT_COULEUR_FEUILLE like &quot;8&quot; || CONCAT_COULEUR_FEUILLE like &quot;% 8 %&quot;) 
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC  &nbsp; 
<hr>
<br>89<br>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 <hr>
(mysqli): select  concat(CHAR_P_GENRE,&quot; &quot;, CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH where  BE_A_ACTIVE=&quot;1&quot; 
AND (CONCAT_COLLECTION like &quot;1 %&quot; || CONCAT_COLLECTION like &quot;% 1&quot; || CONCAT_COLLECTION like &quot;1&quot; || CONCAT_COLLECTION like &quot;% 1 %&quot; ) 
AND (CONCAT_COULEUR_FEUILLE like &quot;9 %&quot; || CONCAT_COULEUR_FEUILLE like &quot;% 9&quot; || CONCAT_COULEUR_FEUILLE like &quot;9&quot; || CONCAT_COULEUR_FEUILLE like &quot;% 9 %&quot;) 
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC  &nbsp; 
<hr>
<br>1952<br>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 <hr>
(mysqli): select  concat(CHAR_P_GENRE,&quot; &quot;, CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH where  BE_A_ACTIVE=&quot;1&quot; 
AND (CONCAT_COLLECTION like &quot;1 %&quot; || CONCAT_COLLECTION like &quot;% 1&quot; || CONCAT_COLLECTION like &quot;1&quot; || CONCAT_COLLECTION like &quot;% 1 %&quot; ) 
AND (CONCAT_COULEUR_FEUILLE like &quot;10 %&quot; || CONCAT_COULEUR_FEUILLE like &quot;% 10&quot; || CONCAT_COULEUR_FEUILLE like &quot;10&quot; || CONCAT_COULEUR_FEUILLE like &quot;% 10 %&quot;) 
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC  &nbsp; 
<hr>
<br>18<br>