Fórum Fortes Report não está 100% #397968

Query simples ele roda, mas query com join não. A query que não roda é a abaixo: select i.operador,i.tipo_edicao,i.num_edicao,i.num_pagina,i.data,l.nome, replace((100-l.per_indef),'.',',')as per_indef from log_index_logs l inner join log_index_img i on l.nome = i.nome_final where substring(nome,1,4) between '1876' and '1940' and 100-l.per_indef >= 82 or substring(nome,1,4) between '1941' and '1950' and 100-l.per_indef >= 85 or substring(nome,1,4) between '1951' and '1960' and 100-l.per_indef >= 87 or substring(nome,1,4) between '1961' and '1970' and 100-l.per_indef >= 88 or substring(nome,1,4) between '1971' and '1980' and 100-l.per_indef >= 89 or substring(nome,1,4) between '1981' and '1990' and 100-l.per_indef >= 90 or substring(nome,1,4) between '1991' and '2001' and 100-l.per_indef >= 92 order by l.nome,i.data,i.operador