SELECT GROUP_CONCAT(DISTINCT CAST(A.ID AS CHAR(15))) as ADS_FIELD,
CONCAT_WS('interestSeparator',MAX(A.INTEREST1_JSON),MAX(A.INTEREST2_JSON), MAX(A.INTEREST3_JSON),MAX(A.INTEREST4_JSON),MAX(A.INTEREST5_JSON),MAX(A.INTEREST6_JSON)) AS GROUP_FIELD
FROM TABLEA A, TABLEB B
WHERE A.ID = B.ID  AND A.CONDITION1 IN(54429,54430)
GROUP BY A.INTEREST1_STRING, A.INTEREST2_STRING, A.INTEREST3_STRING, A.INTEREST4_STRING, A.INTEREST5_STRING, A.INTEREST6_STRING;

ADS_FIELD                                                        GROUP_FIELD

1065661,1065662,1065663,1065664,1065665,1065666,1065667,1065668 {"interests":[{"name":"Alicia Vikander"},{"name":"Batman Begins"}"},{"name":"Board games"}]}

1066063                                                         {"interests":[{"name":"Harry Potter"},{"name":"Los juegos del hambre"},{"name":"saga crepusculo"}]}

1066064                                                         {"interests":[{"name":"Harry Potter"},{"name":"Los juegos del hambre"},{"name":"saga crepusculo"}]}

1066065                                                         {"interests":[{"name":"Harry Potter"},{"name":"Los juegos del hambre"},{"name":"saga crepusculo"}]}

1066066                                                         {"interests":[{"name":"Harry Potter"},{"name":"Los juegos del hambre"},{"name":"saga crepusculo"}]}

1066067                                                         {"interests":[{"name":"Harry Potter"},{"name":"Los juegos del hambre"},{"name":"saga crepusculo"}]}

1066068                                                         {"interests":[{"name":"Harry Potter"},{"name":"Los juegos del hambre"},{"name":"saga crepusculo"}]}

1066069                                                         {"interests":[{"name":"Harry Potter"},{"name":"Los juegos del hambre"},{"name":"saga crepusculo"}]}

ADS_FIELD                                                        GROUP_FIELD
1065661,1065662,1065663,1065664,1065665,1065666,1065667,1065668 {"interests":[{"name":"Alicia Vikander"},{"name":"Batman Begins"}"},{"name":"Board games"}]}

1066063,1066064,1066065,1066066,1066067,1066068,1066069         {"interests":[{"name":"Harry Potter"},{"name":"Los juegos del hambre"},{"name":"saga crepusculo"}]}