Ups! Ein Fehler ist aufgetreten!

Die nachfolgenden Hinweise sollten Ihnen weiterhelfen.

An exception occurred while executing 'SELECT listing_price.cheapest_price 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 (?) 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, 'super' as term, 27710788 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33361325 as keywordID UNION ALL SELECT 100 as relevance, 'super' as term, 27710788 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33380092 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27713822 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33355346 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27715581 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33368413 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33384204 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33387103 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33350523 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33375419 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33373650 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33366783 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33368221 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33358950 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33387065 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33384327 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33355406 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27720601 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27720608 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33385532 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33362838 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27720233 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33362854 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27712686 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27713823 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33362891 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33365256 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27715758 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27718994 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27722343 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33388076 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33388784 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33361206 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33360356 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33352098 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27712604 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27710777 as keywordID UNION ALL SELECT 100 as relevance, 'soaker' as term, 27715589 as keywordID UNION ALL SELECT 100 as relevance, 'soaker' as term, 27715589 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, 'super' as term, 27710788 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33361325 as keywordID UNION ALL SELECT 100 as relevance, 'super' as term, 27710788 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33380092 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27713822 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33355346 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27715581 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33368413 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33384204 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33387103 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33350523 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33375419 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33373650 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33366783 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33368221 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33358950 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33387065 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33384327 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33355406 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27720601 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27720608 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33385532 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33362838 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27720233 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33362854 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27712686 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27713823 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33362891 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33365256 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27715758 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27718994 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27722343 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33388076 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33388784 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33361206 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33360356 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33352098 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27712604 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27710777 as keywordID UNION ALL SELECT 100 as relevance, 'soaker' as term, 27715589 as keywordID UNION ALL SELECT 100 as relevance, 'soaker' as term, 27715589 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, 'super' as term, 27710788 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33361325 as keywordID UNION ALL SELECT 100 as relevance, 'super' as term, 27710788 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33380092 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27713822 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33355346 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27715581 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33368413 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33384204 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33387103 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33350523 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33375419 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33373650 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33366783 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33368221 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33358950 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33387065 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33384327 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33355406 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27720601 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27720608 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33385532 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33362838 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27720233 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33362854 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27712686 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27713823 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33362891 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33365256 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27715758 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27718994 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27722343 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33388076 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33388784 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33361206 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33360356 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33352098 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27712604 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27710777 as keywordID UNION ALL SELECT 100 as relevance, 'soaker' as term, 27715589 as keywordID UNION ALL SELECT 100 as relevance, 'soaker' as term, 27715589 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, 'super' as term, 27710788 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33361325 as keywordID UNION ALL SELECT 100 as relevance, 'super' as term, 27710788 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33380092 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27713822 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33355346 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27715581 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33368413 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33384204 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33387103 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33350523 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33375419 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33373650 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33366783 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33368221 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33358950 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33387065 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33384327 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33355406 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27720601 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27720608 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33385532 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33362838 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27720233 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33362854 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27712686 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27713823 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33362891 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33365256 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27715758 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27718994 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27722343 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33388076 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33388784 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33361206 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33360356 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33352098 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27712604 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27710777 as keywordID UNION ALL SELECT 100 as relevance, 'soaker' as term, 27715589 as keywordID UNION ALL SELECT 100 as relevance, 'soaker' as term, 27715589 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, 'super' as term, 27710788 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33361325 as keywordID UNION ALL SELECT 100 as relevance, 'super' as term, 27710788 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33380092 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27713822 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33355346 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27715581 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33368413 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33384204 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33387103 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33350523 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33375419 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33373650 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33366783 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33368221 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33358950 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33387065 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33384327 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33355406 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27720601 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27720608 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33385532 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33362838 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27720233 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33362854 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27712686 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27713823 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33362891 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33365256 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27715758 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27718994 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27722343 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33388076 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33388784 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33361206 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33360356 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33352098 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27712604 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27710777 as keywordID UNION ALL SELECT 100 as relevance, 'soaker' as term, 27715589 as keywordID UNION ALL SELECT 100 as relevance, 'soaker' as term, 27715589 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) srd GROUP BY srd.articleID ORDER BY relevance DESC LIMIT 5000) sr INNER JOIN s_articles a ON a.id = sr.articleID 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, 'super' as term, 27710788 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33361325 as keywordID UNION ALL SELECT 100 as relevance, 'super' as term, 27710788 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33380092 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27713822 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33355346 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27715581 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33368413 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33384204 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33387103 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33350523 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33375419 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33373650 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33366783 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33368221 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33358950 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33387065 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33384327 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33355406 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27720601 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27720608 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33385532 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33362838 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27720233 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33362854 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27712686 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27713823 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33362891 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33365256 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27715758 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27718994 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27722343 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33388076 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33388784 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33361206 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33360356 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33352098 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27712604 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27710777 as keywordID UNION ALL SELECT 100 as relevance, 'soaker' as term, 27715589 as keywordID UNION ALL SELECT 100 as relevance, 'soaker' as term, 27715589 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, 'super' as term, 27710788 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33361325 as keywordID UNION ALL SELECT 100 as relevance, 'super' as term, 27710788 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33380092 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27713822 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33355346 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27715581 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33368413 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33384204 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33387103 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33350523 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33375419 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33373650 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33366783 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33368221 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33358950 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33387065 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33384327 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33355406 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27720601 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27720608 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33385532 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33362838 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27720233 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33362854 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27712686 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27713823 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33362891 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33365256 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27715758 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27718994 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27722343 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33388076 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33388784 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33361206 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33360356 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33352098 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27712604 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27710777 as keywordID UNION ALL SELECT 100 as relevance, 'soaker' as term, 27715589 as keywordID UNION ALL SELECT 100 as relevance, 'soaker' as term, 27715589 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, 'super' as term, 27710788 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33361325 as keywordID UNION ALL SELECT 100 as relevance, 'super' as term, 27710788 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33380092 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27713822 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33355346 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27715581 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33368413 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33384204 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33387103 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33350523 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33375419 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33373650 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33366783 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33368221 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33358950 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33387065 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33384327 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33355406 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27720601 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27720608 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33385532 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33362838 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27720233 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33362854 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27712686 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27713823 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33362891 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33365256 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27715758 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27718994 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27722343 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33388076 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33388784 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33361206 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33360356 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33352098 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27712604 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27710777 as keywordID UNION ALL SELECT 100 as relevance, 'soaker' as term, 27715589 as keywordID UNION ALL SELECT 100 as relevance, 'soaker' as term, 27715589 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, 'super' as term, 27710788 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33361325 as keywordID UNION ALL SELECT 100 as relevance, 'super' as term, 27710788 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33380092 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27713822 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33355346 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27715581 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33368413 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33384204 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33387103 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33350523 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33375419 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33373650 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33366783 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33368221 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33358950 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33387065 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33384327 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33355406 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27720601 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27720608 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33385532 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33362838 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27720233 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33362854 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27712686 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27713823 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33362891 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33365256 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27715758 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27718994 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27722343 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33388076 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33388784 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33361206 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33360356 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33352098 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27712604 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27710777 as keywordID UNION ALL SELECT 100 as relevance, 'soaker' as term, 27715589 as keywordID UNION ALL SELECT 100 as relevance, 'soaker' as term, 27715589 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, 'super' as term, 27710788 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33361325 as keywordID UNION ALL SELECT 100 as relevance, 'super' as term, 27710788 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33380092 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27713822 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33355346 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27715581 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33368413 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33384204 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33387103 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33350523 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33375419 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33373650 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33366783 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33368221 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33358950 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33387065 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33384327 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33355406 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27720601 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27720608 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33385532 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33362838 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27720233 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33362854 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27712686 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27713823 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33362891 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33365256 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27715758 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27718994 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27722343 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33388076 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33388784 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33361206 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33360356 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 33352098 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27712604 as keywordID UNION ALL SELECT 50 as relevance, 'super' as term, 27710777 as keywordID UNION ALL SELECT 100 as relevance, 'soaker' as term, 27715589 as keywordID UNION ALL SELECT 100 as relevance, 'soaker' as term, 27715589 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) srd GROUP BY srd.articleID ORDER BY relevance DESC LIMIT 5000) sr INNER JOIN s_articles a ON a.id = sr.articleID)) searchTable ON searchTable.product_id = product.id INNER JOIN s_articles_categories_ro productCategory5 ON productCategory5.articleID = product.id AND productCategory5.categoryID IN (?) INNER JOIN (SELECT prices.*, MIN(ROUND(prices.price * ((100 - IFNULL(priceGroup.discount, 0)) / 100) * (( (CASE tax.id WHEN 1 THEN 8.1 WHEN 4 THEN 2.6 END) + 100) / 100) * 1, 2)) as cheapest_price FROM s_articles product INNER JOIN s_core_tax tax ON tax.id = product.taxID INNER JOIN (SELECT defaultPrice.`id`,defaultPrice.`pricegroup`,defaultPrice.`from`,defaultPrice.`to`,defaultPrice.`articleID`,defaultPrice.`articledetailsID`,defaultPrice.`price`,defaultPrice.`pseudoprice`,defaultPrice.`baseprice`,defaultPrice.`percent`,defaultPrice.articleID as product_id,defaultPrice.articledetailsID as variant_id FROM s_articles_prices defaultPrice WHERE defaultPrice.pricegroup = ?) prices ON product.id = prices.articleID INNER JOIN s_articles_details availableVariant ON availableVariant.articleID = product.id AND availableVariant.active = 1 LEFT JOIN s_core_pricegroups_discounts priceGroup ON priceGroup.groupID = product.pricegroupID AND priceGroup.discountstart = 1 AND priceGroup.customergroupID = ? AND product.pricegroupActive = 1 WHERE (prices.articledetailsID = availableVariant.id) AND (prices.from = 1) GROUP BY product.id) listing_price ON listing_price.articleID = product.id INNER JOIN s_articles_attributes productAttribute ON productAttribute.articledetailsID = variant.id WHERE avoidCustomerGroup.articleID IS NULL GROUP BY product.id ORDER BY listing_price.cheapest_price ASC LIMIT 1 OFFSET 0' with params [1, 3, "EK", 1]: SQLSTATE[HY000]: General error: 3 Error writing file '/tmp/MYJH4Jbr' (Errcode: 28 - No space left on device) in vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php on line 131

Stack trace:

#0 vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(855): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(PDOException), 'SELECT listing_...', Array)
#1 vendor/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(206): Doctrine\DBAL\Connection->executeQuery('SELECT listing_...', Array, Array)
#2 engine/Shopware/Bundle/SearchBundleDBAL/FacetHandler/PriceFacetHandler.php(118): Doctrine\DBAL\Query\QueryBuilder->execute()
#3 engine/Shopware/Bundle/SearchBundleDBAL/ProductNumberSearch.php(176): Shopware\Bundle\SearchBundleDBAL\FacetHandler\PriceFacetHandler->generatePartialFacet(Object(Shopware\Bundle\SearchBundle\Facet\PriceFacet), Object(Shopware\Bundle\SearchBundle\Criteria), Object(Shopware\Bundle\SearchBundle\Criteria), Object(Shopware\Bundle\StoreFrontBundle\Struct\ShopContext))
#4 engine/Shopware/Bundle/SearchBundleDBAL/ProductNumberSearch.php(101): Shopware\Bundle\SearchBundleDBAL\ProductNumberSearch->createFacets(Object(Shopware\Bundle\SearchBundle\Criteria), Object(Shopware\Bundle\StoreFrontBundle\Struct\ShopContext))
#5 engine/Shopware/Bundle/SearchBundle/ProductSearch.php(65): Shopware\Bundle\SearchBundleDBAL\ProductNumberSearch->search(Object(Shopware\Bundle\SearchBundle\Criteria), Object(Shopware\Bundle\StoreFrontBundle\Struct\ShopContext))
#6 engine/Shopware/Bundle/SearchBundle/VariantSearch.php(63): Shopware\Bundle\SearchBundle\ProductSearch->search(Object(Shopware\Bundle\SearchBundle\Criteria), Object(Shopware\Bundle\StoreFrontBundle\Struct\ShopContext))
#7 engine/Shopware/Controllers/Frontend/Search.php(72): Shopware\Bundle\SearchBundle\VariantSearch->search(Object(Shopware\Bundle\SearchBundle\Criteria), Object(Shopware\Bundle\StoreFrontBundle\Struct\ShopContext))
#8 engine/Library/Enlight/Controller/Action.php(193): Shopware_Controllers_Frontend_Search->defaultSearchAction()
#9 engine/Library/Enlight/Controller/Dispatcher/Default.php(548): Enlight_Controller_Action->dispatch('defaultSearchAc...')
#10 engine/Library/Enlight/Controller/Front.php(222): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp))
#11 engine/Shopware/Kernel.php(202): Enlight_Controller_Front->dispatch()
#12 vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(102): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#13 vendor/symfony/http-kernel/HttpCache/HttpCache.php(448): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle(Object(Shopware\Kernel), Object(Symfony\Component\HttpFoundation\Request), 1, true)
#14 engine/Shopware/Components/HttpCache/AppCache.php(268): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL)
#15 vendor/symfony/http-kernel/HttpCache/HttpCache.php(420): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true)
#16 vendor/symfony/http-kernel/HttpCache/HttpCache.php(317): Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch(Object(Symfony\Component\HttpFoundation\Request), true)
#17 engine/Shopware/Components/HttpCache/AppCache.php(189): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true)
#18 vendor/symfony/http-kernel/HttpCache/HttpCache.php(192): Shopware\Components\HttpCache\AppCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true)
#19 engine/Shopware/Components/HttpCache/AppCache.php(116): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#20 shopware.php(122): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request))
#21 {main}