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=20 AND (
(
( PrdOptVal0.option_type=1 AND PrdOptSet0.variantID=37)
OR
(PrdOptVal0.option_type=0 AND PrdOptVal0.option_value_ru LIKE '%Li-Ion%')
))) AND (PrdOptVal1.optionID=25 AND (
(
( PrdOptVal1.option_type=1 AND PrdOptSet1.variantID=1008)
OR
(PrdOptVal1.option_type=0 AND PrdOptVal1.option_value_ru LIKE '%14,4V%')
) OR
(
( PrdOptVal1.option_type=1 AND PrdOptSet1.variantID=1019)
OR
(PrdOptVal1.option_type=0 AND PrdOptVal1.option_value_ru LIKE '%2.4V%')
) OR
(
( PrdOptVal1.option_type=1 AND PrdOptSet1.variantID=1032)
OR
(PrdOptVal1.option_type=0 AND PrdOptVal1.option_value_ru LIKE '%4.8V%')
) OR
(
( PrdOptVal1.option_type=1 AND PrdOptSet1.variantID=1033)
OR
(PrdOptVal1.option_type=0 AND PrdOptVal1.option_value_ru LIKE '%4V%')
) OR
(
( PrdOptVal1.option_type=1 AND PrdOptSet1.variantID=578)
OR
(PrdOptVal1.option_type=0 AND PrdOptVal1.option_value_ru LIKE '%24V%')
))) AND `p`.`virtual_ownerID`=0) GROUP BY p.productID ORDER BY sort_order, _name_sort LIMIT 64,32