select *, diffusions.`Event Name` as tten, diffusions.`Arabic Event Name` as ttar, diffusions.`French Event Name` as ttfr, more_info.`Event Name` as tten2, more_info.`Arabic Event Name` as ttar2, more_info.`French Event Name` as ttfr2, diffusions.image as image1 from diffusions left join more_info on ((diffusions.`Event Name` IS NOT NULL and diffusions.`Event Name` <> '' and more_info.`Event Name` = diffusions.`Event Name`) or (diffusions.`Arabic Event Name` IS NOT NULL and diffusions.`Arabic Event Name` <> '' and more_info.`Arabic Event Name` = diffusions.`Arabic Event Name`) or (diffusions.`French Event Name` IS NOT NULL and diffusions.`French Event Name` <> '' and more_info.`French Event Name` = diffusions.`French Event Name`)) left join chaine on diffusions.id_chaine = chaine.CHAINE where diffusions.id_diffussion = '19686473'