select CHAR_P_GENRE, concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH WHERE BE_A_CATALOGUE="1" AND BE_P_LONGUEF=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 CHAR_P_GENRE ASC, CONCAT_NOM_RECHERCHE ASC
34
select CHAR_P_GENRE, concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH WHERE BE_A_CATALOGUE="1" AND BE_P_LONGUEF=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 CHAR_P_GENRE ASC, CONCAT_NOM_RECHERCHE ASC
66
select CHAR_P_GENRE, concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH WHERE BE_A_CATALOGUE="1" AND BE_P_LONGUEF=1 AND (CONCAT_COLLECTION like "1 %" || CONCAT_COLLECTION like "% 1" || CONCAT_COLLECTION like "1" || CONCAT_COLLECTION like "% 1 %" ) AND (CONCAT_COULEUR_FLEUR like "3 %"
|| CONCAT_COULEUR_FLEUR like "% 3" || CONCAT_COULEUR_FLEUR like "3" || CONCAT_COULEUR_FLEUR like "% 3 %" )
ORDER BY CHAR_P_GENRE ASC, CONCAT_NOM_RECHERCHE ASC
48
select CHAR_P_GENRE, concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH WHERE BE_A_CATALOGUE="1" AND BE_P_LONGUEF=1 AND (CONCAT_COLLECTION like "1 %" || CONCAT_COLLECTION like "% 1" || CONCAT_COLLECTION like "1" || CONCAT_COLLECTION like "% 1 %" ) AND (CONCAT_COULEUR_FLEUR like "4 %"
|| CONCAT_COULEUR_FLEUR like "% 4" || CONCAT_COULEUR_FLEUR like "4" || CONCAT_COULEUR_FLEUR like "% 4 %" )
ORDER BY CHAR_P_GENRE ASC, CONCAT_NOM_RECHERCHE ASC
4
select CHAR_P_GENRE, concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH WHERE BE_A_CATALOGUE="1" AND BE_P_LONGUEF=1 AND (CONCAT_COLLECTION like "1 %" || CONCAT_COLLECTION like "% 1" || CONCAT_COLLECTION like "1" || CONCAT_COLLECTION like "% 1 %" ) AND (CONCAT_COULEUR_FLEUR like "5 %"
|| CONCAT_COULEUR_FLEUR like "% 5" || CONCAT_COULEUR_FLEUR like "5" || CONCAT_COULEUR_FLEUR like "% 5 %" )
ORDER BY CHAR_P_GENRE ASC, CONCAT_NOM_RECHERCHE ASC
8
select CHAR_P_GENRE, concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH WHERE BE_A_CATALOGUE="1" AND BE_P_LONGUEF=1 AND (CONCAT_COLLECTION like "1 %" || CONCAT_COLLECTION like "% 1" || CONCAT_COLLECTION like "1" || CONCAT_COLLECTION like "% 1 %" ) AND (CONCAT_COULEUR_FLEUR like "6 %"
|| CONCAT_COULEUR_FLEUR like "% 6" || CONCAT_COULEUR_FLEUR like "6" || CONCAT_COULEUR_FLEUR like "% 6 %" )
ORDER BY CHAR_P_GENRE ASC, CONCAT_NOM_RECHERCHE ASC
49
select CHAR_P_GENRE, concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH WHERE BE_A_CATALOGUE="1" AND BE_P_LONGUEF=1 AND (CONCAT_COLLECTION like "1 %" || CONCAT_COLLECTION like "% 1" || CONCAT_COLLECTION like "1" || CONCAT_COLLECTION like "% 1 %" ) AND (CONCAT_COULEUR_FLEUR like "7 %"
|| CONCAT_COULEUR_FLEUR like "% 7" || CONCAT_COULEUR_FLEUR like "7" || CONCAT_COULEUR_FLEUR like "% 7 %" )
ORDER BY CHAR_P_GENRE ASC, CONCAT_NOM_RECHERCHE ASC
16
select CHAR_P_GENRE, concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH WHERE BE_A_CATALOGUE="1" AND BE_P_LONGUEF=1 AND (CONCAT_COLLECTION like "1 %" || CONCAT_COLLECTION like "% 1" || CONCAT_COLLECTION like "1" || CONCAT_COLLECTION like "% 1 %" ) AND (CONCAT_COULEUR_FLEUR like "8 %"
|| CONCAT_COULEUR_FLEUR like "% 8" || CONCAT_COULEUR_FLEUR like "8" || CONCAT_COULEUR_FLEUR like "% 8 %" )
ORDER BY CHAR_P_GENRE ASC, CONCAT_NOM_RECHERCHE ASC
1
select CHAR_P_GENRE, concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH WHERE BE_A_CATALOGUE="1" AND BE_P_LONGUEF=1 AND (CONCAT_COLLECTION like "1 %" || CONCAT_COLLECTION like "% 1" || CONCAT_COLLECTION like "1" || CONCAT_COLLECTION like "% 1 %" ) AND (CONCAT_COULEUR_FLEUR like "9 %"
|| CONCAT_COULEUR_FLEUR like "% 9" || CONCAT_COULEUR_FLEUR like "9" || CONCAT_COULEUR_FLEUR like "% 9 %" )
ORDER BY CHAR_P_GENRE ASC, CONCAT_NOM_RECHERCHE ASC
21
select CHAR_P_GENRE, concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH WHERE BE_A_CATALOGUE="1" AND BE_P_LONGUEF=1 AND (CONCAT_COLLECTION like "1 %" || CONCAT_COLLECTION like "% 1" || CONCAT_COLLECTION like "1" || CONCAT_COLLECTION like "% 1 %" ) AND (CONCAT_COULEUR_FLEUR like "10 %"
|| CONCAT_COULEUR_FLEUR like "% 10" || CONCAT_COULEUR_FLEUR like "10" || CONCAT_COULEUR_FLEUR like "% 10 %" )
ORDER BY CHAR_P_GENRE ASC, CONCAT_NOM_RECHERCHE ASC
8
select CHAR_P_GENRE, concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH WHERE BE_A_CATALOGUE="1" AND BE_P_LONGUEF=1 AND (CONCAT_COLLECTION like "1 %" || CONCAT_COLLECTION like "% 1" || CONCAT_COLLECTION like "1" || CONCAT_COLLECTION like "% 1 %" ) AND (CONCAT_COULEUR_FLEUR like "11 %"
|| CONCAT_COULEUR_FLEUR like "% 11" || CONCAT_COULEUR_FLEUR like "11" || CONCAT_COULEUR_FLEUR like "% 11 %" )
ORDER BY CHAR_P_GENRE ASC, CONCAT_NOM_RECHERCHE ASC
104
select CHAR_P_GENRE, concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH WHERE BE_A_CATALOGUE="1" AND BE_P_LONGUEF=1 AND (CONCAT_COLLECTION like "1 %" || CONCAT_COLLECTION like "% 1" || CONCAT_COLLECTION like "1" || CONCAT_COLLECTION like "% 1 %" ) AND (CONCAT_COULEUR_FLEUR like "12 %"
|| CONCAT_COULEUR_FLEUR like "% 12" || CONCAT_COULEUR_FLEUR like "12" || CONCAT_COULEUR_FLEUR like "% 12 %" )
ORDER BY CHAR_P_GENRE ASC, CONCAT_NOM_RECHERCHE ASC
49
select CHAR_P_GENRE, concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH WHERE BE_A_CATALOGUE="1" AND BE_P_LONGUEF=1 AND (CONCAT_COLLECTION like "1 %" || CONCAT_COLLECTION like "% 1" || CONCAT_COLLECTION like "1" || CONCAT_COLLECTION like "% 1 %" ) AND (CONCAT_COULEUR_FLEUR like "13 %"
|| CONCAT_COULEUR_FLEUR like "% 13" || CONCAT_COULEUR_FLEUR like "13" || CONCAT_COULEUR_FLEUR like "% 13 %" )
ORDER BY CHAR_P_GENRE ASC, CONCAT_NOM_RECHERCHE ASC
7
select CHAR_P_GENRE, concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH WHERE BE_A_CATALOGUE="1" AND BE_P_LONGUEF=1 AND (CONCAT_COLLECTION like "1 %" || CONCAT_COLLECTION like "% 1" || CONCAT_COLLECTION like "1" || CONCAT_COLLECTION like "% 1 %" ) AND (CONCAT_COULEUR_FLEUR like "14 %"
|| CONCAT_COULEUR_FLEUR like "% 14" || CONCAT_COULEUR_FLEUR like "14" || CONCAT_COULEUR_FLEUR like "% 14 %" )
ORDER BY CHAR_P_GENRE ASC, CONCAT_NOM_RECHERCHE ASC
8
select CHAR_P_GENRE, concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH WHERE BE_A_CATALOGUE="1" AND BE_P_LONGUEF=1 AND (CONCAT_COLLECTION like "1 %" || CONCAT_COLLECTION like "% 1" || CONCAT_COLLECTION like "1" || CONCAT_COLLECTION like "% 1 %" ) AND (CONCAT_COULEUR_FLEUR like "15 %"
|| CONCAT_COULEUR_FLEUR like "% 15" || CONCAT_COULEUR_FLEUR like "15" || CONCAT_COULEUR_FLEUR like "% 15 %" )
ORDER BY CHAR_P_GENRE ASC, CONCAT_NOM_RECHERCHE ASC
1
select CHAR_P_GENRE, concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH WHERE BE_A_CATALOGUE="1" AND BE_P_LONGUEF=1 AND (CONCAT_COLLECTION like "1 %" || CONCAT_COLLECTION like "% 1" || CONCAT_COLLECTION like "1" || CONCAT_COLLECTION like "% 1 %" ) AND (CONCAT_COULEUR_FLEUR like "16 %"
|| CONCAT_COULEUR_FLEUR like "% 16" || CONCAT_COULEUR_FLEUR like "16" || CONCAT_COULEUR_FLEUR like "% 16 %" )
ORDER BY CHAR_P_GENRE ASC, CONCAT_NOM_RECHERCHE ASC
0
select CHAR_P_GENRE, concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH WHERE BE_A_CATALOGUE="1" AND BE_P_LONGUEF=1 AND (CONCAT_COLLECTION like "1 %" || CONCAT_COLLECTION like "% 1" || CONCAT_COLLECTION like "1" || CONCAT_COLLECTION like "% 1 %" ) AND (CONCAT_COULEUR_FLEUR like "17 %"
|| CONCAT_COULEUR_FLEUR like "% 17" || CONCAT_COULEUR_FLEUR like "17" || CONCAT_COULEUR_FLEUR like "% 17 %" )
ORDER BY CHAR_P_GENRE ASC, CONCAT_NOM_RECHERCHE ASC
23
select CHAR_P_GENRE, concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH WHERE BE_A_CATALOGUE="1" AND BE_P_LONGUEF=1 AND (CONCAT_COLLECTION like "1 %" || CONCAT_COLLECTION like "% 1" || CONCAT_COLLECTION like "1" || CONCAT_COLLECTION like "% 1 %" ) AND (CONCAT_COULEUR_FLEUR like "18 %"
|| CONCAT_COULEUR_FLEUR like "% 18" || CONCAT_COULEUR_FLEUR like "18" || CONCAT_COULEUR_FLEUR like "% 18 %" )
ORDER BY CHAR_P_GENRE ASC, CONCAT_NOM_RECHERCHE ASC
0
select CHAR_P_GENRE, concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME from TMP_ARTICLE_SEARCH WHERE BE_A_CATALOGUE="1" AND BE_P_LONGUEF=1 AND (CONCAT_COLLECTION like "1 %" || CONCAT_COLLECTION like "% 1" || CONCAT_COLLECTION like "1" || CONCAT_COLLECTION like "% 1 %" ) AND (CONCAT_COULEUR_FLEUR like "19 %"
|| CONCAT_COULEUR_FLEUR like "% 19" || CONCAT_COULEUR_FLEUR like "19" || CONCAT_COULEUR_FLEUR like "% 19 %" )
ORDER BY CHAR_P_GENRE ASC, CONCAT_NOM_RECHERCHE ASC
0