select * from TMP_ARTICLE_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 "5 %" || CONCAT_COULEUR_FLEUR like "% 5" || CONCAT_COULEUR_FLEUR like "5" || CONCAT_COULEUR_FLEUR like "% 5 %" ) 
AND BE_P_PRIOFLEUR<>2
order by UPPER(REPLACE(CHAR_A_TITRE,"'","")) ASC 
<br>42<br><br>CAS 1 6--->7<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 6--->7<br><br>CAS 1 7--->8<br><br>CAS 1 6--->8<br><br>CAS 1 6--->7 6<br><br>CAS 1 6--->9<br><br>CAS 1 5--->10<br><br>CAS 1 6--->9<br><br>CAS 1 7--->10<br><br>CAS 1 6--->7<br><br>CAS 1 5--->10<br><br>CAS 1 5--->7<br><br>CAS 1 6--->9<br><br>CAS 1 6--->8<br><br>CAS 1 6--->7<br><br>CAS 1 5--->6<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 5--->6<br><br>CAS 1 6--->10<br><br>CAS 1 3--->10<br><br>CAS 1 5--->6<br><br>CAS 1 8--->10<br><br>CAS 2 PAEONIA 'Claire de Lune' 5--->5<br><br>CAS 1 6--->7<br><br>CAS 1 8--->12<br><br>CAS 1 7--->11<br><br>CAS 1 7--->9<br><br>CAS 1 8--->9<br><br>CAS 1 5--->7<br><br>CAS 1 5--->11<br><br>CAS 1 5--->11<br><br>CAS 1 6--->6 0<br><br>CAS 1 6--->11<br><br>CAS 1 6--->11<br><br>CAS 1 6--->7<br><br>CAS 1 4--->5<br><br>CAS 1 7--->9<br><br>CAS 1 5--->6<br>select * from TMP_ARTICLE_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 "3 %" || CONCAT_COULEUR_FLEUR like "% 3" || CONCAT_COULEUR_FLEUR like "3" || CONCAT_COULEUR_FLEUR like "% 3 %" ) 
AND BE_P_PRIOFLEUR<>2
order by UPPER(REPLACE(CHAR_A_TITRE,"'","")) ASC 
<br>262<br><br>CAS 1 6--->9<br><br>CAS 1 7--->8<br><br>CAS 1 6--->9<br><br>CAS 1 6--->7<br><br>CAS 1 6--->9<br><br>CAS 1 7--->9<br><br>CAS 1 7--->8<br><br>CAS 1 6--->9<br><br>CAS 1 7--->8<br><br>CAS 1 7--->9<br><br>CAS 1 7--->8<br><br>CAS 1 7--->8<br><br>CAS 1 6--->9<br><br>CAS 1 6--->7<br><br>CAS 1 6--->8<br><br>CAS 1 6--->9<br><br>CAS 1 8--->9<br><br>CAS 1 7--->10<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 4--->7<br><br>CAS 1 4--->7<br><br>CAS 1 5--->7<br><br>CAS 1 6--->7<br><br>CAS 1 5--->7<br><br>CAS 1 6--->10<br><br>CAS 1 6--->10<br><br>CAS 1 5--->11<br><br>CAS 1 5--->6<br><br>CAS 1 7--->9<br><br>CAS 1 7--->9<br><br>CAS 1 8--->9<br><br>CAS 1 8--->10<br><br>CAS 1 8--->10<br><br>CAS 1 7--->10<br><br>CAS 1 7--->10<br><br>CAS 1 8--->10<br><br>CAS 1 8--->9<br><br>CAS 1 8--->9 0<br><br>CAS 1 9--->10<br><br>CAS 1 9--->10<br><br>CAS 1 9--->10<br><br>CAS 1 9--->10<br><br>CAS 1 9--->10<br><br>CAS 1 9--->10<br><br>CAS 1 8--->10<br><br>CAS 1 8--->9<br><br>CAS 1 8--->10<br><br>CAS 1 4--->6<br><br>CAS 1 5--->7<br><br>CAS 1 8--->10<br><br>CAS 1 4--->5<br><br>CAS 1 6--->8<br><br>CAS 1 4--->5<br><br>CAS 1 4--->6<br><br>CAS 1 4--->6<br><br>CAS 1 6--->8<br><br>CAS 1 6--->9<br><br>CAS 1 5--->9<br><br>CAS 1 6--->8<br><br>CAS 1 5--->9<br><br>CAS 1 6--->8<br><br>CAS 1 5--->9<br><br>CAS 1 5--->10<br><br>CAS 1 5--->10<br><br>CAS 1 6--->8<br><br>CAS 1 7--->9<br><br>CAS 1 6--->7<br><br>CAS 1 5--->8<br><br>CAS 1 8--->10<br><br>CAS 1 8--->10<br><br>CAS 1 7--->10<br><br>CAS 1 7--->8<br><br>CAS 1 4--->6<br><br>CAS 1 6--->10<br><br>CAS 1 5--->7<br><br>CAS 1 4--->9<br><br>CAS 1 5--->6<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 6--->8<br><br>CAS 1 6--->9<br><br>CAS 1 6--->8<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 6--->9<br><br>CAS 1 7--->8<br><br>CAS 1 7--->9<br><br>CAS 1 6--->8<br><br>CAS 1 6--->9<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 7--->8<br><br>CAS 1 8--->10<br><br>CAS 1 6--->8<br><br>CAS 1 7--->9<br><br>CAS 1 6--->8<br><br>CAS 1 5--->11<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 6--->10<br><br>CAS 1 6--->10<br><br>CAS 1 5--->9<br><br>CAS 1 5--->11<br><br>CAS 1 6--->7<br><br>CAS 1 5--->7<br><br>CAS 1 6--->8<br><br>CAS 1 6--->10<br><br>CAS 1 5--->7<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 5--->11<br><br>CAS 1 6--->8<br><br>CAS 1 4--->6<br><br>CAS 1 1--->5<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 4--->5<br><br>CAS 1 4--->5<br><br>CAS 1 3--->4<br><br>CAS 1 4--->5<br><br>CAS 1 4--->5<br><br>CAS 1 4--->5<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 5--->7<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 5--->7<br><br>CAS 1 6--->9<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 5--->7<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 5--->7<br><br>CAS 1 5--->7<br><br>CAS 1 8--->10<br><br>CAS 1 6--->7<br><br>CAS 1 6--->8<br><br>CAS 1 5--->6<br><br>CAS 1 5--->10<br><br>CAS 1 6--->10<br><br>CAS 1 6--->10<br><br>CAS 1 5--->10<br><br>CAS 1 6--->8<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 7--->9<br><br>CAS 1 6--->10<br><br>CAS 1 4--->9<br><br>CAS 1 6--->9<br><br>CAS 1 5--->10<br><br>CAS 1 5--->10<br><br>CAS 1 3--->5<br><br>CAS 1 3--->5<br><br>CAS 1 5--->7<br><br>CAS 1 5--->7<br><br>CAS 1 5--->8<br><br>CAS 1 6--->8<br><br>CAS 1 5--->6<br><br>CAS 1 6--->9<br><br>CAS 1 7--->9<br><br>CAS 1 8--->10<br><br>CAS 1 7--->9<br><br>CAS 1 7--->10<br><br>CAS 1 7--->9<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 5--->7<br><br>CAS 1 4--->5<br><br>CAS 1 4--->6<br><br>CAS 1 7--->8<br><br>CAS 1 7--->9<br><br>CAS 1 5--->7<br><br>CAS 1 4--->7<br><br>CAS 1 5--->7<br><br>CAS 1 3--->5<br><br>CAS 1 3--->4<br><br>CAS 1 2--->5<br><br>CAS 1 3--->7<br><br>CAS 1 2--->5<br><br>CAS 1 10--->11<br><br>CAS 1 5--->6<br><br>CAS 1 3--->4<br><br>CAS 1 5--->6<br><br>CAS 1 5--->8<br><br>CAS 1 5--->11<br><br>CAS 1 7--->10<br><br>CAS 1 5--->10<br><br>CAS 1 6--->8<br><br>CAS 1 7--->9<br><br>CAS 1 6--->9<br><br>CAS 1 7--->9<br><br>CAS 1 5--->11<br><br>CAS 1 7--->9<br><br>CAS 1 6--->10<br><br>CAS 1 6--->10<br><br>CAS 1 6--->10<br><br>CAS 1 7--->10<br><br>CAS 1 6--->8<br><br>CAS 1 8--->11<br><br>CAS 1 6--->9<br><br>CAS 1 6--->11<br><br>CAS 1 6--->11<br><br>CAS 1 4--->10<br><br>CAS 1 4--->7<br><br>CAS 1 6--->11<br><br>CAS 1 6--->7<br><br>CAS 1 7--->10<br><br>CAS 1 5--->7<br><br>CAS 1 4--->5<br><br>CAS 1 4--->6<br><br>CAS 1 5--->9<br><br>CAS 1 5--->9<br><br>CAS 1 8--->10<br><br>CAS 1 6--->9<br><br>CAS 1 4--->7<br><br>CAS 1 6--->8<br><br>CAS 1 6--->9<br><br>CAS 1 5--->7<br><br>CAS 1 5--->6<br><br>CAS 1 5--->9<br><br>CAS 1 6--->8<br><br>CAS 1 5--->6<br><br>CAS 1 6--->7<br><br>CAS 1 5--->7<br><br>CAS 1 5--->7<br><br>CAS 1 4--->7<br><br>CAS 1 7--->9<br><br>CAS 1 4--->6<br><br>CAS 1 4--->6<br><br>CAS 1 4--->6<br><br>CAS 1 4--->6<br><br>CAS 1 5--->6<br><br>CAS 1 6--->8<br>select * from TMP_ARTICLE_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 "4 %" || CONCAT_COULEUR_FLEUR like "% 4" || CONCAT_COULEUR_FLEUR like "4" || CONCAT_COULEUR_FLEUR like "% 4 %" ) 
AND BE_P_PRIOFLEUR<>2
order by UPPER(REPLACE(CHAR_A_TITRE,"'","")) ASC 
<br>27<br><br>CAS 1 9--->10<br><br>CAS 1 6--->8<br><br>CAS 1 6--->7<br><br>CAS 1 7--->9<br><br>CAS 1 7--->9<br><br>CAS 1 5--->7<br><br>CAS 1 8--->10<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 7--->9<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 7--->10<br><br>CAS 1 6--->10<br><br>CAS 1 5--->7<br><br>CAS 1 3--->5<br><br>CAS 1 6--->10<br><br>CAS 1 5--->11<br><br>CAS 1 7--->9<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br>select * from TMP_ARTICLE_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 "11 %" || CONCAT_COULEUR_FLEUR like "% 11" || CONCAT_COULEUR_FLEUR like "11" || CONCAT_COULEUR_FLEUR like "% 11 %" ) 
AND BE_P_PRIOFLEUR<>2
order by UPPER(REPLACE(CHAR_A_TITRE,"'","")) ASC 
<br>524<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 7--->8<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 6--->8<br><br>CAS 1 5--->7<br><br>CAS 1 5--->7<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 5--->10<br><br>CAS 1 6--->9<br><br>CAS 1 10--->11<br><br>CAS 1 4--->5<br><br>CAS 1 4--->7<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 6--->7<br><br>CAS 1 5--->6<br><br>CAS 1 5--->8<br><br>CAS 1 8--->9<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 5--->10<br><br>CAS 1 5--->10<br><br>CAS 1 5--->10<br><br>CAS 1 5--->10<br><br>CAS 1 5--->10<br><br>CAS 1 5--->10<br><br>CAS 1 5--->10<br><br>CAS 1 5--->10<br><br>CAS 1 6--->9<br><br>CAS 1 8--->10<br><br>CAS 1 8--->10<br><br>CAS 1 8--->11<br><br>CAS 1 8--->10<br><br>CAS 1 8--->10<br><br>CAS 1 8--->10<br><br>CAS 1 8--->10<br><br>CAS 1 8--->10<br><br>CAS 1 8--->10<br><br>CAS 1 8--->10<br><br>CAS 1 8--->10<br><br>CAS 1 8--->10<br><br>CAS 1 8--->10<br><br>CAS 1 8--->10<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 4--->5<br><br>CAS 1 4--->5<br><br>CAS 1 4--->6<br><br>CAS 1 4--->6<br><br>CAS 1 9--->10<br><br>CAS 1 8--->10<br><br>CAS 1 4--->6<br><br>CAS 1 7--->9<br><br>CAS 1 8--->10<br><br>CAS 1 8--->10<br><br>CAS 1 8--->10<br><br>CAS 1 8--->10<br><br>CAS 1 9--->10<br><br>CAS 1 9--->10<br><br>CAS 1 9--->10<br><br>CAS 1 9--->10<br><br>CAS 1 9--->10<br><br>CAS 1 7--->10<br><br>CAS 1 6--->7<br><br>CAS 1 6--->7<br><br>CAS 1 6--->7<br><br>CAS 1 7--->8<br><br>CAS 1 7--->9<br><br>CAS 1 7--->8<br><br>CAS 1 6--->7<br><br>CAS 1 6--->7<br><br>CAS 1 6--->7<br><br>CAS 1 6--->7<br><br>CAS 1 6--->7<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 6--->7<br><br>CAS 1 4--->5<br><br>CAS 1 4--->5<br><br>CAS 1 7--->11<br><br>CAS 1 4--->5<br><br>CAS 1 3--->4<br><br>CAS 1 4--->5<br><br>CAS 1 3--->4<br><br>CAS 3 12--->4<br><br>CAS 1 3--->4<br><br>CAS 1 3--->4<br><br>CAS 1 4--->6<br><br>CAS 1 2--->4<br><br>CAS 1 6--->8<br><br>CAS 1 8--->11<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 8--->12<br><br>CAS 1 8--->10<br><br>CAS 1 6--->10<br><br>CAS 1 5--->10<br><br>CAS 1 6--->8<br><br>CAS 1 5--->7<br><br>CAS 1 5--->6<br><br>CAS 1 9--->10<br><br>CAS 1 4--->7<br><br>CAS 1 5--->7<br><br>CAS 1 5--->7<br><br>CAS 1 5--->7<br><br>CAS 1 5--->7<br><br>CAS 1 5--->9<br><br>CAS 1 5--->6<br><br>CAS 1 3--->5<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 6--->10<br><br>CAS 1 5--->9<br><br>CAS 1 7--->8<br><br>CAS 1 6--->7<br><br>CAS 3 12--->3<br><br>CAS 1 9--->11<br><br>CAS 1 6--->10<br><br>CAS 1 6--->10<br><br>CAS 1 5--->9<br><br>CAS 1 5--->10<br><br>CAS 1 6--->10<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 6--->8<br><br>CAS 1 5--->7<br><br>CAS 1 6--->8<br><br>CAS 1 5--->7<br><br>CAS 1 5--->7<br><br>CAS 1 5--->8<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 5--->7<br><br>CAS 1 5--->10<br><br>CAS 1 5--->10<br><br>CAS 1 5--->8<br><br>CAS 1 4--->6<br><br>CAS 1 6--->8<br><br>CAS 1 5--->7<br><br>CAS 1 6--->10<br><br>CAS 1 5--->8<br><br>CAS 1 6--->8<br><br>CAS 1 7--->8<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 7--->9<br><br>CAS 1 6--->9<br><br>CAS 1 6--->11<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 6--->8<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 7--->9<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 6--->8<br><br>CAS 1 6--->9<br><br>CAS 1 3--->5<br><br>CAS 1 3--->5<br><br>CAS 1 3--->5<br><br>CAS 1 4--->5<br><br>CAS 1 6--->7<br><br>CAS 1 8--->10<br><br>CAS 1 6--->10<br><br>CAS 1 1--->5<br><br>CAS 1 7--->9<br><br>CAS 1 6--->9<br><br>CAS 3 10--->4<br><br>CAS 3 10--->4<br><br>CAS 1 3--->5<br><br>CAS 1 6--->10<br><br>CAS 1 7--->10<br><br>CAS 1 7--->10<br><br>CAS 1 6--->8<br><br>CAS 1 5--->11<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 5--->9<br><br>CAS 1 5--->10<br><br>CAS 1 5--->9<br><br>CAS 1 5--->7<br><br>CAS 1 7--->9<br><br>CAS 1 7--->9<br><br>CAS 1 8--->10<br><br>CAS 1 4--->7<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 7--->8<br><br>CAS 1 6--->7<br><br>CAS 1 5--->7<br><br>CAS 1 6--->10<br><br>CAS 1 6--->11<br><br>CAS 1 6--->10<br><br>CAS 1 7--->10<br><br>CAS 1 6--->10<br><br>CAS 1 6--->10<br><br>CAS 1 6--->10<br><br>CAS 1 6--->9<br><br>CAS 1 5--->8<br><br>CAS 1 5--->7<br><br>CAS 1 5--->7<br><br>CAS 1 5--->7<br><br>CAS 1 4--->9<br><br>CAS 1 5--->9<br><br>CAS 1 5--->10<br><br>CAS 1 5--->9<br><br>CAS 1 5--->9<br><br>CAS 1 5--->9<br><br>CAS 1 5--->7<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 6--->10<br><br>CAS 1 7--->10<br><br>CAS 1 5--->11<br><br>CAS 1 5--->10<br><br>CAS 1 5--->10<br><br>CAS 1 5--->10<br><br>CAS 1 6--->10<br><br>CAS 1 5--->7<br><br>CAS 1 5--->7<br><br>CAS 1 5--->7<br><br>CAS 1 5--->9<br><br>CAS 1 6--->10<br><br>CAS 1 6--->9<br><br>CAS 1 6--->10<br><br>CAS 1 6--->7<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 7--->11<br><br>CAS 1 6--->10<br><br>CAS 1 5--->7<br><br>CAS 1 6--->10<br><br>CAS 1 6--->9<br><br>CAS 1 5--->10<br><br>CAS 1 6--->10<br><br>CAS 1 5--->10<br><br>CAS 1 5--->10<br><br>CAS 1 5--->10<br><br>CAS 1 5--->10<br><br>CAS 1 5--->10<br><br>CAS 1 5--->10<br><br>CAS 1 7--->10<br><br>CAS 1 5--->10<br><br>CAS 1 7--->10<br><br>CAS 1 5--->10<br><br>CAS 1 4--->6<br><br>CAS 1 4--->6<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 5--->8<br><br>CAS 1 5--->8<br><br>CAS 1 5--->8<br><br>CAS 1 5--->8<br><br>CAS 1 5--->8<br><br>CAS 3 12--->3<br><br>CAS 1 2--->4<br><br>CAS 1 2--->4<br><br>CAS 1 2--->4<br><br>CAS 1 1--->4<br><br>CAS 1 1--->3<br><br>CAS 1 7--->8<br><br>CAS 1 6--->8<br><br>CAS 1 6--->7<br><br>CAS 1 6--->7<br><br>CAS 1 6--->7<br><br>CAS 1 7--->8<br><br>CAS 1 6--->7<br><br>CAS 1 6--->7<br><br>CAS 1 6--->7<br><br>CAS 1 6--->9<br><br>CAS 1 7--->9<br><br>CAS 1 4--->10<br><br>CAS 1 7--->8<br><br>CAS 1 5--->8<br><br>CAS 1 6--->9<br><br>CAS 1 5--->6<br><br>CAS 1 6--->9<br><br>CAS 1 6--->7<br><br>CAS 1 7--->9<br><br>CAS 1 4--->6<br><br>CAS 1 5--->7<br><br>CAS 1 4--->6<br><br>CAS 3 12--->5<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 4--->5<br><br>CAS 1 3--->4<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 4--->6<br><br>CAS 1 4--->6<br><br>CAS 1 4--->6<br><br>CAS 1 6--->9<br><br>CAS 1 6--->8<br><br>CAS 1 5--->7<br><br>CAS 1 5--->6<br><br>CAS 1 4--->7<br><br>CAS 1 6--->10<br><br>CAS 1 7--->9<br><br>CAS 1 7--->10<br><br>CAS 1 7--->10<br><br>CAS 1 6--->9<br><br>CAS 1 6--->8<br><br>CAS 1 6--->7<br><br>CAS 1 5--->7<br><br>CAS 1 7--->9<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8 0<br><br>CAS 1 6--->8<br><br>CAS 1 7--->9<br><br>CAS 1 6--->8<br><br>CAS 1 6--->11<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 7--->9<br><br>CAS 1 6--->9<br><br>CAS 1 6--->8<br><br>CAS 1 4--->9<br><br>CAS 1 8--->11<br><br>CAS 1 6--->10<br><br>CAS 1 6--->10<br><br>CAS 1 5--->10<br><br>CAS 1 6--->8<br><br>CAS 1 7--->9<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 5--->9<br><br>CAS 1 7--->9<br><br>CAS 1 5--->9<br><br>CAS 1 7--->9<br><br>CAS 1 7--->9<br><br>CAS 1 6--->9<br><br>CAS 1 6--->7<br><br>CAS 1 6--->7<br><br>CAS 1 6--->7<br><br>CAS 2 PAEONIA 'Coral Charm' 5--->5<br><br>CAS 1 6--->7<br><br>CAS 1 6--->7<br><br>CAS 1 6--->7<br><br>CAS 1 6--->7<br><br>CAS 1 6--->7<br><br>CAS 1 6--->7<br><br>CAS 1 6--->7<br><br>CAS 1 6--->7<br><br>CAS 1 6--->7<br><br>CAS 1 6--->7<br><br>CAS 1 6--->7<br><br>CAS 1 6--->7<br><br>CAS 1 4--->6<br><br>CAS 1 4--->6<br><br>CAS 1 8--->12<br><br>CAS 1 8--->12<br><br>CAS 1 7--->9<br><br>CAS 1 8--->12<br><br>CAS 1 6--->10<br><br>CAS 1 7--->9<br><br>CAS 1 7--->9<br><br>CAS 1 6--->10<br><br>CAS 1 0--->0 6<br><br>CAS 1 7--->8<br><br>CAS 1 6--->10<br><br>CAS 1 6--->10<br><br>CAS 1 6--->10<br><br>CAS 1 6--->10<br><br>CAS 1 6--->10<br><br>CAS 1 6--->10<br><br>CAS 1 4--->7<br><br>CAS 1 5--->10<br><br>CAS 1 4--->7<br><br>CAS 1 7--->10<br><br>CAS 1 7--->10<br><br>CAS 1 7--->10<br><br>CAS 1 6--->9<br><br>CAS 1 7--->10<br><br>CAS 1 4--->6<br><br>CAS 1 7--->10<br><br>CAS 1 5--->9<br><br>CAS 1 5--->7<br><br>CAS 1 5--->6<br><br>CAS 1 6--->8<br><br>CAS 1 7--->9<br><br>CAS 1 6--->9<br><br>CAS 1 5--->6<br><br>CAS 1 4--->5<br><br>CAS 1 7--->9<br><br>CAS 1 6--->9<br><br>CAS 1 7--->9<br><br>CAS 1 7--->9<br><br>CAS 1 4--->5<br><br>CAS 1 4--->5<br><br>CAS 1 6--->9<br><br>CAS 1 4--->5<br><br>CAS 1 6--->9<br><br>CAS 1 5--->9<br><br>CAS 1 6--->8<br><br>CAS 1 7--->9<br><br>CAS 1 5--->7<br><br>CAS 1 6--->8<br><br>CAS 1 3--->5<br><br>CAS 1 3--->4<br><br>CAS 1 6--->7<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 2--->5<br><br>CAS 1 2--->5<br><br>CAS 1 3--->5<br><br>CAS 1 3--->5<br><br>CAS 1 4--->5<br><br>CAS 1 3--->7<br><br>CAS 1 4--->5<br><br>CAS 1 6--->7<br><br>CAS 1 5--->6<br><br>CAS 1 5--->11<br><br>CAS 1 7--->11<br><br>CAS 1 5--->11<br><br>CAS 1 7--->10<br><br>CAS 1 5--->10<br><br>CAS 1 5--->11<br><br>CAS 1 5--->8<br><br>CAS 1 6--->8<br><br>CAS 1 6--->9<br><br>CAS 1 6--->10<br><br>CAS 1 6--->10<br><br>CAS 1 6--->10<br><br>CAS 1 6--->9<br><br>CAS 1 7--->10<br><br>CAS 1 7--->9<br><br>CAS 1 6--->8<br><br>CAS 1 7--->8<br><br>CAS 1 6--->8<br><br>CAS 1 6--->9<br><br>CAS 1 5--->7<br><br>CAS 1 6--->9<br><br>CAS 1 4--->6<br><br>CAS 1 4--->6<br><br>CAS 1 4--->6<br><br>CAS 1 6--->10<br><br>CAS 1 9--->12<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 8--->10<br><br>CAS 1 8--->10<br><br>CAS 1 8--->10<br><br>CAS 1 8--->9<br><br>CAS 1 7--->10<br><br>CAS 1 7--->10<br><br>CAS 1 7--->10<br><br>CAS 1 8--->9<br><br>CAS 1 8--->9<br><br>CAS 1 8--->9<br><br>CAS 1 9--->10<br><br>CAS 1 8--->9<br><br>CAS 1 8--->10<br><br>CAS 1 5--->7<br><br>CAS 1 5--->6<br><br>CAS 1 6--->9<br><br>CAS 1 7--->9<br><br>CAS 1 6--->7<br><br>CAS 1 6--->7<br><br>CAS 1 6--->7<br><br>CAS 1 7--->10<br><br>CAS 1 6--->9<br><br>CAS 1 4--->5<br><br>CAS 1 7--->8<br><br>CAS 1 5--->6<br><br>CAS 1 7--->11<br><br>CAS 1 6--->8<br><br>CAS 1 7--->8<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 6--->7<br><br>CAS 1 6--->8<br><br>CAS 1 4--->6<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 6--->7<br><br>CAS 1 4--->7<br><br>CAS 1 4--->6<br><br>CAS 1 5--->6<br><br>CAS 1 7--->10<br><br>CAS 1 5--->6<br><br>CAS 1 4--->6<br><br>CAS 1 6--->8<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 5--->10<br><br>CAS 1 6--->9<br><br>CAS 1 8--->10<br><br>CAS 1 5--->6<br><br>CAS 1 6--->9<br><br>CAS 1 6--->8<br><br>CAS 1 5--->7<br><br>CAS 1 7--->8<br><br>CAS 1 6--->9<br><br>CAS 1 7--->9<br><br>CAS 1 7--->9<br>select * from TMP_ARTICLE_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 "12 %" || CONCAT_COULEUR_FLEUR like "% 12" || CONCAT_COULEUR_FLEUR like "12" || CONCAT_COULEUR_FLEUR like "% 12 %" ) 
AND BE_P_PRIOFLEUR<>2
order by UPPER(REPLACE(CHAR_A_TITRE,"'","")) ASC 
<br>192<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 6--->8<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 6--->10<br><br>CAS 1 6--->10<br><br>CAS 1 7--->9<br><br>CAS 1 6--->9<br><br>CAS 1 5--->10<br><br>CAS 1 5--->10<br><br>CAS 1 5--->10<br><br>CAS 1 5--->10<br><br>CAS 1 5--->10<br><br>CAS 1 5--->10<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 5--->8<br><br>CAS 1 9--->10<br><br>CAS 1 6--->7<br><br>CAS 1 6--->7<br><br>CAS 1 6--->7<br><br>CAS 1 6--->7<br><br>CAS 1 6--->8<br><br>CAS 1 6--->9<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 6--->7<br><br>CAS 1 5--->9<br><br>CAS 1 6--->10<br><br>CAS 1 5--->9<br><br>CAS 1 7--->10<br><br>CAS 1 6--->9<br><br>CAS 1 6--->10<br><br>CAS 1 6--->10<br><br>CAS 1 6--->10<br><br>CAS 1 7--->10<br><br>CAS 1 7--->10<br><br>CAS 1 5--->8<br><br>CAS 1 4--->10<br><br>CAS 1 5--->7<br><br>CAS 1 5--->7<br><br>CAS 1 5--->7<br><br>CAS 1 5--->7<br><br>CAS 1 0--->0 5<br><br>CAS 1 5--->8<br><br>CAS 1 5--->6<br><br>CAS 1 6--->9<br><br>CAS 1 7--->9<br><br>CAS 1 6--->9<br><br>CAS 1 6--->10<br><br>CAS 1 6--->8<br><br>CAS 1 7--->9<br><br>CAS 1 6--->9<br><br>CAS 1 4--->5<br><br>CAS 1 4--->5<br><br>CAS 1 1--->5<br><br>CAS 1 7--->9<br><br>CAS 3 10--->4<br><br>CAS 1 6--->10<br><br>CAS 1 6--->10<br><br>CAS 1 6--->10<br><br>CAS 1 6--->8<br><br>CAS 1 7--->11<br><br>CAS 1 6--->10<br><br>CAS 1 6--->10<br><br>CAS 1 5--->7<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 5--->7<br><br>CAS 1 5--->8<br><br>CAS 1 5--->8<br><br>CAS 1 5--->10<br><br>CAS 1 5--->8<br><br>CAS 1 5--->7<br><br>CAS 1 5--->7<br><br>CAS 1 7--->9<br><br>CAS 1 7--->9<br><br>CAS 1 6--->8<br><br>CAS 1 6--->9<br><br>CAS 1 7--->9<br><br>CAS 1 7--->8<br><br>CAS 1 7--->9<br><br>CAS 1 7--->9<br><br>CAS 1 5--->8<br><br>CAS 1 5--->8<br><br>CAS 1 4--->7<br><br>CAS 3 12--->5<br><br>CAS 1 7--->8<br><br>CAS 1 7--->8<br><br>CAS 1 6--->7<br><br>CAS 1 6--->7<br><br>CAS 1 7--->8<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 5--->10<br><br>CAS 1 5--->6<br><br>CAS 1 7--->8<br><br>CAS 1 7--->8<br><br>CAS 1 6--->7<br><br>CAS 1 6--->7<br><br>CAS 1 5--->7<br><br>CAS 1 5--->7<br><br>CAS 1 7--->9<br><br>CAS 3 5--->0 5<br><br>CAS 1 5--->6<br><br>CAS 1 7--->9<br><br>CAS 1 5--->9<br><br>CAS 1 5--->9<br><br>CAS 1 6--->10<br><br>CAS 1 6--->9<br><br>CAS 1 6--->10<br><br>CAS 1 6--->7<br><br>CAS 1 6--->7<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 7--->10<br><br>CAS 1 7--->10<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 6--->10<br><br>CAS 1 6--->7<br><br>CAS 1 6--->7<br><br>CAS 1 6--->7<br><br>CAS 1 6--->7<br><br>CAS 1 6--->7<br><br>CAS 1 6--->7<br><br>CAS 1 4--->6<br><br>CAS 1 4--->6<br><br>CAS 1 0--->0 5<br><br>CAS 1 6--->9<br><br>CAS 1 6--->10<br><br>CAS 1 5--->8<br><br>CAS 1 6--->10<br><br>CAS 1 0--->0 6<br><br>CAS 1 6--->9<br><br>CAS 1 5--->9<br><br>CAS 1 5--->9<br><br>CAS 1 5--->7<br><br>CAS 1 4--->7<br><br>CAS 1 7--->10<br><br>CAS 1 6--->9<br><br>CAS 1 7--->9<br><br>CAS 1 7--->10<br><br>CAS 1 7--->9<br><br>CAS 1 7--->9<br><br>CAS 1 4--->5<br><br>CAS 1 6--->9<br><br>CAS 1 4--->5<br><br>CAS 1 6--->9<br><br>CAS 1 8--->9<br><br>CAS 1 6--->8<br><br>CAS 1 7--->9<br><br>CAS 1 4--->5<br><br>CAS 1 6--->10<br><br>CAS 1 6--->11<br><br>CAS 1 5--->11<br><br>CAS 1 7--->11<br><br>CAS 1 5--->11<br><br>CAS 1 5--->11<br><br>CAS 1 7--->9<br><br>CAS 1 5--->10<br><br>CAS 1 5--->6<br><br>CAS 1 5--->7<br><br>CAS 1 7--->8<br><br>CAS 1 9--->12<br><br>CAS 1 9--->12<br><br>CAS 1 5--->9<br><br>CAS 1 6--->9<br><br>CAS 1 7--->9<br><br>CAS 1 8--->9<br><br>CAS 1 8--->9 4<br><br>CAS 1 6--->8<br><br>CAS 1 5--->9<br><br>CAS 1 6--->8<br><br>CAS 1 9--->11<br><br>CAS 1 5--->9<br><br>CAS 1 6--->8<br><br>CAS 1 5--->10<br><br>CAS 1 5--->10<br><br>CAS 1 7--->9<br><br>CAS 1 7--->9<br><br>CAS 1 5--->10<br><br>CAS 1 7--->9<br>select * from TMP_ARTICLE_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 "13 %" || CONCAT_COULEUR_FLEUR like "% 13" || CONCAT_COULEUR_FLEUR like "13" || CONCAT_COULEUR_FLEUR like "% 13 %" ) 
AND BE_P_PRIOFLEUR<>2
order by UPPER(REPLACE(CHAR_A_TITRE,"'","")) ASC 
<br>21<br><br>CAS 1 6--->8<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 7--->10<br><br>CAS 1 6--->9<br><br>CAS 1 5--->6<br><br>CAS 1 4--->6<br><br>CAS 1 1--->4<br><br>CAS 1 6--->9<br><br>CAS 1 6--->8<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 6--->10<br><br>CAS 2 PAEONIA 'Early Scout' 5--->5<br><br>CAS 1 7--->9<br><br>CAS 1 6--->8<br><br>CAS 1 6--->7<br><br>CAS 1 6--->9<br><br>CAS 1 8--->10<br>select * from TMP_ARTICLE_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 "17 %" || CONCAT_COULEUR_FLEUR like "% 17" || CONCAT_COULEUR_FLEUR like "17" || CONCAT_COULEUR_FLEUR like "% 17 %" ) 
AND BE_P_PRIOFLEUR<>2
order by UPPER(REPLACE(CHAR_A_TITRE,"'","")) ASC 
<br>116<br><br>CAS 1 7--->9<br><br>CAS 1 6--->8<br><br>CAS 1 6--->9<br><br>CAS 1 8--->9<br><br>CAS 1 5--->8<br><br>CAS 1 5--->10<br><br>CAS 1 5--->6<br><br>CAS 1 4--->6<br><br>CAS 1 7--->9<br><br>CAS 1 7--->9<br><br>CAS 1 8--->10<br><br>CAS 1 8--->11<br><br>CAS 1 9--->10<br><br>CAS 1 9--->10<br><br>CAS 1 9--->11<br><br>CAS 1 8--->10<br><br>CAS 1 4--->5<br><br>CAS 1 4--->5<br><br>CAS 1 4--->5<br><br>CAS 1 6--->8<br><br>CAS 1 5--->9<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 7--->8<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 6--->10<br><br>CAS 1 6--->8<br><br>CAS 1 4--->7<br><br>CAS 1 6--->10<br><br>CAS 1 6--->10<br><br>CAS 1 7--->11<br><br>CAS 1 6--->10<br><br>CAS 1 6--->10<br><br>CAS 1 6--->8<br><br>CAS 1 6--->10<br><br>CAS 1 5--->8<br><br>CAS 1 5--->10<br><br>CAS 1 4--->6<br><br>CAS 1 7--->10<br><br>CAS 1 6--->8<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 4--->5<br><br>CAS 1 4--->5<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 2 IRIS tectorum 5--->5<br><br>CAS 1 1--->3<br><br>CAS 1 5--->7<br><br>CAS 1 4--->5<br><br>CAS 1 6--->8<br><br>CAS 1 7--->8<br><br>CAS 1 6--->8<br><br>CAS 1 6--->7<br><br>CAS 1 5--->7<br><br>CAS 1 7--->10<br><br>CAS 1 7--->10<br><br>CAS 1 7--->9<br><br>CAS 1 8--->10<br><br>CAS 1 8--->9<br><br>CAS 1 6--->9<br><br>CAS 1 5--->7<br><br>CAS 1 6--->10<br><br>CAS 1 6--->10<br><br>CAS 1 5--->10<br><br>CAS 1 6--->10<br><br>CAS 1 0--->0 6<br><br>CAS 1 6--->10<br><br>CAS 1 5--->6<br><br>CAS 1 6--->9<br><br>CAS 1 3--->5<br><br>CAS 1 4--->5<br><br>CAS 1 5--->10<br><br>CAS 1 5--->10<br><br>CAS 1 7--->11<br><br>CAS 1 5--->7<br><br>CAS 1 5--->7<br><br>CAS 1 5--->8<br><br>CAS 1 5--->7<br><br>CAS 1 6--->10<br><br>CAS 1 6--->10<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 3--->5<br><br>CAS 1 5--->9<br><br>CAS 1 8--->10<br><br>CAS 1 7--->11<br><br>CAS 1 7--->10<br><br>CAS 1 6--->10<br><br>CAS 1 4--->10<br><br>CAS 1 6--->8<br><br>CAS 1 4--->6<br><br>CAS 1 2--->5<br><br>CAS 1 5--->6<br>select * from TMP_ARTICLE_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 "7 %" || CONCAT_COULEUR_FLEUR like "% 7" || CONCAT_COULEUR_FLEUR like "7" || CONCAT_COULEUR_FLEUR like "% 7 %" ) 
AND BE_P_PRIOFLEUR<>2
order by UPPER(REPLACE(CHAR_A_TITRE,"'","")) ASC 
<br>61<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 7--->8<br><br>CAS 1 7--->9<br><br>CAS 1 6--->10<br><br>CAS 1 5--->8<br><br>CAS 1 9--->10<br><br>CAS 1 7--->9<br><br>CAS 1 7--->8<br><br>CAS 1 5--->7<br><br>CAS 1 7--->10<br><br>CAS 1 8--->9<br><br>CAS 1 7--->9<br><br>CAS 1 8--->10<br><br>CAS 1 6--->8<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 6--->8<br><br>CAS 1 4--->5<br><br>CAS 1 6--->9<br><br>CAS 1 5--->11<br><br>CAS 1 6--->9<br><br>CAS 1 4--->9<br><br>CAS 1 2--->6<br><br>CAS 1 5--->9<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 5--->7<br><br>CAS 1 3--->5<br><br>CAS 1 6--->7<br><br>CAS 1 6--->8<br><br>CAS 1 6--->7<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 6--->9<br><br>CAS 1 5--->9<br><br>CAS 1 6--->10<br><br>CAS 1 6--->8<br><br>CAS 1 8--->10<br><br>CAS 1 4--->6<br><br>CAS 1 6--->9<br><br>CAS 1 6--->8<br><br>CAS 1 0--->0 5<br><br>CAS 1 6--->10<br><br>CAS 1 4--->5<br><br>CAS 1 5--->7<br><br>CAS 1 4--->5<br><br>CAS 1 3--->5<br><br>CAS 1 6--->8<br><br>CAS 1 7--->9<br><br>CAS 1 6--->8<br><br>CAS 1 5--->9<br><br>CAS 1 4--->6<br><br>CAS 1 7--->8<br><br>CAS 1 7--->8<br><br>CAS 1 8--->9<br><br>CAS 1 7--->9<br><br>CAS 1 6--->10<br><br>CAS 1 7--->10<br><br>CAS 1 6--->9<br><br>CAS 1 7--->9<br>select * from TMP_ARTICLE_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 "10 %" || CONCAT_COULEUR_FLEUR like "% 10" || CONCAT_COULEUR_FLEUR like "10" || CONCAT_COULEUR_FLEUR like "% 10 %" ) 
AND BE_P_PRIOFLEUR<>2
order by UPPER(REPLACE(CHAR_A_TITRE,"'","")) ASC 
<br>54<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 5--->6<br><br>CAS 1 5--->8<br><br>CAS 1 5--->8<br><br>CAS 1 8--->9<br><br>CAS 1 6--->9<br><br>CAS 1 7--->9<br><br>CAS 1 6--->10<br><br>CAS 1 6--->10<br><br>CAS 1 6--->10<br><br>CAS 1 5--->10<br><br>CAS 1 5--->9<br><br>CAS 1 6--->9<br><br>CAS 1 6--->10<br><br>CAS 1 5--->7<br><br>CAS 1 2--->4<br><br>CAS 1 1--->3<br><br>CAS 1 1--->3<br><br>CAS 1 1--->3<br><br>CAS 1 5--->6<br><br>CAS 1 7--->9<br><br>CAS 1 6--->9<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 7--->9<br><br>CAS 1 6--->7<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 5--->8<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 4--->5<br><br>CAS 1 4--->5<br><br>CAS 1 5--->6<br><br>CAS 1 5--->8<br><br>CAS 1 5--->7<br><br>CAS 1 4--->6<br><br>CAS 1 4--->6<br><br>CAS 1 4--->6<br><br>CAS 1 4--->6<br><br>CAS 1 5--->8<br><br>CAS 1 5--->10<br><br>CAS 1 6--->10<br><br>CAS 1 0--->0 6<br><br>CAS 1 5--->7<br><br>CAS 1 6--->10<br><br>CAS 1 9--->10<br><br>CAS 1 5--->7<br><br>CAS 1 4--->6<br>select * from TMP_ARTICLE_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 "9 %" || CONCAT_COULEUR_FLEUR like "% 9" || CONCAT_COULEUR_FLEUR like "9" || CONCAT_COULEUR_FLEUR like "% 9 %" ) 
AND BE_P_PRIOFLEUR<>2
order by UPPER(REPLACE(CHAR_A_TITRE,"'","")) ASC 
<br>76<br><br>CAS 1 6--->9<br><br>CAS 1 6--->7<br><br>CAS 1 6--->9<br><br>CAS 1 6--->10<br><br>CAS 1 6--->9<br><br>CAS 1 6--->10<br><br>CAS 1 5--->10<br><br>CAS 1 5--->10<br><br>CAS 1 5--->10<br><br>CAS 1 5--->10<br><br>CAS 1 5--->10<br><br>CAS 1 5--->10<br><br>CAS 1 5--->10<br><br>CAS 1 7--->9<br><br>CAS 1 7--->8<br><br>CAS 1 6--->10<br><br>CAS 1 7--->8 0<br><br>CAS 1 6--->10<br><br>CAS 1 7--->10<br><br>CAS 1 6--->10<br><br>CAS 1 6--->9<br><br>CAS 1 6--->7<br><br>CAS 1 7--->9<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 7--->9<br><br>CAS 1 6--->9<br><br>CAS 1 7--->9<br><br>CAS 1 6--->9<br><br>CAS 1 4--->5<br><br>CAS 1 5--->7<br><br>CAS 1 7--->9<br><br>CAS 1 5--->9<br><br>CAS 1 5--->8<br><br>CAS 1 5--->8<br><br>CAS 1 5--->8<br><br>CAS 1 5--->8<br><br>CAS 1 4--->7<br><br>CAS 1 5--->9<br><br>CAS 1 5--->8<br><br>CAS 1 5--->7<br><br>CAS 1 7--->9<br><br>CAS 1 5--->8<br><br>CAS 1 5--->8<br><br>CAS 1 5--->8<br><br>CAS 1 6--->9<br><br>CAS 1 1--->3<br><br>CAS 1 6--->7<br><br>CAS 1 7--->8<br><br>CAS 1 7--->8<br><br>CAS 1 7--->8<br><br>CAS 1 6--->8<br><br>CAS 1 6--->9<br><br>CAS 1 5--->6<br><br>CAS 1 7--->9<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 4--->5<br><br>CAS 1 4--->5<br><br>CAS 1 6--->9<br><br>CAS 1 6--->10<br><br>CAS 1 6--->10<br><br>CAS 1 6--->10<br><br>CAS 1 6--->10<br><br>CAS 1 5--->9<br><br>CAS 1 5--->9<br><br>CAS 1 8--->10<br><br>CAS 1 6--->10<br><br>CAS 1 5--->10<br><br>CAS 1 6--->7<br><br>CAS 1 4--->6<br><br>CAS 1 6--->9<br><br>CAS 1 6--->11<br><br>CAS 1 9--->11<br>select * from TMP_ARTICLE_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 "14 %" || CONCAT_COULEUR_FLEUR like "% 14" || CONCAT_COULEUR_FLEUR like "14" || CONCAT_COULEUR_FLEUR like "% 14 %" ) 
AND BE_P_PRIOFLEUR<>2
order by UPPER(REPLACE(CHAR_A_TITRE,"'","")) ASC 
<br>25<br><br>CAS 1 6--->10<br><br>CAS 1 6--->10<br><br>CAS 1 6--->9<br><br>CAS 1 5--->10<br><br>CAS 1 5--->10<br><br>CAS 1 7--->10<br><br>CAS 1 6--->8<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 3--->5<br><br>CAS 1 5--->7<br><br>CAS 1 6--->7<br><br>CAS 1 5--->7<br><br>CAS 1 1--->3<br><br>CAS 1 7--->8<br><br>CAS 3 5--->0 5<br><br>CAS 1 5--->6<br><br>CAS 1 3--->4<br><br>CAS 1 5--->10<br><br>CAS 1 5--->7<br><br>CAS 1 4--->6<br><br>CAS 1 4--->6<br><br>CAS 1 4--->6<br><br>CAS 1 5--->11<br><br>CAS 1 5--->10<br>select * from TMP_ARTICLE_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 "6 %" || CONCAT_COULEUR_FLEUR like "% 6" || CONCAT_COULEUR_FLEUR like "6" || CONCAT_COULEUR_FLEUR like "% 6 %" ) 
AND BE_P_PRIOFLEUR<>2
order by UPPER(REPLACE(CHAR_A_TITRE,"'","")) ASC 
<br>223<br><br>CAS 1 6--->7<br><br>CAS 1 5--->7<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 6--->9<br><br>CAS 1 6--->7<br><br>CAS 1 6--->9<br><br>CAS 1 10--->11<br><br>CAS 1 6--->9<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 6--->7<br><br>CAS 1 5--->10<br><br>CAS 1 4--->5<br><br>CAS 1 5--->9<br><br>CAS 1 5--->6<br><br>CAS 1 6--->9<br><br>CAS 1 5--->9<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 8--->9<br><br>CAS 1 4--->5<br><br>CAS 1 5--->7<br><br>CAS 1 6--->8<br><br>CAS 1 7--->10<br><br>CAS 1 6--->9<br><br>CAS 1 3--->5<br><br>CAS 1 7--->9<br><br>CAS 1 6--->7<br><br>CAS 1 5--->9<br><br>CAS 1 6--->10<br><br>CAS 1 7--->10<br><br>CAS 1 5--->9<br><br>CAS 1 5--->9<br><br>CAS 1 5--->9<br><br>CAS 1 5--->9<br><br>CAS 1 5--->9<br><br>CAS 1 5--->9<br><br>CAS 1 5--->9<br><br>CAS 1 5--->10<br><br>CAS 1 5--->9<br><br>CAS 1 6--->10<br><br>CAS 1 6--->10<br><br>CAS 1 6--->10<br><br>CAS 1 6--->10<br><br>CAS 1 6--->8<br><br>CAS 1 4--->6<br><br>CAS 1 6--->10<br><br>CAS 1 7--->10<br><br>CAS 1 6--->9<br><br>CAS 1 4--->10<br><br>CAS 1 6--->10<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 6--->9<br><br>CAS 1 4--->5<br><br>CAS 1 6--->9<br><br>CAS 1 6--->8<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 4--->5<br><br>CAS 1 3--->5<br><br>CAS 1 3--->5<br><br>CAS 1 5--->7<br><br>CAS 1 4--->6<br><br>CAS 1 4--->7<br><br>CAS 1 5--->6<br><br>CAS 1 4--->5<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 4--->5<br><br>CAS 1 6--->10<br><br>CAS 1 7--->10<br><br>CAS 1 5--->7<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 5--->7<br><br>CAS 1 6--->9<br><br>CAS 1 5--->7<br><br>CAS 1 5--->8<br><br>CAS 1 6--->9<br><br>CAS 1 8--->11<br><br>CAS 1 7--->9<br><br>CAS 1 7--->9<br><br>CAS 1 5--->6<br><br>CAS 1 7--->9<br><br>CAS 1 7--->9<br><br>CAS 1 6--->9<br><br>CAS 1 7--->9<br><br>CAS 1 7--->9<br><br>CAS 1 5--->8<br><br>CAS 1 5--->8<br><br>CAS 1 5--->8<br><br>CAS 1 5--->8<br><br>CAS 1 7--->10<br><br>CAS 1 7--->10<br><br>CAS 1 7--->10<br><br>CAS 1 8--->10<br><br>CAS 1 9--->10<br><br>CAS 1 7--->11<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 7--->9<br><br>CAS 1 7--->9<br><br>CAS 1 1--->3<br><br>CAS 1 6--->8<br><br>CAS 1 6--->7<br><br>CAS 1 7--->9<br><br>CAS 1 7--->8<br><br>CAS 1 7--->9<br><br>CAS 1 6--->7<br><br>CAS 1 7--->8<br><br>CAS 1 6--->7<br><br>CAS 1 6--->9<br><br>CAS 1 6--->7<br><br>CAS 1 6--->7<br><br>CAS 1 6--->7<br><br>CAS 1 7--->8<br><br>CAS 1 7--->8<br><br>CAS 1 5--->7<br><br>CAS 1 6--->9<br><br>CAS 1 6--->7<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 5--->8<br><br>CAS 1 6--->8<br><br>CAS 1 7--->9<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 6--->8<br><br>CAS 1 7--->9<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 6--->8<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 4--->5<br><br>CAS 1 3--->4<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 8--->10<br><br>CAS 1 6--->10<br><br>CAS 1 7--->9<br><br>CAS 1 6--->9<br><br>CAS 1 6--->10<br><br>CAS 1 7--->9<br><br>CAS 1 6--->10<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 5--->7<br><br>CAS 1 6--->9<br><br>CAS 1 6--->7<br><br>CAS 1 5--->7<br><br>CAS 1 6--->8<br><br>CAS 1 6--->9<br><br>CAS 1 5--->10<br><br>CAS 1 6--->10<br><br>CAS 1 6--->8<br><br>CAS 1 6--->10<br><br>CAS 1 6--->9<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 5--->8<br><br>CAS 1 6--->8<br><br>CAS 1 3--->6<br><br>CAS 1 6--->8<br><br>CAS 1 6--->7<br><br>CAS 1 3--->5<br><br>CAS 1 2--->4<br><br>CAS 1 7--->10<br><br>CAS 1 7--->10<br><br>CAS 1 6--->9<br><br>CAS 1 7--->9<br><br>CAS 1 7--->9<br><br>CAS 1 8--->9<br><br>CAS 1 7--->9<br><br>CAS 1 8--->10<br><br>CAS 1 7--->10<br><br>CAS 1 8--->9<br><br>CAS 1 7--->9<br><br>CAS 1 8--->9<br><br>CAS 1 5--->8<br><br>CAS 1 8--->9<br><br>CAS 1 7--->9<br><br>CAS 1 8--->9<br><br>CAS 1 7--->9<br><br>CAS 1 8--->10<br><br>CAS 1 7--->9<br><br>CAS 1 6--->11<br><br>CAS 1 7--->11<br><br>CAS 1 7--->8<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 4--->6<br><br>CAS 1 5--->6<br><br>CAS 1 7--->9<br><br>CAS 1 6--->8<br><br>CAS 1 5--->7<br><br>CAS 1 6--->8<br>select * from TMP_ARTICLE_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 BE_P_PRIOFLEUR<>2
order by UPPER(REPLACE(CHAR_A_TITRE,"'","")) ASC 
<br>404<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 4--->6<br><br>CAS 1 4--->6<br><br>CAS 1 5--->7<br><br>CAS 1 6--->9<br><br>CAS 1 5--->6<br><br>CAS 1 7--->9<br><br>CAS 1 7--->9<br><br>CAS 1 7--->9<br><br>CAS 1 6--->9<br><br>CAS 1 8--->11<br><br>CAS 1 9--->11<br><br>CAS 1 6--->9<br><br>CAS 1 7--->9<br><br>CAS 1 7--->8<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 7--->9<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 10--->11<br><br>CAS 1 4--->7<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 3 7--->0 6<br><br>CAS 1 6--->7<br><br>CAS 1 5--->8<br><br>CAS 1 8--->9<br><br>CAS 1 8--->9<br><br>CAS 1 5--->10<br><br>CAS 1 5--->10<br><br>CAS 1 5--->10<br><br>CAS 1 5--->10<br><br>CAS 1 5--->10<br><br>CAS 1 6--->9<br><br>CAS 1 5--->9<br><br>CAS 1 8--->10<br><br>CAS 1 6--->10<br><br>CAS 1 6--->10<br><br>CAS 1 8--->10<br><br>CAS 1 8--->10<br><br>CAS 1 8--->9<br><br>CAS 1 6--->10<br><br>CAS 1 4--->6<br><br>CAS 1 5--->11<br><br>CAS 1 5--->7<br><br>CAS 1 5--->7<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 4--->5<br><br>CAS 1 4--->5<br><br>CAS 1 8--->10<br><br>CAS 1 5--->7<br><br>CAS 1 4--->6<br><br>CAS 1 5--->8<br><br>CAS 1 7--->8<br><br>CAS 1 5--->7 0<br><br>CAS 1 4--->6<br><br>CAS 1 8--->9<br><br>CAS 1 7--->10<br><br>CAS 1 9--->10<br><br>CAS 1 9--->10<br><br>CAS 1 8--->9<br><br>CAS 1 9--->10<br><br>CAS 1 9--->10<br><br>CAS 1 8--->10<br><br>CAS 1 8--->10<br><br>CAS 1 8--->10<br><br>CAS 1 6--->7<br><br>CAS 1 6--->7<br><br>CAS 1 6--->7<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 6--->10<br><br>CAS 1 4--->5<br><br>CAS 1 4--->5<br><br>CAS 1 6--->8<br><br>CAS 1 5--->7<br><br>CAS 1 7--->11<br><br>CAS 1 3--->6<br><br>CAS 1 3--->4<br><br>CAS 1 3--->4<br><br>CAS 1 3--->5<br><br>CAS 1 4--->5<br><br>CAS 1 3--->4<br><br>CAS 1 9--->10<br><br>CAS 1 9--->10<br><br>CAS 1 4--->6<br><br>CAS 1 3--->4<br><br>CAS 1 6--->8<br><br>CAS 1 5--->7<br><br>CAS 1 6--->8<br><br>CAS 1 8--->9<br><br>CAS 1 7--->9<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 5--->9<br><br>CAS 1 5--->9<br><br>CAS 1 5--->10<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 5--->8<br><br>CAS 1 5--->9<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 5--->7<br><br>CAS 1 5--->7<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 6--->8<br><br>CAS 1 4--->8<br><br>CAS 1 6--->9<br><br>CAS 1 6--->8<br><br>CAS 1 9--->11<br><br>CAS 1 9--->11<br><br>CAS 1 4--->10<br><br>CAS 1 4--->10<br><br>CAS 1 4--->10<br><br>CAS 1 6--->9<br><br>CAS 1 7--->9<br><br>CAS 1 5--->7<br><br>CAS 1 5--->7<br><br>CAS 1 6--->9<br><br>CAS 1 4--->6<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 7--->8<br><br>CAS 1 6--->7<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 6--->11<br><br>CAS 1 6--->9<br><br>CAS 1 6--->7<br><br>CAS 1 6--->9<br><br>CAS 1 7--->9<br><br>CAS 1 6--->8<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 4--->5<br><br>CAS 1 4--->5<br><br>CAS 1 4--->5<br><br>CAS 3 12--->5<br><br>CAS 1 1--->5<br><br>CAS 1 1--->5<br><br>CAS 1 1--->5<br><br>CAS 3 10--->4<br><br>CAS 3 12--->4<br><br>CAS 1 8--->11<br><br>CAS 1 6--->8<br><br>CAS 1 5--->10<br><br>CAS 1 6--->9<br><br>CAS 1 5--->6<br><br>CAS 1 5--->10<br><br>CAS 1 5--->10<br><br>CAS 1 6--->9<br><br>CAS 1 6--->8<br><br>CAS 1 7--->9<br><br>CAS 1 7--->9<br><br>CAS 1 7--->9<br><br>CAS 1 5--->8<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 6--->10<br><br>CAS 1 6--->10<br><br>CAS 1 7--->8<br><br>CAS 1 6--->10<br><br>CAS 1 7--->10<br><br>CAS 1 6--->10<br><br>CAS 1 6--->10<br><br>CAS 1 6--->10<br><br>CAS 1 6--->10<br><br>CAS 1 6--->10<br><br>CAS 1 6--->10<br><br>CAS 1 7--->10<br><br>CAS 1 7--->9<br><br>CAS 1 6--->8 0<br><br>CAS 1 5--->7<br><br>CAS 1 6--->9<br><br>CAS 1 6--->7<br><br>CAS 1 5--->7<br><br>CAS 1 5--->7<br><br>CAS 1 5--->9<br><br>CAS 1 5--->7<br><br>CAS 1 5--->7<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 5--->10<br><br>CAS 1 5--->9<br><br>CAS 1 4--->6<br><br>CAS 1 7--->10<br><br>CAS 1 6--->7<br><br>CAS 1 6--->7<br><br>CAS 1 6--->9<br><br>CAS 1 5--->6<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 5--->8<br><br>CAS 1 5--->8<br><br>CAS 1 5--->8<br><br>CAS 1 1--->3<br><br>CAS 1 1--->4<br><br>CAS 3 12--->3<br><br>CAS 1 2--->4<br><br>CAS 1 1--->4<br><br>CAS 1 1--->4<br><br>CAS 1 1--->4<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 7--->9<br><br>CAS 1 2--->5<br><br>CAS 1 4--->6<br><br>CAS 1 4--->6<br><br>CAS 1 3--->5<br><br>CAS 1 3--->5<br><br>CAS 3 12--->5<br><br>CAS 3 12--->5<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 4--->5<br><br>CAS 1 3--->4<br><br>CAS 1 4--->5<br><br>CAS 1 5--->6<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 4--->5<br><br>CAS 1 5--->7<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 5--->7<br><br>CAS 1 5--->6<br><br>CAS 1 6--->10<br><br>CAS 1 4--->6<br><br>CAS 1 4--->6<br><br>CAS 1 6--->9<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 6--->7<br><br>CAS 1 6--->8<br><br>CAS 1 6--->10<br><br>CAS 1 5--->7<br><br>CAS 1 5--->6 9<br><br>CAS 1 9--->10<br><br>CAS 1 7--->9<br><br>CAS 1 7--->9<br><br>CAS 1 7--->9<br><br>CAS 1 7--->9<br><br>CAS 1 5--->10<br><br>CAS 1 5--->9<br><br>CAS 1 7--->9<br><br>CAS 1 6--->9<br><br>CAS 1 7--->9<br><br>CAS 1 5--->7<br><br>CAS 1 5--->6<br><br>CAS 2 LIATRIS spicata 'Alba' 7--->7<br><br>CAS 1 7--->10<br><br>CAS 1 4--->5<br><br>CAS 1 6--->8<br><br>CAS 1 5--->7<br><br>CAS 1 7--->8<br><br>CAS 1 5--->7<br><br>CAS 1 6--->9<br><br>CAS 1 6--->7<br><br>CAS 1 5--->7<br><br>CAS 1 6--->8<br><br>CAS 1 5--->7<br><br>CAS 1 7--->9<br><br>CAS 1 7--->9<br><br>CAS 1 7--->9<br><br>CAS 1 7--->9<br><br>CAS 1 6--->9<br><br>CAS 1 5--->7<br><br>CAS 1 5--->7<br><br>CAS 1 5--->7<br><br>CAS 1 5--->6<br><br>CAS 1 6--->8<br><br>CAS 3 4--->0 3<br><br>CAS 1 4--->5<br><br>CAS 1 6--->9<br><br>CAS 1 4--->10<br><br>CAS 1 5--->9<br><br>CAS 1 6--->8<br><br>CAS 1 3--->5<br><br>CAS 1 7--->10<br><br>CAS 1 3--->5<br><br>CAS 1 6--->7<br><br>CAS 1 6--->7<br><br>CAS 1 6--->7<br><br>CAS 1 6--->7<br><br>CAS 1 4--->6<br><br>CAS 1 4--->6<br><br>CAS 1 4--->6<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 6--->10<br><br>CAS 1 6--->10<br><br>CAS 1 6--->10<br><br>CAS 1 0--->0 6<br><br>CAS 1 6--->10<br><br>CAS 1 7--->10<br><br>CAS 1 8--->9<br><br>CAS 1 7--->9<br><br>CAS 1 7--->9<br><br>CAS 1 4--->5<br><br>CAS 1 6--->9<br><br>CAS 1 7--->9<br><br>CAS 1 4--->6<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 4--->5<br><br>CAS 1 4--->5<br><br>CAS 1 7--->9<br><br>CAS 1 7--->9<br><br>CAS 1 6--->8<br><br>CAS 1 4--->6<br><br>CAS 1 6--->10<br><br>CAS 1 4--->6<br><br>CAS 1 5--->7<br><br>CAS 1 4--->5<br><br>CAS 1 6--->9<br><br>CAS 1 3--->5<br><br>CAS 1 4--->5<br><br>CAS 1 7--->8<br><br>CAS 1 7--->8<br><br>CAS 1 3--->5<br><br>CAS 1 6--->7<br><br>CAS 1 6--->7<br><br>CAS 1 6--->8<br><br>CAS 1 5--->7<br><br>CAS 1 5--->10<br><br>CAS 1 5--->10<br><br>CAS 1 5--->11<br><br>CAS 1 5--->11<br><br>CAS 1 5--->8<br><br>CAS 1 6--->10<br><br>CAS 1 7--->10<br><br>CAS 1 6--->8<br><br>CAS 1 6--->9<br><br>CAS 1 5--->8<br><br>CAS 1 8--->9<br><br>CAS 1 5--->7<br><br>CAS 1 6--->9<br><br>CAS 1 4--->6<br><br>CAS 1 5--->7<br><br>CAS 1 5--->6<br><br>CAS 1 6--->11<br><br>CAS 1 6--->10<br><br>CAS 1 9--->12<br><br>CAS 1 6--->8<br><br>CAS 1 7--->10<br><br>CAS 1 6--->9<br><br>CAS 1 7--->9<br><br>CAS 1 6--->9<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 4--->8<br><br>CAS 1 9--->10<br><br>CAS 1 6--->10<br><br>CAS 1 6--->7<br><br>CAS 1 6--->8<br><br>CAS 1 5--->6<br><br>CAS 1 6--->8<br><br>CAS 1 6--->7<br><br>CAS 1 4--->5<br><br>CAS 1 4--->6<br><br>CAS 1 3--->6<br><br>CAS 1 4--->6<br><br>CAS 1 4--->7<br><br>CAS 1 5--->6<br><br>CAS 1 4--->5<br><br>CAS 1 4--->5<br><br>CAS 1 5--->9<br><br>CAS 1 5--->9<br><br>CAS 1 8--->10<br><br>CAS 1 7--->11<br><br>CAS 1 5--->7<br><br>CAS 1 6--->9<br><br>CAS 1 6--->7<br><br>CAS 1 7--->9<br><br>CAS 1 4--->6<br><br>CAS 1 4--->6<br><br>CAS 1 2--->5<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 6--->8<br>select * from TMP_ARTICLE_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 "16 %" || CONCAT_COULEUR_FLEUR like "% 16" || CONCAT_COULEUR_FLEUR like "16" || CONCAT_COULEUR_FLEUR like "% 16 %" ) 
AND BE_P_PRIOFLEUR<>2
order by UPPER(REPLACE(CHAR_A_TITRE,"'","")) ASC 
<br>13<br><br>CAS 1 8--->10<br><br>CAS 1 7--->9<br><br>CAS 1 7--->9<br><br>CAS 1 6--->7<br><br>CAS 1 5--->6<br><br>CAS 1 5--->6<br><br>CAS 1 4--->6<br><br>CAS 1 2--->4<br><br>CAS 1 1--->5<br><br>CAS 1 1--->5<br><br>CAS 1 2--->4<br><br>CAS 1 1--->4<br><br>CAS 1 7--->10<br>select * from TMP_ARTICLE_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 "8 %" || CONCAT_COULEUR_FLEUR like "% 8" || CONCAT_COULEUR_FLEUR like "8" || CONCAT_COULEUR_FLEUR like "% 8 %" ) 
AND BE_P_PRIOFLEUR<>2
order by UPPER(REPLACE(CHAR_A_TITRE,"'","")) ASC 
<br>8<br><br>CAS 1 7--->8<br><br>CAS 1 6--->9<br><br>CAS 1 6--->8<br><br>CAS 1 6--->9<br><br>CAS 1 7--->10<br><br>CAS 1 7--->10<br><br>CAS 1 7--->10<br><br>CAS 1 4--->9<br>select * from TMP_ARTICLE_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 "15 %" || CONCAT_COULEUR_FLEUR like "% 15" || CONCAT_COULEUR_FLEUR like "15" || CONCAT_COULEUR_FLEUR like "% 15 %" ) 
AND BE_P_PRIOFLEUR<>2
order by UPPER(REPLACE(CHAR_A_TITRE,"'","")) ASC 
<br>16<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 6--->9<br><br>CAS 1 6--->9<br><br>CAS 1 5--->6<br><br>CAS 1 6--->10<br><br>CAS 1 5--->6<br><br>CAS 1 6--->9<br><br>CAS 1 1--->4<br><br>CAS 1 7--->9<br><br>CAS 1 4--->6<br><br>CAS 1 6--->7<br><br>CAS 1 6--->9<br><br>CAS 1 5--->7<br><br>CAS 1 7--->9<br><br>CAS 1 5--->7<br>select * from TMP_ARTICLE_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 "18 %" || CONCAT_COULEUR_FLEUR like "% 18" || CONCAT_COULEUR_FLEUR like "18" || CONCAT_COULEUR_FLEUR like "% 18 %" ) 
AND BE_P_PRIOFLEUR<>2
order by UPPER(REPLACE(CHAR_A_TITRE,"'","")) ASC 
<br>20<br><br>CAS 1 7--->8<br><br>CAS 1 5--->10<br><br>CAS 1 5--->6<br><br>CAS 1 8--->12<br><br>CAS 1 8--->10<br><br>CAS 1 8--->12<br><br>CAS 1 7--->12<br><br>CAS 1 7--->11<br><br>CAS 1 6--->9<br><br>CAS 1 8--->9<br><br>CAS 1 8--->12<br><br>CAS 1 8--->10<br><br>CAS 1 7--->9<br><br>CAS 1 8--->12<br><br>CAS 1 8--->11<br><br>CAS 1 8--->12<br><br>CAS 1 8--->10<br><br>CAS 1 7--->8<br><br>CAS 1 7--->8<br><br>CAS 1 6--->7<br>select * from TMP_ARTICLE_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 "19 %" || CONCAT_COULEUR_FLEUR like "% 19" || CONCAT_COULEUR_FLEUR like "19" || CONCAT_COULEUR_FLEUR like "% 19 %" ) 
AND BE_P_PRIOFLEUR<>2
order by UPPER(REPLACE(CHAR_A_TITRE,"'","")) ASC 
<br>9<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 6--->8<br><br>CAS 1 6--->9<br><br>CAS 1 7--->12<br><br>CAS 1 7--->9<br><br>CAS 1 5--->8<br><br>CAS 1 6--->8<br>