Server shutdown in progress
SELECT SQL_CALC_FOUND_ROWS p.*, name_ru AS _name_sort FROM SC_products p LEFT JOIN SC_product_options_values PrdOptVal0 ON p.productID=PrdOptVal0.`productID` LEFT JOIN SC_product_options_set PrdOptSet0 ON p.productID=PrdOptSet0.`productID` LEFT JOIN SC_product_options_values PrdOptVal1 ON p.productID=PrdOptVal1.`productID` LEFT JOIN SC_product_options_set PrdOptSet1 ON p.productID=PrdOptSet1.`productID` LEFT JOIN SC_product_options_values PrdOptVal2 ON p.productID=PrdOptVal2.`productID` LEFT JOIN SC_product_options_set PrdOptSet2 ON p.productID=PrdOptSet2.`productID` WHERE ( ((categoryID IN (978)) AND ( enabled=1)) AND (PrdOptVal0.optionID=17 AND ( ( ( PrdOptVal0.option_type=1 AND PrdOptSet0.variantID=51) OR (PrdOptVal0.option_type=0 AND PrdOptVal0.option_value_ru LIKE '%5000mAh%') ))) AND (PrdOptVal1.optionID=25 AND ( ( ( PrdOptVal1.option_type=1 AND PrdOptSet1.variantID=1001) OR (PrdOptVal1.option_type=0 AND PrdOptVal1.option_value_ru LIKE '%11.1V%') ) OR ( ( PrdOptVal1.option_type=1 AND PrdOptSet1.variantID=1025) OR (PrdOptVal1.option_type=0 AND PrdOptVal1.option_value_ru LIKE '%3.7V%') ) OR ( ( PrdOptVal1.option_type=1 AND PrdOptSet1.variantID=1038) OR (PrdOptVal1.option_type=0 AND PrdOptVal1.option_value_ru LIKE '%7.2V%') ) OR ( ( PrdOptVal1.option_type=1 AND PrdOptSet1.variantID=1040) OR (PrdOptVal1.option_type=0 AND PrdOptVal1.option_value_ru LIKE '%7.4V%') ) OR ( ( PrdOptVal1.option_type=1 AND PrdOptSet1.variantID=1034) OR (PrdOptVal1.option_type=0 AND PrdOptVal1.option_value_ru LIKE '%5V%') ))) AND (PrdOptVal2.optionID=56 AND ( ( ( PrdOptVal2.option_type=1 AND PrdOptSet2.variantID=1891) OR (PrdOptVal2.option_type=0 AND PrdOptVal2.option_value_ru LIKE '%Wolf Garten%') ))) AND `p`.`virtual_ownerID`=0) GROUP BY p.productID ORDER BY sort_order, _name_sort LIMIT 0,32