Deprecated: Assigning the return value of new by reference is deprecated in /xfsdata/www/htdocs_deepershopping/includes/_systemcode/functions/menu/goodyear_menu.php on line 14

Deprecated: Assigning the return value of new by reference is deprecated in /xfsdata/www/htdocs_deepershopping/includes/_systemcode/functions/worker/goodyear_worker.php on line 344

Deprecated: Assigning the return value of new by reference is deprecated in /xfsdata/www/htdocs_deepershopping/includes/_systemcode/functions/worker/goodyear_worker.php on line 345

Deprecated: Assigning the return value of new by reference is deprecated in /xfsdata/www/htdocs_deepershopping/includes/_systemcode/functions/worker/goodyear_worker.php on line 346
sphinx port=9306FUNCTION weight does not exist

SELECT id as product_id, title_string, author_string, image_count , stock_qty_sold, store_qty_sold, weight() as relevance, relevance + (relevance * (decile_sales_rank/3)) as relevance_sales_weighted FROM index_0000001_products WHERE department3 = 799 ORDER BY store_qty_sold desc, stock_qty_sold desc, relevance DESC LIMIT 5000 OPTION ranker=proximity_bm25, max_matches=170000, field_weights=(product_id=7, product_config=6, title=5, series=4, author=4, keywords=4, keywords_auto=4, publisher=3, binding=3, isbn=2, upc=2, ean=2, description=1) ;SELECT 10+10 as wobblyjunk, count(*) as itemcount FROM index_0000001_products WHERE department = 799 GROUP BY wobblyjunk LIMIT 5000 OPTION ranker=proximity_bm25, max_matches=170000, field_weights=(product_id=7, product_config=6, title=5, series=4, author=4, keywords=4, keywords_auto=4, publisher=3, binding=3, isbn=2, upc=2, ean=2, description=1) ;SELECT 10+10 as wobblyjunk, count(*) as itemcount FROM index_0000001_products WHERE department = 24 GROUP BY wobblyjunk LIMIT 5000 OPTION ranker=proximity_bm25, max_matches=170000, field_weights=(product_id=7, product_config=6, title=5, series=4, author=4, keywords=4, keywords_auto=4, publisher=3, binding=3, isbn=2, upc=2, ean=2, description=1) ;SELECT 10+10 as wobblyjunk, count(*) as itemcount FROM index_0000001_products WHERE department = 8 GROUP BY wobblyjunk LIMIT 5000 OPTION ranker=proximity_bm25, max_matches=170000, field_weights=(product_id=7, product_config=6, title=5, series=4, author=4, keywords=4, keywords_auto=4, publisher=3, binding=3, isbn=2, upc=2, ean=2, description=1) ;SELECT @groupby as department, count(*) as itemcount FROM index_0000001_products WHERE department3 = 799 GROUP BY department4 LIMIT 120000 OPTION ranker=proximity_bm25, max_matches=170000, field_weights=(product_id=7, product_config=6, title=5, series=4, author=4, keywords=4, keywords_auto=4, publisher=3, binding=3, isbn=2, upc=2, ean=2, description=1) ;SELECT @groupby as bible_translation_id, count(*) as itemcount FROM index_0000001_products WHERE department3 = 799 and bible_translation_id > 0 GROUP BY bible_translation_id LIMIT 5000 OPTION ranker=proximity_bm25, max_matches=170000, field_weights=(product_id=7, product_config=6, title=5, series=4, author=4, keywords=4, keywords_auto=4, publisher=3, binding=3, isbn=2, upc=2, ean=2, description=1) ;SELECT @groupby as bible_pointsize, count(*) as itemcount FROM index_0000001_products WHERE department3 = 799 and bible_pointsize > 0 GROUP BY bible_pointsize LIMIT 5000 OPTION ranker=proximity_bm25, max_matches=170000, field_weights=(product_id=7, product_config=6, title=5, series=4, author=4, keywords=4, keywords_auto=4, publisher=3, binding=3, isbn=2, upc=2, ean=2, description=1) ;SELECT @groupby as bible_features, count(*) as itemcount FROM index_0000001_products WHERE department3 = 799 and bible_features > 0 GROUP BY bible_features LIMIT 5000 OPTION ranker=proximity_bm25, max_matches=170000, field_weights=(product_id=7, product_config=6, title=5, series=4, author=4, keywords=4, keywords_auto=4, publisher=3, binding=3, isbn=2, upc=2, ean=2, description=1) ;SELECT @groupby as publisher_id, count(*) as itemcount FROM index_0000001_products WHERE department3 = 799 and publisher_id > 0 GROUP BY publisher_id LIMIT 5000 OPTION ranker=proximity_bm25, max_matches=170000, field_weights=(product_id=7, product_config=6, title=5, series=4, author=4, keywords=4, keywords_auto=4, publisher=3, binding=3, isbn=2, upc=2, ean=2, description=1) ;SELECT @groupby as metal_id, count(*) as itemcount FROM index_0000001_products WHERE department3 = 799 and metal_id > 0 GROUP BY metal_id LIMIT 5000 OPTION ranker=proximity_bm25, max_matches=170000, field_weights=(product_id=7, product_config=6, title=5, series=4, author=4, keywords=4, keywords_auto=4, publisher=3, binding=3, isbn=2, upc=2, ean=2, description=1) ;SELECT @groupby as gemstone_id, count(*) as itemcount FROM index_0000001_products WHERE department3 = 799 and gemstone_id > 0 GROUP BY gemstone_id LIMIT 5000 OPTION ranker=proximity_bm25, max_matches=170000, field_weights=(product_id=7, product_config=6, title=5, series=4, author=4, keywords=4, keywords_auto=4, publisher=3, binding=3, isbn=2, upc=2, ean=2, description=1) ;SELECT @groupby as temp_theme, count(*) as itemcount FROM index_0000001_products WHERE department3 = 799 and theme > 0 GROUP BY theme LIMIT 5000 OPTION ranker=proximity_bm25, max_matches=170000, field_weights=(product_id=7, product_config=6, title=5, series=4, author=4, keywords=4, keywords_auto=4, publisher=3, binding=3, isbn=2, upc=2, ean=2, description=1) ;SELECT binding_code, count(*) as itemcount FROM index_0000001_products WHERE department3 = 799 and binding_code > 0 GROUP BY binding_code LIMIT 5000 OPTION ranker=proximity_bm25, max_matches=170000, field_weights=(product_id=7, product_config=6, title=5, series=4, author=4, keywords=4, keywords_auto=4, publisher=3, binding=3, isbn=2, upc=2, ean=2, description=1) ;SELECT groupprice, count(*) as itemcount FROM index_0000001_products WHERE department3 = 799 GROUP BY groupprice LIMIT 5000 OPTION ranker=proximity_bm25, max_matches=170000, field_weights=(product_id=7, product_config=6, title=5, series=4, author=4, keywords=4, keywords_auto=4, publisher=3, binding=3, isbn=2, upc=2, ean=2, description=1) ;SELECT groupdiscount, count(*) as itemcount FROM index_0000001_products WHERE department3 = 799 and groupdiscount < 10 GROUP BY groupdiscount LIMIT 5000 OPTION ranker=proximity_bm25, max_matches=170000, field_weights=(product_id=7, product_config=6, title=5, series=4, author=4, keywords=4, keywords_auto=4, publisher=3, binding=3, isbn=2, upc=2, ean=2, description=1) ;SELECT @groupby as age, count(*) as itemcount FROM index_0000001_products WHERE department3 = 799 and age > 0 GROUP BY age LIMIT 5000 OPTION ranker=proximity_bm25, max_matches=170000, field_weights=(product_id=7, product_config=6, title=5, series=4, author=4, keywords=4, keywords_auto=4, publisher=3, binding=3, isbn=2, upc=2, ean=2, description=1) ;SELECT @groupby as gradelevel, count(*) as itemcount FROM index_0000001_products WHERE department3 = 799 and gradelevel > 0 GROUP BY gradelevel LIMIT 5000 OPTION ranker=proximity_bm25, max_matches=170000, field_weights=(product_id=7, product_config=6, title=5, series=4, author=4, keywords=4, keywords_auto=4, publisher=3, binding=3, isbn=2, upc=2, ean=2, description=1) ;