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` WHERE ( ((categoryID IN (978)) AND ( enabled=1)) AND (PrdOptVal0.optionID=17 AND ( ( ( PrdOptVal0.option_type=1 AND PrdOptSet0.variantID=102) OR (PrdOptVal0.option_type=0 AND PrdOptVal0.option_value_ru LIKE '%3000mAh%') ) OR ( ( PrdOptVal0.option_type=1 AND PrdOptSet0.variantID=139) OR (PrdOptVal0.option_type=0 AND PrdOptVal0.option_value_ru LIKE '%9000mAh%') ) OR ( ( PrdOptVal0.option_type=1 AND PrdOptSet0.variantID=41) OR (PrdOptVal0.option_type=0 AND PrdOptVal0.option_value_ru LIKE '%2200mAh%') ) OR ( ( PrdOptVal0.option_type=1 AND PrdOptSet0.variantID=42) OR (PrdOptVal0.option_type=0 AND PrdOptVal0.option_value_ru LIKE '%2400mAh%') ) OR ( ( PrdOptVal0.option_type=1 AND PrdOptSet0.variantID=770) OR (PrdOptVal0.option_type=0 AND PrdOptVal0.option_value_ru LIKE '%13800mAh%') ))) AND (PrdOptVal1.optionID=20 AND ( ( ( PrdOptVal1.option_type=1 AND PrdOptSet1.variantID=38) OR (PrdOptVal1.option_type=0 AND PrdOptVal1.option_value_ru LIKE '%Ni-Mh%') ))) AND `p`.`virtual_ownerID`=0) GROUP BY p.productID ORDER BY sort_order, _name_sort LIMIT 32,32