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
3

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
253

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
389