Новые поступления
[Bitrix\Main\DB\SqlQueryException]
MS Sql query error: SQLSTATE: 42000; code: 156; message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Неправильный синтаксис около ключевого слова "FETCH".
SQLSTATE: 42000; code: 153; message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Недопустимое использование параметра NEXT в инструкции FETCH.
(400)
/* voltag:news.list (news list) */
WITH X AS (
SELECT FORMAT(i._Date_Time, 'dd/MM/yyyy') AS DATE
, i._Date_Time AS DATETIME
, i._IDRRef AS IDRREF
, ABS(CAST(i._IDRRef AS BIGINT) % 25) AS IMG_NUM
, ISNULL(itr._Fld8884, i._Fld9145) AS TOPIC
, CAST(br._Fld8767 AS VARCHAR(64)) AS BRAND
, 'INCOME' AS TYPE
FROM _Reference45 br, _Document138 i
LEFT JOIN _Reference8874_VT8881 itr
ON i._Fld9193RRef = itr._Reference8874_IDRRef
AND itr._Fld8883RRef IN (SELECT lng._IDRRef
FROM _Reference8871 lng
WHERE lng._Description = 'RU')
WHERE i._Fld9143 = 1
AND i._Fld9144RRef = br._IDRRef
AND i._Marked = 0x00
AND i._Fld3116RRef IN(
SELECT DISTINCT W_IDRREF
FROM v_agreement2 (SNAPSHOT), v_warehouse2 (SNAPSHOT)
WHERE A_CUSTOMER = 0x9104000c29e00b1311df492c2b414ad6
AND (A_WAREHOUSE = W_IDRREF OR A_WAREHOUSE = W_ROOT_IDRREF)
)
)
SELECT X.DATE AS DATE
, X.IDRREF AS IDRREF
, X.IMG_NUM AS IMG_NUM
, X.TOPIC AS TOPIC
, X.BRAND AS BRAND
, X.TYPE AS TYPE
, ROW_NUMBER() OVER (ORDER BY X.DATETIME DESC) AS INCOME_NUM
FROM X
ORDER BY X.DATETIME DESC
OFFSET ROWS FETCH NEXT 10 ROWS ONLY
/var/www/local/modules/voltag/lib/db/PHP8_mssqlconnection.php:95
#0: Voltag\DB\PHP8_MSSQLConnection->queryInternal
/var/www/bitrix_business/modules/main/lib/db/connection.php:331
#1: Bitrix\Main\DB\Connection->query
/var/www/local/components/voltag/news.list/class.php:271
#2: Voltag\NewsList->onPrepareItemsQuery
/var/www/local/modules/voltag/lib/items_list.php:98
#3: Voltag\ItemsList->getItemsWithPrice
/var/www/local/components/voltag/action.list/class.php:201
#4: Voltag\ActionList->getItemsWithPrice
/var/www/local/modules/voltag/lib/items_list.php:302
#5: Voltag\ItemsList->executeComponent
/var/www/bitrix_business/modules/main/classes/general/component.php:668
#6: CBitrixComponent->includeComponent
/var/www/bitrix_business/modules/main/classes/general/main.php:1195
#7: CAllMain->IncludeComponent
/var/www/voltag.ru/about/news/index.php:26
#8: include_once(string)
/var/www/bitrix_business/modules/main/include/urlrewrite.php:184
#9: include_once(string)
/var/www/bitrix_business/urlrewrite.php:2
----------