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
(mysqli): 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
111
(mysqli): select count(*) 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 CHAR_P_GENRE="ACANTHUS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ACANTHUS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ACANTHUS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ACANTHUS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="AGAPANTHUS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="AGAPANTHUS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="AGAPANTHUS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="AGAPANTHUS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="AGAPANTHUS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="AGAPANTHUS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="AGAPANTHUS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="AGAPANTHUS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ALSTROEMERIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ALSTROEMERIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ALSTROEMERIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ALSTROEMERIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ALSTROEMERIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ALSTROEMERIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ALSTROEMERIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ALSTROEMERIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ALSTROEMERIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ALSTROEMERIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ANEMONE"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ANEMONE"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ANEMONE"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ANEMONE"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ANEMONE"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ANEMONE"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ANEMONE"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ANEMONE"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="AQUILEGIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="AQUILEGIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="COREOPSIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="COREOPSIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="COREOPSIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="COREOPSIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="COREOPSIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="COREOPSIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="COREOPSIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="COREOPSIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="COREOPSIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="COREOPSIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="DELOSPERMA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="DELOSPERMA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="DIGITALIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="DIGITALIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ECHINACEA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ECHINACEA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ECHINACEA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ECHINACEA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ECHINACEA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ECHINACEA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ECHINACEA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ECHINACEA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ECHINACEA "
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ECHINACEA "
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="EPIMEDIUM"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="EPIMEDIUM"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="EPIPACTIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="EPIPACTIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="EUPHORBIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="EUPHORBIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="FUCHSIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="FUCHSIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="FUCHSIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="FUCHSIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="FUCHSIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="FUCHSIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="FUCHSIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="FUCHSIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="FUCHSIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="FUCHSIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="FUCHSIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="FUCHSIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="GAILLARDIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="GAILLARDIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="GAILLARDIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="GAILLARDIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="GAILLARDIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="GAILLARDIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="GAILLARDIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="GAILLARDIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="GAILLARDIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="GAILLARDIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="GAURA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="GAURA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="GAURA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="GAURA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="GENTIANA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="GENTIANA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="GERANIUM "
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="GERANIUM "
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="GERANIUM"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="GERANIUM"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="GERANIUM"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="GERANIUM"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="HELENIUM"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="HELENIUM"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="HELENIUM"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="HELENIUM"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="HELENIUM"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="HELENIUM"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="HELLEBORUS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="HELLEBORUS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="HELLEBORUS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="HELLEBORUS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="HEMEROCALLIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="HEMEROCALLIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="HEMEROCALLIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="HEMEROCALLIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="HEMEROCALLIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="HEMEROCALLIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="HEMEROCALLIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="HEMEROCALLIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="HEMEROCALLIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="HEMEROCALLIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="HEMEROCALLIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="HEMEROCALLIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="HEMEROCALLIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="HEMEROCALLIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="HEMEROCALLIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="HEMEROCALLIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="HEMEROCALLIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="HEMEROCALLIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="IRIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="IRIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="IRIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="IRIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="IRIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="IRIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="IRIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="IRIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="IRIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="IRIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="IRIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="IRIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="IRIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="IRIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="IRIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="IRIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="IRIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="IRIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="IRIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="IRIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="IRIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="IRIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="IRIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="IRIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="IRIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="IRIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="IRIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="IRIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="IRIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="IRIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="IRIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="IRIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="IRIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="IRIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="IRIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="IRIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="IRIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="IRIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="KNIPHOFIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="KNIPHOFIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="KNIPHOFIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="KNIPHOFIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="KNIPHOFIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="KNIPHOFIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="KNIPHOFIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="KNIPHOFIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="LAVATERA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="LAVATERA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="LITHODORA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="LITHODORA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="MELITTIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="MELITTIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="NARCISSUS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="NARCISSUS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="NARCISSUS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="NARCISSUS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="PAPAVER"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="PAPAVER"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="PENSTEMON"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="PENSTEMON"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="PENSTEMON"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="PENSTEMON"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="PHLOX"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="PHLOX"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="PHLOX"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="PHLOX"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="PULMONARIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="PULMONARIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="PULMONARIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="PULMONARIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="PULMONARIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="PULMONARIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="SALVIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="SALVIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="SALVIA "
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="SALVIA "
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="SALVIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="SALVIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="SALVIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="SALVIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="SALVIA "
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="SALVIA "
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="TITANOTRICHUM "
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="TITANOTRICHUM "
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="TRICYRTIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="TRICYRTIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="TULIPA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="TULIPA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="TULIPA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="TULIPA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="TULIPA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="TULIPA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="TULIPA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="TULIPA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="VERBENA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="VERBENA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="VIOLA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="VIOLA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
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
(mysqli): 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
530
(mysqli): select count(*) 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 CHAR_P_GENRE="ACAENA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ACAENA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ACAENA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ACAENA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ACAENA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ACAENA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ACANTHUS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ACANTHUS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ACANTHUS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ACANTHUS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ACANTHUS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ACANTHUS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ACANTHUS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ACANTHUS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ACHILLEA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ACHILLEA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ACHILLEA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ACHILLEA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ACHILLEA "
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ACHILLEA "
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ACHILLEA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ACHILLEA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ACHILLEA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ACHILLEA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ACHILLEA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ACHILLEA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ACHILLEA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ACHILLEA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ACHILLEA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ACHILLEA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ACTAEA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ACTAEA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ACTAEA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ACTAEA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ACTAEA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ACTAEA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ACTAEA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ACTAEA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="AEGOPODIUM"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="AEGOPODIUM"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="AEGOPODIUM"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="AEGOPODIUM"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="AGAPANTHUS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="AGAPANTHUS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="AGAPANTHUS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="AGAPANTHUS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="AGAPANTHUS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="AGAPANTHUS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="AGAPANTHUS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="AGAPANTHUS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="AGAPANTHUS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="AGAPANTHUS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="AGAPANTHUS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="AGAPANTHUS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="AGASTACHE"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="AGASTACHE"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="AGASTACHE"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="AGASTACHE"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="AJANIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="AJANIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="AJUGA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="AJUGA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ALCEA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ALCEA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ALISMA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ALISMA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ALLIUM"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ALLIUM"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ALLIUM"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ALLIUM"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ALLIUM"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ALLIUM"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ALLIUM"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ALLIUM"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ALLIUM"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ALLIUM"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ALLIUM"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ALLIUM"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ALLIUM"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ALLIUM"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ALOYSIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ALOYSIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ALSTROEMERIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ALSTROEMERIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ALSTROEMERIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ALSTROEMERIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ALSTROEMERIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ALSTROEMERIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ALSTROEMERIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ALSTROEMERIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ALSTROEMERIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ALSTROEMERIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ALTHAEA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ALTHAEA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ANACYCLUS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ANACYCLUS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ANAPHALIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ANAPHALIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ANAPHALIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ANAPHALIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ANDROPOGON"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ANDROPOGON"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ANEMONE"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ANEMONE"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ANEMONE"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ANEMONE"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ANEMONE"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ANEMONE"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ANEMONE "
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ANEMONE "
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ANEMONE"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ANEMONE"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ANEMONE"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ANEMONE"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ANEMONE"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ANEMONE"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ANEMONE"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ANEMONE"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ANEMONE"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ANEMONE"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ANEMONE"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ANEMONE"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ANGELICA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ANGELICA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ANTHEMIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ANTHEMIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ANTHRISCUS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ANTHRISCUS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="AQUILEGIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="AQUILEGIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="AQUILEGIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="AQUILEGIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ARABIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ARABIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ARABIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ARABIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ARABIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ARABIS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ARCTANTHEMUM"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ARCTANTHEMUM"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ARENARIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ARENARIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ARMERIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ARMERIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ARMERIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ARMERIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ARTEMISIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ARTEMISIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ARTEMISIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ARTEMISIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ARTEMISIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ARTEMISIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ARTEMISIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ARTEMISIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ARTEMISIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ARTEMISIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ARTHROPODIUM"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ARTHROPODIUM"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ASPHODELUS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ASPHODELUS"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ASTER"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ASTER"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ASTER"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ASTER"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ASTER"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ASTER"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ASTER"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ASTER"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ASTER"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ASTER"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ASTER"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ASTER"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ASTER"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ASTER"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ASTER"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ASTER"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ASTER"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ASTER"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ASTER"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ASTER"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ASTER"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ASTER"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ASTILBE"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ASTILBE"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ASTILBE"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ASTILBE"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ASTILBE"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ASTILBE"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ASTILBOIDES"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ASTILBOIDES"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ASTRANTIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ASTRANTIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ASTRANTIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ASTRANTIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="ASTRANTIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 %" ) AND CHAR_P_GENRE="ASTRANTIA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC
(mysqli): select count(*) 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 CHAR_P_GENRE="AUBRIETA"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC