SELECT DISTINCT shop_view_active_item.*
FROM shop_item_has_category
INNER JOIN shop_view_active_item ON (
shop_view_active_item.company = shop_item_has_category.company AND
shop_view_active_item.shop_code = shop_item_has_category.shop_code AND
shop_view_active_item.language_code = shop_item_has_category.language_code AND
(
shop_item_has_category.item_no = shop_view_active_item.item_no
)
)
-- LEFT JOIN shop_permissions_group_link ON shop_permissions_group_link.item_no = shop_view_active_item.item_no
-- AND shop_permissions_group_link.company = shop_view_active_item.company
WHERE (shop_item_has_category.category_line_no = 157187 OR shop_item_has_category.category_line_no = )
AND shop_view_active_item.language_code = 'ENU'
AND shop_view_active_item.company = 'DESOI'
AND shop_view_active_item.shop_code = 'B2B'
AND shop_item_has_category.company = 'DESOI'
AND shop_item_has_category.shop_code = 'B2B'
AND shop_item_has_category.language_code = 'ENU'
AND shop_item_has_category.category_shop_code = 'B2B'
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')
AND shop_view_active_item.language_code = 'ENU'
AND shop_vie' at line 14
/var/www/web2471/htdocs/master/releases/8435764749a8/dc/common/traits/genericRepositoryTrait.php #1075
#0 /var/www/web2471/htdocs/master/releases/8435764749a8/dc/common/traits/genericRepositoryTrait.php(1075): PDO->query()
#1 [internal function]: DynCom\dc\dcShop\classes\WebshopItemRepository->getAllByQueryAsArray()
#2 /var/www/web2471/htdocs/master/releases/8435764749a8/module/dcshop/common/classes/WebshopItemBuilder.php(407): Generator->current()
#3 /var/www/web2471/htdocs/master/releases/8435764749a8/module/dcshop/common/classes/WebshopItemBuilder.php(420): DynCom\dc\dcShop\classes\WebshopItemBuilder->buildWebshopItemsFromItemQuery()
#4 /var/www/web2471/htdocs/master/releases/8435764749a8/module/dcshop/catalog/show_item_list.inc.php(2066): DynCom\dc\dcShop\classes\WebshopItemBuilder->getAllWebshopItemsDecoratedForItemListAsArray()
#5 /var/www/web2471/htdocs/master/releases/8435764749a8/module/dcshop/catalog/show_item_list.inc.php(2042): query_to_item_array()
#6 /var/www/web2471/htdocs/master/releases/8435764749a8/module/dcshop/catalog/show_item_list.inc.php(2021): show_item_list_from_query()
#7 /var/www/web2471/htdocs/master/releases/8435764749a8/module/dcshop/catalog/navshop_catalog.inc.php(558): show_item_list_with_pages()
#8 /var/www/web2471/htdocs/master/releases/8435764749a8/module/dcshop/siteparts/main/shop_main.php(83): require_once('/var/www/web247...')
#9 /var/www/web2471/htdocs/master/releases/8435764749a8/dc/frontend/frontend_functions.inc.php(325): shop_main_show()
#10 /var/www/web2471/htdocs/master/releases/8435764749a8/dc/frontend/frontend_functions.inc.php(89): show_sitepart_content()
#11 /var/www/web2471/htdocs/master/releases/8435764749a8/dc/frontend/frontend_desoi_catalog.php(211): get_content()
#12 /var/www/web2471/htdocs/master/releases/8435764749a8/dc/frontend/frontend.php(190): require_once('/var/www/web247...')
#13 {main}
