A Database Error Occurred

Error Number: 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 'AND vagasDisponiveis > 0 AND `ta`.`status` = '1' ORDER BY data_inicio ASC' at line 10

SELECT `ta`.`data_exibicao`, `ta`.`id`, `ta`.`vagas` - (SELECT count(*) FROM tb_treinamentoContrata AS ttc JOIN tb_inscricaoContrata tic ON `tic`.`id_treinamentoContrata` = `ttc`.`id` WHERE `ttc`.`id_agenda` = `ta`.`id` AND `ttc`.`status_pagamento` <> 7 ) AS vagasDisponiveis, if(date(DATE_SUB(`ta`.`data_inicio`, INTERVAL 8 DAY)) >= date(now()), 1, 0) AS disponivel FROM tb_agenda AS ta WHERE `ta`.`id_curso` = AND vagasDisponiveis > 0 AND `ta`.`status` = '1' ORDER BY data_inicio ASC

Filename: /home/httpd/html/jci-hitachi.cloudbr.net/public_html/modules/site/models/treinamento_model.php

Line Number: 444