Erro no banco de dados do WordPress: [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 'and data_consulta <= DATE('')
order by data_consulta desc
LIMIT 12' at line 3]SELECT * from rentabilidade_v2
where codigo_indicador =
and data_consulta <= DATE('')
order by data_consulta desc
LIMIT 12
Erro no banco de dados do WordPress: [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 ')
and DATE(data_consulta) <= ''
group by serie
order by codigo_indicador asc' at line 12]SELECT
GROUP_CONCAT(data_consulta order by data_consulta asc) as data_consulta,
serie,
codigo_indicador,
GROUP_CONCAT(rental_mes order by data_consulta asc) as rental_mes,
GROUP_CONCAT(rental_ano order by data_consulta asc) as rental_ano,
GROUP_CONCAT(rental_12 order by data_consulta asc) as rental_12,
GROUP_CONCAT(rental_24 order by data_consulta asc) as rental_24,
GROUP_CONCAT(rental_36 order by data_consulta asc) as rental_36,
GROUP_CONCAT(rental_60 order by data_consulta asc) as rental_60
from rentabilidade_v2
where codigo_indicador in ()
and DATE(data_consulta) <= ''
group by serie
order by codigo_indicador asc
Erro no banco de dados do WordPress: [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 'GROUP BY codigo_segmento' at line 11]SELECT
segmento,
codigo_segmento,
sum(porcentagem) as porcentagem,
sum(valor) as valor,
GROUP_CONCAT(REPLACE(valor, '.', '')) as valorsolto,
valor as valor_semsoma
from carteira_v2
where DATE(data_base) = ''
and codigo_plano =
GROUP BY codigo_segmento
Erro no banco de dados do WordPress: [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 ' 4, , , , , , , )
and data_consulta > DATE('') - INTERVAL 3 month
group by co...' at line 13]SELECT
GROUP_CONCAT(data_consulta order by data_consulta asc) as data_consulta,
serie,
codigo_indicador,
GROUP_CONCAT(rental_mes order by data_consulta asc) as rental_mes,
GROUP_CONCAT(rental_ano order by data_consulta asc) as rental_ano,
GROUP_CONCAT(CASE WHEN data_consulta = '' THEN rental_ano ELSE NULL END order by data_consulta asc SEPARATOR '|') as rental_ano,
GROUP_CONCAT(CASE WHEN data_consulta = '' THEN rental_12 ELSE NULL END order by data_consulta asc SEPARATOR '|') as rental_12,
GROUP_CONCAT(CASE WHEN data_consulta = '' THEN rental_24 ELSE NULL END order by data_consulta asc SEPARATOR '|') as rental_24,
GROUP_CONCAT(CASE WHEN data_consulta = '' THEN rental_36 ELSE NULL END order by data_consulta asc SEPARATOR '|') as rental_36,
GROUP_CONCAT(CASE WHEN data_consulta = '' THEN rental_60 ELSE NULL END order by data_consulta asc SEPARATOR '|') as rental_60
from rentabilidade_v2
where codigo_indicador in (, 4, , , , , , , )
and data_consulta > DATE('') - INTERVAL 3 month
group by codigo_indicador
order by codigo_indicador asc
Segmento de Aplicação |
Percentual da Carteira |
Indicadores |
Notice: Undefined variable: data_consulta in /var/www/html/wp-content/themes/centrus-2020/lamina/build-rentabilidade.php on line 800 Notice: Trying to access array offset on value of type null in /var/www/html/wp-content/themes/centrus-2020/lamina/build-rentabilidade.php on line 800 Notice: Trying to access array offset on value of type null in /var/www/html/wp-content/themes/centrus-2020/lamina/build-rentabilidade.php on line 800 dez/2023 |
Notice: Undefined variable: data_consulta in /var/www/html/wp-content/themes/centrus-2020/lamina/build-rentabilidade.php on line 800 Notice: Trying to access array offset on value of type null in /var/www/html/wp-content/themes/centrus-2020/lamina/build-rentabilidade.php on line 800 Notice: Trying to access array offset on value of type null in /var/www/html/wp-content/themes/centrus-2020/lamina/build-rentabilidade.php on line 800 dez/2023 |
Notice: Undefined variable: data_consulta in /var/www/html/wp-content/themes/centrus-2020/lamina/build-rentabilidade.php on line 800 Notice: Trying to access array offset on value of type null in /var/www/html/wp-content/themes/centrus-2020/lamina/build-rentabilidade.php on line 800 Notice: Trying to access array offset on value of type null in /var/www/html/wp-content/themes/centrus-2020/lamina/build-rentabilidade.php on line 800 dez/2023 |
Acumulado | ||||
Ano | 12 meses | 24 meses | 36 meses | 60 meses |