select distinct CHAR_P_GENRE as NAME from TMP_ARTICLE_SEARCH WHERE BE_A_ACTIVE="1" AND (CONCAT_COLLECTION like "2 %" || CONCAT_COLLECTION like "% 2" || CONCAT_COLLECTION like "2" || CONCAT_COLLECTION like "% 2 %" ) order by CHAR_P_GENRE ASC
(mysqli): select distinct CHAR_P_GENRE as NAME from TMP_ARTICLE_SEARCH WHERE BE_A_ACTIVE="1" AND (CONCAT_COLLECTION like "2 %" || CONCAT_COLLECTION like "% 2" || CONCAT_COLLECTION like "2" || CONCAT_COLLECTION like "% 2 %" ) order by CHAR_P_GENRE ASC  

14
select distinct CHAR_P_GENRE as NAME from TMP_ARTICLE_SEARCH WHERE BE_A_ACTIVE="1" AND (CONCAT_COLLECTION like "3 %" || CONCAT_COLLECTION like "% 3" || CONCAT_COLLECTION like "3" || CONCAT_COLLECTION like "% 3 %" ) order by CHAR_P_GENRE ASC
(mysqli): select distinct CHAR_P_GENRE as NAME from TMP_ARTICLE_SEARCH WHERE BE_A_ACTIVE="1" AND (CONCAT_COLLECTION like "3 %" || CONCAT_COLLECTION like "% 3" || CONCAT_COLLECTION like "3" || CONCAT_COLLECTION like "% 3 %" ) order by CHAR_P_GENRE ASC  

54
select distinct CHAR_P_GENRE as NAME from TMP_ARTICLE_SEARCH WHERE BE_A_ACTIVE="1" AND (CONCAT_COLLECTION like "4 %" || CONCAT_COLLECTION like "% 4" || CONCAT_COLLECTION like "4" || CONCAT_COLLECTION like "% 4 %" ) order by CHAR_P_GENRE ASC
(mysqli): select distinct CHAR_P_GENRE as NAME from TMP_ARTICLE_SEARCH WHERE BE_A_ACTIVE="1" AND (CONCAT_COLLECTION like "4 %" || CONCAT_COLLECTION like "% 4" || CONCAT_COLLECTION like "4" || CONCAT_COLLECTION like "% 4 %" ) order by CHAR_P_GENRE ASC  

44
select distinct CHAR_P_GENRE as NAME from TMP_ARTICLE_SEARCH WHERE BE_A_ACTIVE="1" AND (CONCAT_COLLECTION like "5 %" || CONCAT_COLLECTION like "% 5" || CONCAT_COLLECTION like "5" || CONCAT_COLLECTION like "% 5 %" ) order by CHAR_P_GENRE ASC
(mysqli): select distinct CHAR_P_GENRE as NAME from TMP_ARTICLE_SEARCH WHERE BE_A_ACTIVE="1" AND (CONCAT_COLLECTION like "5 %" || CONCAT_COLLECTION like "% 5" || CONCAT_COLLECTION like "5" || CONCAT_COLLECTION like "% 5 %" ) order by CHAR_P_GENRE ASC  

2
select distinct CHAR_P_GENRE as NAME from TMP_ARTICLE_SEARCH WHERE BE_A_ACTIVE="1" AND (CONCAT_COLLECTION like "31 %" || CONCAT_COLLECTION like "% 31" || CONCAT_COLLECTION like "31" || CONCAT_COLLECTION like "% 31 %" ) order by CHAR_P_GENRE ASC
(mysqli): select distinct CHAR_P_GENRE as NAME from TMP_ARTICLE_SEARCH WHERE BE_A_ACTIVE="1" AND (CONCAT_COLLECTION like "31 %" || CONCAT_COLLECTION like "% 31" || CONCAT_COLLECTION like "31" || CONCAT_COLLECTION like "% 31 %" ) order by CHAR_P_GENRE ASC  

21
select distinct CHAR_P_GENRE as NAME from TMP_ARTICLE_SEARCH WHERE BE_A_ACTIVE="1" AND (CONCAT_COLLECTION like "40 %" || CONCAT_COLLECTION like "% 40" || CONCAT_COLLECTION like "40" || CONCAT_COLLECTION like "% 40 %" ) order by CHAR_P_GENRE ASC
(mysqli): select distinct CHAR_P_GENRE as NAME from TMP_ARTICLE_SEARCH WHERE BE_A_ACTIVE="1" AND (CONCAT_COLLECTION like "40 %" || CONCAT_COLLECTION like "% 40" || CONCAT_COLLECTION like "40" || CONCAT_COLLECTION like "% 40 %" ) order by CHAR_P_GENRE ASC  

325