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