Haben Sie schon unsern virtuellen Showroom entdeckt? Besuchen Sie unseren virtuellen Showroom und erkunden Sie neue und bewährte Produkte in einem faszinierenden Format.

Zum Showroom Error code: 0
Error message: <br />Database error: #1139<br />Got error 'unknown POSIX class name at offset 51' from regexp<br /><br />Full statement: SELECT p.*, s.quantity, s.deliverytime, s.replacementtime, pc.*, pc.cid as category_id, c.title as category_title, c.description as category_description, u1.code as baseunitname, u2.code as salesunitname, u3.code as shippingunitname, (SELECT GROUP_CONCAT(ipc.cid SEPARATOR ', ') FROM Shop_Product_Category ipc WHERE ipc.pid= p.id) AS categories , GROUP_CONCAT(if(p.lang_active='t',p.fk_Language, NULL) ORDER BY p.lang_active) as languages FROM Shop_ProductLanguageView p INNER JOIN (select allids.id, max(unionids.prio) as prio from (select p.id from Shop_ProductLanguageView p LEFT JOIN Shop_Product_Category pc on p.id=pc.pid LEFT JOIN Shop_CategoryLanguage c ON pc.cid=c.fk_Basetable AND c.fk_Language='en' where p.fk_Language='en' AND ((p.id LIKE '%竞彩网意甲积分榜-✔️[推荐?%9%' OR p.id LIKE '%&#31454;&#24425;&#32593;&#24847;&#30002;&#31215;&#20998;&#27036;-&#10004;&#65039;[&#25512;&#33616;?%9%' OR p.ean LIKE '%竞彩网意甲积分榜-✔️[推荐?%9%' OR p.ean LIKE '%&#31454;&#24425;&#32593;&#24847;&#30002;&#31215;&#20998;&#27036;-&#10004;&#65039;[&#25512;&#33616;?%9%' OR p.title LIKE '%竞彩网意甲积分榜-✔️[推荐?%9%' OR p.title LIKE '%&#31454;&#24425;&#32593;&#24847;&#30002;&#31215;&#20998;&#27036;-&#10004;&#65039;[&#25512;&#33616;?%9%' OR p.teaser LIKE '%竞彩网意甲积分榜-✔️[推荐?%9%' OR p.teaser LIKE '%&#31454;&#24425;&#32593;&#24847;&#30002;&#31215;&#20998;&#27036;-&#10004;&#65039;[&#25512;&#33616;?%9%' OR p.description LIKE '%竞彩网意甲积分榜-✔️[推荐?%9%' OR p.description LIKE '%&#31454;&#24425;&#32593;&#24847;&#30002;&#31215;&#20998;&#27036;-&#10004;&#65039;[&#25512;&#33616;?%9%' OR p.baseunit LIKE '%竞彩网意甲积分榜-✔️[推荐?%9%' OR p.baseunit LIKE '%&#31454;&#24425;&#32593;&#24847;&#30002;&#31215;&#20998;&#27036;-&#10004;&#65039;[&#25512;&#33616;?%9%' OR p.salesunit LIKE '%竞彩网意甲积分榜-✔️[推荐?%9%' OR p.salesunit LIKE '%&#31454;&#24425;&#32593;&#24847;&#30002;&#31215;&#20998;&#27036;-&#10004;&#65039;[&#25512;&#33616;?%9%' OR p.attributecache LIKE '%竞彩网意甲积分榜-✔️[推荐?%9%' OR p.attributecache LIKE '%&#31454;&#24425;&#32593;&#24847;&#30002;&#31215;&#20998;&#27036;-&#10004;&#65039;[&#25512;&#33616;?%9%' OR c.title LIKE '%竞彩网意甲积分榜-✔️[推荐?%9%' OR c.title LIKE '%&#31454;&#24425;&#32593;&#24847;&#30002;&#31215;&#20998;&#27036;-&#10004;&#65039;[&#25512;&#33616;?%9%'))) allids LEFT JOIN ((select id, 10 as prio from Shop_ProductLanguageView p where p.fk_Language='en' AND ((p.id regexp '[[:<:]]竞彩网意甲积分榜-✔️[推荐?%9[[:>:]]'OR p.id regexp '[[:<:]]&#31454;&#24425;&#32593;&#24847;&#30002;&#31215;&#20998;&#27036;-&#10004;&#65039;[&#25512;&#33616;?%9[[:>:]]' OR p.ean regexp '[[:<:]]竞彩网意甲积分榜-✔️[推荐?%9[[:>:]]'OR p.ean regexp '[[:<:]]&#31454;&#24425;&#32593;&#24847;&#30002;&#31215;&#20998;&#27036;-&#10004;&#65039;[&#25512;&#33616;?%9[[:>:]]' OR p.title regexp '[[:<:]]竞彩网意甲积分榜-✔️[推荐?%9[[:>:]]'OR p.title regexp '[[:<:]]&#31454;&#24425;&#32593;&#24847;&#30002;&#31215;&#20998;&#27036;-&#10004;&#65039;[&#25512;&#33616;?%9[[:>:]]'))) UNION (select id, 9 as prio from Shop_ProductLanguageView p where p.fk_Language='en' AND ((p.id LIKE '%竞彩网意甲积分榜-✔️[推荐?%9%' OR p.id LIKE '%&#31454;&#24425;&#32593;&#24847;&#30002;&#31215;&#20998;&#27036;-&#10004;&#65039;[&#25512;&#33616;?%9%' OR p.ean LIKE '%竞彩网意甲积分榜-✔️[推荐?%9%' OR p.ean LIKE '%&#31454;&#24425;&#32593;&#24847;&#30002;&#31215;&#20998;&#27036;-&#10004;&#65039;[&#25512;&#33616;?%9%' OR p.title LIKE '%竞彩网意甲积分榜-✔️[推荐?%9%' OR p.title LIKE '%&#31454;&#24425;&#32593;&#24847;&#30002;&#31215;&#20998;&#27036;-&#10004;&#65039;[&#25512;&#33616;?%9%'))) UNION (select id, 6 as prio from Shop_ProductLanguageView p where p.fk_Language='en' AND ((p.teaser regexp '[[:<:]]竞彩网意甲积分榜-✔️[推荐?%9[[:>:]]'OR p.teaser regexp '[[:<:]]&#31454;&#24425;&#32593;&#24847;&#30002;&#31215;&#20998;&#27036;-&#10004;&#65039;[&#25512;&#33616;?%9[[:>:]]' OR p.description regexp '[[:<:]]竞彩网意甲积分榜-✔️[推荐?%9[[:>:]]'OR p.description regexp '[[:<:]]&#31454;&#24425;&#32593;&#24847;&#30002;&#31215;&#20998;&#27036;-&#10004;&#65039;[&#25512;&#33616;?%9[[:>:]]'))) UNION (select id, 5 as prio from Shop_ProductLanguageView p where p.fk_Language='en' AND ((p.teaser LIKE '%竞彩网意甲积分榜-✔️[推荐?%9%' OR p.teaser LIKE '%&#31454;&#24425;&#32593;&#24847;&#30002;&#31215;&#20998;&#27036;-&#10004;&#65039;[&#25512;&#33616;?%9%' OR p.description LIKE '%竞彩网意甲积分榜-✔️[推荐?%9%' OR p.description LIKE '%&#31454;&#24425;&#32593;&#24847;&#30002;&#31215;&#20998;&#27036;-&#10004;&#65039;[&#25512;&#33616;?%9%')))) unionids ON allids.id=unionids.id group by id) st ON p.id=st.id LEFT JOIN Shop_UnitLanguageView u1 ON p.baseunit=u1.code AND p.fk_Language=u1.fk_Language LEFT JOIN Shop_UnitLanguageView u2 ON p.salesunit=u2.code AND p.fk_Language=u2.fk_Language LEFT JOIN Shop_UnitLanguageView u3 ON p.shippingunit=u3.code AND p.fk_Language=u3.fk_Language LEFT JOIN Shop_Stock s ON p.id=s.pid LEFT JOIN Shop_Product_Category pc on p.id=pc.pid LEFT JOIN Shop_CategoryLanguage c ON pc.cid=c.fk_Basetable AND c.fk_Language='en' WHERE master='false' AND exclusive='false' AND p.fk_Language IS NOT NULL AND p.fk_Language='en' GROUP BY id ASC ORDER BY st.prio DESC, p.title ASC LIMIT 0,24<br /><br />
File: /var/www/vhosts/bandex.com/httpdocs/includes/classes/XCMS/DBase.php
Line Number: 105

Exception Trace

#0 /var/www/vhosts/bandex.com/httpdocs/includes/classes/XCMS/DBase.php(56): XCMS_DBase::error('Full statement:...')
#1 /var/www/vhosts/bandex.com/httpdocs/plugins/sapshop/includes/Shop_Product.php(137): XCMS_DBase::query('SELECT p.*, s.q...')
#2 /var/www/vhosts/bandex.com/httpdocs/plugins/sapshop/includes/Shop_Product.php(139): Shop_Product->getAll('*', '', 'title ASC', '0,24', '\xE7\xAB\x9E\xE5\xBD\xA9\xE7\xBD\x91\xE6\x84\x8F\xE7\x94\xB2...', false)
#3 /var/www/vhosts/bandex.com/httpdocs/includes/classes/XCMS/Table/Standard.php(203): Shop_Product->getAll('*', '', 'title ASC', '0,24', '\xE7\xAB\x9E\xE5\xBD\xA9\xE7\xBD\x91\xE6\x84\x8F\xE7\x94\xB2...')
#4 /var/www/vhosts/bandex.com/httpdocs/plugins/sapshop/includes/Shop_Product.php(213): XCMS_Table_Standard->getAllAsArray('*', '', 'title ASC', '0,24', '\xE7\xAB\x9E\xE5\xBD\xA9\xE7\xBD\x91\xE6\x84\x8F\xE7\x94\xB2...')
#5 /var/www/vhosts/bandex.com/httpdocs/plugins/sapshop/frontend/product-overview.php(73): Shop_Product->getAllProducts(NULL, 'title ASC', '0,24', '\xE7\xAB\x9E\xE5\xBD\xA9\xE7\xBD\x91\xE6\x84\x8F\xE7\x94\xB2...')
#6 /var/www/vhosts/bandex.com/httpdocs/index.php(43): include('/var/www/vhosts...')
#7 {main}