Меню
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(2057): DynCom\dc\dcShop\classes\WebshopItemBuilder->getAllWebshopItemsDecoratedForItemListAsArray() #5 /var/www/web2471/htdocs/master/releases/8435764749a8/module/dcshop/catalog/show_item_list.inc.php(2033): query_to_item_array() #6 /var/www/web2471/htdocs/master/releases/8435764749a8/module/dcshop/catalog/show_item_list.inc.php(2012): show_item_list_from_query() #7 /var/www/web2471/htdocs/master/releases/8435764749a8/module/dcshop/catalog/navshop_catalog.inc.php(520): 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}