О нас и о том,
как мы работаем
Все об оплате,
доставке и гарантии
Информация для
профессионалов
Есть вопросы?
Поможем с ответом!
... для прямого
общения
Телефоны и адреса
наших офисов
ENGLISH VERSION

Новые поступления

/ Новые поступления
[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
----------