select * from TMP_ARTICLE_SEARCH WHERE BE_A_ACTIVE="1"  AND (CONCAT_COLLECTION like "1 %" || CONCAT_COLLECTION like "% 1" || CONCAT_COLLECTION like "1" || CONCAT_COLLECTION like "% 1 %" ) 
AND (CONCAT_COULEUR_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 
<br>114<br>select * from TMP_ARTICLE_SEARCH WHERE BE_A_ACTIVE="1"  AND (CONCAT_COLLECTION like "1 %" || CONCAT_COLLECTION like "% 1" || CONCAT_COLLECTION like "1" || CONCAT_COLLECTION like "% 1 %" ) 
AND (CONCAT_COULEUR_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 
<br>546<br>select * from TMP_ARTICLE_SEARCH WHERE BE_A_ACTIVE="1"  AND (CONCAT_COLLECTION like "1 %" || CONCAT_COLLECTION like "% 1" || CONCAT_COLLECTION like "1" || CONCAT_COLLECTION like "% 1 %" ) 
AND (CONCAT_COULEUR_FLEUR like "3 %" || CONCAT_COULEUR_FLEUR like "% 3" || CONCAT_COULEUR_FLEUR like "3" || CONCAT_COULEUR_FLEUR like "% 3 %" ) order by UPPER(REPLACE(CHAR_A_TITRE,"'","")) ASC 
<br>297<br>select * from TMP_ARTICLE_SEARCH WHERE BE_A_ACTIVE="1"  AND (CONCAT_COLLECTION like "1 %" || CONCAT_COLLECTION like "% 1" || CONCAT_COLLECTION like "1" || CONCAT_COLLECTION like "% 1 %" ) 
AND (CONCAT_COULEUR_FLEUR like "4 %" || CONCAT_COULEUR_FLEUR like "% 4" || CONCAT_COULEUR_FLEUR like "4" || CONCAT_COULEUR_FLEUR like "% 4 %" ) order by UPPER(REPLACE(CHAR_A_TITRE,"'","")) ASC 
<br>28<br>select * from TMP_ARTICLE_SEARCH WHERE BE_A_ACTIVE="1"  AND (CONCAT_COLLECTION like "1 %" || CONCAT_COLLECTION like "% 1" || CONCAT_COLLECTION like "1" || CONCAT_COLLECTION like "% 1 %" ) 
AND (CONCAT_COULEUR_FLEUR like "5 %" || CONCAT_COULEUR_FLEUR like "% 5" || CONCAT_COULEUR_FLEUR like "5" || CONCAT_COULEUR_FLEUR like "% 5 %" ) order by UPPER(REPLACE(CHAR_A_TITRE,"'","")) ASC 
<br>82<br>select * from TMP_ARTICLE_SEARCH WHERE BE_A_ACTIVE="1"  AND (CONCAT_COLLECTION like "1 %" || CONCAT_COLLECTION like "% 1" || CONCAT_COLLECTION like "1" || CONCAT_COLLECTION like "% 1 %" ) 
AND (CONCAT_COULEUR_FLEUR like "6 %" || CONCAT_COULEUR_FLEUR like "% 6" || CONCAT_COULEUR_FLEUR like "6" || CONCAT_COULEUR_FLEUR like "% 6 %" ) order by UPPER(REPLACE(CHAR_A_TITRE,"'","")) ASC 
<br>324<br>select * from TMP_ARTICLE_SEARCH WHERE BE_A_ACTIVE="1"  AND (CONCAT_COLLECTION like "1 %" || CONCAT_COLLECTION like "% 1" || CONCAT_COLLECTION like "1" || CONCAT_COLLECTION like "% 1 %" ) 
AND (CONCAT_COULEUR_FLEUR like "7 %" || CONCAT_COULEUR_FLEUR like "% 7" || CONCAT_COULEUR_FLEUR like "7" || CONCAT_COULEUR_FLEUR like "% 7 %" ) order by UPPER(REPLACE(CHAR_A_TITRE,"'","")) ASC 
<br>97<br>select * from TMP_ARTICLE_SEARCH WHERE BE_A_ACTIVE="1"  AND (CONCAT_COLLECTION like "1 %" || CONCAT_COLLECTION like "% 1" || CONCAT_COLLECTION like "1" || CONCAT_COLLECTION like "% 1 %" ) 
AND (CONCAT_COULEUR_FLEUR like "8 %" || CONCAT_COULEUR_FLEUR like "% 8" || CONCAT_COULEUR_FLEUR like "8" || CONCAT_COULEUR_FLEUR like "% 8 %" ) order by UPPER(REPLACE(CHAR_A_TITRE,"'","")) ASC 
<br>10<br>select * from TMP_ARTICLE_SEARCH WHERE BE_A_ACTIVE="1"  AND (CONCAT_COLLECTION like "1 %" || CONCAT_COLLECTION like "% 1" || CONCAT_COLLECTION like "1" || CONCAT_COLLECTION like "% 1 %" ) 
AND (CONCAT_COULEUR_FLEUR like "9 %" || CONCAT_COULEUR_FLEUR like "% 9" || CONCAT_COULEUR_FLEUR like "9" || CONCAT_COULEUR_FLEUR like "% 9 %" ) order by UPPER(REPLACE(CHAR_A_TITRE,"'","")) ASC 
<br>79<br>select * from TMP_ARTICLE_SEARCH WHERE BE_A_ACTIVE="1"  AND (CONCAT_COLLECTION like "1 %" || CONCAT_COLLECTION like "% 1" || CONCAT_COLLECTION like "1" || CONCAT_COLLECTION like "% 1 %" ) 
AND (CONCAT_COULEUR_FLEUR like "10 %" || CONCAT_COULEUR_FLEUR like "% 10" || CONCAT_COULEUR_FLEUR like "10" || CONCAT_COULEUR_FLEUR like "% 10 %" ) order by UPPER(REPLACE(CHAR_A_TITRE,"'","")) ASC 
<br>70<br>select * from TMP_ARTICLE_SEARCH WHERE BE_A_ACTIVE="1"  AND (CONCAT_COLLECTION like "1 %" || CONCAT_COLLECTION like "% 1" || CONCAT_COLLECTION like "1" || CONCAT_COLLECTION like "% 1 %" ) 
AND (CONCAT_COULEUR_FLEUR like "11 %" || CONCAT_COULEUR_FLEUR like "% 11" || CONCAT_COULEUR_FLEUR like "11" || CONCAT_COULEUR_FLEUR like "% 11 %" ) order by UPPER(REPLACE(CHAR_A_TITRE,"'","")) ASC 
<br>607<br>select * from TMP_ARTICLE_SEARCH WHERE BE_A_ACTIVE="1"  AND (CONCAT_COLLECTION like "1 %" || CONCAT_COLLECTION like "% 1" || CONCAT_COLLECTION like "1" || CONCAT_COLLECTION like "% 1 %" ) 
AND (CONCAT_COULEUR_FLEUR like "12 %" || CONCAT_COULEUR_FLEUR like "% 12" || CONCAT_COULEUR_FLEUR like "12" || CONCAT_COULEUR_FLEUR like "% 12 %" ) order by UPPER(REPLACE(CHAR_A_TITRE,"'","")) ASC 
<br>212<br>select * from TMP_ARTICLE_SEARCH WHERE BE_A_ACTIVE="1"  AND (CONCAT_COLLECTION like "1 %" || CONCAT_COLLECTION like "% 1" || CONCAT_COLLECTION like "1" || CONCAT_COLLECTION like "% 1 %" ) 
AND (CONCAT_COULEUR_FLEUR like "13 %" || CONCAT_COULEUR_FLEUR like "% 13" || CONCAT_COULEUR_FLEUR like "13" || CONCAT_COULEUR_FLEUR like "% 13 %" ) order by UPPER(REPLACE(CHAR_A_TITRE,"'","")) ASC 
<br>25<br>select * from TMP_ARTICLE_SEARCH WHERE BE_A_ACTIVE="1"  AND (CONCAT_COLLECTION like "1 %" || CONCAT_COLLECTION like "% 1" || CONCAT_COLLECTION like "1" || CONCAT_COLLECTION like "% 1 %" ) 
AND (CONCAT_COULEUR_FLEUR like "14 %" || CONCAT_COULEUR_FLEUR like "% 14" || CONCAT_COULEUR_FLEUR like "14" || CONCAT_COULEUR_FLEUR like "% 14 %" ) order by UPPER(REPLACE(CHAR_A_TITRE,"'","")) ASC 
<br>24<br>select * from TMP_ARTICLE_SEARCH WHERE BE_A_ACTIVE="1"  AND (CONCAT_COLLECTION like "1 %" || CONCAT_COLLECTION like "% 1" || CONCAT_COLLECTION like "1" || CONCAT_COLLECTION like "% 1 %" ) 
AND (CONCAT_COULEUR_FLEUR like "15 %" || CONCAT_COULEUR_FLEUR like "% 15" || CONCAT_COULEUR_FLEUR like "15" || CONCAT_COULEUR_FLEUR like "% 15 %" ) order by UPPER(REPLACE(CHAR_A_TITRE,"'","")) ASC 
<br>20<br>select * from TMP_ARTICLE_SEARCH WHERE BE_A_ACTIVE="1"  AND (CONCAT_COLLECTION like "1 %" || CONCAT_COLLECTION like "% 1" || CONCAT_COLLECTION like "1" || CONCAT_COLLECTION like "% 1 %" ) 
AND (CONCAT_COULEUR_FLEUR like "16 %" || CONCAT_COULEUR_FLEUR like "% 16" || CONCAT_COULEUR_FLEUR like "16" || CONCAT_COULEUR_FLEUR like "% 16 %" ) order by UPPER(REPLACE(CHAR_A_TITRE,"'","")) ASC 
<br>26<br>select * from TMP_ARTICLE_SEARCH WHERE BE_A_ACTIVE="1"  AND (CONCAT_COLLECTION like "1 %" || CONCAT_COLLECTION like "% 1" || CONCAT_COLLECTION like "1" || CONCAT_COLLECTION like "% 1 %" ) 
AND (CONCAT_COULEUR_FLEUR like "17 %" || CONCAT_COULEUR_FLEUR like "% 17" || CONCAT_COULEUR_FLEUR like "17" || CONCAT_COULEUR_FLEUR like "% 17 %" ) order by UPPER(REPLACE(CHAR_A_TITRE,"'","")) ASC 
<br>137<br>select * from TMP_ARTICLE_SEARCH WHERE BE_A_ACTIVE="1"  AND (CONCAT_COLLECTION like "1 %" || CONCAT_COLLECTION like "% 1" || CONCAT_COLLECTION like "1" || CONCAT_COLLECTION like "% 1 %" ) 
AND (CONCAT_COULEUR_FLEUR like "18 %" || CONCAT_COULEUR_FLEUR like "% 18" || CONCAT_COULEUR_FLEUR like "18" || CONCAT_COULEUR_FLEUR like "% 18 %" ) order by UPPER(REPLACE(CHAR_A_TITRE,"'","")) ASC 
<br>73<br>select * from TMP_ARTICLE_SEARCH WHERE BE_A_ACTIVE="1"  AND (CONCAT_COLLECTION like "1 %" || CONCAT_COLLECTION like "% 1" || CONCAT_COLLECTION like "1" || CONCAT_COLLECTION like "% 1 %" ) 
AND (CONCAT_COULEUR_FLEUR like "19 %" || CONCAT_COULEUR_FLEUR like "% 19" || CONCAT_COULEUR_FLEUR like "19" || CONCAT_COULEUR_FLEUR like "% 19 %" ) order by UPPER(REPLACE(CHAR_A_TITRE,"'","")) ASC 
<br>42<br>