Query

SQLSTATE[42000]: Syntax error OR access violation: 1064 You have an error IN your SQL syntax; CHECK the manual that corresponds TO your MySQL server version FOR the RIGHT syntax TO USE near 'on `ativos_extratos`.`data_import_id` = `borders`.`min_id` or `ativos_extratos`.' at line 3 (SQL: SELECT `titulo_id`, SUM(CASE WHEN ativos_extratos.data_import_id = borders.min_id THEN valor_bruto_atual END) AS valor_init, SUM(CASE WHEN ativos_extratos.data_import_id = borders.max_id THEN valor_bruto_atual END) AS valor_end, `data_imports`.`data_import` AS `created_at`, MONTH(data_imports.data_import) AS weeknumber FROM `ativos_extratos` INNER JOIN `titulos` ON `titulo_id` = `titulos`.`id` INNER JOIN `representantes` ON `representante_id` = `representantes`.`id` INNER JOIN `data_imports` ON `data_import_id` = `data_imports`.`id` INNER JOIN ON `ativos_extratos`.`data_import_id` = `borders`.`min_id` OR `ativos_extratos`.`data_import_id` = `borders`.`max_id` WHERE `user_id` = 1 AND `data_import` BETWEEN 2018-01-01 AND 2018-12-10 GROUP BY `titulos`.`nome_titulo`, `weeknumber` ORDER BY `data_import` ASC, `titulos`.`nome_titulo` ASC)