In this case, jointure with entities table should be included through ${table} placeholder but $context['table'] is set instead in the sql2 request. We get the following kind of request that provokes an error : SELECT COUNT(titreoeuvre) as nbresults FROM textes WHERE status > 0 AND SUBSTRING(titreoeuvre,1,1) = 'A'
In this case, jointure with entities table should be included through ${table} placeholder but $context['table'] is set instead in the sql2 request. We get the following kind of request that provokes an error : SELECT COUNT(titreoeuvre) as nbresults FROM textes WHERE status > 0 AND SUBSTRING(titreoeuvre,1,1) = 'A'