Каталог товаров
[Bitrix\Main\DB\SqlQueryException] Mysql query error: (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 ') GROUP BY property_name, code, use_synonym2, val1' at line 6 (400) SELECT `property_name`, `code`, `use_synonym2`, COUNT(*) as cnt, CASE WHEN `use_synonym2` = 1 THEN `synonym2` ELSE `val` END AS val1 FROM `sf_props_from_1c` WHERE `filter2` = 1 AND `offer_id` IN () GROUP BY property_name, code, use_synonym2, val1 /home/d/derom/28032019/public_html/bitrix/modules/main/lib/db/mysqliconnection.php:137 #0: Bitrix\Main\DB\MysqliConnection->queryInternal(string, array, NULL) /home/d/derom/28032019/public_html/bitrix/modules/main/lib/db/connection.php:330 #1: Bitrix\Main\DB\Connection->query(string) /home/d/derom/28032019/public_html/local/templates/dresscodeV2/components/bitrix/catalog.smart.filter/serfed/result_modifier.php:127 #2: include(string) /home/d/derom/28032019/public_html/bitrix/modules/main/classes/general/component_template.php:877 #3: CBitrixComponentTemplate->__IncludeMutatorFile(array, array) /home/d/derom/28032019/public_html/bitrix/modules/main/classes/general/component_template.php:784 #4: CBitrixComponentTemplate->IncludeTemplate(array) /home/d/derom/28032019/public_html/bitrix/modules/main/classes/general/component.php:735 #5: CBitrixComponent->showComponentTemplate() /home/d/derom/28032019/public_html/bitrix/modules/main/classes/general/component.php:683 #6: CBitrixComponent->includeComponentTemplate() /home/d/derom/28032019/public_html/bitrix/components/bitrix/catalog.smart.filter/component.php:947 #7: include(string) /home/d/derom/28032019/public_html/bitrix/modules/main/classes/general/component.php:594 #8: CBitrixComponent->__includeComponent() /home/d/derom/28032019/public_html/bitrix/modules/main/classes/general/component.php:102 #9: CBitrixComponent->executeComponent() /home/d/derom/28032019/public_html/bitrix/components/bitrix/catalog.smart.filter/class.php:130 #10: CBitrixCatalogSmartFilter->executeComponent() /home/d/derom/28032019/public_html/bitrix/modules/main/classes/general/component.php:638 #11: CBitrixComponent->includeComponent(string, array, boolean) /home/d/derom/28032019/public_html/bitrix/modules/main/classes/general/main.php:1064 #12: CAllMain->IncludeComponent(string, string, array, boolean) /home/d/derom/28032019/public_html/bitrix/templates/dresscodeV2/components/bitrix/catalog/.default/section.php:230 #13: include(string) /home/d/derom/28032019/public_html/bitrix/modules/main/classes/general/component_template.php:720 #14: CBitrixComponentTemplate->__IncludePHPTemplate(array, array, string) /home/d/derom/28032019/public_html/bitrix/modules/main/classes/general/component_template.php:815 #15: CBitrixComponentTemplate->IncludeTemplate(array) /home/d/derom/28032019/public_html/bitrix/modules/main/classes/general/component.php:735 #16: CBitrixComponent->showComponentTemplate() /home/d/derom/28032019/public_html/bitrix/modules/main/classes/general/component.php:683 #17: CBitrixComponent->includeComponentTemplate(string) /home/d/derom/28032019/public_html/bitrix/components/bitrix/catalog/component.php:172 #18: include(string) /home/d/derom/28032019/public_html/bitrix/modules/main/classes/general/component.php:594 #19: CBitrixComponent->__includeComponent() /home/d/derom/28032019/public_html/bitrix/modules/main/classes/general/component.php:653 #20: CBitrixComponent->includeComponent(string, array, boolean) /home/d/derom/28032019/public_html/bitrix/modules/main/classes/general/main.php:1064 #21: CAllMain->IncludeComponent(string, string, array, boolean) /home/d/derom/28032019/public_html/catalog/index.php:729 #22: include_once(string) /home/d/derom/28032019/public_html/bitrix/modules/main/include/urlrewrite.php:159 #23: include_once(string) /home/d/derom/28032019/public_html/bitrix/urlrewrite.php:2