SELECT DISTINCT svac.*
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
OR
shop_item_has_category.item_no = shop_view_active_item.parent_item_group_no
)
)
LEFT JOIN shop_item_attribute_links_ext sial ON (
sial.company = 'DESOI'
AND sial.shop_code = 'B2B'
AND sial.no = shop_view_active_item.item_no
AND (sial.language_code = 'DEU' OR sial.language_code = '')
)
RIGHT JOIN shop_view_active_item svac
ON svac.item_no = shop_view_active_item.item_no
AND svac.company = shop_view_active_item.company
AND svac.shop_code = shop_view_active_item.shop_code
AND svac.language_code = shop_view_active_item.language_code
WHERE (shop_item_has_category.category_line_no = 158281)
AND shop_view_active_item.language_code = 'DEU'
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 = 'DEU'
AND shop_item_has_category.category_shop_code = 'B2B'
AND
( ( sial.='kom' AND sial.attribute_code='ART-SERV'))
AND sial.shop_code = 'B2B'
AND (
(
sial.type = 0
AND sial.company = 'DESOI'
)
OR (
sial.company IS NULL
AND sial.type IS NULL
)
) GROUP BY shop_view_active_item.item_no HAVING COUNT(DISTINCT sial.attribute_code) = 1
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 '='kom' AND sial.attribute_code='ART-SERV'))
' at line 37
/var/www/web2471/htdocs/master/releases/6e2cc409/dc/common/traits/genericRepositoryTrait.php #1075
#0 /var/www/web2471/htdocs/master/releases/6e2cc409/dc/common/traits/genericRepositoryTrait.php(1075): PDO->query()
#1 [internal function]: DynCom\dc\dcShop\classes\WebshopItemRepository->getAllByQueryAsArray()
#2 /var/www/web2471/htdocs/master/releases/6e2cc409/module/dcshop/common/classes/WebshopItemBuilder.php(407): Generator->current()
#3 /var/www/web2471/htdocs/master/releases/6e2cc409/module/dcshop/common/classes/WebshopItemBuilder.php(420): DynCom\dc\dcShop\classes\WebshopItemBuilder->buildWebshopItemsFromItemQuery()
#4 /var/www/web2471/htdocs/master/releases/6e2cc409/module/dcshop/catalog/show_item_list.inc.php(2131): DynCom\dc\dcShop\classes\WebshopItemBuilder->getAllWebshopItemsDecoratedForItemListAsArray()
#5 /var/www/web2471/htdocs/master/releases/6e2cc409/module/dcshop/catalog/show_item_list.inc.php(2107): query_to_item_array()
#6 /var/www/web2471/htdocs/master/releases/6e2cc409/module/dcshop/catalog/show_item_list.inc.php(2086): show_item_list_from_query()
#7 /var/www/web2471/htdocs/master/releases/6e2cc409/module/dcshop/catalog/navshop_catalog.inc.php(551): show_item_list_with_pages()
#8 /var/www/web2471/htdocs/master/releases/6e2cc409/module/dcshop/siteparts/main/shop_main.php(83): require_once('/var/www/web247...')
#9 /var/www/web2471/htdocs/master/releases/6e2cc409/dc/frontend/frontend_functions.inc.php(325): shop_main_show()
#10 /var/www/web2471/htdocs/master/releases/6e2cc409/dc/frontend/frontend_functions.inc.php(89): show_sitepart_content()
#11 /var/www/web2471/htdocs/master/releases/6e2cc409/dc/frontend/frontend_desoi_catalog.php(240): get_content()
#12 /var/www/web2471/htdocs/master/releases/6e2cc409/dc/frontend/frontend.php(177): require_once('/var/www/web247...')
#13 {main} 
