SELECT DISTINCT `Reg_id`, `Reg_IdNom`, `Reg_Lieu`, `Reg_DateDeb`, `Reg_Nom`, `Reg_Cat`, `TR_Nom`
FROM `Regate`, `TypeReg`
WHERE `Reg_DateDeb` > '2011'
AND `Reg_DateDeb` <= NOW()
AND (`Reg_Nom` LIKE 'Championnat de France vétéran' OR `Reg_Nom` LIKE 'Championnat de France master')
AND `Reg_IdNom` LIKE `TR_id`
ORDER BY `Reg_DateDeb` DESC - Illegal mix of collations (latin1_general_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation 'like'