Warning: odbc_exec(): SQL error: [Sybase][ODBC Driver][Adaptive Server Anywhere]Connection was terminated, SQL state 08S01 in SQLExecDirect in C:\xampp\htdocs\herrerobooks\actions\dao.php on line 1054
Error al ejecutar consulta:
SELECT RE.CODIGO AS CODIGO, RE.NOMBRE AS TITULO, CASE WHEN RE.NOMBRE = REPLACE(RE.NOMBRE, LI.SUBTITU, '') THEN LI.SUBTITU ELSE NULL END AS SUBTITULO, CASE WHEN RE.NOMBRE = REPLACE(RE.NOMBRE, LI.COLECCION, '') THEN LI.COLECCION ELSE NULL END AS COLECCION, LI.EDITORIAL AS EDITORIAL_CODIGO, PR1.NOMBRE AS EDITORIAL_NOMBRE, LI.DISTRI AS DISTRIBUTOR_CODIGO, AUTOR1, ANOEDI, MESEDI, NUMEDI, ENCUADER, PAGINAS, CAST(PESO AS INTEGER), COMENTARIO, SITUACION, ISNULL(RE.VITALSOURCE, 0) AS VITALSOURCE, LI.VITAL_ISBN_PAPEL, ISNULL(LI.VITAL_DISTRIBUIBLE, 0) AS VITAL_DISTRIBUIBLE, LI.VITAL_DURACION_DESC, LI.VITAL_DURACION_ONLINE, ISNULL(AL.UNIDADES, 0) AS ESTOC, CASE WHEN (ISNULL(RE.PROMO_PRECIO, 0) > 0 AND ISNULL(PROM.FIN, '1900-01-01') >= GETDATE()) THEN ISNULL(RE.PROMO_PRECIO, 0) WHEN (ISNULL(LI.PRECIOSALDO, 0) > 0 AND ISNULL(LI.PRECIOSALDO_ACTIVO, 0) = 1) THEN ISNULL(LI.PRECIOSALDO, 0) ELSE ISNULL(RE.PRECIO, 0) END AS PRECIO_FINAL, CASE WHEN RE.IVA IS NOT NULL THEN RE.IVA ELSE CE.IVA END AS IVA, ISNULL(CA.CANTIDAD, 0) AS CARRO_CANT, 0 AS VITAL_LICENCIA FROM CV.TL_RECAMBIO RE INNER JOIN CV.LI_LI LI ON RE.CODIGO = LI.CODIGO LEFT OUTER JOIN CV.PROMOS PROM ON PROM.CODIGO = RE.PROMO_COD LEFT OUTER JOIN CV.TL_ALMACENSTK AL FORCE INDEX (RECAMBIO_ALMACEN) ON AL.RECAMBIO = LI.CODIGO AND AL.ALMACEN = '00' INNER JOIN CV.PROVEE1 PR1 ON PR1.NUM_PROVEE = LI.EDITORIAL LEFT OUTER JOIN CV.CARRITO CA ON CA.PRODUCTO = RE.CODIGO AND COMPRADOR = 'rc55j0evsm8vlma89vfpt74ek9' CROSS JOIN CV.CONFI_EMP CE WHERE RE.CLAVE_REC IN (1252493) AND CE.EMPRESA = 'LH'