Erro Fatal: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'Sullivan%' GROUP BY indice.idIndice ORDER BY titulo, compositor, yout...' at line 4

SELECT indice.*, codigoYt FROM indice LEFT JOIN youtube ON indice.idIndice=youtube.idIndice WHERE compositor LIKE '%Gilbert O'Sullivan%' GROUP BY indice.idIndice ORDER BY titulo, compositor, youtube.dataEnvio DESC