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 '%agroalimentaire%' or  sw_referencekeyword.rk_word ='Agroalimentaire')  AND sw_contribution.language=2     ORDER BY sw_contribution.publicationDate desc