select distinct concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME, CHAR_A_SOUSTITRE from TMP_ARTICLE_SEARCH WHERE (CONCAT_COLLECTION like "1 %" || CONCAT_COLLECTION like "% 1" || CONCAT_COLLECTION like "1" || CONCAT_COLLECTION like "% 1 %" ) AND BE_A_ACTIVE="1" AND  BE_P_COUVRESOL="1" and FKID_REF_FORME="10"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC<br>0<br><br>select distinct concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME, CHAR_A_SOUSTITRE from TMP_ARTICLE_SEARCH WHERE (CONCAT_COLLECTION like "1 %" || CONCAT_COLLECTION like "% 1" || CONCAT_COLLECTION like "1" || CONCAT_COLLECTION like "% 1 %" ) AND BE_A_ACTIVE="1" AND  BE_P_COUVRESOL="1" and FKID_REF_FORME="9"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC<br>0<br><br>select distinct concat(CHAR_P_GENRE," ", CHAR_P_ESPECE) as NAME, CHAR_A_SOUSTITRE from TMP_ARTICLE_SEARCH WHERE (CONCAT_COLLECTION like "1 %" || CONCAT_COLLECTION like "% 1" || CONCAT_COLLECTION like "1" || CONCAT_COLLECTION like "% 1 %" ) AND BE_A_ACTIVE="1" AND  BE_P_COUVRESOL="1" and FKID_REF_FORME<>"9" and FKID_REF_FORME<>"10"
ORDER BY TMP_ARTICLE_SEARCH.CONCAT_NOM_RECHERCHE ASC<br>0<br><br>