A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: models/Api.php

Line Number: 445

Backtrace:

File: /www/ursino.com.ar/htdocs/develop/application/modules/app/models/Api.php
Line: 445
Function: _error_handler

File: /www/ursino.com.ar/htdocs/develop/application/modules/app/controllers/Site.php
Line: 280
Function: get_books_detail_relateds

File: /www/ursino.com.ar/htdocs/develop/index.php
Line: 370
Function: require_once

Database Error

Ha ocurrido un error con la base de datos

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 a01art.Statu <> 'B' AND a01art.TipPr >= 'V' AND ' at line 13

SELECT a01art.IdArt as 'id', a01art.Statu, CONCAT(DeArt, IF(ISNULL(SuArt),'',CONCAT(' ', SuArt))) as 'title', (SELECT GROUP_CONCAT(a08coa.DeCoa SEPARATOR '-') FROM a10csa LEFT JOIN a08coa ON a10csa.IdEmp = a08coa.IdEmp AND a10csa.IdDes = a08coa.IdDes AND a10csa.IdCoa = a08coa.IdCoa WHERE a10csa.IdEmp = a01art.IdEmp AND a10csa.IdArt = a01art.IdArt AND a10csa.IdDes = 1 GROUP BY a08coa.IdDes LIMIT 1) as 'autor', (SELECT GROUP_CONCAT(a08coa.DeCoa SEPARATOR '-') FROM a10csa LEFT JOIN a08coa ON a10csa.IdEmp = a08coa.IdEmp AND a10csa.IdDes = a08coa.IdDes AND a10csa.IdCoa = a08coa.IdCoa WHERE a10csa.IdEmp = a01art.IdEmp AND a10csa.IdArt = a01art.IdArt AND a10csa.IdDes = 5 GROUP BY a08coa.IdDes LIMIT 1) as 'edicion', (SELECT CONCAT(GROUP_CONCAT(a08coa.DeCoa SEPARATOR '-')) FROM a10csa LEFT JOIN a08coa ON a10csa.IdEmp = a08coa.IdEmp AND a10csa.IdDes = a08coa.IdDes AND a10csa.IdCoa = a08coa.IdCoa WHERE a10csa.IdEmp = a01art.IdEmp AND a10csa.IdArt = a01art.IdArt AND a10csa.IdDes = 2 GROUP BY a08coa.IdDes LIMIT 1) as editorial, (SELECT GROUP_CONCAT(a08coa.DeCoa SEPARATOR '-') FROM a10csa LEFT JOIN a08coa ON a10csa.IdEmp = a08coa.IdEmp AND a10csa.IdDes = a08coa.IdDes AND a10csa.IdCoa = a08coa.IdCoa WHERE a10csa.IdEmp = a01art.IdEmp AND a10csa.IdArt = a01art.IdArt AND a10csa.IdDes = 6 GROUP BY a08coa.IdDes) as 'year', (SELECT GROUP_CONCAT(Codig SEPARATOR '-') FROM a04ide WHERE a04ide.IdEmp = a01art.IdEmp AND a04ide.IdArt = a01art.IdArt AND a04ide.TiCod = 'B' GROUP BY a04ide.IdArt) as 'isbn', IF((SELECT SUM(a13stk.Canti) FROM a13stk WHERE a13stk.IdEmp = a01art.IdEmp AND a13stk.IdArt = a01art.IdArt GROUP BY a13stk.IdArt) >=1, (SELECT MIN(PrePu * Cotiz) FROM a17llp LEFT JOIN g20cot ON g20cot.IdMon = a17llp.IdMon WHERE IdEmp = a01art.IdEmp AND IdArt = a01art.IdArt AND (SELECT SUM(a13stk.Canti) FROM a13stk WHERE a13stk.IdEmp = a01art.IdEmp AND a13stk.IdArt = a01art.IdArt AND a13stk.IdCli = a17llp.IdLis GROUP BY a13stk.IdArt) > 0 LIMIT 1), (SELECT MAX(PrePu * Cotiz) FROM a17llp LEFT JOIN g20cot ON g20cot.IdMon = a17llp.IdMon WHERE IdEmp = a01art.IdEmp AND IdArt = a01art.IdArt LIMIT 1)) AS precio, (SELECT precio * CoLoc FROM a25dap WHERE IdEmp = a01art.IdEmp AND IdDes = 2 AND IdCoa = (SELECT IdCoa FROM a10csa WHERE IdEmp = a01art.IdEmp AND IdArt = a01art.IdArt AND IdDes = 2 LIMIT 1) AND IdArt = a01art.IdArt) AS dto_titulo, (SELECT precio * CoLoc FROM a25dap WHERE IdEmp = a01art.IdEmp AND IdDes = 2 AND IdCoa = (SELECT IdCoa FROM a10csa WHERE IdEmp = a01art.IdEmp AND IdArt = a01art.IdArt AND IdDes = 2 LIMIT 1) AND IdArt = 0) AS dto_editorial, (SELECT SUM(a13stk.Canti) FROM a13stk WHERE a13stk.IdEmp = a01art.IdEmp AND a13stk.IdArt = a01art.IdArt GROUP BY a13stk.IdArt) as stock FROM a10csa LEFT JOIN a01art ON a01art.IdEmp = a10csa.IdEmp AND a01art.IdArt = a10csa.IdArt WHERE a10csa.IdEmp = 1 AND a10csa.IdDes = 3 AND a10csa.IdCoa = AND a01art.Statu <> 'B' AND a01art.TipPr >= 'V' AND a01art.TipPr <= 'W' AND a10csa.IdArt <> 77983 ORDER BY year DESC, stock DESC LIMIT 0, 3

Filename: modules/app/models/Api.php

Line Number: 468