Ups! Ein Fehler ist aufgetreten!

Die nachfolgenden Hinweise sollten Ihnen weiterhelfen.

An exception occurred while executing 'SELECT SQL_CALC_FOUND_ROWS product.id as __product_id, variant.id as __variant_id, variant.ordernumber as __variant_ordernumber, searchTable.* FROM s_articles product INNER JOIN s_articles_details variant ON variant.id = product.main_detail_id AND variant.active = 1 AND product.active = 1 LEFT JOIN s_articles_avoid_customergroups avoidCustomerGroup ON avoidCustomerGroup.articleID = product.id AND avoidCustomerGroup.customerGroupId IN (:customerGroupIds38ba0f9d2195aa1ed719d712288c9fae) INNER JOIN (SELECT a.id as product_id, (sr.relevance + IF(a.topseller = 1, 50, 0) + IF(a.datum >= DATE_SUB(NOW(),INTERVAL 7 DAY), 25, 0)) as ranking FROM (SELECT srd.articleID, SUM(srd.relevance) as relevance, COUNT(DISTINCT term) as termCount FROM ( SELECT MAX(sf.relevance * sm.relevance) as relevance, sm.keywordID, term, si.elementID as articleID FROM (SELECT 100 as relevance, 'stoffwinde' as term, 29389780 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29397898 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 362840 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 19057132 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 19057133 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 19057134 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29155272 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29155273 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29155274 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 19057135 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845212 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8880083 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 6076852 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846251 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045057 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045058 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845213 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18273998 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045059 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846252 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845214 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8880084 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 6076853 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846253 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846254 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845215 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18273999 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846255 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846256 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845216 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8880085 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 45152685 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 6076854 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846257 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045060 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 36787933 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 36787934 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 36787935 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 36787936 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045061 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845217 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18274000 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045062 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846258 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845218 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8880086 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846259 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 6076855 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846260 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045063 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045064 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845219 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18274001 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18274002 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18274003 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045065 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846261 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 569117 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399245 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29388734 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29388735 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 1762 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29388672 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29388606 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29389450 as keywordID UNION ALL SELECT 100 as relevance, 'stoffwinde' as term, 29388707 as keywordID UNION ALL SELECT 100 as relevance, 'stoffwinde' as term, 29389780 as keywordID UNION ALL SELECT 100 as relevance, 'stoffwinde' as term, 29388741 as keywordID UNION ALL SELECT 100 as relevance, 'stoffwinde' as term, 1678 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399239 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29390453 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 42489035 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29401182 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29401186 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29401888 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29390079 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29391604 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29396212 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399971 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29390952 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29395417 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399318 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 33668893 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 1677 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399973 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399187 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 90232 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 6370567 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29391636 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29397886 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399172 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29389473 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29390456 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 12225059 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29390459 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29388800 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29397895 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2869 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 15233669 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 42954881 as keywordID) sm INNER JOIN s_search_index si ON sm.keywordID = si.keywordID INNER JOIN s_search_fields sf ON si.fieldID = sf.id AND sf.relevance != 0 AND sf.tableID = 1 GROUP BY articleID, sm.term, sf.id UNION ALL SELECT MAX(sf.relevance * sm.relevance) as relevance, sm.keywordID, term, st2.articleID as articleID FROM (SELECT 100 as relevance, 'stoffwinde' as term, 29389780 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29397898 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 362840 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 19057132 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 19057133 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 19057134 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29155272 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29155273 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29155274 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 19057135 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845212 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8880083 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 6076852 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846251 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045057 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045058 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845213 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18273998 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045059 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846252 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845214 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8880084 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 6076853 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846253 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846254 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845215 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18273999 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846255 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846256 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845216 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8880085 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 45152685 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 6076854 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846257 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045060 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 36787933 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 36787934 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 36787935 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 36787936 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045061 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845217 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18274000 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045062 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846258 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845218 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8880086 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846259 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 6076855 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846260 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045063 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045064 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845219 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18274001 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18274002 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18274003 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045065 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846261 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 569117 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399245 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29388734 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29388735 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 1762 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29388672 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29388606 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29389450 as keywordID UNION ALL SELECT 100 as relevance, 'stoffwinde' as term, 29388707 as keywordID UNION ALL SELECT 100 as relevance, 'stoffwinde' as term, 29389780 as keywordID UNION ALL SELECT 100 as relevance, 'stoffwinde' as term, 29388741 as keywordID UNION ALL SELECT 100 as relevance, 'stoffwinde' as term, 1678 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399239 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29390453 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 42489035 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29401182 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29401186 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29401888 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29390079 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29391604 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29396212 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399971 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29390952 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29395417 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399318 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 33668893 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 1677 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399973 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399187 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 90232 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 6370567 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29391636 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29397886 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399172 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29389473 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29390456 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 12225059 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29390459 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29388800 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29397895 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2869 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 15233669 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 42954881 as keywordID) sm INNER JOIN s_search_index si ON sm.keywordID = si.keywordID INNER JOIN s_search_fields sf ON si.fieldID = sf.id AND sf.relevance != 0 AND sf.tableID = 2 INNER JOIN s_articles_categories st2 ON si.elementID = st2.categoryID GROUP BY articleID, sm.term, sf.id UNION ALL SELECT MAX(sf.relevance * sm.relevance) as relevance, sm.keywordID, term, st3.id as articleID FROM (SELECT 100 as relevance, 'stoffwinde' as term, 29389780 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29397898 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 362840 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 19057132 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 19057133 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 19057134 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29155272 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29155273 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29155274 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 19057135 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845212 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8880083 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 6076852 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846251 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045057 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045058 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845213 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18273998 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045059 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846252 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845214 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8880084 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 6076853 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846253 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846254 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845215 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18273999 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846255 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846256 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845216 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8880085 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 45152685 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 6076854 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846257 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045060 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 36787933 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 36787934 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 36787935 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 36787936 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045061 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845217 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18274000 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045062 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846258 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845218 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8880086 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846259 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 6076855 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846260 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045063 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045064 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845219 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18274001 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18274002 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18274003 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045065 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846261 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 569117 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399245 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29388734 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29388735 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 1762 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29388672 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29388606 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29389450 as keywordID UNION ALL SELECT 100 as relevance, 'stoffwinde' as term, 29388707 as keywordID UNION ALL SELECT 100 as relevance, 'stoffwinde' as term, 29389780 as keywordID UNION ALL SELECT 100 as relevance, 'stoffwinde' as term, 29388741 as keywordID UNION ALL SELECT 100 as relevance, 'stoffwinde' as term, 1678 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399239 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29390453 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 42489035 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29401182 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29401186 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29401888 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29390079 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29391604 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29396212 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399971 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29390952 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29395417 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399318 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 33668893 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 1677 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399973 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399187 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 90232 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 6370567 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29391636 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29397886 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399172 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29389473 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29390456 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 12225059 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29390459 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29388800 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29397895 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2869 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 15233669 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 42954881 as keywordID) sm INNER JOIN s_search_index si ON sm.keywordID = si.keywordID INNER JOIN s_search_fields sf ON si.fieldID = sf.id AND sf.relevance != 0 AND sf.tableID = 3 INNER JOIN s_articles st3 ON si.elementID = st3.supplierID GROUP BY articleID, sm.term, sf.id UNION ALL SELECT MAX(sf.relevance * sm.relevance) as relevance, sm.keywordID, term, st4.articleID as articleID FROM (SELECT 100 as relevance, 'stoffwinde' as term, 29389780 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29397898 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 362840 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 19057132 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 19057133 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 19057134 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29155272 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29155273 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29155274 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 19057135 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845212 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8880083 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 6076852 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846251 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045057 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045058 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845213 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18273998 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045059 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846252 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845214 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8880084 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 6076853 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846253 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846254 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845215 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18273999 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846255 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846256 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845216 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8880085 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 45152685 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 6076854 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846257 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045060 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 36787933 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 36787934 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 36787935 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 36787936 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045061 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845217 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18274000 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045062 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846258 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845218 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8880086 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846259 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 6076855 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846260 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045063 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045064 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845219 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18274001 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18274002 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18274003 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045065 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846261 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 569117 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399245 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29388734 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29388735 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 1762 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29388672 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29388606 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29389450 as keywordID UNION ALL SELECT 100 as relevance, 'stoffwinde' as term, 29388707 as keywordID UNION ALL SELECT 100 as relevance, 'stoffwinde' as term, 29389780 as keywordID UNION ALL SELECT 100 as relevance, 'stoffwinde' as term, 29388741 as keywordID UNION ALL SELECT 100 as relevance, 'stoffwinde' as term, 1678 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399239 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29390453 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 42489035 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29401182 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29401186 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29401888 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29390079 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29391604 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29396212 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399971 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29390952 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29395417 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399318 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 33668893 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 1677 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399973 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399187 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 90232 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 6370567 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29391636 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29397886 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399172 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29389473 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29390456 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 12225059 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29390459 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29388800 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29397895 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2869 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 15233669 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 42954881 as keywordID) sm INNER JOIN s_search_index si ON sm.keywordID = si.keywordID INNER JOIN s_search_fields sf ON si.fieldID = sf.id AND sf.relevance != 0 AND sf.tableID = 4 INNER JOIN s_articles_details st4 ON si.elementID = st4.id GROUP BY articleID, sm.term, sf.id UNION ALL SELECT MAX(sf.relevance * sm.relevance) as relevance, sm.keywordID, term, si.elementID as articleID FROM (SELECT 100 as relevance, 'stoffwinde' as term, 29389780 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29397898 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 362840 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 19057132 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 19057133 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 19057134 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29155272 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29155273 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29155274 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 19057135 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845212 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8880083 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 6076852 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846251 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045057 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045058 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845213 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18273998 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045059 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846252 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845214 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8880084 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 6076853 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846253 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846254 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845215 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18273999 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846255 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846256 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845216 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8880085 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 45152685 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 6076854 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846257 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045060 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 36787933 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 36787934 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 36787935 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 36787936 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045061 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845217 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18274000 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045062 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846258 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845218 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8880086 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846259 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 6076855 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846260 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045063 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045064 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845219 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18274001 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18274002 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18274003 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045065 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846261 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 569117 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399245 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29388734 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29388735 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 1762 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29388672 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29388606 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29389450 as keywordID UNION ALL SELECT 100 as relevance, 'stoffwinde' as term, 29388707 as keywordID UNION ALL SELECT 100 as relevance, 'stoffwinde' as term, 29389780 as keywordID UNION ALL SELECT 100 as relevance, 'stoffwinde' as term, 29388741 as keywordID UNION ALL SELECT 100 as relevance, 'stoffwinde' as term, 1678 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399239 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29390453 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 42489035 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29401182 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29401186 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29401888 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29390079 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29391604 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29396212 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399971 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29390952 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29395417 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399318 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 33668893 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 1677 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399973 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399187 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 90232 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 6370567 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29391636 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29397886 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399172 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29389473 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29390456 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 12225059 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29390459 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29388800 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29397895 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2869 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 15233669 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 42954881 as keywordID) sm INNER JOIN s_search_index si ON sm.keywordID = si.keywordID INNER JOIN s_search_fields sf ON si.fieldID = sf.id AND sf.relevance != 0 AND sf.tableID = 5 GROUP BY articleID, sm.term, sf.id UNION ALL SELECT MAX(sf.relevance * sm.relevance) as relevance, sm.keywordID, term, si.elementID as articleID FROM (SELECT 100 as relevance, 'stoffwinde' as term, 29389780 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29397898 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 362840 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 19057132 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 19057133 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 19057134 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29155272 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29155273 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29155274 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 19057135 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845212 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8880083 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 6076852 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846251 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045057 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045058 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845213 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18273998 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045059 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846252 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845214 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8880084 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 6076853 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846253 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846254 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845215 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18273999 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846255 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846256 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845216 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8880085 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 45152685 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 6076854 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846257 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045060 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 36787933 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 36787934 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 36787935 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 36787936 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045061 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845217 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18274000 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045062 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846258 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845218 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8880086 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846259 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 6076855 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846260 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045063 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045064 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845219 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18274001 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18274002 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18274003 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045065 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846261 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 569117 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399245 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29388734 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29388735 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 1762 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29388672 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29388606 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29389450 as keywordID UNION ALL SELECT 100 as relevance, 'stoffwinde' as term, 29388707 as keywordID UNION ALL SELECT 100 as relevance, 'stoffwinde' as term, 29389780 as keywordID UNION ALL SELECT 100 as relevance, 'stoffwinde' as term, 29388741 as keywordID UNION ALL SELECT 100 as relevance, 'stoffwinde' as term, 1678 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399239 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29390453 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 42489035 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29401182 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29401186 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29401888 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29390079 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29391604 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29396212 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399971 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29390952 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29395417 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399318 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 33668893 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 1677 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399973 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399187 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 90232 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 6370567 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29391636 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29397886 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399172 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29389473 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29390456 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 12225059 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29390459 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29388800 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29397895 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2869 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 15233669 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 42954881 as keywordID) sm INNER JOIN s_search_index si ON sm.keywordID = si.keywordID INNER JOIN s_search_fields sf ON si.fieldID = sf.id AND sf.relevance != 0 AND sf.tableID = 7 GROUP BY articleID, sm.term, sf.id) srd GROUP BY srd.articleID ORDER BY relevance DESC LIMIT 5000) sr INNER JOIN s_articles a ON a.id = sr.articleID AND a.active = 1 WHERE (sr.relevance + IF(a.topseller = 1, 50, 0) + IF(a.datum >= DATE_SUB(NOW(),INTERVAL 7 DAY), 25, 0)) > (SELECT MAX(sr.relevance + IF(a.topseller = 1, 50, 0) + IF(a.datum >= DATE_SUB(NOW(),INTERVAL 7 DAY), 25, 0)) / 100 * 20 FROM (SELECT srd.articleID, SUM(srd.relevance) as relevance, COUNT(DISTINCT term) as termCount FROM ( SELECT MAX(sf.relevance * sm.relevance) as relevance, sm.keywordID, term, si.elementID as articleID FROM (SELECT 100 as relevance, 'stoffwinde' as term, 29389780 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29397898 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 362840 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 19057132 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 19057133 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 19057134 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29155272 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29155273 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29155274 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 19057135 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845212 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8880083 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 6076852 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846251 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045057 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045058 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845213 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18273998 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045059 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846252 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845214 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8880084 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 6076853 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846253 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846254 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845215 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18273999 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846255 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846256 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845216 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8880085 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 45152685 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 6076854 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846257 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045060 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 36787933 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 36787934 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 36787935 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 36787936 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045061 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845217 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18274000 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045062 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846258 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845218 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8880086 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846259 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 6076855 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846260 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045063 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045064 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845219 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18274001 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18274002 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18274003 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045065 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846261 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 569117 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399245 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29388734 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29388735 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 1762 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29388672 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29388606 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29389450 as keywordID UNION ALL SELECT 100 as relevance, 'stoffwinde' as term, 29388707 as keywordID UNION ALL SELECT 100 as relevance, 'stoffwinde' as term, 29389780 as keywordID UNION ALL SELECT 100 as relevance, 'stoffwinde' as term, 29388741 as keywordID UNION ALL SELECT 100 as relevance, 'stoffwinde' as term, 1678 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399239 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29390453 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 42489035 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29401182 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29401186 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29401888 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29390079 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29391604 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29396212 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399971 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29390952 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29395417 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399318 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 33668893 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 1677 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399973 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399187 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 90232 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 6370567 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29391636 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29397886 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399172 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29389473 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29390456 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 12225059 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29390459 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29388800 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29397895 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2869 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 15233669 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 42954881 as keywordID) sm INNER JOIN s_search_index si ON sm.keywordID = si.keywordID INNER JOIN s_search_fields sf ON si.fieldID = sf.id AND sf.relevance != 0 AND sf.tableID = 1 GROUP BY articleID, sm.term, sf.id UNION ALL SELECT MAX(sf.relevance * sm.relevance) as relevance, sm.keywordID, term, st2.articleID as articleID FROM (SELECT 100 as relevance, 'stoffwinde' as term, 29389780 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29397898 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 362840 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 19057132 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 19057133 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 19057134 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29155272 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29155273 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29155274 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 19057135 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845212 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8880083 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 6076852 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846251 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045057 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045058 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845213 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18273998 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045059 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846252 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845214 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8880084 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 6076853 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846253 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846254 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845215 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18273999 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846255 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846256 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845216 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8880085 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 45152685 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 6076854 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846257 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045060 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 36787933 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 36787934 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 36787935 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 36787936 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045061 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845217 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18274000 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045062 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846258 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845218 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8880086 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846259 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 6076855 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846260 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045063 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045064 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845219 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18274001 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18274002 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18274003 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045065 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846261 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 569117 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399245 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29388734 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29388735 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 1762 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29388672 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29388606 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29389450 as keywordID UNION ALL SELECT 100 as relevance, 'stoffwinde' as term, 29388707 as keywordID UNION ALL SELECT 100 as relevance, 'stoffwinde' as term, 29389780 as keywordID UNION ALL SELECT 100 as relevance, 'stoffwinde' as term, 29388741 as keywordID UNION ALL SELECT 100 as relevance, 'stoffwinde' as term, 1678 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399239 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29390453 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 42489035 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29401182 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29401186 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29401888 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29390079 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29391604 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29396212 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399971 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29390952 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29395417 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399318 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 33668893 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 1677 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399973 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399187 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 90232 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 6370567 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29391636 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29397886 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399172 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29389473 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29390456 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 12225059 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29390459 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29388800 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29397895 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2869 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 15233669 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 42954881 as keywordID) sm INNER JOIN s_search_index si ON sm.keywordID = si.keywordID INNER JOIN s_search_fields sf ON si.fieldID = sf.id AND sf.relevance != 0 AND sf.tableID = 2 INNER JOIN s_articles_categories st2 ON si.elementID = st2.categoryID GROUP BY articleID, sm.term, sf.id UNION ALL SELECT MAX(sf.relevance * sm.relevance) as relevance, sm.keywordID, term, st3.id as articleID FROM (SELECT 100 as relevance, 'stoffwinde' as term, 29389780 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29397898 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 362840 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 19057132 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 19057133 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 19057134 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29155272 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29155273 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29155274 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 19057135 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845212 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8880083 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 6076852 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846251 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045057 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045058 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845213 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18273998 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045059 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846252 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845214 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8880084 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 6076853 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846253 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846254 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845215 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18273999 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846255 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846256 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845216 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8880085 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 45152685 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 6076854 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846257 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045060 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 36787933 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 36787934 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 36787935 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 36787936 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045061 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845217 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18274000 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045062 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846258 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845218 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8880086 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846259 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 6076855 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846260 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045063 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045064 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845219 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18274001 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18274002 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18274003 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045065 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846261 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 569117 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399245 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29388734 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29388735 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 1762 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29388672 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29388606 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29389450 as keywordID UNION ALL SELECT 100 as relevance, 'stoffwinde' as term, 29388707 as keywordID UNION ALL SELECT 100 as relevance, 'stoffwinde' as term, 29389780 as keywordID UNION ALL SELECT 100 as relevance, 'stoffwinde' as term, 29388741 as keywordID UNION ALL SELECT 100 as relevance, 'stoffwinde' as term, 1678 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399239 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29390453 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 42489035 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29401182 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29401186 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29401888 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29390079 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29391604 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29396212 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399971 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29390952 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29395417 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399318 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 33668893 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 1677 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399973 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399187 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 90232 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 6370567 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29391636 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29397886 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399172 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29389473 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29390456 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 12225059 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29390459 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29388800 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29397895 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2869 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 15233669 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 42954881 as keywordID) sm INNER JOIN s_search_index si ON sm.keywordID = si.keywordID INNER JOIN s_search_fields sf ON si.fieldID = sf.id AND sf.relevance != 0 AND sf.tableID = 3 INNER JOIN s_articles st3 ON si.elementID = st3.supplierID GROUP BY articleID, sm.term, sf.id UNION ALL SELECT MAX(sf.relevance * sm.relevance) as relevance, sm.keywordID, term, st4.articleID as articleID FROM (SELECT 100 as relevance, 'stoffwinde' as term, 29389780 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29397898 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 362840 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 19057132 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 19057133 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 19057134 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29155272 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29155273 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29155274 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 19057135 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845212 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8880083 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 6076852 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846251 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045057 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045058 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845213 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18273998 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045059 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846252 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845214 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8880084 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 6076853 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846253 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846254 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845215 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18273999 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846255 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846256 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845216 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8880085 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 45152685 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 6076854 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846257 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045060 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 36787933 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 36787934 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 36787935 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 36787936 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045061 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845217 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18274000 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045062 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846258 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845218 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8880086 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846259 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 6076855 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846260 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045063 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045064 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845219 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18274001 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18274002 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18274003 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045065 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846261 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 569117 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399245 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29388734 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29388735 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 1762 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29388672 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29388606 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29389450 as keywordID UNION ALL SELECT 100 as relevance, 'stoffwinde' as term, 29388707 as keywordID UNION ALL SELECT 100 as relevance, 'stoffwinde' as term, 29389780 as keywordID UNION ALL SELECT 100 as relevance, 'stoffwinde' as term, 29388741 as keywordID UNION ALL SELECT 100 as relevance, 'stoffwinde' as term, 1678 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399239 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29390453 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 42489035 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29401182 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29401186 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29401888 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29390079 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29391604 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29396212 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399971 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29390952 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29395417 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399318 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 33668893 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 1677 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399973 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399187 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 90232 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 6370567 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29391636 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29397886 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399172 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29389473 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29390456 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 12225059 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29390459 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29388800 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29397895 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2869 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 15233669 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 42954881 as keywordID) sm INNER JOIN s_search_index si ON sm.keywordID = si.keywordID INNER JOIN s_search_fields sf ON si.fieldID = sf.id AND sf.relevance != 0 AND sf.tableID = 4 INNER JOIN s_articles_details st4 ON si.elementID = st4.id GROUP BY articleID, sm.term, sf.id UNION ALL SELECT MAX(sf.relevance * sm.relevance) as relevance, sm.keywordID, term, si.elementID as articleID FROM (SELECT 100 as relevance, 'stoffwinde' as term, 29389780 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29397898 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 362840 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 19057132 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 19057133 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 19057134 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29155272 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29155273 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29155274 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 19057135 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845212 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8880083 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 6076852 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846251 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045057 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045058 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845213 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18273998 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045059 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846252 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845214 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8880084 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 6076853 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846253 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846254 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845215 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18273999 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846255 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846256 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845216 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8880085 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 45152685 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 6076854 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846257 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045060 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 36787933 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 36787934 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 36787935 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 36787936 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045061 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845217 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18274000 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045062 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846258 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845218 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8880086 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846259 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 6076855 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846260 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045063 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045064 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845219 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18274001 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18274002 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18274003 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045065 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846261 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 569117 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399245 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29388734 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29388735 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 1762 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29388672 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29388606 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29389450 as keywordID UNION ALL SELECT 100 as relevance, 'stoffwinde' as term, 29388707 as keywordID UNION ALL SELECT 100 as relevance, 'stoffwinde' as term, 29389780 as keywordID UNION ALL SELECT 100 as relevance, 'stoffwinde' as term, 29388741 as keywordID UNION ALL SELECT 100 as relevance, 'stoffwinde' as term, 1678 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399239 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29390453 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 42489035 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29401182 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29401186 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29401888 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29390079 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29391604 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29396212 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399971 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29390952 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29395417 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399318 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 33668893 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 1677 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399973 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399187 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 90232 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 6370567 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29391636 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29397886 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399172 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29389473 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29390456 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 12225059 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29390459 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29388800 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29397895 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2869 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 15233669 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 42954881 as keywordID) sm INNER JOIN s_search_index si ON sm.keywordID = si.keywordID INNER JOIN s_search_fields sf ON si.fieldID = sf.id AND sf.relevance != 0 AND sf.tableID = 5 GROUP BY articleID, sm.term, sf.id UNION ALL SELECT MAX(sf.relevance * sm.relevance) as relevance, sm.keywordID, term, si.elementID as articleID FROM (SELECT 100 as relevance, 'stoffwinde' as term, 29389780 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29397898 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 362840 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 19057132 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 19057133 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 19057134 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29155272 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29155273 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29155274 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 19057135 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845212 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8880083 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 6076852 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846251 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045057 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045058 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845213 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18273998 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045059 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846252 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845214 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8880084 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 6076853 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846253 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846254 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845215 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18273999 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846255 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846256 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845216 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8880085 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 45152685 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 6076854 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846257 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045060 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 36787933 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 36787934 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 36787935 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 36787936 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045061 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845217 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18274000 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045062 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846258 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845218 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8880086 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846259 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 6076855 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846260 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045063 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045064 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 8845219 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18274001 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18274002 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 18274003 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2045065 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2846261 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 569117 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399245 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29388734 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29388735 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 1762 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29388672 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29388606 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29389450 as keywordID UNION ALL SELECT 100 as relevance, 'stoffwinde' as term, 29388707 as keywordID UNION ALL SELECT 100 as relevance, 'stoffwinde' as term, 29389780 as keywordID UNION ALL SELECT 100 as relevance, 'stoffwinde' as term, 29388741 as keywordID UNION ALL SELECT 100 as relevance, 'stoffwinde' as term, 1678 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399239 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29390453 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 42489035 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29401182 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29401186 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29401888 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29390079 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29391604 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29396212 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399971 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29390952 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29395417 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399318 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 33668893 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 1677 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399973 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399187 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 90232 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 6370567 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29391636 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29397886 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29399172 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29389473 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29390456 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 12225059 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29390459 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29388800 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 29397895 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 2869 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 15233669 as keywordID UNION ALL SELECT 50 as relevance, 'stoffwinde' as term, 42954881 as keywordID) sm INNER JOIN s_search_index si ON sm.keywordID = si.keywordID INNER JOIN s_search_fields sf ON si.fieldID = sf.id AND sf.relevance != 0 AND sf.tableID = 7 GROUP BY articleID, sm.term, sf.id) srd GROUP BY srd.articleID ORDER BY relevance DESC LIMIT 5000) sr INNER JOIN s_articles a ON a.id = sr.articleID AND a.active = 1)) searchTable ON searchTable.product_id = product.id INNER JOIN s_articles_categories_ro productCategory ON productCategory.articleID = product.id AND productCategory.categoryID IN (:productCategory) INNER JOIN s_articles_attributes productAttribute ON productAttribute.articledetailsID = variant.id WHERE avoidCustomerGroup.articleID IS NULL GROUP BY product.id ORDER BY FIELD (product.id, :fieldIds) ASC, variant.id ASC LIMIT 200': 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 ':customerGroupIds38ba0f9d2195aa1ed719d712288c9fae) INNER JOIN (SELECT a.id as...' at line 4 in /var/www/11326/die-besten-stoffwindeln.de/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php on line 98

Stack trace:

#0 /var/www/11326/die-besten-stoffwindeln.de/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(182): Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException()
#1 /var/www/11326/die-besten-stoffwindeln.de/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(159): Doctrine\DBAL\DBALException::wrapException()
#2 /var/www/11326/die-besten-stoffwindeln.de/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(2226): Doctrine\DBAL\DBALException::driverExceptionDuringQuery()
#3 /var/www/11326/die-besten-stoffwindeln.de/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1313): Doctrine\DBAL\Connection->handleExceptionDuringQuery()
#4 /var/www/11326/die-besten-stoffwindeln.de/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(212): Doctrine\DBAL\Connection->executeQuery()
#5 /var/www/11326/die-besten-stoffwindeln.de/htdocs/engine/Shopware/Bundle/SearchBundleDBAL/ProductNumberSearch.php(101): Doctrine\DBAL\Query\QueryBuilder->execute()
#6 /var/www/11326/die-besten-stoffwindeln.de/htdocs/engine/Shopware/Bundle/SearchBundleDBAL/ProductNumberSearch.php(84): Shopware\Bundle\SearchBundleDBAL\ProductNumberSearch->getProducts()
#7 /var/www/11326/die-besten-stoffwindeln.de/htdocs/engine/Shopware/Plugins/Community/Frontend/SwkweSetBuy/Bundle/SearchBundleDBAL/ProductNumberSearch.php(30): Shopware\Bundle\SearchBundleDBAL\ProductNumberSearch->search()
#8 /var/www/11326/die-besten-stoffwindeln.de/htdocs/engine/Shopware/Plugins/Community/Frontend/IntediaDoofinder/Search/DoofinderProductNumberSearch.php(211): Shopware\Plugins\SwkweSetBuy\Bundle\SearchBundleDBAL\ProductNumberSearch->search()
#9 /var/www/11326/die-besten-stoffwindeln.de/htdocs/custom/plugins/PxExtendArticlesWithVariants/Bundle/SearchBundle/ProductSearch.php(41): ShopwarePlugins\IntediaDoofinder\Search\DoofinderProductNumberSearch->search()
#10 /var/www/11326/die-besten-stoffwindeln.de/htdocs/engine/Shopware/Bundle/SearchBundle/VariantSearch.php(66): PxExtendArticlesWithVariants\Bundle\SearchBundle\ProductSearch->search()
#11 /var/www/11326/die-besten-stoffwindeln.de/htdocs/engine/Shopware/Controllers/Frontend/Search.php(74): Shopware\Bundle\SearchBundle\VariantSearch->search()
#12 /var/www/11326/die-besten-stoffwindeln.de/htdocs/engine/Library/Enlight/Controller/Action.php(187): Shopware_Controllers_Frontend_Search->defaultSearchAction()
#13 /var/www/11326/die-besten-stoffwindeln.de/htdocs/engine/Library/Enlight/Controller/Dispatcher/Default.php(467): Enlight_Controller_Action->dispatch()
#14 /var/www/11326/die-besten-stoffwindeln.de/htdocs/engine/Library/Enlight/Controller/Front.php(226): Enlight_Controller_Dispatcher_Default->dispatch()
#15 /var/www/11326/die-besten-stoffwindeln.de/htdocs/engine/Shopware/Kernel.php(197): Enlight_Controller_Front->dispatch()
#16 /var/www/11326/die-besten-stoffwindeln.de/htdocs/vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(85): Shopware\Kernel->handle()
#17 /var/www/11326/die-besten-stoffwindeln.de/htdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(479): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle()
#18 /var/www/11326/die-besten-stoffwindeln.de/htdocs/engine/Shopware/Components/HttpCache/AppCache.php(270): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward()
#19 /var/www/11326/die-besten-stoffwindeln.de/htdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(452): Shopware\Components\HttpCache\AppCache->forward()
#20 /var/www/11326/die-besten-stoffwindeln.de/htdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(346): Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch()
#21 /var/www/11326/die-besten-stoffwindeln.de/htdocs/engine/Shopware/Components/HttpCache/AppCache.php(196): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup()
#22 /var/www/11326/die-besten-stoffwindeln.de/htdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(224): Shopware\Components\HttpCache\AppCache->lookup()
#23 /var/www/11326/die-besten-stoffwindeln.de/htdocs/engine/Shopware/Components/HttpCache/AppCache.php(117): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle()
#24 /var/www/11326/die-besten-stoffwindeln.de/htdocs/shopware.php(122): Shopware\Components\HttpCache\AppCache->handle()
#25 {main}