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, 'pail' as term, 1731119 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 1733770 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 1733771 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3692296 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2259709 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3692297 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2713306 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 6337908 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2713307 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2259710 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2290564 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 6337909 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2713308 as keywordID UNION ALL SELECT 100 as relevance, 'pail' as term, 1731119 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 29401886 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669310 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669311 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871447 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669312 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871452 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669314 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871453 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871454 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669315 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871455 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 7165311 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3575324 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871456 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3575327 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 4406593 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3575328 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 7165312 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2846414 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669317 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2884115 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 6540290 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 30549419 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 6540291 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 17210949 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 30549420 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 6540293 as keywordID UNION ALL SELECT 100 as relevance, 'liner' as term, 2091 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 34146334 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 205780 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 25606596 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 37806191 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 33143278 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 29401901 as keywordID UNION ALL SELECT 100 as relevance, 'liner' as term, 195732 as keywordID UNION ALL SELECT 100 as relevance, 'liner' as term, 2091 as keywordID UNION ALL SELECT 100 as relevance, 'liner' as term, 29388729 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 202709 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 33150815 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 29401886 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4406592 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669310 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669311 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871447 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871448 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4493358 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871449 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669312 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871450 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871451 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871452 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669313 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669314 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871453 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871454 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669315 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871455 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669316 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 7165311 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846409 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575324 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846410 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4493359 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871456 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575325 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 5839917 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871457 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871458 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575326 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846411 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575327 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4406593 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846412 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4493360 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846413 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884110 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575328 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575329 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 7165312 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575330 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 9764100 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884111 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846414 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4984051 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846415 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884112 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884113 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669317 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884114 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884115 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 16320149 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 30549399 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 16320150 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 17206962 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 30549400 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 6540290 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 30549419 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 6540291 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 17210949 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 6540292 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 30549420 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 6540293 as keywordID UNION ALL SELECT 50 as relevance, 'spartner' as term, 1806 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, 'pail' as term, 1731119 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 1733770 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 1733771 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3692296 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2259709 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3692297 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2713306 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 6337908 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2713307 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2259710 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2290564 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 6337909 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2713308 as keywordID UNION ALL SELECT 100 as relevance, 'pail' as term, 1731119 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 29401886 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669310 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669311 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871447 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669312 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871452 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669314 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871453 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871454 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669315 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871455 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 7165311 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3575324 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871456 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3575327 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 4406593 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3575328 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 7165312 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2846414 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669317 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2884115 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 6540290 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 30549419 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 6540291 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 17210949 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 30549420 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 6540293 as keywordID UNION ALL SELECT 100 as relevance, 'liner' as term, 2091 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 34146334 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 205780 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 25606596 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 37806191 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 33143278 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 29401901 as keywordID UNION ALL SELECT 100 as relevance, 'liner' as term, 195732 as keywordID UNION ALL SELECT 100 as relevance, 'liner' as term, 2091 as keywordID UNION ALL SELECT 100 as relevance, 'liner' as term, 29388729 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 202709 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 33150815 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 29401886 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4406592 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669310 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669311 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871447 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871448 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4493358 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871449 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669312 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871450 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871451 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871452 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669313 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669314 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871453 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871454 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669315 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871455 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669316 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 7165311 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846409 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575324 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846410 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4493359 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871456 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575325 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 5839917 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871457 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871458 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575326 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846411 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575327 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4406593 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846412 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4493360 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846413 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884110 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575328 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575329 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 7165312 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575330 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 9764100 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884111 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846414 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4984051 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846415 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884112 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884113 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669317 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884114 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884115 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 16320149 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 30549399 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 16320150 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 17206962 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 30549400 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 6540290 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 30549419 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 6540291 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 17210949 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 6540292 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 30549420 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 6540293 as keywordID UNION ALL SELECT 50 as relevance, 'spartner' as term, 1806 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, 'pail' as term, 1731119 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 1733770 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 1733771 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3692296 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2259709 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3692297 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2713306 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 6337908 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2713307 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2259710 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2290564 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 6337909 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2713308 as keywordID UNION ALL SELECT 100 as relevance, 'pail' as term, 1731119 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 29401886 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669310 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669311 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871447 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669312 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871452 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669314 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871453 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871454 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669315 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871455 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 7165311 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3575324 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871456 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3575327 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 4406593 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3575328 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 7165312 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2846414 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669317 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2884115 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 6540290 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 30549419 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 6540291 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 17210949 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 30549420 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 6540293 as keywordID UNION ALL SELECT 100 as relevance, 'liner' as term, 2091 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 34146334 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 205780 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 25606596 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 37806191 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 33143278 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 29401901 as keywordID UNION ALL SELECT 100 as relevance, 'liner' as term, 195732 as keywordID UNION ALL SELECT 100 as relevance, 'liner' as term, 2091 as keywordID UNION ALL SELECT 100 as relevance, 'liner' as term, 29388729 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 202709 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 33150815 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 29401886 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4406592 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669310 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669311 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871447 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871448 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4493358 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871449 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669312 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871450 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871451 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871452 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669313 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669314 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871453 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871454 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669315 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871455 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669316 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 7165311 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846409 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575324 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846410 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4493359 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871456 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575325 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 5839917 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871457 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871458 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575326 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846411 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575327 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4406593 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846412 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4493360 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846413 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884110 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575328 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575329 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 7165312 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575330 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 9764100 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884111 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846414 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4984051 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846415 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884112 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884113 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669317 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884114 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884115 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 16320149 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 30549399 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 16320150 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 17206962 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 30549400 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 6540290 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 30549419 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 6540291 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 17210949 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 6540292 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 30549420 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 6540293 as keywordID UNION ALL SELECT 50 as relevance, 'spartner' as term, 1806 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, 'pail' as term, 1731119 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 1733770 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 1733771 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3692296 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2259709 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3692297 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2713306 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 6337908 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2713307 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2259710 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2290564 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 6337909 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2713308 as keywordID UNION ALL SELECT 100 as relevance, 'pail' as term, 1731119 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 29401886 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669310 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669311 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871447 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669312 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871452 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669314 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871453 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871454 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669315 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871455 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 7165311 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3575324 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871456 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3575327 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 4406593 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3575328 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 7165312 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2846414 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669317 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2884115 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 6540290 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 30549419 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 6540291 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 17210949 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 30549420 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 6540293 as keywordID UNION ALL SELECT 100 as relevance, 'liner' as term, 2091 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 34146334 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 205780 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 25606596 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 37806191 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 33143278 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 29401901 as keywordID UNION ALL SELECT 100 as relevance, 'liner' as term, 195732 as keywordID UNION ALL SELECT 100 as relevance, 'liner' as term, 2091 as keywordID UNION ALL SELECT 100 as relevance, 'liner' as term, 29388729 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 202709 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 33150815 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 29401886 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4406592 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669310 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669311 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871447 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871448 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4493358 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871449 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669312 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871450 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871451 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871452 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669313 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669314 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871453 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871454 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669315 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871455 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669316 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 7165311 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846409 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575324 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846410 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4493359 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871456 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575325 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 5839917 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871457 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871458 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575326 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846411 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575327 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4406593 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846412 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4493360 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846413 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884110 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575328 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575329 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 7165312 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575330 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 9764100 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884111 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846414 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4984051 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846415 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884112 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884113 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669317 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884114 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884115 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 16320149 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 30549399 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 16320150 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 17206962 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 30549400 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 6540290 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 30549419 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 6540291 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 17210949 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 6540292 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 30549420 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 6540293 as keywordID UNION ALL SELECT 50 as relevance, 'spartner' as term, 1806 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, 'pail' as term, 1731119 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 1733770 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 1733771 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3692296 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2259709 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3692297 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2713306 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 6337908 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2713307 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2259710 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2290564 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 6337909 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2713308 as keywordID UNION ALL SELECT 100 as relevance, 'pail' as term, 1731119 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 29401886 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669310 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669311 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871447 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669312 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871452 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669314 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871453 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871454 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669315 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871455 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 7165311 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3575324 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871456 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3575327 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 4406593 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3575328 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 7165312 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2846414 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669317 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2884115 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 6540290 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 30549419 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 6540291 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 17210949 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 30549420 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 6540293 as keywordID UNION ALL SELECT 100 as relevance, 'liner' as term, 2091 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 34146334 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 205780 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 25606596 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 37806191 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 33143278 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 29401901 as keywordID UNION ALL SELECT 100 as relevance, 'liner' as term, 195732 as keywordID UNION ALL SELECT 100 as relevance, 'liner' as term, 2091 as keywordID UNION ALL SELECT 100 as relevance, 'liner' as term, 29388729 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 202709 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 33150815 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 29401886 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4406592 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669310 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669311 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871447 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871448 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4493358 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871449 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669312 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871450 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871451 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871452 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669313 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669314 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871453 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871454 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669315 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871455 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669316 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 7165311 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846409 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575324 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846410 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4493359 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871456 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575325 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 5839917 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871457 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871458 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575326 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846411 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575327 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4406593 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846412 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4493360 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846413 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884110 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575328 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575329 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 7165312 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575330 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 9764100 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884111 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846414 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4984051 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846415 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884112 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884113 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669317 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884114 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884115 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 16320149 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 30549399 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 16320150 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 17206962 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 30549400 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 6540290 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 30549419 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 6540291 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 17210949 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 6540292 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 30549420 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 6540293 as keywordID UNION ALL SELECT 50 as relevance, 'spartner' as term, 1806 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, 'pail' as term, 1731119 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 1733770 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 1733771 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3692296 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2259709 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3692297 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2713306 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 6337908 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2713307 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2259710 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2290564 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 6337909 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2713308 as keywordID UNION ALL SELECT 100 as relevance, 'pail' as term, 1731119 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 29401886 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669310 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669311 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871447 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669312 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871452 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669314 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871453 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871454 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669315 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871455 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 7165311 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3575324 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871456 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3575327 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 4406593 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3575328 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 7165312 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2846414 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669317 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2884115 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 6540290 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 30549419 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 6540291 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 17210949 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 30549420 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 6540293 as keywordID UNION ALL SELECT 100 as relevance, 'liner' as term, 2091 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 34146334 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 205780 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 25606596 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 37806191 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 33143278 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 29401901 as keywordID UNION ALL SELECT 100 as relevance, 'liner' as term, 195732 as keywordID UNION ALL SELECT 100 as relevance, 'liner' as term, 2091 as keywordID UNION ALL SELECT 100 as relevance, 'liner' as term, 29388729 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 202709 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 33150815 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 29401886 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4406592 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669310 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669311 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871447 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871448 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4493358 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871449 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669312 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871450 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871451 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871452 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669313 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669314 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871453 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871454 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669315 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871455 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669316 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 7165311 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846409 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575324 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846410 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4493359 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871456 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575325 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 5839917 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871457 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871458 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575326 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846411 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575327 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4406593 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846412 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4493360 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846413 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884110 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575328 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575329 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 7165312 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575330 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 9764100 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884111 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846414 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4984051 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846415 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884112 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884113 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669317 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884114 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884115 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 16320149 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 30549399 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 16320150 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 17206962 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 30549400 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 6540290 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 30549419 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 6540291 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 17210949 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 6540292 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 30549420 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 6540293 as keywordID UNION ALL SELECT 50 as relevance, 'spartner' as term, 1806 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, 'pail' as term, 1731119 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 1733770 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 1733771 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3692296 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2259709 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3692297 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2713306 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 6337908 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2713307 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2259710 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2290564 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 6337909 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2713308 as keywordID UNION ALL SELECT 100 as relevance, 'pail' as term, 1731119 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 29401886 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669310 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669311 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871447 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669312 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871452 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669314 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871453 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871454 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669315 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871455 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 7165311 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3575324 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871456 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3575327 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 4406593 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3575328 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 7165312 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2846414 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669317 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2884115 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 6540290 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 30549419 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 6540291 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 17210949 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 30549420 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 6540293 as keywordID UNION ALL SELECT 100 as relevance, 'liner' as term, 2091 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 34146334 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 205780 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 25606596 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 37806191 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 33143278 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 29401901 as keywordID UNION ALL SELECT 100 as relevance, 'liner' as term, 195732 as keywordID UNION ALL SELECT 100 as relevance, 'liner' as term, 2091 as keywordID UNION ALL SELECT 100 as relevance, 'liner' as term, 29388729 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 202709 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 33150815 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 29401886 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4406592 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669310 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669311 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871447 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871448 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4493358 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871449 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669312 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871450 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871451 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871452 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669313 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669314 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871453 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871454 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669315 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871455 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669316 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 7165311 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846409 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575324 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846410 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4493359 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871456 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575325 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 5839917 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871457 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871458 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575326 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846411 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575327 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4406593 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846412 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4493360 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846413 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884110 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575328 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575329 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 7165312 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575330 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 9764100 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884111 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846414 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4984051 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846415 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884112 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884113 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669317 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884114 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884115 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 16320149 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 30549399 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 16320150 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 17206962 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 30549400 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 6540290 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 30549419 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 6540291 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 17210949 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 6540292 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 30549420 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 6540293 as keywordID UNION ALL SELECT 50 as relevance, 'spartner' as term, 1806 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, 'pail' as term, 1731119 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 1733770 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 1733771 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3692296 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2259709 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3692297 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2713306 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 6337908 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2713307 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2259710 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2290564 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 6337909 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2713308 as keywordID UNION ALL SELECT 100 as relevance, 'pail' as term, 1731119 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 29401886 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669310 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669311 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871447 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669312 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871452 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669314 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871453 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871454 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669315 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871455 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 7165311 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3575324 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871456 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3575327 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 4406593 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3575328 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 7165312 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2846414 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669317 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2884115 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 6540290 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 30549419 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 6540291 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 17210949 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 30549420 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 6540293 as keywordID UNION ALL SELECT 100 as relevance, 'liner' as term, 2091 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 34146334 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 205780 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 25606596 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 37806191 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 33143278 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 29401901 as keywordID UNION ALL SELECT 100 as relevance, 'liner' as term, 195732 as keywordID UNION ALL SELECT 100 as relevance, 'liner' as term, 2091 as keywordID UNION ALL SELECT 100 as relevance, 'liner' as term, 29388729 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 202709 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 33150815 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 29401886 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4406592 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669310 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669311 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871447 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871448 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4493358 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871449 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669312 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871450 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871451 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871452 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669313 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669314 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871453 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871454 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669315 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871455 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669316 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 7165311 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846409 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575324 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846410 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4493359 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871456 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575325 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 5839917 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871457 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871458 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575326 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846411 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575327 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4406593 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846412 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4493360 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846413 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884110 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575328 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575329 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 7165312 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575330 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 9764100 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884111 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846414 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4984051 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846415 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884112 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884113 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669317 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884114 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884115 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 16320149 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 30549399 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 16320150 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 17206962 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 30549400 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 6540290 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 30549419 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 6540291 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 17210949 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 6540292 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 30549420 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 6540293 as keywordID UNION ALL SELECT 50 as relevance, 'spartner' as term, 1806 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, 'pail' as term, 1731119 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 1733770 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 1733771 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3692296 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2259709 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3692297 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2713306 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 6337908 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2713307 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2259710 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2290564 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 6337909 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2713308 as keywordID UNION ALL SELECT 100 as relevance, 'pail' as term, 1731119 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 29401886 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669310 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669311 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871447 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669312 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871452 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669314 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871453 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871454 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669315 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871455 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 7165311 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3575324 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871456 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3575327 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 4406593 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3575328 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 7165312 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2846414 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669317 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2884115 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 6540290 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 30549419 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 6540291 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 17210949 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 30549420 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 6540293 as keywordID UNION ALL SELECT 100 as relevance, 'liner' as term, 2091 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 34146334 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 205780 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 25606596 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 37806191 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 33143278 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 29401901 as keywordID UNION ALL SELECT 100 as relevance, 'liner' as term, 195732 as keywordID UNION ALL SELECT 100 as relevance, 'liner' as term, 2091 as keywordID UNION ALL SELECT 100 as relevance, 'liner' as term, 29388729 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 202709 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 33150815 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 29401886 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4406592 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669310 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669311 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871447 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871448 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4493358 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871449 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669312 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871450 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871451 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871452 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669313 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669314 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871453 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871454 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669315 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871455 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669316 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 7165311 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846409 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575324 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846410 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4493359 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871456 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575325 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 5839917 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871457 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871458 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575326 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846411 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575327 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4406593 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846412 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4493360 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846413 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884110 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575328 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575329 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 7165312 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575330 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 9764100 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884111 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846414 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4984051 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846415 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884112 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884113 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669317 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884114 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884115 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 16320149 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 30549399 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 16320150 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 17206962 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 30549400 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 6540290 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 30549419 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 6540291 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 17210949 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 6540292 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 30549420 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 6540293 as keywordID UNION ALL SELECT 50 as relevance, 'spartner' as term, 1806 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, 'pail' as term, 1731119 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 1733770 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 1733771 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3692296 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2259709 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3692297 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2713306 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 6337908 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2713307 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2259710 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2290564 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 6337909 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2713308 as keywordID UNION ALL SELECT 100 as relevance, 'pail' as term, 1731119 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 29401886 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669310 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669311 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871447 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669312 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871452 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669314 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871453 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871454 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669315 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871455 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 7165311 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3575324 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871456 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3575327 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 4406593 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3575328 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 7165312 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2846414 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669317 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2884115 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 6540290 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 30549419 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 6540291 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 17210949 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 30549420 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 6540293 as keywordID UNION ALL SELECT 100 as relevance, 'liner' as term, 2091 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 34146334 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 205780 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 25606596 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 37806191 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 33143278 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 29401901 as keywordID UNION ALL SELECT 100 as relevance, 'liner' as term, 195732 as keywordID UNION ALL SELECT 100 as relevance, 'liner' as term, 2091 as keywordID UNION ALL SELECT 100 as relevance, 'liner' as term, 29388729 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 202709 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 33150815 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 29401886 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4406592 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669310 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669311 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871447 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871448 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4493358 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871449 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669312 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871450 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871451 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871452 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669313 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669314 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871453 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871454 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669315 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871455 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669316 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 7165311 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846409 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575324 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846410 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4493359 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871456 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575325 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 5839917 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871457 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871458 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575326 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846411 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575327 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4406593 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846412 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4493360 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846413 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884110 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575328 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575329 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 7165312 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575330 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 9764100 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884111 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846414 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4984051 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846415 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884112 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884113 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669317 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884114 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884115 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 16320149 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 30549399 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 16320150 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 17206962 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 30549400 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 6540290 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 30549419 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 6540291 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 17210949 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 6540292 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 30549420 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 6540293 as keywordID UNION ALL SELECT 50 as relevance, 'spartner' as term, 1806 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, 'pail' as term, 1731119 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 1733770 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 1733771 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3692296 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2259709 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3692297 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2713306 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 6337908 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2713307 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2259710 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2290564 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 6337909 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2713308 as keywordID UNION ALL SELECT 100 as relevance, 'pail' as term, 1731119 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 29401886 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669310 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669311 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871447 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669312 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871452 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669314 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871453 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871454 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669315 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871455 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 7165311 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3575324 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871456 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3575327 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 4406593 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3575328 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 7165312 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2846414 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669317 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2884115 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 6540290 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 30549419 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 6540291 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 17210949 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 30549420 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 6540293 as keywordID UNION ALL SELECT 100 as relevance, 'liner' as term, 2091 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 34146334 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 205780 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 25606596 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 37806191 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 33143278 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 29401901 as keywordID UNION ALL SELECT 100 as relevance, 'liner' as term, 195732 as keywordID UNION ALL SELECT 100 as relevance, 'liner' as term, 2091 as keywordID UNION ALL SELECT 100 as relevance, 'liner' as term, 29388729 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 202709 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 33150815 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 29401886 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4406592 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669310 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669311 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871447 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871448 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4493358 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871449 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669312 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871450 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871451 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871452 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669313 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669314 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871453 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871454 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669315 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871455 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669316 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 7165311 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846409 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575324 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846410 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4493359 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871456 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575325 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 5839917 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871457 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871458 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575326 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846411 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575327 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4406593 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846412 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4493360 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846413 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884110 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575328 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575329 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 7165312 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575330 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 9764100 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884111 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846414 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4984051 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846415 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884112 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884113 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669317 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884114 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884115 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 16320149 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 30549399 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 16320150 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 17206962 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 30549400 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 6540290 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 30549419 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 6540291 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 17210949 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 6540292 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 30549420 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 6540293 as keywordID UNION ALL SELECT 50 as relevance, 'spartner' as term, 1806 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, 'pail' as term, 1731119 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 1733770 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 1733771 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3692296 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2259709 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3692297 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2713306 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 6337908 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2713307 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2259710 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2290564 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 6337909 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2713308 as keywordID UNION ALL SELECT 100 as relevance, 'pail' as term, 1731119 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 29401886 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669310 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669311 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871447 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669312 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871452 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669314 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871453 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871454 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669315 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871455 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 7165311 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3575324 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2871456 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3575327 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 4406593 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3575328 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 7165312 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2846414 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 3669317 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 2884115 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 6540290 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 30549419 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 6540291 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 17210949 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 30549420 as keywordID UNION ALL SELECT 50 as relevance, 'pail' as term, 6540293 as keywordID UNION ALL SELECT 100 as relevance, 'liner' as term, 2091 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 34146334 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 205780 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 25606596 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 37806191 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 33143278 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 29401901 as keywordID UNION ALL SELECT 100 as relevance, 'liner' as term, 195732 as keywordID UNION ALL SELECT 100 as relevance, 'liner' as term, 2091 as keywordID UNION ALL SELECT 100 as relevance, 'liner' as term, 29388729 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 202709 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 33150815 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 29401886 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4406592 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669310 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669311 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871447 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871448 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4493358 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871449 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669312 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871450 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871451 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871452 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669313 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669314 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871453 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871454 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669315 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871455 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669316 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 7165311 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846409 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575324 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846410 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4493359 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871456 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575325 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 5839917 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871457 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2871458 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575326 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846411 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575327 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4406593 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846412 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4493360 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846413 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884110 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575328 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575329 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 7165312 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3575330 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 9764100 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884111 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846414 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 4984051 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2846415 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884112 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884113 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 3669317 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884114 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 2884115 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 16320149 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 30549399 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 16320150 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 17206962 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 30549400 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 6540290 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 30549419 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 6540291 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 17210949 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 6540292 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 30549420 as keywordID UNION ALL SELECT 50 as relevance, 'liner' as term, 6540293 as keywordID UNION ALL SELECT 50 as relevance, 'spartner' as term, 1806 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}