Hay un error en su setencia SQL. SELECT
noti.idNoticias AS ID,
ROW_NUMBER() OVER (ORDER BY noti.idNoticias DESC) AS numero,
NOTIRANS.Titulo AS titulo,
noti.Fecha AS fecha,
noti.fecha_publicar AS fecha_publicacion,
NOTIRANS.Volanta AS VOLANTA,
noti.Contenido AS conteBIG,
TRANSLA.seccion AS categoria,
CONCAT(LOWER(TRANSLA.seccion), "/IDNO") AS LINK_SEC,
CONCAT(LOWER(TRANSLA.seccion), "/IDNO", noti.idNoticias, "/", NOTIRANS.Titulo) AS LINK,
CONCAT(noti.idNoticias, "/", NOTIRANS.Titulo) AS LINK_PAG,
IF(LENGTH(noti.fotoDefault) > 0, "block", "none") AS CSS,
CONCAT(noti.ruta, noti.fotoDefault) AS foto,
noti.Orden,
noti.i2m_api_categorianoticias_idCategoriaNoticias AS catenoticias,
noti.Destacado AS destacado,
noti.fotoDefault AS FOTODEF,
noti.ruta AS RUTA,
noti.i2m_core_estados_idEstados AS IDESTADO,
noti.VaAlHome AS VAALHOME,
ESTA.color AS BG_ESTADOS,
cate.idi2m_api_noticias_secciones AS IDSECCION,
noti.i2m_core_template_pagina_idi2m_core_template_pagina AS IDPAGINA,
LNG.setDefault AS ISDEFAULT,
noti.fecha_publicar AS FECHA_PUBLICAR,
GROUP_CONCAT(CATENOTI.Categoria SEPARATOR " | ") AS CATEGORIAS
FROM
i2m_api_noticias noti
INNER JOIN i2m_core_noticias_translation NOTIRANS
ON NOTIRANS.i2m_api_noticias_idNoticias = noti.idNoticias
INNER JOIN i2m_api_noticias_secciones cate
ON cate.idi2m_api_noticias_secciones = noti.i2m_api_noticias_secciones_idi2m_api_noticias_secciones
INNER JOIN i2m_api_noticias_secciones_translations AS TRANSLA
ON TRANSLA.i2m_api_noticias_secciones_idi2m_api_noticias_secciones = cate.idi2m_api_noticias_secciones
AND TRANSLA.i2m_core_language_idi2m_core_language = NOTIRANS.i2m_core_language_idi2m_core_language
INNER JOIN i2m_core_language LNG
ON LNG.idi2m_core_language = TRANSLA.i2m_core_language_idi2m_core_language
INNER JOIN i2m_core_estados ESTA
ON ESTA.idEstados = noti.i2m_core_estados_idEstados
LEFT JOIN i2m_api_noticias_has_i2m_api_noticias_categorias RELA ON RELA.i2m_api_noticias_idNoticias=noti.idNoticias
LEFT JOIN i2m_api_noticias_categorias CATENOTI ON CATENOTI.idi2m_api_noticias_categorias=RELA.i2m_api_noticias_categorias_idi2m_api_noticias_categorias
WHERE
LNG.setDefault = "Y"
AND noti.fecha_publicar <= CURDATE()
AND noti.i2m_core_estados_idEstados = 1
AND CATENOTI.idi2m_api_noticias_categorias IN()
AND noti.idNoticias != 59
AND noti.i2m_core_template_pagina_idi2m_core_template_pagina = 14
GROUP BY noti.idNoticias
ORDER BY
noti.idNoticias DESC
LIMIT 0, 10; mysqli_sql_exception: 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 noti.idNoticias != 59
AND noti.i2m_core_template_pagina_idi2m_core_' at line 47 in /home/drfernan/public_html/php/clases/I2m/i2m_DB/MySQLI.class.php:79
Stack trace:
#0 /home/drfernan/public_html/php/clases/I2m/i2m_DB/MySQLI.class.php(79): mysqli->prepare('SELECT\r\n not...')
#1 /home/drfernan/public_html/php/clases/I2m/i2m_DB/i2m_db.php(65): I2m\DB\i2m_MySQLI->ejecutarQuery('SELECT\r\n not...', true)
#2 /home/drfernan/public_html/php/clases/I2m/i2m_Noticias/i2m_Noticias.php(1153): I2m\DB\i2m_Base_de_Datos->consultar('SELECT\r\n not...')
#3 /home/drfernan/public_html/themes/I2M_OPTICAS/modulos/i2m_noticias_optica/i2m_theme_noticias_optica.php(825): I2m\NOTICIAS\i2m_Noticias->showRelationArticles(NULL, '59', '/home/drfernan/...', 0, 10)
#4 /home/drfernan/public_html/themes/I2M_OPTICAS/layout/config_vars.php(436): I2m\NOTICIAS\i2m_theme_noticias_optica->ampliarNota('59')
#5 /home/drfernan/public_html/php/index.php(22): I2m\i2m_theme_I2M_MAPA_CDP_config_vars->newsGetTheme()
#6 {main}
Hay un error en su setencia SQL. SELECT
noti.idNoticias AS ID,
ROW_NUMBER() OVER (ORDER BY noti.idNoticias DESC) AS numero,
NOTIRANS.Titulo AS titulo,
noti.Fecha AS fecha,
noti.fecha_publicar AS fecha_publicacion,
NOTIRANS.Volanta AS VOLANTA,
noti.Contenido AS conteBIG,
TRANSLA.seccion AS categoria,
CONCAT(LOWER(TRANSLA.seccion), "/IDNO") AS LINK_SEC,
CONCAT(LOWER(TRANSLA.seccion), "/IDNO", noti.idNoticias, "/", NOTIRANS.Titulo) AS LINK,
CONCAT(noti.idNoticias, "/", NOTIRANS.Titulo) AS LINK_PAG,
IF(LENGTH(noti.fotoDefault) > 0, "block", "none") AS CSS,
CONCAT(noti.ruta, noti.fotoDefault) AS foto,
noti.Orden,
noti.i2m_api_categorianoticias_idCategoriaNoticias AS catenoticias,
noti.Destacado AS destacado,
noti.fotoDefault AS FOTODEF,
noti.ruta AS RUTA,
noti.i2m_core_estados_idEstados AS IDESTADO,
noti.VaAlHome AS VAALHOME,
ESTA.color AS BG_ESTADOS,
cate.idi2m_api_noticias_secciones AS IDSECCION,
noti.i2m_core_template_pagina_idi2m_core_template_pagina AS IDPAGINA,
LNG.setDefault AS ISDEFAULT,
noti.fecha_publicar AS FECHA_PUBLICAR,
GROUP_CONCAT(CATENOTI.Categoria SEPARATOR " | ") AS CATEGORIAS
FROM
i2m_api_noticias noti
INNER JOIN i2m_core_noticias_translation NOTIRANS
ON NOTIRANS.i2m_api_noticias_idNoticias = noti.idNoticias
INNER JOIN i2m_api_noticias_secciones cate
ON cate.idi2m_api_noticias_secciones = noti.i2m_api_noticias_secciones_idi2m_api_noticias_secciones
INNER JOIN i2m_api_noticias_secciones_translations AS TRANSLA
ON TRANSLA.i2m_api_noticias_secciones_idi2m_api_noticias_secciones = cate.idi2m_api_noticias_secciones
AND TRANSLA.i2m_core_language_idi2m_core_language = NOTIRANS.i2m_core_language_idi2m_core_language
INNER JOIN i2m_core_language LNG
ON LNG.idi2m_core_language = TRANSLA.i2m_core_language_idi2m_core_language
INNER JOIN i2m_core_estados ESTA
ON ESTA.idEstados = noti.i2m_core_estados_idEstados
LEFT JOIN i2m_api_noticias_has_i2m_api_noticias_categorias RELA ON RELA.i2m_api_noticias_idNoticias=noti.idNoticias
LEFT JOIN i2m_api_noticias_categorias CATENOTI ON CATENOTI.idi2m_api_noticias_categorias=RELA.i2m_api_noticias_categorias_idi2m_api_noticias_categorias
WHERE
LNG.setDefault = "Y"
AND noti.fecha_publicar <= CURDATE()
AND noti.i2m_core_estados_idEstados = 1
AND CATENOTI.idi2m_api_noticias_categorias IN()
AND noti.idNoticias != 59
AND noti.i2m_core_template_pagina_idi2m_core_template_pagina = 14
GROUP BY noti.idNoticias
ORDER BY
noti.idNoticias DESC
LIMIT 0, 10; mysqli_sql_exception: 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 noti.idNoticias != 59
AND noti.i2m_core_template_pagina_idi2m_core_' at line 47 in /home/drfernan/public_html/php/clases/I2m/i2m_DB/MySQLI.class.php:79
Stack trace:
#0 /home/drfernan/public_html/php/clases/I2m/i2m_DB/MySQLI.class.php(79): mysqli->prepare('SELECT\r\n not...')
#1 /home/drfernan/public_html/php/clases/I2m/i2m_DB/i2m_db.php(65): I2m\DB\i2m_MySQLI->ejecutarQuery('SELECT\r\n not...', true)
#2 /home/drfernan/public_html/php/clases/I2m/i2m_Noticias/i2m_Noticias.php(1153): I2m\DB\i2m_Base_de_Datos->consultar('SELECT\r\n not...')
#3 /home/drfernan/public_html/themes/I2M_OPTICAS/modulos/i2m_noticias_optica/i2m_theme_noticias_optica.php(825): I2m\NOTICIAS\i2m_Noticias->showRelationArticles(NULL, '59', '/home/drfernan/...', 0, 10)
#4 /home/drfernan/public_html/themes/I2M_OPTICAS/layout/config_vars.php(443): I2m\NOTICIAS\i2m_theme_noticias_optica->ampliarNota('59')
#5 /home/drfernan/public_html/php/index.php(22): I2m\i2m_theme_I2M_MAPA_CDP_config_vars->newsGetTheme()
#6 {main}
