select  CHAR_P_GENRE, concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE="1"  AND (CONCAT_COLLECTION like "1 %" || CONCAT_COLLECTION like "% 1" || CONCAT_COLLECTION like "1" || CONCAT_COLLECTION like "% 1 %" ) 
AND (CONCAT_COULEUR_FLEUR like "1 %" || CONCAT_COULEUR_FLEUR like "% 1" || CONCAT_COULEUR_FLEUR like "1" || CONCAT_COULEUR_FLEUR like "% 1 %" ) order by UPPER(REPLACE(CHAR_A_TITRE,"'","")) ASC 
<hr>
(mysqli): select  CHAR_P_GENRE, concat(CHAR_P_GENRE,&quot; &quot;, CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; ) order by UPPER(REPLACE(CHAR_A_TITRE,&quot;'&quot;,&quot;&quot;)) ASC 
 &nbsp; 
<hr>
<br>111<br><hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ACANTHUS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;ACANTHUS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ACANTHUS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;ACANTHUS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;AGAPANTHUS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;AGAPANTHUS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;AGAPANTHUS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;AGAPANTHUS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;AGAPANTHUS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;AGAPANTHUS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;AGAPANTHUS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;AGAPANTHUS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ALSTROEMERIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;ALSTROEMERIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ALSTROEMERIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;ALSTROEMERIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ALSTROEMERIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;ALSTROEMERIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ALSTROEMERIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;ALSTROEMERIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ALSTROEMERIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;ALSTROEMERIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ANEMONE&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;ANEMONE&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ANEMONE&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;ANEMONE&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ANEMONE&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;ANEMONE&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ANEMONE&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;ANEMONE&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;AQUILEGIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;AQUILEGIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;COREOPSIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;COREOPSIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;COREOPSIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;COREOPSIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;COREOPSIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;COREOPSIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;COREOPSIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;COREOPSIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;COREOPSIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;COREOPSIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;DELOSPERMA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;DELOSPERMA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;DIGITALIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;DIGITALIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ECHINACEA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;ECHINACEA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ECHINACEA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;ECHINACEA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ECHINACEA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;ECHINACEA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ECHINACEA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;ECHINACEA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ECHINACEA &quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;ECHINACEA &quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;EPIMEDIUM&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;EPIMEDIUM&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;EPIPACTIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;EPIPACTIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;EUPHORBIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;EUPHORBIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;FUCHSIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;FUCHSIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;FUCHSIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;FUCHSIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;FUCHSIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;FUCHSIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;FUCHSIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;FUCHSIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;FUCHSIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;FUCHSIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;FUCHSIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;FUCHSIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;GAILLARDIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;GAILLARDIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;GAILLARDIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;GAILLARDIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;GAILLARDIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;GAILLARDIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;GAILLARDIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;GAILLARDIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;GAILLARDIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;GAILLARDIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;GAURA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;GAURA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;GAURA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;GAURA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;GENTIANA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;GENTIANA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;GERANIUM &quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;GERANIUM &quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;GERANIUM&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;GERANIUM&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;GERANIUM&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;GERANIUM&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;HELENIUM&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;HELENIUM&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;HELENIUM&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;HELENIUM&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;HELENIUM&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;HELENIUM&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;HELLEBORUS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;HELLEBORUS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;HELLEBORUS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;HELLEBORUS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;HEMEROCALLIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;HEMEROCALLIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;HEMEROCALLIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;HEMEROCALLIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;HEMEROCALLIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;HEMEROCALLIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;HEMEROCALLIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;HEMEROCALLIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;HEMEROCALLIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;HEMEROCALLIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;HEMEROCALLIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;HEMEROCALLIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;HEMEROCALLIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;HEMEROCALLIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;HEMEROCALLIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;HEMEROCALLIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;HEMEROCALLIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;HEMEROCALLIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;IRIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;IRIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;IRIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;IRIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;IRIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;IRIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;IRIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;IRIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;IRIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;IRIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;IRIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;IRIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;IRIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;IRIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;IRIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;IRIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;IRIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;IRIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;IRIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;IRIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;IRIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;IRIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;IRIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;IRIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;IRIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;IRIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;IRIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;IRIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;IRIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;IRIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;IRIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;IRIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;IRIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;IRIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;IRIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;IRIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;IRIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;IRIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;KNIPHOFIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;KNIPHOFIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;KNIPHOFIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;KNIPHOFIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;KNIPHOFIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;KNIPHOFIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;KNIPHOFIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;KNIPHOFIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;LAVATERA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;LAVATERA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;LITHODORA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;LITHODORA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;MELITTIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;MELITTIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;NARCISSUS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;NARCISSUS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;NARCISSUS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;NARCISSUS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;PAPAVER&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;PAPAVER&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;PENSTEMON&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;PENSTEMON&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;PENSTEMON&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;PENSTEMON&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;PHLOX&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;PHLOX&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;PHLOX&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;PHLOX&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;PULMONARIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;PULMONARIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;PULMONARIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;PULMONARIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;PULMONARIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;PULMONARIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;SALVIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;SALVIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;SALVIA &quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;SALVIA &quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;SALVIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;SALVIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;SALVIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;SALVIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;SALVIA &quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;SALVIA &quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;TITANOTRICHUM &quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;TITANOTRICHUM &quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;TRICYRTIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;TRICYRTIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;TULIPA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;TULIPA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;TULIPA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;TULIPA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;TULIPA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;TULIPA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;TULIPA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;TULIPA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;VERBENA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;VERBENA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;VIOLA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;1 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1&quot; || CONCAT_COULEUR_FLEUR like &quot;1&quot; || CONCAT_COULEUR_FLEUR like &quot;% 1 %&quot; )  AND CHAR_P_GENRE=&quot;VIOLA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
select  CHAR_P_GENRE, concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE="1"  AND (CONCAT_COLLECTION like "1 %" || CONCAT_COLLECTION like "% 1" || CONCAT_COLLECTION like "1" || CONCAT_COLLECTION like "% 1 %" ) 
AND (CONCAT_COULEUR_FLEUR like "2 %" || CONCAT_COULEUR_FLEUR like "% 2" || CONCAT_COULEUR_FLEUR like "2" || CONCAT_COULEUR_FLEUR like "% 2 %" ) order by UPPER(REPLACE(CHAR_A_TITRE,"'","")) ASC 
<hr>
(mysqli): select  CHAR_P_GENRE, concat(CHAR_P_GENRE,&quot; &quot;, CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; ) order by UPPER(REPLACE(CHAR_A_TITRE,&quot;'&quot;,&quot;&quot;)) ASC 
 &nbsp; 
<hr>
<br>530<br><hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ACAENA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ACAENA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ACAENA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ACAENA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ACAENA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ACAENA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ACANTHUS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ACANTHUS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ACANTHUS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ACANTHUS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ACANTHUS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ACANTHUS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ACANTHUS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ACANTHUS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ACHILLEA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ACHILLEA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ACHILLEA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ACHILLEA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ACHILLEA &quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ACHILLEA &quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ACHILLEA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ACHILLEA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ACHILLEA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ACHILLEA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ACHILLEA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ACHILLEA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ACHILLEA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ACHILLEA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ACHILLEA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ACHILLEA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ACTAEA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ACTAEA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ACTAEA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ACTAEA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ACTAEA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ACTAEA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ACTAEA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ACTAEA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;AEGOPODIUM&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;AEGOPODIUM&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;AEGOPODIUM&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;AEGOPODIUM&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;AGAPANTHUS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;AGAPANTHUS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;AGAPANTHUS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;AGAPANTHUS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;AGAPANTHUS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;AGAPANTHUS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;AGAPANTHUS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;AGAPANTHUS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;AGAPANTHUS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;AGAPANTHUS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;AGAPANTHUS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;AGAPANTHUS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;AGASTACHE&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;AGASTACHE&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;AGASTACHE&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;AGASTACHE&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;AJANIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;AJANIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;AJUGA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;AJUGA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ALCEA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ALCEA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ALISMA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ALISMA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ALLIUM&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ALLIUM&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ALLIUM&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ALLIUM&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ALLIUM&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ALLIUM&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ALLIUM&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ALLIUM&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ALLIUM&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ALLIUM&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ALLIUM&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ALLIUM&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ALLIUM&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ALLIUM&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ALOYSIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ALOYSIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ALSTROEMERIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ALSTROEMERIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ALSTROEMERIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ALSTROEMERIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ALSTROEMERIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ALSTROEMERIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ALSTROEMERIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ALSTROEMERIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ALSTROEMERIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ALSTROEMERIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ALTHAEA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ALTHAEA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ANACYCLUS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ANACYCLUS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ANAPHALIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ANAPHALIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ANAPHALIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ANAPHALIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ANDROPOGON&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ANDROPOGON&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ANEMONE&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ANEMONE&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ANEMONE&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ANEMONE&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ANEMONE&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ANEMONE&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ANEMONE &quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ANEMONE &quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ANEMONE&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ANEMONE&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ANEMONE&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ANEMONE&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ANEMONE&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ANEMONE&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ANEMONE&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ANEMONE&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ANEMONE&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ANEMONE&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ANEMONE&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ANEMONE&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ANGELICA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ANGELICA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ANTHEMIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ANTHEMIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ANTHRISCUS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ANTHRISCUS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;AQUILEGIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;AQUILEGIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;AQUILEGIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;AQUILEGIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ARABIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ARABIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ARABIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ARABIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ARABIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ARABIS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ARCTANTHEMUM&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ARCTANTHEMUM&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ARENARIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ARENARIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ARMERIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ARMERIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ARMERIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ARMERIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ARTEMISIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ARTEMISIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ARTEMISIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ARTEMISIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ARTEMISIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ARTEMISIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ARTEMISIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ARTEMISIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ARTEMISIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ARTEMISIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ARTHROPODIUM&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ARTHROPODIUM&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ASPHODELUS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ASPHODELUS&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ASTER&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ASTER&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ASTER&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ASTER&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ASTER&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ASTER&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ASTER&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ASTER&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ASTER&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ASTER&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ASTER&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ASTER&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ASTER&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ASTER&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ASTER&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ASTER&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ASTER&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ASTER&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ASTER&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ASTER&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ASTER&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ASTER&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ASTILBE&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ASTILBE&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ASTILBE&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ASTILBE&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ASTILBE&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ASTILBE&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ASTILBOIDES&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ASTILBOIDES&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ASTRANTIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ASTRANTIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ASTRANTIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ASTRANTIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;ASTRANTIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
WHERE BE_A_CATALOGUE=&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_FLEUR like &quot;2 %&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2&quot; || CONCAT_COULEUR_FLEUR like &quot;2&quot; || CONCAT_COULEUR_FLEUR like &quot;% 2 %&quot; )  AND CHAR_P_GENRE=&quot;ASTRANTIA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>
<hr>
(mysqli): select  count(*) from TMP_ARTICLE_SEARCH 
  WHERE BE_A_CATALOGUE=&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 CHAR_P_GENRE=&quot;AUBRIETA&quot;
 ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC &nbsp; 
<hr>