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, 'sio' as term, 3891 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 20067278 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 14016161 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 831518 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 13801089 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 3709788 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 197116 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 831519 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 206210 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 9656609 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 206212 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376038 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376039 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376040 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376042 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376043 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376044 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376046 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376047 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376060 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376061 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376062 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376063 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 33095727 as keywordID UNION ALL SELECT 5 as relevance, 'sio' as term, 3891 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 29392338 as keywordID UNION ALL SELECT 100 as relevance, 'ueberhose' as term, 1867 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352286 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16118264 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056959 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056960 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640243 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734633 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734634 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370380 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370381 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056961 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352287 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640244 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640245 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640246 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093813 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370382 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352288 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16118265 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056962 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056963 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640247 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734635 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734636 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370383 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370384 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056964 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352289 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640248 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640249 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640250 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093814 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370385 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352290 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16118266 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056965 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056966 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640251 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734637 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734638 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370386 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370387 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056967 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352291 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640252 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640253 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640254 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093815 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370388 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537702 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537703 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177730 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177731 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611507 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352292 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177732 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734639 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640255 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799465 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177733 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177734 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611508 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611509 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537704 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537705 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537706 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734640 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611510 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611511 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734641 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611512 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537707 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611513 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537708 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611514 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093816 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611515 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734642 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537709 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537710 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093817 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177735 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611516 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611517 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611518 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799466 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611519 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611520 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537711 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537712 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537713 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177736 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177737 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611521 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352293 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177738 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734643 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640256 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799467 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177739 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177740 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611522 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611523 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537714 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537715 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537716 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734644 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611524 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611525 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734645 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611526 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537717 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611527 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537718 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611528 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093818 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611529 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734646 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537719 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537720 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093819 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177741 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611530 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611531 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611532 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799468 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611533 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611534 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537721 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537722 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537723 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177742 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177743 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611535 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352294 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177744 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734647 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640257 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799469 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177745 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177746 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611536 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611537 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537724 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537725 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537726 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734648 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611538 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611539 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734649 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611540 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537727 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611541 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537728 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611542 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093820 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611543 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734650 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537729 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537730 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093821 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177747 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611544 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611545 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611546 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799470 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611547 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611548 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537731 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388788 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29399257 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388801 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388800 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388909 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 1921 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388881 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29391639 as keywordID UNION ALL SELECT 100 as relevance, 'ueberhose' as term, 29390076 as keywordID UNION ALL SELECT 100 as relevance, 'ueberhose' as term, 1867 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29401926 as keywordID UNION ALL SELECT 100 as relevance, 'ueberhose' as term, 1872 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29401925 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29390071 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 142011 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388696 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388787 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 1909 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 1841 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, 'sio' as term, 3891 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 20067278 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 14016161 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 831518 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 13801089 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 3709788 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 197116 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 831519 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 206210 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 9656609 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 206212 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376038 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376039 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376040 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376042 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376043 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376044 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376046 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376047 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376060 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376061 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376062 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376063 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 33095727 as keywordID UNION ALL SELECT 5 as relevance, 'sio' as term, 3891 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 29392338 as keywordID UNION ALL SELECT 100 as relevance, 'ueberhose' as term, 1867 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352286 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16118264 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056959 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056960 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640243 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734633 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734634 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370380 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370381 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056961 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352287 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640244 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640245 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640246 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093813 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370382 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352288 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16118265 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056962 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056963 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640247 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734635 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734636 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370383 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370384 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056964 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352289 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640248 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640249 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640250 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093814 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370385 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352290 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16118266 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056965 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056966 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640251 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734637 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734638 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370386 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370387 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056967 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352291 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640252 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640253 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640254 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093815 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370388 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537702 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537703 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177730 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177731 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611507 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352292 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177732 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734639 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640255 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799465 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177733 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177734 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611508 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611509 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537704 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537705 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537706 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734640 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611510 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611511 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734641 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611512 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537707 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611513 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537708 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611514 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093816 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611515 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734642 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537709 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537710 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093817 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177735 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611516 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611517 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611518 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799466 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611519 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611520 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537711 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537712 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537713 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177736 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177737 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611521 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352293 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177738 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734643 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640256 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799467 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177739 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177740 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611522 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611523 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537714 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537715 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537716 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734644 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611524 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611525 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734645 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611526 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537717 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611527 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537718 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611528 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093818 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611529 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734646 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537719 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537720 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093819 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177741 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611530 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611531 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611532 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799468 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611533 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611534 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537721 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537722 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537723 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177742 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177743 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611535 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352294 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177744 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734647 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640257 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799469 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177745 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177746 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611536 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611537 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537724 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537725 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537726 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734648 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611538 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611539 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734649 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611540 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537727 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611541 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537728 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611542 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093820 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611543 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734650 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537729 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537730 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093821 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177747 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611544 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611545 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611546 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799470 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611547 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611548 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537731 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388788 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29399257 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388801 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388800 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388909 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 1921 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388881 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29391639 as keywordID UNION ALL SELECT 100 as relevance, 'ueberhose' as term, 29390076 as keywordID UNION ALL SELECT 100 as relevance, 'ueberhose' as term, 1867 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29401926 as keywordID UNION ALL SELECT 100 as relevance, 'ueberhose' as term, 1872 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29401925 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29390071 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 142011 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388696 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388787 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 1909 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 1841 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, 'sio' as term, 3891 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 20067278 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 14016161 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 831518 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 13801089 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 3709788 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 197116 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 831519 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 206210 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 9656609 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 206212 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376038 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376039 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376040 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376042 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376043 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376044 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376046 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376047 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376060 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376061 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376062 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376063 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 33095727 as keywordID UNION ALL SELECT 5 as relevance, 'sio' as term, 3891 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 29392338 as keywordID UNION ALL SELECT 100 as relevance, 'ueberhose' as term, 1867 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352286 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16118264 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056959 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056960 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640243 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734633 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734634 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370380 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370381 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056961 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352287 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640244 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640245 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640246 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093813 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370382 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352288 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16118265 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056962 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056963 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640247 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734635 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734636 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370383 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370384 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056964 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352289 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640248 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640249 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640250 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093814 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370385 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352290 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16118266 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056965 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056966 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640251 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734637 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734638 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370386 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370387 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056967 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352291 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640252 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640253 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640254 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093815 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370388 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537702 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537703 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177730 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177731 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611507 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352292 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177732 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734639 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640255 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799465 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177733 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177734 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611508 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611509 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537704 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537705 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537706 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734640 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611510 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611511 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734641 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611512 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537707 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611513 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537708 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611514 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093816 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611515 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734642 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537709 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537710 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093817 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177735 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611516 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611517 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611518 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799466 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611519 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611520 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537711 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537712 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537713 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177736 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177737 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611521 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352293 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177738 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734643 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640256 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799467 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177739 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177740 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611522 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611523 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537714 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537715 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537716 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734644 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611524 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611525 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734645 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611526 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537717 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611527 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537718 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611528 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093818 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611529 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734646 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537719 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537720 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093819 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177741 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611530 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611531 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611532 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799468 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611533 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611534 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537721 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537722 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537723 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177742 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177743 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611535 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352294 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177744 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734647 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640257 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799469 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177745 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177746 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611536 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611537 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537724 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537725 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537726 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734648 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611538 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611539 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734649 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611540 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537727 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611541 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537728 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611542 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093820 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611543 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734650 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537729 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537730 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093821 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177747 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611544 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611545 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611546 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799470 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611547 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611548 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537731 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388788 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29399257 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388801 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388800 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388909 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 1921 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388881 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29391639 as keywordID UNION ALL SELECT 100 as relevance, 'ueberhose' as term, 29390076 as keywordID UNION ALL SELECT 100 as relevance, 'ueberhose' as term, 1867 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29401926 as keywordID UNION ALL SELECT 100 as relevance, 'ueberhose' as term, 1872 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29401925 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29390071 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 142011 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388696 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388787 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 1909 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 1841 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, 'sio' as term, 3891 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 20067278 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 14016161 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 831518 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 13801089 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 3709788 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 197116 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 831519 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 206210 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 9656609 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 206212 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376038 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376039 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376040 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376042 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376043 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376044 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376046 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376047 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376060 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376061 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376062 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376063 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 33095727 as keywordID UNION ALL SELECT 5 as relevance, 'sio' as term, 3891 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 29392338 as keywordID UNION ALL SELECT 100 as relevance, 'ueberhose' as term, 1867 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352286 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16118264 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056959 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056960 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640243 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734633 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734634 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370380 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370381 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056961 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352287 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640244 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640245 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640246 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093813 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370382 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352288 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16118265 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056962 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056963 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640247 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734635 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734636 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370383 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370384 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056964 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352289 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640248 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640249 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640250 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093814 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370385 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352290 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16118266 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056965 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056966 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640251 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734637 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734638 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370386 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370387 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056967 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352291 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640252 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640253 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640254 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093815 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370388 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537702 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537703 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177730 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177731 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611507 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352292 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177732 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734639 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640255 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799465 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177733 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177734 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611508 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611509 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537704 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537705 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537706 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734640 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611510 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611511 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734641 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611512 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537707 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611513 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537708 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611514 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093816 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611515 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734642 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537709 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537710 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093817 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177735 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611516 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611517 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611518 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799466 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611519 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611520 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537711 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537712 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537713 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177736 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177737 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611521 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352293 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177738 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734643 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640256 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799467 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177739 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177740 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611522 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611523 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537714 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537715 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537716 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734644 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611524 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611525 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734645 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611526 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537717 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611527 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537718 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611528 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093818 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611529 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734646 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537719 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537720 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093819 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177741 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611530 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611531 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611532 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799468 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611533 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611534 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537721 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537722 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537723 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177742 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177743 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611535 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352294 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177744 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734647 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640257 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799469 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177745 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177746 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611536 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611537 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537724 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537725 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537726 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734648 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611538 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611539 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734649 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611540 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537727 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611541 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537728 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611542 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093820 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611543 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734650 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537729 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537730 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093821 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177747 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611544 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611545 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611546 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799470 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611547 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611548 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537731 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388788 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29399257 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388801 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388800 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388909 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 1921 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388881 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29391639 as keywordID UNION ALL SELECT 100 as relevance, 'ueberhose' as term, 29390076 as keywordID UNION ALL SELECT 100 as relevance, 'ueberhose' as term, 1867 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29401926 as keywordID UNION ALL SELECT 100 as relevance, 'ueberhose' as term, 1872 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29401925 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29390071 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 142011 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388696 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388787 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 1909 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 1841 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, 'sio' as term, 3891 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 20067278 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 14016161 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 831518 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 13801089 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 3709788 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 197116 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 831519 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 206210 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 9656609 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 206212 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376038 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376039 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376040 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376042 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376043 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376044 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376046 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376047 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376060 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376061 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376062 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376063 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 33095727 as keywordID UNION ALL SELECT 5 as relevance, 'sio' as term, 3891 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 29392338 as keywordID UNION ALL SELECT 100 as relevance, 'ueberhose' as term, 1867 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352286 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16118264 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056959 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056960 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640243 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734633 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734634 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370380 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370381 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056961 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352287 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640244 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640245 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640246 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093813 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370382 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352288 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16118265 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056962 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056963 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640247 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734635 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734636 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370383 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370384 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056964 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352289 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640248 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640249 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640250 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093814 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370385 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352290 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16118266 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056965 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056966 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640251 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734637 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734638 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370386 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370387 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056967 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352291 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640252 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640253 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640254 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093815 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370388 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537702 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537703 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177730 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177731 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611507 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352292 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177732 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734639 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640255 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799465 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177733 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177734 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611508 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611509 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537704 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537705 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537706 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734640 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611510 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611511 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734641 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611512 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537707 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611513 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537708 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611514 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093816 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611515 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734642 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537709 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537710 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093817 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177735 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611516 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611517 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611518 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799466 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611519 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611520 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537711 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537712 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537713 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177736 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177737 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611521 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352293 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177738 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734643 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640256 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799467 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177739 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177740 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611522 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611523 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537714 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537715 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537716 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734644 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611524 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611525 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734645 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611526 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537717 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611527 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537718 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611528 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093818 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611529 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734646 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537719 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537720 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093819 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177741 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611530 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611531 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611532 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799468 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611533 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611534 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537721 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537722 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537723 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177742 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177743 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611535 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352294 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177744 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734647 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640257 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799469 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177745 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177746 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611536 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611537 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537724 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537725 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537726 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734648 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611538 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611539 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734649 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611540 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537727 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611541 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537728 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611542 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093820 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611543 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734650 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537729 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537730 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093821 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177747 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611544 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611545 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611546 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799470 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611547 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611548 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537731 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388788 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29399257 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388801 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388800 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388909 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 1921 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388881 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29391639 as keywordID UNION ALL SELECT 100 as relevance, 'ueberhose' as term, 29390076 as keywordID UNION ALL SELECT 100 as relevance, 'ueberhose' as term, 1867 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29401926 as keywordID UNION ALL SELECT 100 as relevance, 'ueberhose' as term, 1872 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29401925 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29390071 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 142011 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388696 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388787 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 1909 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 1841 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, 'sio' as term, 3891 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 20067278 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 14016161 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 831518 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 13801089 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 3709788 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 197116 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 831519 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 206210 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 9656609 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 206212 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376038 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376039 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376040 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376042 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376043 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376044 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376046 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376047 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376060 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376061 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376062 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376063 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 33095727 as keywordID UNION ALL SELECT 5 as relevance, 'sio' as term, 3891 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 29392338 as keywordID UNION ALL SELECT 100 as relevance, 'ueberhose' as term, 1867 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352286 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16118264 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056959 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056960 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640243 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734633 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734634 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370380 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370381 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056961 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352287 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640244 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640245 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640246 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093813 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370382 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352288 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16118265 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056962 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056963 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640247 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734635 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734636 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370383 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370384 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056964 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352289 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640248 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640249 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640250 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093814 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370385 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352290 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16118266 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056965 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056966 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640251 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734637 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734638 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370386 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370387 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056967 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352291 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640252 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640253 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640254 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093815 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370388 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537702 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537703 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177730 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177731 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611507 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352292 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177732 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734639 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640255 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799465 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177733 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177734 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611508 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611509 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537704 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537705 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537706 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734640 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611510 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611511 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734641 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611512 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537707 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611513 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537708 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611514 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093816 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611515 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734642 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537709 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537710 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093817 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177735 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611516 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611517 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611518 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799466 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611519 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611520 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537711 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537712 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537713 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177736 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177737 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611521 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352293 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177738 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734643 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640256 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799467 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177739 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177740 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611522 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611523 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537714 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537715 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537716 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734644 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611524 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611525 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734645 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611526 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537717 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611527 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537718 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611528 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093818 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611529 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734646 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537719 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537720 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093819 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177741 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611530 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611531 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611532 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799468 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611533 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611534 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537721 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537722 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537723 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177742 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177743 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611535 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352294 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177744 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734647 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640257 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799469 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177745 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177746 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611536 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611537 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537724 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537725 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537726 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734648 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611538 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611539 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734649 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611540 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537727 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611541 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537728 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611542 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093820 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611543 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734650 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537729 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537730 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093821 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177747 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611544 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611545 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611546 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799470 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611547 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611548 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537731 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388788 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29399257 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388801 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388800 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388909 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 1921 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388881 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29391639 as keywordID UNION ALL SELECT 100 as relevance, 'ueberhose' as term, 29390076 as keywordID UNION ALL SELECT 100 as relevance, 'ueberhose' as term, 1867 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29401926 as keywordID UNION ALL SELECT 100 as relevance, 'ueberhose' as term, 1872 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29401925 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29390071 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 142011 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388696 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388787 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 1909 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 1841 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, 'sio' as term, 3891 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 20067278 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 14016161 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 831518 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 13801089 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 3709788 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 197116 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 831519 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 206210 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 9656609 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 206212 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376038 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376039 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376040 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376042 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376043 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376044 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376046 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376047 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376060 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376061 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376062 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376063 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 33095727 as keywordID UNION ALL SELECT 5 as relevance, 'sio' as term, 3891 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 29392338 as keywordID UNION ALL SELECT 100 as relevance, 'ueberhose' as term, 1867 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352286 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16118264 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056959 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056960 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640243 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734633 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734634 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370380 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370381 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056961 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352287 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640244 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640245 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640246 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093813 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370382 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352288 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16118265 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056962 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056963 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640247 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734635 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734636 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370383 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370384 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056964 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352289 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640248 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640249 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640250 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093814 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370385 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352290 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16118266 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056965 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056966 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640251 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734637 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734638 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370386 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370387 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056967 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352291 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640252 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640253 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640254 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093815 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370388 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537702 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537703 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177730 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177731 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611507 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352292 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177732 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734639 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640255 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799465 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177733 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177734 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611508 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611509 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537704 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537705 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537706 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734640 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611510 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611511 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734641 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611512 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537707 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611513 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537708 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611514 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093816 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611515 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734642 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537709 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537710 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093817 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177735 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611516 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611517 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611518 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799466 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611519 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611520 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537711 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537712 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537713 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177736 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177737 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611521 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352293 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177738 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734643 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640256 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799467 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177739 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177740 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611522 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611523 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537714 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537715 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537716 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734644 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611524 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611525 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734645 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611526 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537717 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611527 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537718 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611528 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093818 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611529 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734646 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537719 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537720 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093819 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177741 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611530 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611531 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611532 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799468 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611533 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611534 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537721 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537722 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537723 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177742 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177743 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611535 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352294 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177744 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734647 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640257 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799469 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177745 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177746 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611536 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611537 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537724 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537725 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537726 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734648 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611538 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611539 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734649 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611540 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537727 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611541 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537728 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611542 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093820 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611543 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734650 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537729 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537730 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093821 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177747 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611544 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611545 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611546 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799470 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611547 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611548 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537731 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388788 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29399257 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388801 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388800 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388909 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 1921 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388881 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29391639 as keywordID UNION ALL SELECT 100 as relevance, 'ueberhose' as term, 29390076 as keywordID UNION ALL SELECT 100 as relevance, 'ueberhose' as term, 1867 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29401926 as keywordID UNION ALL SELECT 100 as relevance, 'ueberhose' as term, 1872 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29401925 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29390071 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 142011 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388696 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388787 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 1909 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 1841 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, 'sio' as term, 3891 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 20067278 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 14016161 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 831518 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 13801089 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 3709788 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 197116 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 831519 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 206210 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 9656609 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 206212 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376038 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376039 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376040 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376042 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376043 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376044 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376046 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376047 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376060 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376061 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376062 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376063 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 33095727 as keywordID UNION ALL SELECT 5 as relevance, 'sio' as term, 3891 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 29392338 as keywordID UNION ALL SELECT 100 as relevance, 'ueberhose' as term, 1867 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352286 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16118264 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056959 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056960 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640243 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734633 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734634 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370380 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370381 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056961 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352287 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640244 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640245 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640246 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093813 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370382 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352288 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16118265 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056962 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056963 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640247 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734635 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734636 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370383 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370384 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056964 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352289 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640248 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640249 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640250 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093814 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370385 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352290 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16118266 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056965 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056966 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640251 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734637 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734638 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370386 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370387 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056967 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352291 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640252 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640253 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640254 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093815 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370388 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537702 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537703 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177730 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177731 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611507 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352292 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177732 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734639 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640255 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799465 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177733 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177734 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611508 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611509 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537704 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537705 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537706 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734640 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611510 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611511 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734641 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611512 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537707 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611513 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537708 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611514 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093816 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611515 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734642 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537709 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537710 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093817 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177735 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611516 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611517 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611518 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799466 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611519 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611520 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537711 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537712 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537713 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177736 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177737 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611521 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352293 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177738 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734643 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640256 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799467 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177739 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177740 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611522 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611523 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537714 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537715 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537716 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734644 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611524 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611525 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734645 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611526 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537717 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611527 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537718 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611528 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093818 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611529 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734646 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537719 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537720 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093819 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177741 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611530 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611531 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611532 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799468 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611533 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611534 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537721 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537722 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537723 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177742 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177743 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611535 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352294 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177744 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734647 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640257 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799469 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177745 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177746 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611536 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611537 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537724 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537725 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537726 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734648 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611538 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611539 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734649 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611540 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537727 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611541 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537728 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611542 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093820 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611543 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734650 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537729 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537730 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093821 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177747 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611544 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611545 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611546 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799470 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611547 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611548 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537731 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388788 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29399257 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388801 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388800 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388909 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 1921 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388881 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29391639 as keywordID UNION ALL SELECT 100 as relevance, 'ueberhose' as term, 29390076 as keywordID UNION ALL SELECT 100 as relevance, 'ueberhose' as term, 1867 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29401926 as keywordID UNION ALL SELECT 100 as relevance, 'ueberhose' as term, 1872 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29401925 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29390071 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 142011 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388696 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388787 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 1909 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 1841 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, 'sio' as term, 3891 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 20067278 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 14016161 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 831518 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 13801089 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 3709788 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 197116 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 831519 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 206210 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 9656609 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 206212 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376038 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376039 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376040 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376042 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376043 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376044 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376046 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376047 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376060 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376061 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376062 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376063 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 33095727 as keywordID UNION ALL SELECT 5 as relevance, 'sio' as term, 3891 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 29392338 as keywordID UNION ALL SELECT 100 as relevance, 'ueberhose' as term, 1867 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352286 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16118264 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056959 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056960 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640243 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734633 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734634 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370380 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370381 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056961 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352287 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640244 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640245 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640246 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093813 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370382 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352288 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16118265 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056962 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056963 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640247 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734635 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734636 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370383 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370384 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056964 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352289 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640248 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640249 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640250 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093814 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370385 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352290 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16118266 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056965 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056966 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640251 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734637 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734638 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370386 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370387 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056967 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352291 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640252 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640253 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640254 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093815 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370388 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537702 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537703 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177730 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177731 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611507 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352292 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177732 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734639 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640255 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799465 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177733 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177734 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611508 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611509 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537704 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537705 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537706 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734640 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611510 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611511 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734641 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611512 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537707 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611513 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537708 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611514 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093816 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611515 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734642 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537709 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537710 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093817 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177735 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611516 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611517 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611518 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799466 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611519 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611520 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537711 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537712 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537713 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177736 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177737 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611521 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352293 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177738 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734643 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640256 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799467 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177739 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177740 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611522 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611523 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537714 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537715 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537716 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734644 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611524 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611525 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734645 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611526 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537717 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611527 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537718 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611528 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093818 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611529 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734646 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537719 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537720 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093819 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177741 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611530 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611531 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611532 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799468 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611533 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611534 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537721 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537722 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537723 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177742 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177743 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611535 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352294 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177744 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734647 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640257 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799469 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177745 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177746 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611536 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611537 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537724 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537725 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537726 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734648 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611538 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611539 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734649 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611540 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537727 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611541 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537728 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611542 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093820 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611543 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734650 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537729 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537730 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093821 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177747 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611544 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611545 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611546 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799470 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611547 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611548 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537731 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388788 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29399257 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388801 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388800 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388909 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 1921 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388881 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29391639 as keywordID UNION ALL SELECT 100 as relevance, 'ueberhose' as term, 29390076 as keywordID UNION ALL SELECT 100 as relevance, 'ueberhose' as term, 1867 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29401926 as keywordID UNION ALL SELECT 100 as relevance, 'ueberhose' as term, 1872 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29401925 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29390071 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 142011 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388696 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388787 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 1909 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 1841 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, 'sio' as term, 3891 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 20067278 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 14016161 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 831518 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 13801089 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 3709788 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 197116 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 831519 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 206210 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 9656609 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 206212 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376038 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376039 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376040 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376042 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376043 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376044 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376046 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376047 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376060 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376061 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376062 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376063 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 33095727 as keywordID UNION ALL SELECT 5 as relevance, 'sio' as term, 3891 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 29392338 as keywordID UNION ALL SELECT 100 as relevance, 'ueberhose' as term, 1867 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352286 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16118264 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056959 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056960 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640243 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734633 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734634 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370380 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370381 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056961 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352287 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640244 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640245 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640246 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093813 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370382 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352288 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16118265 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056962 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056963 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640247 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734635 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734636 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370383 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370384 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056964 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352289 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640248 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640249 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640250 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093814 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370385 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352290 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16118266 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056965 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056966 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640251 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734637 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734638 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370386 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370387 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056967 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352291 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640252 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640253 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640254 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093815 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370388 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537702 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537703 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177730 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177731 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611507 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352292 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177732 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734639 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640255 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799465 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177733 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177734 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611508 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611509 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537704 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537705 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537706 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734640 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611510 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611511 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734641 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611512 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537707 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611513 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537708 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611514 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093816 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611515 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734642 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537709 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537710 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093817 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177735 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611516 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611517 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611518 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799466 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611519 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611520 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537711 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537712 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537713 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177736 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177737 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611521 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352293 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177738 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734643 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640256 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799467 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177739 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177740 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611522 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611523 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537714 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537715 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537716 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734644 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611524 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611525 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734645 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611526 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537717 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611527 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537718 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611528 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093818 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611529 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734646 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537719 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537720 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093819 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177741 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611530 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611531 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611532 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799468 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611533 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611534 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537721 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537722 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537723 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177742 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177743 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611535 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352294 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177744 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734647 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640257 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799469 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177745 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177746 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611536 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611537 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537724 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537725 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537726 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734648 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611538 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611539 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734649 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611540 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537727 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611541 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537728 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611542 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093820 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611543 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734650 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537729 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537730 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093821 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177747 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611544 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611545 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611546 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799470 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611547 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611548 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537731 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388788 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29399257 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388801 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388800 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388909 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 1921 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388881 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29391639 as keywordID UNION ALL SELECT 100 as relevance, 'ueberhose' as term, 29390076 as keywordID UNION ALL SELECT 100 as relevance, 'ueberhose' as term, 1867 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29401926 as keywordID UNION ALL SELECT 100 as relevance, 'ueberhose' as term, 1872 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29401925 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29390071 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 142011 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388696 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388787 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 1909 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 1841 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, 'sio' as term, 3891 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 20067278 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 14016161 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 831518 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 13801089 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 3709788 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 197116 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 831519 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 206210 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 9656609 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 206212 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376038 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376039 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376040 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376042 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376043 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376044 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376046 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376047 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376060 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376061 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376062 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376063 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 33095727 as keywordID UNION ALL SELECT 5 as relevance, 'sio' as term, 3891 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 29392338 as keywordID UNION ALL SELECT 100 as relevance, 'ueberhose' as term, 1867 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352286 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16118264 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056959 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056960 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640243 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734633 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734634 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370380 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370381 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056961 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352287 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640244 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640245 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640246 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093813 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370382 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352288 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16118265 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056962 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056963 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640247 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734635 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734636 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370383 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370384 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056964 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352289 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640248 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640249 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640250 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093814 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370385 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352290 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16118266 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056965 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056966 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640251 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734637 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734638 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370386 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370387 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056967 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352291 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640252 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640253 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640254 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093815 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370388 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537702 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537703 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177730 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177731 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611507 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352292 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177732 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734639 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640255 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799465 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177733 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177734 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611508 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611509 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537704 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537705 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537706 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734640 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611510 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611511 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734641 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611512 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537707 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611513 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537708 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611514 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093816 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611515 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734642 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537709 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537710 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093817 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177735 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611516 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611517 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611518 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799466 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611519 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611520 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537711 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537712 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537713 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177736 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177737 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611521 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352293 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177738 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734643 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640256 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799467 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177739 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177740 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611522 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611523 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537714 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537715 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537716 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734644 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611524 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611525 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734645 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611526 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537717 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611527 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537718 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611528 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093818 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611529 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734646 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537719 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537720 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093819 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177741 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611530 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611531 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611532 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799468 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611533 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611534 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537721 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537722 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537723 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177742 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177743 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611535 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352294 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177744 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734647 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640257 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799469 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177745 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177746 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611536 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611537 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537724 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537725 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537726 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734648 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611538 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611539 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734649 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611540 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537727 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611541 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537728 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611542 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093820 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611543 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734650 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537729 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537730 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093821 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177747 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611544 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611545 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611546 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799470 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611547 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611548 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537731 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388788 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29399257 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388801 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388800 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388909 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 1921 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388881 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29391639 as keywordID UNION ALL SELECT 100 as relevance, 'ueberhose' as term, 29390076 as keywordID UNION ALL SELECT 100 as relevance, 'ueberhose' as term, 1867 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29401926 as keywordID UNION ALL SELECT 100 as relevance, 'ueberhose' as term, 1872 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29401925 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29390071 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 142011 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388696 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388787 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 1909 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 1841 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, 'sio' as term, 3891 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 20067278 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 14016161 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 831518 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 13801089 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 3709788 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 197116 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 831519 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 206210 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 9656609 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 206212 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376038 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376039 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376040 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376042 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376043 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376044 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376046 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376047 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376060 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376061 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376062 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 47376063 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 33095727 as keywordID UNION ALL SELECT 5 as relevance, 'sio' as term, 3891 as keywordID UNION ALL SELECT 50 as relevance, 'sio' as term, 29392338 as keywordID UNION ALL SELECT 100 as relevance, 'ueberhose' as term, 1867 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352286 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16118264 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056959 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056960 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640243 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734633 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734634 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370380 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370381 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056961 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352287 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640244 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640245 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640246 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093813 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370382 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352288 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16118265 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056962 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056963 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640247 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734635 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734636 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370383 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370384 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056964 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352289 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640248 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640249 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640250 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093814 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370385 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352290 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16118266 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056965 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056966 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640251 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734637 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734638 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370386 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370387 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 27056967 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352291 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640252 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640253 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640254 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093815 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16370388 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537702 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537703 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177730 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177731 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611507 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352292 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177732 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734639 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640255 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799465 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177733 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177734 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611508 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611509 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537704 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537705 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537706 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734640 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611510 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611511 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734641 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611512 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537707 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611513 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537708 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611514 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093816 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611515 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734642 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537709 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537710 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093817 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177735 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611516 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611517 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611518 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799466 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611519 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611520 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537711 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537712 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537713 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177736 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177737 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611521 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352293 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177738 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734643 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640256 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799467 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177739 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177740 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611522 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611523 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537714 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537715 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537716 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734644 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611524 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611525 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734645 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611526 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537717 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611527 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537718 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611528 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093818 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611529 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734646 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537719 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537720 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093819 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177741 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611530 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611531 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611532 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799468 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611533 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611534 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537721 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537722 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537723 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177742 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177743 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611535 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 16352294 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177744 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734647 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24640257 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799469 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177745 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177746 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611536 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611537 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537724 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537725 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537726 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734648 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611538 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611539 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734649 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611540 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537727 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611541 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537728 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611542 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093820 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611543 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 26734650 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537729 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537730 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 24093821 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 37177747 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611544 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611545 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611546 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 18799470 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611547 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17611548 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 17537731 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388788 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29399257 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388801 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388800 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388909 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 1921 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388881 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29391639 as keywordID UNION ALL SELECT 100 as relevance, 'ueberhose' as term, 29390076 as keywordID UNION ALL SELECT 100 as relevance, 'ueberhose' as term, 1867 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29401926 as keywordID UNION ALL SELECT 100 as relevance, 'ueberhose' as term, 1872 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29401925 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29390071 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 142011 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388696 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 29388787 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 1909 as keywordID UNION ALL SELECT 50 as relevance, 'ueberhose' as term, 1841 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}