select distinct sw_contribution.*, sw_users.*, sw_contribution_display.*, sw_contribution_content.*, sw_themes.title as titlet,sw_themes.titleFR as titlefrt, sw_contribution_socialDatas.*, (SELECT concat('[',GROUP_CONCAT( CONCAT( '{''idTheme'':''',t.idTheme, ''',''title'':''', replace(ifNull(t.title,''),\"'\",\"''\"), ''',''titleFR'':''', replace(ifNull(t.titleFR,''),\"'\",\"''\"),'''}' ),' ' ) ,']') FROM sw_themes t JOIN sw_contribution_2ndTheme ON ( t.idTheme = c2t_idTheme ) WHERE sw_contribution.idContribution = c2t_idContribution GROUP BY c2t_idContribution ) otherThemes, ( SELECT CONCAT('[', GROUP_CONCAT('{\'id\':', sw_contribution_keyword.ck_refkeyword, ',\'word\':\'', sw_referencekeyword.rk_word, '\',\'wordforcompare\':\'', sw_referencekeyword.rk_wordforcompare, '\',\'isPartner\':', sw_referencekeyword.rk_partner, '}'), ']') FROM sw_contribution_keyword INNER JOIN sw_referencekeyword ON sw_referencekeyword.rk_id = sw_contribution_keyword.ck_refkeyword WHERE sw_contribution_keyword.ck_contribution = sw_contribution.idContribution ) AS keywords from sw_contribution JOIN sw_themes on sw_contribution.idTheme=sw_themes.idTheme JOIN sw_users on sw_contribution.idUser=sw_users.idUser left join sw_contribution_content on sw_contribution.idContribution = cc_idcontribution LEFT JOIN sw_contribution_display ON sw_contribution_display.idContributionDisplay = sw_contribution.idContribution LEFT JOIN sw_contribution_socialDatas ON sw_contribution_socialDatas.idContributionSocial = sw_contribution.idContribution JOIN sw_contribution_keyword on sw_contribution.idContribution=sw_contribution_keyword.ck_contribution JOIN sw_referencekeyword on sw_contribution_keyword.ck_refkeyword = sw_referencekeyword.rk_id where (sw_contribution.type <= 3 AND sw_contribution.onLine=1) and (sw_referencekeyword.rk_word like '%changement%climatique%' or sw_referencekeyword.rk_word ='changement climatique') AND sw_contribution.language=2 ORDER BY sw_contribution.publicationDate desc